Closed Bug 784330 Opened 12 years ago Closed 12 years ago

apply database changes needed to support new 10.8 slaves to 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:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: kmoir, Assigned: scabral)

References

Details

Attachments

(1 file)

patch
(deleted), patch
Details | Diff | Splinter Review
This the sql that needss to be added nsert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-001.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-002.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-003.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-004.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-005.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-006.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-007.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-008.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-009.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-010.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-011.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-012.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-013.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-014.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-015.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-016.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-017.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-018.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-019.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-020.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-021.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-024.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-023.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-024.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-025.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-026.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-027.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-028.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-029.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-030.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-031.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-032.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-033.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-034.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-035.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-036.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-037.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-038.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-039.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-040.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-041.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-042.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-043.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-044.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-045.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-046.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-047.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-048.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-049.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-050.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-051.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-052.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-053.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-054.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-055.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-056.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-057.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-058.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-059.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-060.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-061.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-062.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-063.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-064.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-065.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-066.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-067.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-068.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-069.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-070.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-071.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-072.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-073.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-074.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-075.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-076.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-077.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-078.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-079.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-080.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-081.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-082.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-083.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-084.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-085.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-086.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-087.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-088.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-089.n",1,unix_timestamp()); insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-090.n",1,unix_timestamp());
sorry wrong bucket initially
Assignee: nobody → server-ops
Product: Mozilla Messaging → mozilla.org
QA Contact: jdow
Assignee: server-ops → server-ops-database
Component: Server Operations → Server Operations: Database
QA Contact: jdow → cshields
Blocks: 731278
Attached patch patch (deleted) — — Splinter Review
Ignore the patch in comment 1, there was one typo, this patch should be used to add them.
FWIW I prefer the patches as attachments (so comment 2 was great). On production, everything went fine except for one insert: mysql> insert into machines values (NULL,24,0,"2.0","talos-mtnlion-r5-024.n",1,unix_timestamp()); ERROR 1062 (23000): Duplicate entry 'talos-mtnlion-r5-024.n' for key 'name' There were no issues on stage.
Assignee: server-ops-database → scabral
Status: NEW → RESOLVED
Closed: 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.

Attachment

General

Creator:
Created:
Updated:
Size: