669548 - Missing add-on stats

Status: RESOLVED FIXED

(Mozilla Metrics :: Data/Backend Reports, defect)

Description

[Wil Clouser [:clouserw]]

We have two add-ons that have zero daily users but should have some:

https://addons.mozilla.org/en-US/firefox/addon/mafiaafire-redirector/
https://addons.mozilla.org/en-US/firefox/addon/mafiaafire-gee-no-evil/

They recently changed add-on ids on the site (not guids), but I'm not sure if that affects anything in your stats.

Comment 1

[MAFIAA]

Guys... any update on this?

Thanks!

Comment 2

[Daniel Einspanjer [:dre] [:deinspanjer]]

When an addon id is deleted, what happens to the corresponding version ids and file ids? Do those records get deleted in a cascade?  Is it impossible for a user to download the previous versions?

Comment 3

[Daniel Einspanjer [:dre] [:deinspanjer]]

What is the desired behavior for tracking ADU for users still running those old versions?

Comment 4

[Daniel Einspanjer [:dre] [:deinspanjer]]

I corrected the addon_ids for these two guids also.  It should be fixed in tomorrow's export.  We need to run an update statement tomorrow morning to fix the historic data.

The old/new ids are:

321739 -> 324964

304744 -> 324971

Wil, can you take care of that?

Comment 5

[Wil Clouser [:clouserw]]

mysql> select count(*) from update_counts where addon_id=321739;
+----------+
| count(*) |
+----------+
|       20 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from update_counts where addon_id=324964;
+----------+
| count(*) |
+----------+
|       10 | 
+----------+
1 row in set (0.01 sec)

mysql> update update_counts set addon_id=324964 where addon_id=321739;
Query OK, 20 rows affected (0.21 sec)
Rows matched: 20  Changed: 20  Warnings: 0

mysql> select count(*) from update_counts where addon_id=304744;
+----------+
| count(*) |
+----------+
|       20 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from update_counts where addon_id=324971;
+----------+
| count(*) |
+----------+
|       73 | 
+----------+
1 row in set (0.00 sec)

mysql> update update_counts set addon_id=324971 where addon_id=304744;
Query OK, 20 rows affected (0.27 sec)
Rows matched: 20  Changed: 20  Warnings: 0

Comment 6

[Wil Clouser [:clouserw]]

(In reply to comment #2)
> When an addon id is deleted, what happens to the corresponding version ids
> and file ids? Do those records get deleted in a cascade?  Is it impossible
> for a user to download the previous versions?

They are deleted from the site.  Users won't be able to download them from AMO.

Comment 7

[MAFIAA]

Yay! It works! My stats are back and it looks good!

That moron who hacked my account and deleted everything might have gotten away with it if it were not for your _fantastic help_ , and now getting back everything looks even sweeter!

Thanks guys, and have a fantastic day!