Phil Ringnalda (:philor) Reporter
	Description • 12 years ago

https://tbpl.mozilla.org/php/getParsedLog.php?id=14776837&tree=Mozilla-Beta

utils.talosError: 'Graph server unreachable (5 attempts)\nsend failed, graph server says:\nNo machine_name called \'talos-mtnlion-r5-022\' can be found\n  File "/var/www/html/graphs/server/pyfomatic/collect.py", line 271, in handleRequest\n    metadata = MetaDataFromTalos(databaseCursor, databaseModule, inputStream)\n  File "/var/www/html/graphs/server/pyfomatic/collect.py", line 63, in __init__\n    self.doDatabaseThings(databaseCursor)\n  File "/var/www/html/graphs/server/pyfomatic/collect.py", line 92, in doDatabaseThings\n    raise DatabaseException("No machine_name called \'%s\' can be found" % self.machine_name)\n\n'

	Kim Moir [:kmoir] ET Assignee
	Comment 2 • 12 years ago

sorry I missed this the first time due to a typo

	Justin Wood (:Callek)
	Comment 3 • 12 years ago

Comment on attachment 656048 [details]
add talos-mtnlion-r5-022 slave to sql/data.sql' on the default branch of http://hg.mozilla.org/graphs

wrong file?

	Dustin J. Mitchell [:dustin] (he/him)
	Comment 4 • 12 years ago

Comment on attachment 656048 [details]
add talos-mtnlion-r5-022 slave to sql/data.sql' on the default branch of http://hg.mozilla.org/graphs

I can put my DBA hat on and run these patches, but I'm not the one to r? them..

	Kim Moir [:kmoir] ET Assignee
	Comment 5 • 12 years ago

Comment on attachment 656048 [details]
add talos-mtnlion-r5-022 slave to sql/data.sql' on the default branch of http://hg.mozilla.org/graphs

Callek, I don't think they are added to hg, I think IT just needs to sql to insert into the db.  My previous patch from bug 783660 doesn't appear committed here http://hg.mozilla.org/graphs but the slaves appear in the db.

	Dustin J. Mitchell [:dustin] (he/him)
	Comment 6 • 12 years ago

I think they should get committed.  You want I should run that SQL now?

	Sheeri Cabral [:sheeri]
	Comment 7 • 12 years ago

Kim, Callek, does this need a review before we do it?

	Justin Wood (:Callek)
	Comment 8 • 12 years ago

Comment on attachment 656052 [details] [diff] [review]
add talos-mtnlion-r5-022 to graphs.mozilla.org and graphs.allizom.org

This SQL command adds a ".n" but per https://bug783660.bugzilla.mozilla.org/attachment.cgi?id=652881 I don't see ".n" used.

Unless I'm missing something this is wrong.

Also, yes we need to commit the sql to the graphs hg repo, both for this slave and the patch I just cited

	Justin Wood (:Callek)
	Comment 9 • 12 years ago

Comment on attachment 656048 [details]
add talos-mtnlion-r5-022 slave to sql/data.sql' on the default branch of http://hg.mozilla.org/graphs

THIS statement should be good/fine to run

	Sheeri Cabral [:sheeri]
	Comment 10 • 12 years ago

from IRC:

[13:24:05] <Callek> sheeri: https://bugzilla.mozilla.org/attachment.cgi?id=656048 should be fine to run, but its a different attachment than what was called out there ;-)

	Kim Moir [:kmoir] ET Assignee
	Comment 11 • 12 years ago

this one was the wrong file, multitasking fail on my part

	Kim Moir [:kmoir] ET Assignee
	Comment 12 • 12 years ago

I've disabled this slave until the graphing server issue is fixed.

	Dustin J. Mitchell [:dustin] (he/him)
	Comment 13 • 12 years ago

(In reply to Justin Wood (:Callek) from comment #9)
> Comment on attachment 656048 [details]
> add talos-mtnlion-r5-022 slave to sql/data.sql' on the default branch of
> http://hg.mozilla.org/graphs
> 
> THIS statement should be good/fine to run

done.

	Justin Wood (:Callek)
	Comment 14 • 12 years ago

we still need these slaves added to the hg file.

Also, dustin: kim alluded to you claiming we needed ".n" in the slave entries for mtnlion as well. Is that correct, do you know, etc?

	Dustin J. Mitchell [:dustin] (he/him)
	Comment 15 • 12 years ago

I have no idea.  I assumed that was a typo.  I never had anything to do with graphserver updates as a relenger, nor as a relopsiang.  I'm only here as an apprentice DBA running queries.

	Sheeri Cabral [:sheeri]
	Comment 16 • 12 years ago

We DBAs claim nothing. You give us SQL statements, we run them. We don't make editorial comments unless there's an obvious error or if the statement fails.

From my point of view, all the DBA work is done here, so I'm reassigning to you, and you should probably change the component (unless you realize there's more DBA work).

	Kim Moir [:kmoir] ET Assignee
	Comment 17 • 12 years ago

Closing, the 022 slave is writing to the database successfully.