695994 - Please run this sql on production and staging graphserver database

Status: RESOLVED FIXED

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

Description

[John Ford [:jhford] CET/CEST Berlin Time]

Attachment: graphserver sql

Please run the attached sql on the production and staging graphserver.

Please also run *only on staging*:
insert into machines values (NULL,22,0,"2.4","lion-testing1",1,unix_timestamp());
insert into machines values (NULL,22,0,"2.4","lion-testing2",1,unix_timestamp());
insert into machines values (NULL,22,0,"2.4","lion-testing3",1,unix_timestamp());

These are temporary machines that I don't plan to ever put into production.

Comment 1

[Matt Pressman [:mpressman]]

graphserver.sql ran on staging and prod successfully

additional three inserts from bug description ran on staging successfully

Comment 2

[John Ford [:jhford] CET/CEST Berlin Time]

I am still having machines complaining about the three lion-testingX machines.

RETURN:send failed, graph server says:
RETURN:No machine_name called 'lion-testing1' can be found

Can you please verify that these machines were added to the graphs staging db?

Comment 3

[Ashish Vijayaram [:ashish]]

Oddly, stage never had the corresponding rows. Redid sourcing the sql. Verified with :jhford on irc.