947000 - Move day details for tegras/foopies/web-servers from mtv1 to scl3

Status: RESOLVED FIXED

(Release Engineering :: General, defect)

Description

[Hal Wine [:hwine] use NI!]

Using a bug, instead of etherpad, for now to capture all the coordination that will happen on move day between the 4 (or more) teams.

Comment 1

[Justin Wood (:Callek)]

So the info for releng details:

T+0 (start of window) - checkin patches from Bug 958140
T+0 (start of window) - merge puppet to production for Bug 958140
T+? (foopies are all up) - use fabric to update foopies `manage_foopies.py -H all update`
T+? (tegras suspected to be up) - use fabric to create dirs `manage_foopies.py -H all create_device_dirs`
*** this is from 
T+trees-open - Update slavealloc for new info on tegras (scl3 DC, etc)

:hal, can you think of anything missing? Any questions?

Comment 2

[Hal Wine [:hwine] use NI!]

(In reply to Justin Wood (:Callek) from comment #1)
> T+trees-open - Update slavealloc for new info on tegras (scl3 DC, etc)

a) why do we have to wait for tree open?
b) is there a sql file for this?

Comment 3

[Amy Rich [:arr] [:arich]]

Move complete.

Comment 4

[Justin Wood (:Callek)]

(In reply to Hal Wine [:hwine] (use needinfo) from comment #2)
> (In reply to Justin Wood (:Callek) from comment #1)
> > T+trees-open - Update slavealloc for new info on tegras (scl3 DC, etc)
> 
> a) why do we have to wait for tree open?

We didn't but it curbed additional headspace during closure. This was merely a non-canonical data source improvement for us.

> b) is there a sql file for this?

No, but I did it with the following and r+ from jhopkins on IRC:


mysql> describe slaves;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| slaveid          | int(11)      | NO   | PRI | NULL    | auto_increment |
| name             | varchar(128) | NO   | UNI | NULL    |                |
| distroid         | int(11)      | NO   | MUL | NULL    |                |
| bitsid           | int(11)      | NO   | MUL | NULL    |                |
| speedid          | int(11)      | NO   | MUL | NULL    |                |
| purposeid        | int(11)      | NO   | MUL | NULL    |                |
| dcid             | int(11)      | NO   | MUL | NULL    |                |
| trustid          | int(11)      | NO   | MUL | NULL    |                |
| envid            | int(11)      | NO   | MUL | NULL    |                |
| poolid           | int(11)      | NO   | MUL | NULL    |                |
| basedir          | text         | NO   |     | NULL    |                |
| locked_masterid  | int(11)      | YES  | MUL | NULL    |                |
| enabled          | tinyint(1)   | NO   |     | NULL    |                |
| current_masterid | int(11)      | YES  | MUL | NULL    |                |
| notes            | text         | YES  |     | NULL    |                |
| custom_tplid     | int(11)      | YES  |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)

mysql> select * from environments;
+-------+--------+
| envid | name   |
+-------+--------+
|     5 | decomm |
|     3 | dev/pp |
|     2 | prod   |
+-------+--------+
3 rows in set (0.00 sec)

mysql> select COUNT(*) from slaves WHERE envid != 5 and name LIKE "tegra-%";
+----------+
| COUNT(*) |
+----------+
|      275 |
+----------+
1 row in set (0.01 sec)

mysql> select * from datacenters;
+------+---------------+
| dcid | name          |
+------+---------------+
|   19 | aws-us-east-1 |
|   12 | aws-us-west-1 |
|   21 | aws-us-west-2 |
|    5 | mtv1          |
|    7 | scl1          |
|   10 | scl3          |
|   13 | sjc1          |
+------+---------------+
7 rows in set (0.12 sec)

mysql> DESCRIBE UPDATE slaves SET dcid=10 WHERE envid !=5 AND name LIKE "tegra-%";
+----+-------------+--------+-------+---------------+------+---------+-------+------+-----
--------+
| id | select_type | table  | type  | possible_keys | key  | key_len | ref   | rows | Extr
a       |
+----+-------------+--------+-------+---------------+------+---------+-------+------+-----
--------+
|  1 | SIMPLE      | slaves | range | name,envid    | name | 386     | const |  369 | Usin
g where |
+----+-------------+--------+-------+---------------+------+---------+-------+------+-----
--------+
1 row in set (0.22 sec)

mysql> UPDATE slaves SET dcid=10 WHERE envid !=5 AND name LIKE "tegra-%";
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    3070900
Current database: buildslaves

Query OK, 269 rows affected (4.18 sec)
Rows matched: 275  Changed: 269  Warnings: 0