558153 - getpersonas.com up & coming showing year old personas

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Ryan Doherty (:rdoherty)]

http://www.getpersonas.com/en-US/gallery/

is showing year old personas. A few hours ago all the personas were completely different. 

This page sorts on the 'movers' column in the personas table. Can it be checked to see if there are still values in that column?

cc'ing Pedro in case he's working on something (the movers column is populated by metrics.

Comment 1

[Derek Moore [:dmoore]]

I'm not sure which direction you'd sort movers, but there are some amount of NULL values in the column:

mysql> select movers, id from personas order by movers limit 10;
+--------+-------+
| movers | id    |
+--------+-------+
|   NULL | 64938 | 
|   NULL | 64886 | 
|   NULL | 64887 | 
|   NULL | 64888 | 
|   NULL | 64889 | 
|   NULL | 64890 | 
|   NULL | 64891 | 
|   NULL | 64892 | 
|   NULL | 64893 | 
|   NULL | 64894 | 
+--------+-------+
10 rows in set (0.00 sec)


mysql> select movers, id from personas order by movers desc limit 10;
+---------+-------+
| movers  | id    |
+---------+-------+
| 49.1786 | 62056 | 
| 33.2381 | 62632 | 
|  13.125 | 51635 | 
| 7.92316 |    43 | 
| 6.35409 |   508 | 
| 3.89741 | 47815 | 
| 3.79709 | 56051 | 
| 3.64973 | 58231 | 
| 3.51294 | 60440 | 
| 3.39587 | 50970 | 
+---------+-------+
10 rows in set (0.14 sec)

Comment 2

[Ryan Doherty (:rdoherty)]

We order by 'movers desc', but it appears the movers column has bad data, none of the personas in the second query were in the movers list yesterday (null is ok). Most stick around for a day or two in the top 10.

I'll ping metrics to see if they know what's up.

Comment 3

[Pedro Alves]

I'll check asap

Comment 4

[Pedro Alves]

Done - Sorry, our fault. We were doing a few tests for the swap of the number calculations and a faulty command was run that cleaned the table

Comment 5

[Ryan Doherty (:rdoherty)]

(In reply to comment #4)
> Done - Sorry, our fault. We were doing a few tests for the swap of the number
> calculations and a faulty command was run that cleaned the table

Have you re-populated the table? Just want to make sure b/c I can only see cached content on getpersonas.com.

Thanks!

Comment 6

[Pedro Alves]

mysql> select id, name, popularity, movers, modified from personas order by movers desc limit 10;
+--------+-------------------------+------------+---------+---------------------+
| id     | name                    | popularity | movers  | modified            |
+--------+-------------------------+------------+---------+---------------------+
| 148472 | Liquid Copper           |       1030 | 79.2931 | 2010-03-24 17:18:37 |
| 109649 | Garden Color Pink       |       2878 | 19.2575 | 2010-02-21 21:24:51 |
| 132818 | God of War 003 - Bureke |       1475 | 18.6371 | 2010-03-15 10:46:39 |
| 119768 | Bar Refaeli - Sexy Babe |       2110 | 13.5097 | 2010-03-07 23:12:55 |
| 119755 | Elisabetta - Sexy Babe  |        240 | 13.4762 | 2010-03-07 22:22:20 |
| 102261 | Three Crosses           |        819 | 10.8962 | 2010-04-03 12:05:15 |
| 139529 | Blue Floral Design      |        591 | 10.5602 | 2010-03-19 08:08:32 |
|  50062 | Flowers for Pinks       |       2625 | 10.0743 | 2009-12-15 17:07:06 |
| 119762 | Krystal - Sexy Babe     |       5013 | 9.57631 | 2010-03-07 22:48:33 |
| 110215 | BMW Roundel             |        780 | 8.29455 | 2010-02-22 12:03:16 |
+--------+-------------------------+------------+---------+---------------------+

Comment 7

[Stephen Donner [:stephend] Not actively reading bugmail]

Looks fixed to me, on http://www.getpersonas.com/en-US/gallery/; verified.