909459 - Datazilla Data Update

Status: RESOLVED FIXED

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

Description

[Jonathan Eads ( :jeads )]

There are two datazilla projects that require some data updates.


1.) Please execute the following update on datazilla-rw-vip.db.scl3.mozilla.com to remove tests containing the string "-wptdriver" in the webpagetest project.

UPDATE `webpagetest_perftest_1`.`test_data_all_dimensions` SET `status`=0 WHERE `test_id` IN (1, 2, 3, 4, 5, 6);


2.) Please execute the following update on datazilla-rw-vip.db.scl3.mozilla.com to remove data having an incorrect branch association from the b2g project. This addresses the problem described in Bug 904166

UPDATE `b2g_perftest_1`.`test_run` SET `status`=0 WHERE `id` IN (5331, 53335);

Comment 1

[Brandon Johnson [:cyborgshadow]]

These queries have been executed.

mysql> UPDATE `webpagetest_perftest_1`.`test_data_all_dimensions` SET `status`=0 WHERE
    -> `test_id` IN (1, 2, 3, 4, 5, 6);
Query OK, 332 rows affected (0.05 sec)
Rows matched: 332  Changed: 332  Warnings: 0

mysql> UPDATE `b2g_perftest_1`.`test_run` SET `status`=0 WHERE `id` IN (5331, 53335);
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0