If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

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

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
5 years ago
3 years ago

People

(Reporter: jmaher, Unassigned)

Tracking

Details

(Reporter)

Description

5 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());
Added into graphs stage and prod.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
(Reporter)

Comment 2

5 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;
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)
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.
(Reporter)

Comment 5

5 years ago
thanks!
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.