874966 - Run this command on the graphs production DB

Status: RESOLVED FIXED

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

Description

[Armen [:armenzg]]

Hi,
Can you please run this command on the graphs production DB?
delete from machines where name like 't-xp32-ix-137';

No rush. Thanks!

Comment 1

[Brandon Johnson [:cyborgshadow]]

mysql> use graphs_mozilla_org_new;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from machines where name = 't-xp32-ix-137';
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)


mysql> delete from machines where name = 't-xp32-ix-137';
Query OK, 1 row affected (0.00 sec)

mysql> select count(*) from machines where name = 't-xp32-ix-137';
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

Comment 2

[Armen [:armenzg]]

Thank you sir!