Page MenuHomePhabricator

Update rack information on zarcillo.servers
Closed, ResolvedPublic

Description

All the new hosts that have been added to our fleet do not have the rack information updated:

root@db1115.eqiad.wmnet[zarcillo]> select fqdn,rack from servers where rack is NULL and  fqdn like 'db%';
+--------------------+------+
| fqdn               | rack |
+--------------------+------+
| db1126.eqiad.wmnet | NULL |
| db1127.eqiad.wmnet | NULL |
| db1128.eqiad.wmnet | NULL |
| db1129.eqiad.wmnet | NULL |
| db1130.eqiad.wmnet | NULL |
| db1131.eqiad.wmnet | NULL |
| db1132.eqiad.wmnet | NULL |
| db1133.eqiad.wmnet | NULL |
| db1134.eqiad.wmnet | NULL |
| db1135.eqiad.wmnet | NULL |
| db1136.eqiad.wmnet | NULL |
| db1137.eqiad.wmnet | NULL |
| db1138.eqiad.wmnet | NULL |
| db2065.codfw.wmnet | NULL |
| db2103.codfw.wmnet | NULL |
| db2104.codfw.wmnet | NULL |
| db2105.codfw.wmnet | NULL |
| db2106.codfw.wmnet | NULL |
| db2107.codfw.wmnet | NULL |
| db2108.codfw.wmnet | NULL |
| db2109.codfw.wmnet | NULL |
| db2110.codfw.wmnet | NULL |
| db2111.codfw.wmnet | NULL |
| db2112.codfw.wmnet | NULL |
| db2113.codfw.wmnet | NULL |
| db2114.codfw.wmnet | NULL |
| db2115.codfw.wmnet | NULL |
| db2116.codfw.wmnet | NULL |
| db2118.codfw.wmnet | NULL |
| db2119.codfw.wmnet | NULL |
| db2120.codfw.wmnet | NULL |
| db2123.codfw.wmnet | NULL |
| db2124.codfw.wmnet | NULL |
| db2125.codfw.wmnet | NULL |
| db2126.codfw.wmnet | NULL |
| db2128.codfw.wmnet | NULL |
| db2129.codfw.wmnet | NULL |
+--------------------+------+
37 rows in set (0.00 sec)

Event Timeline

Mentioned in SAL (#wikimedia-operations) [2019-08-05T05:58:14Z] <marostegui> Update rack column on zarcillo.servers for the new servers T229683

This is now fixed:

root@db1115.eqiad.wmnet[zarcillo]> select fqdn,rack from servers where rack is NULL and  fqdn like 'db%';
Empty set (0.00 sec)