689232 - run the sql on Graphs and Graphs-stage to add new tegras to the tables

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Mike Taylor [:bear]]

Attachment: sql to insert into graphs and graphs-stage

We need to add the new tegras to the graph server table, attached is the sql to insert

thanks

Comment 1

[Aki Sasaki (not active)]

Do you know when this might be done?
We missed doing this before rolling out the new tegras, so these are currently burning production test runs.
If this can be done today, awesome; if not, we might need to disable the new tegras.

Comment 2

[John O'Duinn [:joduinn] (please use "needinfo?" flag)]

cshields/justdave: do you have an ETA when this could be done? 

(To stop these new tegras continuing to burn the trees, we've had to take them out of production until this SQL patch is landed. And yes, it was our bad for not filing this bug earlier when we were setting up the machines - sorry - we'll do better with the next batch.)

Comment 3

[John O'Duinn [:joduinn] (please use "needinfo?" flag)]

(In reply to John O'Duinn [:joduinn] from comment #2)
> cshields/justdave: do you have an ETA when this could be done? 

Raising to blocker, as this blocks us deploying ~40 tegras into production, to improve our bad-tegra-wait-times. 



> (To stop these new tegras continuing to burn the trees, we've had to take
> them out of production until this SQL patch is landed. And yes, it was our
> bad for not filing this bug earlier when we were setting up the machines -
> sorry - we'll do better with the next batch.)

Comment 4

[Dustin J. Mitchell [:dustin] (he/him)]

I'll get someone on this as soon as possible.  Folks are busy dealing with the mtv1 downtime.

Comment 5

[Mike Taylor [:bear]]

Attachment: sql to insert into graphs and graphs-stage

Comment 6

[Dave Miller [:justdave]]

We're apparently missing this component on the list nagios checks to page people about blockers, so it never paged.  I'll get that fixed.  In the mean time, I'm on this.

Comment 7

[Dave Miller [:justdave]]

Done.

Comment 8

[Dave Miller [:justdave]]

This reminds me of bug 505803 ....   :)