Closed Bug 1013035 Opened 10 years ago Closed 10 years ago

scl1 Move Train A releng config Work

Categories

(Infrastructure & Operations Graveyard :: CIDuty, task)

Product:
Infrastructure & Operations Graveyard
Component:
CIDuty
Platform:
x86_64
Windows 7
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: Callek, Assigned: Callek)

References

(
URL
)

Details

Attachments

(2 files)

[configs] move-train-A
3.51 KB, patch
hwine
: review+
Details | Diff | Splinter Review
Update hostnames moving on train A in the graphserver
6.28 KB, text/plain
hwine
: review+
Details 
please cross check this
Attachment #8425210 - Flags: review?(hwine)
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)
Someone will also have to do graph server additions ala Bug 985625 c#16 (help welcome for that sql)
(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)
(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 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-
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 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 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 on attachment 8426259 [details]
Update hostnames moving on train A in the graphserver

applied to both staging and production graph server databases.
I've run the slavealloc update SQL from comment #4 and am starting to move the slaves back into production.
found last minute flow issue for linux boxen -> cruncher:80 - see bug 1014221
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
And 0040 didn't get properly introduced to graphserver, bug 770902.
(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.
Depends on: 1011542
Something here went live today
Everything is done for train A
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Component: Platform Support → Buildduty
Product: Release Engineering → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: