1045389 - Need to hide corrupted b2g datazilla data

Status: RESOLVED FIXED

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

Description

[Jonathan Eads ( :jeads )]

A bug in a test patch resulted in the submission of abnormally large data points to datazilla database b2g_perftest_1. I've identified the offending test runs and need the following query run to hide the data in the UI display.

UPDATE `b2g_perftest_1`.`test_result`
SET `status` = 2
WHERE `id` IN (296273, 296835, 298698, 301593, 301961, 303736, 304986, 305056, 306320);

Comment 1

[Brandon Johnson [:cyborgshadow]]

Hi jeads,

In production there is no table b2g_perftest_1.test_result. Please advise.

mysql> show tables like 'test%';
+----------------------------------+
| Tables_in_b2g_perftest_1 (test%) |
+----------------------------------+
| test                             | 
| test_aux_data                    | 
| test_collection                  | 
| test_collection_map              | 
| test_data_all_dimensions         | 
| test_option_values               | 
| test_page_metric                 | 
| test_run                         | 
| test_value                       | 
+----------------------------------+
9 rows in set (0.00 sec)

Comment 2

[Jonathan Eads ( :jeads )]

Whoops, that would be test_run


UPDATE `b2g_perftest_1`.`test_run`
SET `status` = 2
WHERE `id` IN (296273, 296835, 298698, 301593, 301961, 303736, 304986, 305056, 306320);

Comment 3

[Brandon Johnson [:cyborgshadow]]

Done. 9 rows affected. :)

Comment 4

[Jonathan Eads ( :jeads )]

Thanks for the fast turn around cyborgshadow. It looks like another corrupted data point slipped in during the interim. Could you also run?

UPDATE `b2g_perftest_1`.`test_run` SET `status` = 2 WHERE `id` = 312320;

Comment 5

[Brandon Johnson [:cyborgshadow]]

Done! 1 row affected. Please recheck and verify. :)