866649 - bld-centos6-hp-024 is not in visible on slavealoc webui

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: CIDuty, task)

Description

[Rail Aliiev [:rail]]

... but still in the database and takes jobs

mysql> select * from slaves where name = 'bld-centos6-hp-024';
+---------+--------------------+----------+--------+---------+-----------+------+---------+-------+--------+---------------+-----------------+---------+------------------+----------------------------------------+--------------+
| slaveid | name               | distroid | bitsid | speedid | purposeid | dcid | trustid | envid | poolid | basedir       | locked_masterid | enabled | current_masterid | notes                                  | custom_tplid |
+---------+--------------------+----------+--------+---------+-----------+------+---------+-------+--------+---------------+-----------------+---------+------------------+----------------------------------------+--------------+
|    1811 | bld-centos6-hp-024 |       15 |      2 |       6 |         5 |    7 |       4 |     5 |      6 | /builds/slave |            NULL |       1 |               58 | changed to AHCI vs RAID for bug 779487 |         NULL |
+---------+--------------------+----------+--------+---------+-----------+------+---------+-------+--------+---------------+-----------------+---------+------------------+----------------------------------------+--------------+

Comment 1

[Rail Aliiev [:rail]]

It turns out that envid=5 is decomm. I updated envid and poolid (moved to aws masters):

mysql> update slaves set envid=2 where name = 'bld-centos6-hp-024';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update slaves set poolid=39 where name = 'bld-centos6-hp-024';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0