Closed
Bug 1013035
Opened 10 years ago
Closed 10 years ago
scl1 Move Train A releng config Work
Categories
(Infrastructure & Operations Graveyard :: CIDuty, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: Callek, Assigned: Callek)
References
()
Details
Attachments
(2 files)
please cross check this
Attachment #8425210 -
Flags: review?(hwine)
|
Assignee | |
Comment 1•10 years ago
|
||
Per Bug 985625 (c#5), the following SQL was created. n-i to :hwine for review.
(I used the following python first to generate it -- tmp.txt was generated by copying first two columns of each sheet at https://docs.google.com/a/mozilla.com/spreadsheets/d/1QuB69Aor4YK9TWeBKWRtgGF8i_PZfXmL8uAnneqaw74/edit#gid=66084899 into a text file, my paste did \t delims, but wanted space to work)
import re
pat = re.compile('[\t ]')
with open("C://Sources/tmp.txt") as f:
for line in f:
parts = pat.split(line.strip())
print "Update slaves s JOIN datacenters dc on dc.name='scl3' \\"
print " set s.dcid = dc.dcid, s.name='%s' \\" % parts[0].split('.')[0]
print " where s.name = '%s';" % parts[1].split('.')[0]
# For graphs server
print "=================="
print "= for graphs ="
print "=================="
with open("C://Sources/tmp.txt") as f:
for line in f:
====
The SQL is:
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-002' \
where s.name = 'b-linux64-hp-0002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-003' \
where s.name = 'b-linux64-hp-0003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-004' \
where s.name = 'b-linux64-hp-0004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-005' \
where s.name = 'b-linux64-hp-0005';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-006' \
where s.name = 'b-linux64-hp-0006';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-centos6-hp-001' \
where s.name = 'b-linux64-hp-0020';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-centos6-hp-002' \
where s.name = 'b-linux64-hp-0021';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-centos6-hp-003' \
where s.name = 'b-linux64-hp-0022';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-centos6-hp-004' \
where s.name = 'b-linux64-hp-0023';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-centos6-hp-005' \
where s.name = 'b-linux64-hp-0024';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-linux64-ix-028' \
where s.name = 'b-linux64-ix-0002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-linux64-ix-029' \
where s.name = 'b-linux64-ix-0003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='bld-linux64-ix-030' \
where s.name = 'b-linux64-ix-0004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave03' \
where s.name = 'b-2008-ix-0018';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave41' \
where s.name = 'b-2008-ix-0020';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave44' \
where s.name = 'b-2008-ix-0021';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave45' \
where s.name = 'b-2008-ix-0022';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave46' \
where s.name = 'b-2008-ix-0023';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave47' \
where s.name = 'b-2008-ix-0024';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave48' \
where s.name = 'b-2008-ix-0025';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave49' \
where s.name = 'b-2008-ix-0026';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave50' \
where s.name = 'b-2008-ix-0027';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave51' \
where s.name = 'b-2008-ix-0028';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave52' \
where s.name = 'b-2008-ix-0029';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave32' \
where s.name = 'b-2008-ix-0173';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave33' \
where s.name = 'b-2008-ix-0174';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave34' \
where s.name = 'b-2008-ix-0175';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave06' \
where s.name = 'b-2008-ix-0065';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave07' \
where s.name = 'b-2008-ix-0066';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave08' \
where s.name = 'b-2008-ix-0067';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave09' \
where s.name = 'b-2008-ix-0068';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave10' \
where s.name = 'b-2008-ix-0069';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave11' \
where s.name = 'b-2008-ix-0070';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave12' \
where s.name = 'b-2008-ix-0071';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave13' \
where s.name = 'b-2008-ix-0072';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave14' \
where s.name = 'b-2008-ix-0073';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave15' \
where s.name = 'b-2008-ix-0074';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave16' \
where s.name = 'b-2008-ix-0075';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave17' \
where s.name = 'b-2008-ix-0076';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave18' \
where s.name = 'b-2008-ix-0077';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave19' \
where s.name = 'b-2008-ix-0078';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave20' \
where s.name = 'b-2008-ix-0079';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave21' \
where s.name = 'b-2008-ix-0080';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave22' \
where s.name = 'b-2008-ix-0081';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave23' \
where s.name = 'b-2008-ix-0082';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave24' \
where s.name = 'b-2008-ix-0083';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave25' \
where s.name = 'b-2008-ix-0084';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave26' \
where s.name = 'b-2008-ix-0085';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave27' \
where s.name = 'b-2008-ix-0086';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave28' \
where s.name = 'b-2008-ix-0087';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave29' \
where s.name = 'b-2008-ix-0088';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave156' \
where s.name = 'b-2008-ix-0161';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave145' \
where s.name = 'b-2008-ix-0162';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave146' \
where s.name = 'b-2008-ix-0163';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='w64-ix-slave147' \
where s.name = 'b-2008-ix-0164';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-002' \
where s.name = 't-snow-r4-0002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-003' \
where s.name = 't-snow-r4-0003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-004' \
where s.name = 't-snow-r4-0004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-005' \
where s.name = 't-snow-r4-0005';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-006' \
where s.name = 't-snow-r4-0006';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-007' \
where s.name = 't-snow-r4-0007';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-008' \
where s.name = 't-snow-r4-0008';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-009' \
where s.name = 't-snow-r4-0009';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-010' \
where s.name = 't-snow-r4-0010';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-011' \
where s.name = 't-snow-r4-0011';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-012' \
where s.name = 't-snow-r4-0012';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-013' \
where s.name = 't-snow-r4-0013';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-014' \
where s.name = 't-snow-r4-0014';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-015' \
where s.name = 't-snow-r4-0015';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-016' \
where s.name = 't-snow-r4-0016';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-017' \
where s.name = 't-snow-r4-0017';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-018' \
where s.name = 't-snow-r4-0018';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-019' \
where s.name = 't-snow-r4-0019';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-020' \
where s.name = 't-snow-r4-0020';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-021' \
where s.name = 't-snow-r4-0021';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-022' \
where s.name = 't-snow-r4-0022';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-023' \
where s.name = 't-snow-r4-0023';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-024' \
where s.name = 't-snow-r4-0024';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-025' \
where s.name = 't-snow-r4-0025';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-026' \
where s.name = 't-snow-r4-0026';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-027' \
where s.name = 't-snow-r4-0027';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-028' \
where s.name = 't-snow-r4-0028';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-029' \
where s.name = 't-snow-r4-0029';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-031' \
where s.name = 't-snow-r4-0030';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-032' \
where s.name = 't-snow-r4-0031';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-033' \
where s.name = 't-snow-r4-0032';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-034' \
where s.name = 't-snow-r4-0033';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-035' \
where s.name = 't-snow-r4-0034';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-036' \
where s.name = 't-snow-r4-0035';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-037' \
where s.name = 't-snow-r4-0036';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-038' \
where s.name = 't-snow-r4-0037';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-039' \
where s.name = 't-snow-r4-0038';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-040' \
where s.name = 't-snow-r4-0039';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='talos-r4-snow-042' \
where s.name = 't-snow-r4-0040';
Flags: needinfo?(hwine)
|
|
Assignee | |
Comment 2•10 years ago
|
||
Someone will also have to do graph server additions ala Bug 985625 c#16 (help welcome for that sql)
|
||
Comment 3•10 years ago
|
||
(In reply to Justin Wood (:Callek) from comment #1)
> Per Bug 985625 (c#5), the following SQL was created. n-i to :hwine for
> review.
>
> (I used the following python first to generate it -- tmp.txt was generated
> by copying first two columns of each sheet at
> https://docs.google.com/a/mozilla.com/spreadsheets/d/
> 1QuB69Aor4YK9TWeBKWRtgGF8i_PZfXmL8uAnneqaw74/edit#gid=66084899 into a text
> file, my paste did \t delims, but wanted space to work)
fyi, you can also do a file->download->as csv.
> Update slaves s JOIN datacenters dc on dc.name='scl3' \
> set s.dcid = dc.dcid, s.name='talos-r4-snow-042' \
> where s.name = 't-snow-r4-0040';
Isn't this backwards?
- The old name is 'talos-*', and should be used in the where clause.
- The new name 't-*' should be used in the set clause.
fwiw, the newlines don't need to be backslash escaped -- the sql statement doesn't end until the semi-colon (';').
Flags: needinfo?(hwine)
|
|
Assignee | |
Comment 4•10 years ago
|
||
(In reply to Hal Wine [:hwine] (use needinfo) from comment #3)
> (In reply to Justin Wood (:Callek) from comment #1)
> fyi, you can also do a file->download->as csv.
Yep, but then I get headers and I have to do that seperately for each sheet (and I get extra columns) this was easier for me ;-)
> > Update slaves s JOIN datacenters dc on dc.name='scl3' \
> > set s.dcid = dc.dcid, s.name='talos-r4-snow-042' \
> > where s.name = 't-snow-r4-0040';
>
> Isn't this backwards?
> - The old name is 'talos-*', and should be used in the where clause.
> - The new name 't-*' should be used in the set clause.
You're absolutely right, fixed (pasting new python and SQL for completeness below)
> fwiw, the newlines don't need to be backslash escaped -- the sql statement
> doesn't end until the semi-colon (';').
You're indeed right here, but I felt better explicit than implicit for sanity!
import re
pat = re.compile('[\t ]')
with open("C://Sources/tmp.txt") as f:
for line in f:
parts = pat.split(line.strip())
print "Update slaves s JOIN datacenters dc on dc.name='scl3' \\"
print " set s.dcid = dc.dcid, s.name='%s' \\" % parts[1].split('.')[0]
print " where s.name = '%s';" % parts[0].split('.')[0]
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0002' \
where s.name = 'b-linux64-hp-002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0003' \
where s.name = 'b-linux64-hp-003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0004' \
where s.name = 'b-linux64-hp-004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0005' \
where s.name = 'b-linux64-hp-005';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0006' \
where s.name = 'b-linux64-hp-006';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0020' \
where s.name = 'bld-centos6-hp-001';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0021' \
where s.name = 'bld-centos6-hp-002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0022' \
where s.name = 'bld-centos6-hp-003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0023' \
where s.name = 'bld-centos6-hp-004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-hp-0024' \
where s.name = 'bld-centos6-hp-005';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-ix-0002' \
where s.name = 'bld-linux64-ix-028';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-ix-0003' \
where s.name = 'bld-linux64-ix-029';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-linux64-ix-0004' \
where s.name = 'bld-linux64-ix-030';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0018' \
where s.name = 'w64-ix-slave03';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0020' \
where s.name = 'w64-ix-slave41';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0021' \
where s.name = 'w64-ix-slave44';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0022' \
where s.name = 'w64-ix-slave45';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0023' \
where s.name = 'w64-ix-slave46';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0024' \
where s.name = 'w64-ix-slave47';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0025' \
where s.name = 'w64-ix-slave48';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0026' \
where s.name = 'w64-ix-slave49';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0027' \
where s.name = 'w64-ix-slave50';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0028' \
where s.name = 'w64-ix-slave51';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0029' \
where s.name = 'w64-ix-slave52';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0173' \
where s.name = 'w64-ix-slave32';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0174' \
where s.name = 'w64-ix-slave33';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0175' \
where s.name = 'w64-ix-slave34';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0065' \
where s.name = 'w64-ix-slave06';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0066' \
where s.name = 'w64-ix-slave07';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0067' \
where s.name = 'w64-ix-slave08';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0068' \
where s.name = 'w64-ix-slave09';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0069' \
where s.name = 'w64-ix-slave10';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0070' \
where s.name = 'w64-ix-slave11';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0071' \
where s.name = 'w64-ix-slave12';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0072' \
where s.name = 'w64-ix-slave13';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0073' \
where s.name = 'w64-ix-slave14';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0074' \
where s.name = 'w64-ix-slave15';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0075' \
where s.name = 'w64-ix-slave16';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0076' \
where s.name = 'w64-ix-slave17';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0077' \
where s.name = 'w64-ix-slave18';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0078' \
where s.name = 'w64-ix-slave19';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0079' \
where s.name = 'w64-ix-slave20';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0080' \
where s.name = 'w64-ix-slave21';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0081' \
where s.name = 'w64-ix-slave22';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0082' \
where s.name = 'w64-ix-slave23';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0083' \
where s.name = 'w64-ix-slave24';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0084' \
where s.name = 'w64-ix-slave25';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0085' \
where s.name = 'w64-ix-slave26';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0086' \
where s.name = 'w64-ix-slave27';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0087' \
where s.name = 'w64-ix-slave28';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0088' \
where s.name = 'w64-ix-slave29';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0161' \
where s.name = 'w64-ix-slave156';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0162' \
where s.name = 'w64-ix-slave145';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0163' \
where s.name = 'w64-ix-slave146';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='b-2008-ix-0164' \
where s.name = 'w64-ix-slave147';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0002' \
where s.name = 'talos-r4-snow-002';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0003' \
where s.name = 'talos-r4-snow-003';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0004' \
where s.name = 'talos-r4-snow-004';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0005' \
where s.name = 'talos-r4-snow-005';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0006' \
where s.name = 'talos-r4-snow-006';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0007' \
where s.name = 'talos-r4-snow-007';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0008' \
where s.name = 'talos-r4-snow-008';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0009' \
where s.name = 'talos-r4-snow-009';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0010' \
where s.name = 'talos-r4-snow-010';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0011' \
where s.name = 'talos-r4-snow-011';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0012' \
where s.name = 'talos-r4-snow-012';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0013' \
where s.name = 'talos-r4-snow-013';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0014' \
where s.name = 'talos-r4-snow-014';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0015' \
where s.name = 'talos-r4-snow-015';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0016' \
where s.name = 'talos-r4-snow-016';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0017' \
where s.name = 'talos-r4-snow-017';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0018' \
where s.name = 'talos-r4-snow-018';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0019' \
where s.name = 'talos-r4-snow-019';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0020' \
where s.name = 'talos-r4-snow-020';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0021' \
where s.name = 'talos-r4-snow-021';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0022' \
where s.name = 'talos-r4-snow-022';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0023' \
where s.name = 'talos-r4-snow-023';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0024' \
where s.name = 'talos-r4-snow-024';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0025' \
where s.name = 'talos-r4-snow-025';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0026' \
where s.name = 'talos-r4-snow-026';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0027' \
where s.name = 'talos-r4-snow-027';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0028' \
where s.name = 'talos-r4-snow-028';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0029' \
where s.name = 'talos-r4-snow-029';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0030' \
where s.name = 'talos-r4-snow-031';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0031' \
where s.name = 'talos-r4-snow-032';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0032' \
where s.name = 'talos-r4-snow-033';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0033' \
where s.name = 'talos-r4-snow-034';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0034' \
where s.name = 'talos-r4-snow-035';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0035' \
where s.name = 'talos-r4-snow-036';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0036' \
where s.name = 'talos-r4-snow-037';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0037' \
where s.name = 'talos-r4-snow-038';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0038' \
where s.name = 'talos-r4-snow-039';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0039' \
where s.name = 'talos-r4-snow-040';
Update slaves s JOIN datacenters dc on dc.name='scl3' \
set s.dcid = dc.dcid, s.name='t-snow-r4-0040' \
where s.name = 'talos-r4-snow-042';
|
|
||
Comment 5•10 years ago
|
||
Comment on attachment 8425210 [details] [diff] [review]
[configs] move-train-A
Review of attachment 8425210 [details] [diff] [review]:
-----------------------------------------------------------------
Missing linux build thunderbird (bld-centos6-hp-00[1-5] => b-linux64-hp-002[0-4])
::: mozilla/production_config.py
@@ -7,1 @@
> ['w64-ix-slave%03i' % x for x in range(100,110) + range(111,158)] + \
w64-ix-slaves 145-147, 156 now gone
@@ -14,1 @@
> ['b-linux64-ix-%04d' % x for x in range(1, 12)]
The new linux build host names include b-linux64-ix-000[234] - old conf in error?
@@ -41,2 @@
> ['w64-ix-slave%03i' % x for x in [110] + range(159,171)] + \
> - ['b-2008-ix-%04i' % x for x in range(18, 65) + range(173,15)] + \
New names include 18, 20-29 - old conf in error?
Attachment #8425210 -
Flags: review?(hwine) → review-
|
|
Assignee | |
Comment 6•10 years ago
|
||
Comment on attachment 8425210 [details] [diff] [review]
[configs] move-train-A
Review of attachment 8425210 [details] [diff] [review]:
-----------------------------------------------------------------
::: mozilla/production_config.py
@@ -7,1 @@
> ['w64-ix-slave%03i' % x for x in range(100,110) + range(111,158)] + \
I chose to not muddy up range()'s if there were just a few machines going away. But when an endpoint moves or a whole range is eliminated to remove it.
I'm arguing for *attempted* clarity here. Of course the alternative muddy them up now for an easier clean later may be indeed the better choice. what-say-you?
@@ -14,1 @@
> ['b-linux64-ix-%04d' % x for x in range(1, 12)]
I think I added 0002->0012 the first time around when we tested the individual hosts
@@ -41,2 @@
> ['w64-ix-slave%03i' % x for x in [110] + range(159,171)] + \
> - ['b-2008-ix-%04i' % x for x in range(18, 65) + range(173,15)] + \
same answer as b-linux64 above
|
|
||
Comment 7•10 years ago
|
||
Comment on attachment 8425210 [details] [diff] [review]
[configs] move-train-A
The extra hosts configured will never be used, as they will never be enabled in slave alloc. Therefore, config is fail safe w.r.t. extra hosts, and clarity > perfection. wfm!
Attachment #8425210 -
Flags: review- → review+
|
||
Comment 8•10 years ago
|
||
Attachment #8426259 -
Flags: review?(hwine)
|
|
||
Comment 9•10 years ago
|
||
Comment on attachment 8426259 [details]
Update hostnames moving on train A in the graphserver
correct # hosts, old->new direction correct; lgtm
Attachment #8426259 -
Attachment is patch: false
Attachment #8426259 -
Flags: review?(hwine) → review+
|
|
||
Comment 10•10 years ago
|
||
Comment on attachment 8426259 [details]
Update hostnames moving on train A in the graphserver
applied to both staging and production graph server databases.
|
|
||
Comment 11•10 years ago
|
||
I've run the slavealloc update SQL from comment #4 and am starting to move the slaves back into production.
|
|
||
Comment 12•10 years ago
|
||
found last minute flow issue for linux boxen -> cruncher:80 - see bug 1014221
|
|
||
Comment 13•10 years ago
|
||
Only outstanding issue from yesterday:
* t-snow-r4-002[2-4] are up, but are not allowing pubkey auth, and aren't accepting known passwords for cltbld
** inventory PDU entries for these slaves are wrong
*** pdu1.201-10.ops.releng.scl3.mozilla.com <- current
*** pdu1.r201-10.ops.releng.scl3.mozilla.com <- should be
|
||
Comment 14•10 years ago
|
||
And 0040 didn't get properly introduced to graphserver, bug 770902.
|
|
||
Comment 15•10 years ago
|
||
(In reply to Phil Ringnalda (:philor) from comment #14)
> And 0040 didn't get properly introduced to graphserver, bug 770902.
Fixed in production and staging, and re-enabled.
|
|
Assignee | |
Comment 16•10 years ago
|
||
Something here went live today
|
||
Updated•10 years ago
|
|
|
||
Comment 17•10 years ago
|
||
Everything is done for train A
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
|
||
Updated•6 years ago
|
Component: Platform Support → Buildduty
Product: Release Engineering → Infrastructure & Operations
|
||
Updated•5 years ago
|
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•