Closed Bug 782783 Opened 13 years ago Closed 12 years ago

apply database changes needed to support new tegras to graphs.mozilla.org and graphs.allizom.org

Categories

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

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
ARM
Android
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: jmaher, Assigned: scabral)

References

Details

I will paste the raw sql that we need to insert into both graphs.mozilla.org and graphs.allizom.org. There are 122 inserts we need to do.
insert into machines values (NULL,20,0,1.0,"tegra-289.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-290.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-291.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-292.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-293.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-294.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-295.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-296.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-297.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-298.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-299.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-300.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-301.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-302.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-303.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-304.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-305.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-306.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-307.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-308.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-309.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-310.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-311.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-312.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-313.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-314.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-315.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-316.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-317.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-318.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-319.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-320.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-321.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-322.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-323.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-324.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-325.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-326.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-327.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-328.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-329.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-330.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-331.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-332.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-333.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-334.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-335.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-336.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-337.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-338.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-339.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-340.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-341.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-342.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-343.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-344.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-345.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-346.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-347.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-348.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-349.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-350.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-351.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-352.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-353.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-354.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-355.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-356.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-357.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-358.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-359.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-360.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-289",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-290",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-291",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-292",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-293",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-294",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-295",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-296",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-297",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-298",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-299",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-300",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-301",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-302",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-303",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-304",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-305",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-306",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-307",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-308",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-309",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-310",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-311",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-312",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-313",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-314",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-315",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-316",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-317",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-318",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-319",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-320",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-321",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-322",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-323",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-324",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-325",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-326",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-327",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-328",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-329",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-330",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-331",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-332",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-333",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-334",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-335",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-336",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-337",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-338",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-339",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-340",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-341",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-342",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-343",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-344",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-345",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-346",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-347",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-348",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-349",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-350",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-351",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-352",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-353",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-354",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-355",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-356",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-357",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-358",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-359",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-360",1,unix_timestamp());
Done on stage and prod.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
thanks for getting this done fast! I appreciate the quick turnaround.
we missed a few, pasting SQL for it momentarily
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
insert into machines values (NULL,20,0,1.0,"tegra-361.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-361",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-362.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-362",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-363.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-363",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-364.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-364",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-365.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-365",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-366.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-366",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-367.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-367",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-368.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-368",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-369.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-369",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-370.n",1,unix_timestamp()); insert into machines values (NULL,20,0,1.0,"tegra-370",1,unix_timestamp());
the SQL in Comment 5 has been applied to stage and production.
Assignee: server-ops-database → scabral
Status: REOPENED → RESOLVED
Closed: 13 years ago → 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.