692113 - Please run this sql on production graphserver database

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[John Ford [:jhford] CET/CEST Berlin Time]

Attachment: please run after reading comment 0

This needs to be run on the graphserver, preferably before 8:15 so that I can start running the new machines against these changes.

The gist of this bug is:
1) rename existing 'MacOSX 10.6.2' to 'MacOSX 10.6.2 (rev3)'
2) create new platform 'MacOSX 10.6 (rev4)
3) correct the incorrect auto incrementing ID from operation 2) above
4) insert talos-r4-snow-XXX into DB


Point 1-3 should be fixed with the three lines of SQL below

=========
update os_list set name = "MacOSX 10.6.2 rev3" where id = 17;
insert into os_list values (NULL, "MacOSX 10.6");
update os_list set id = 21 where name = "MacOSX 10.6 (rev4)";
=========

Please verify that:
1) "MacOSX 10.6.2" before modifications is 'id = 17'
2) 'id = 21' is the correct number for 'MacOSX 10.6 (rev4)

I'd have done a subselect, but I don't have a testing DB and my sql knowledge is a little rusty.

Once you have verified that 'id = 21' is valid, please run the attached sql inserts.

Comment 1

[John Ford [:jhford] CET/CEST Berlin Time]

(In reply to John Ford [:jhford] from comment #0)
> =========
> update os_list set name = "MacOSX 10.6.2 rev3" where id = 17;
> insert into os_list values (NULL, "MacOSX 10.6");
> update os_list set id = 21 where name = "MacOSX 10.6 (rev4)";
> =========

The insert should read:
insert into os_list values (NULL, "MacOSX 10.6 (rev4)");

Comment 2

[John O'Duinn [:joduinn] (please use "needinfo?" flag)]

nudging to blocker, as this is how mrz wanted us to handle bugs that block downtimes-in-progress.

Comment 3

[Ashish Vijayaram [:ashish]]

id=17 should have been "MacOSX 10.6.2 (rev3)" - corrected. Here's the output:

mysql> select * from os_list order by id;
+----+-----------------------------------+
| id | name                              |
+----+-----------------------------------+
|  1 | WINNT 5.1                         | 
|  2 | WINNT 6.0                         | 
|  3 | MacOSX Darwin 8.8.1               | 
|  4 | MacOSX Darwin 9.2.2               | 
|  5 | Ubuntu 7.10                       | 
|  6 | CentOS release 5 (Final)          | 
|  7 | MacOSX 10.5.2                     | 
|  8 | WINNT 5.2                         | 
|  9 | Nokia n810                        | 
| 10 | Ubuntu 9.04 (x64)                 | 
| 12 | WINNT 6.1                         | 
| 13 | MacOSX 10.5.8                     | 
| 14 | Fedora 12 - Constantine           | 
| 15 | Fedora 12 x64 - Constantine       | 
| 16 | Nokia n900                        | 
| 17 | MacOSX 10.6.2 (rev3)              | 
| 18 | CentOS (x86_64) release 5 (Final) | 
| 19 | WINNT 6.1 x64                     | 
| 20 | Android 2.2                       | 
| 21 | MacOSX 10.6 (rev4)                | 
+----+-----------------------------------+
20 rows in set (0.00 sec)

mysql> select count(*) from machines where os_id="21";
+----------+
| count(*) |
+----------+
|      183 |
+----------+
1 row in set (0.00 sec)