649153 - Remove fastestfox from perf_results

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Jeff Balogh (:jbalogh)]

mysql> select id, ts_slowness from addons where slug='fastestfox-browse-faster';
+------+-------------+
| id   | ts_slowness |
+------+-------------+
| 9825 |     32.8208 | 
+------+-------------+
1 row in set (0.00 sec)

mysql> update addons set ts_slowness=null where id=9825;                                  Query OK, 1 row affected (0.05 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> show tables like 'perf%';
+---------------------------------+
| Tables_in_addons_remora (perf%) |
+---------------------------------+
| perf_appversions                | 
| perf_osversions                 | 
| perf_results                    | 
+---------------------------------+
3 rows in set (0.00 sec)

mysql> select * from perf_results where addon_id=9825;
+------+----------+---------------+--------------+---------+------+---------------------+---------------------+
| id   | addon_id | appversion_id | osversion_id | average | test | created             | modified            |
+------+----------+---------------+--------------+---------+------+---------------------+---------------------+
|  429 |     9825 |            23 |            1 |  771.32 | ts   | 2011-03-19 07:15:29 | 2011-03-19 07:15:29 | 
|  401 |     9825 |            23 |            2 |  599.37 | ts   | 2011-03-19 07:12:22 | 2011-03-19 07:12:22 | 
|  705 |     9825 |            23 |            3 |  451.47 | ts   | 2011-03-19 07:50:33 | 2011-03-19 07:50:33 | 
|  471 |     9825 |            23 |            4 |  526.47 | ts   | 2011-03-19 07:21:02 | 2011-03-19 07:21:02 | 
| 1570 |     9825 |            24 |            1 |  819.47 | ts   | 2011-04-09 07:26:17 | 2011-04-09 07:26:17 | 
| 1448 |     9825 |            24 |            2 |  678.79 | ts   | 2011-04-09 07:15:51 | 2011-04-09 07:15:51 | 
| 1750 |     9825 |            24 |            3 |  566.26 | ts   | 2011-04-09 07:49:26 | 2011-04-09 07:49:26 | 
| 1535 |     9825 |            24 |            4 |  732.95 | ts   | 2011-04-09 07:22:39 | 2011-04-09 07:22:39 | 
+------+----------+---------------+--------------+---------+------+---------------------+---------------------+
8 rows in set (0.00 sec)

mysql> delete from perf_results where addon_id=9825;
Query OK, 8 rows affected (0.02 sec)

Comment 1

[Justin Scott [:fligtar]]

Thanks

Comment 2

[krupa raj[:krupa]]

verified fixed @ https://addons.mozilla.org/en-US/firefox/performance/

Comment 3

[krupa raj[:krupa]]

Attachment: post-fix screenshot