Closed Bug 822280 Opened 12 years ago Closed 12 years ago

add graph server sql definitions for new pandas to graphs.mozilla.org and graphs.allizom.org

Tracking

(Not tracked)

Status:

RESOLVED FIXED

People

(Reporter: jmaher, Unassigned)

References

Details

Joel Maher ( :jmaher ) (UTC -8)

Reporter

Description

•

12 years ago

as per bug 822248 we need to add definitions to the graph server (and staging server) to support the full pool of panda boards.

Here is the sql:
insert into machines values (NULL,25,0,1.0,"panda-0462",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0463",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0464",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0465",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0466",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0467",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0468",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0469",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0470",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0471",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0472",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0473",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0474",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0475",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0476",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0477",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0478",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0479",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0480",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0481",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0482",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0483",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0484",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0485",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0486",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0487",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0488",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0489",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0490",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0491",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0492",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0493",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0494",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0495",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0496",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0497",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0498",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0499",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0500",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0501",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0502",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0503",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0504",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0505",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0506",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0507",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0508",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0509",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0510",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0511",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0512",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0513",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0514",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0515",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0516",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0517",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0518",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0519",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0520",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0521",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0522",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0523",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0524",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0525",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0526",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0527",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0528",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0529",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0530",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0531",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0532",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0533",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0534",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0535",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0536",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0537",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0538",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0539",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0540",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0541",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0542",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0543",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0544",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0545",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0546",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0547",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0548",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0549",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0550",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0551",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0552",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0553",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0554",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0555",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0556",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0557",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0558",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0559",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0560",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0561",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0562",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0563",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0564",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0565",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0566",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0567",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0568",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0569",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0570",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0571",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0572",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0573",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0574",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0575",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0576",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0577",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0578",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0579",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0580",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0581",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0582",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0583",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0584",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0585",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0586",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0587",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0588",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0589",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0590",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0591",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0592",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0593",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0594",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0595",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0596",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0597",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0598",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0599",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0600",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0601",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0602",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0603",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0604",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0605",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0606",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0607",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0608",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0609",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0610",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0611",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0612",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0613",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0614",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0615",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0616",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0617",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0618",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0619",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0620",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0621",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0622",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0623",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0624",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0625",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0626",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0627",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0628",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0629",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0630",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0631",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0632",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0633",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0634",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0635",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0636",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0637",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0638",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0639",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0640",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0641",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0642",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0643",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0644",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0645",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0646",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0647",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0648",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0649",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0650",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0651",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0652",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0653",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0654",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0655",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0656",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0657",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0658",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0659",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0660",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0661",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0662",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0663",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0664",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0665",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0666",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0667",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0668",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0669",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0670",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0671",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0672",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0673",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0674",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0675",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0676",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0677",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0678",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0679",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0680",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0681",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0682",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0683",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0684",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0685",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0686",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0687",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0688",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0689",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0690",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0691",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0692",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0693",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0694",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0695",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0696",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0697",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0698",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0699",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0700",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0701",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0702",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0703",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0704",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0705",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0706",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0707",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0708",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0709",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0710",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0711",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0712",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0713",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0714",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0715",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0716",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0717",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0718",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0719",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0720",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0721",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0722",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0723",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0724",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0725",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0726",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0727",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0728",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0729",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0730",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0731",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0732",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0733",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0734",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0735",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0736",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0737",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0738",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0739",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0740",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0741",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0742",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0743",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0744",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0745",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0746",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0747",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0748",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0749",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0750",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0751",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0752",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0753",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0754",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0755",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0756",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0757",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0758",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0759",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0760",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0761",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0762",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0763",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0764",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0765",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0766",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0767",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0768",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0769",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0770",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0771",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0772",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0773",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0774",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0775",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0776",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0777",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0778",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0779",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0780",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0781",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0782",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0783",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0784",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0785",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0786",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0787",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0788",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0789",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0790",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0791",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0792",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0793",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0794",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0795",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0796",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0797",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0798",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0799",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0800",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0801",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0802",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0803",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0804",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0805",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0806",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0807",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0808",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0809",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0810",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0811",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0812",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0813",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0814",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0815",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0816",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0817",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0818",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0819",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0820",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0821",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0822",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0823",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0824",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0825",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0826",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0827",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0828",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0829",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0830",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0831",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0832",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0833",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0834",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0835",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0836",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0837",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0838",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0839",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0840",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0841",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0842",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0843",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0844",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0845",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0846",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0847",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0848",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0849",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0850",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0851",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0852",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0853",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0854",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0855",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0856",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0857",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0858",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0859",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0860",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0861",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0862",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0863",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0864",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0865",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0866",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0867",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0868",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0869",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0870",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0871",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0872",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0873",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0874",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0875",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0876",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0877",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0878",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0879",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0880",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0881",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0882",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0883",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0884",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0885",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0886",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0887",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0888",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0889",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0890",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0891",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0892",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0893",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0894",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0895",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0896",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0897",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0898",1,unix_timestamp());
insert into machines values (NULL,25,0,1.0,"panda-0899",1,unix_timestamp());

Sheeri Cabral [:sheeri]

Comment 1

•

12 years ago

Added into graphs stage and prod.

Status: NEW → RESOLVED

Closed: 12 years ago

Resolution: --- → FIXED

Joel Maher ( :jmaher ) (UTC -8)

Reporter

Comment 2

•

12 years ago

We have an instance where a test failed because it couldn't find the name panda-0834.

Can we ensure these were applied correctly to graphs.mozilla.org:
select * from machines where name='panda-0834';
select count(id) from machines where os_id=25;

Sheeri Cabral [:sheeri]

Comment 3

•

12 years ago

stage:

mysql> select * from machines where name='panda-0834';
+------+-------+---------------+-----------+------------+-----------+------------+
| id   | os_id | is_throttling | cpu_speed | name       | is_active | date_added |
+------+-------+---------------+-----------+------------+-----------+------------+
| 3757 |    25 |             0 | 1.0       | panda-0834 |         1 | 1355760924 |
+------+-------+---------------+-----------+------------+-----------+------------+
1 row in set (0.02 sec)

mysql> select count(id) from machines where os_id=25;
+-----------+
| count(id) |
+-----------+
|       898 |
+-----------+
1 row in set (0.07 sec)

prod:

mysql> select * from machines where name='panda-0834';
Empty set (0.00 sec)

mysql> select count(id) from machines where os_id=25;
+-----------+
| count(id) |
+-----------+
|       884 |
+-----------+
1 row in set (0.00 sec)

Sheeri Cabral [:sheeri]

Comment 4

•

12 years ago

I have re-run the SQL, lots of duplicate keys, but now in prod:

mysql> select * from machines where name='panda-0834';
+------+-------+---------------+-----------+------------+-----------+------------+
| id   | os_id | is_throttling | cpu_speed | name       | is_active | date_added |
+------+-------+---------------+-----------+------------+-----------+------------+
| 6377 |    25 |             0 | 1.0       | panda-0834 |         1 | 1356117751 |
+------+-------+---------------+-----------+------------+-----------+------------+
1 row in set (0.00 sec)

mysql> select count(id) from machines where os_id=25;
+-----------+
| count(id) |
+-----------+
|       898 |
+-----------+
1 row in set (0.00 sec)

So the count now matches.

Joel Maher ( :jmaher ) (UTC -8)

Reporter

Comment 5

•

12 years ago

thanks!

Nobody; OK to take it and work on it

Updated

•

10 years ago

Product: mozilla.org → Data & BI Services Team

You need to log in before you can comment on or make changes to this bug.

Bugzilla

Quick Search

add graph server sql definitions for new pandas to graphs.mozilla.org and graphs.allizom.org

Categories

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

Tracking

(Not tracked)

People

(Reporter: jmaher, Unassigned)

References

Details

Crash Data

Security

(public)

User Story

Description

Comment 1

Comment 2

Comment 3

Comment 4

Comment 5

Updated