364097 - SpreadFirefox Download counter RSS feed does not update

Status: RESOLVED FIXED

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

Description

[Chris L]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en; rv:1.8.1) Gecko/20061018 Firefox/2.0
Build Identifier: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en; rv:1.8.1) Gecko/20061018 Firefox/2.0

The SpreadFirefox Download counter RSS feed does not update at all. The last update appears to be at: Thu, 14 Dec 2006 19:03:01 -0800, according to the feed.

Reproducible: Always

Steps to Reproduce:
1. Load the feed
2. Wait about 5 mins
3. Reload the feed

Actual Results:  
The feed does not change

Expected Results:  
The count of downloads should have updated

Comment 1

[Asbjørn Sloth Tønnesen [:a5n]]

The bug is about both feeds:
http://feeds.spreadfirefox.com/downloads/firefox.xml
http://feeds.spreadfirefox.com/downloads/thunderbird.xml

Both feeds publish timestamp is Thu, 14 Dec 2006 19:03:01 -0800

The result of these missing updates can be seen at my sites:
http://ff.asbjorn.it/
http://tb.asbjorn.it/

Due to prior problems I uses the timestamp in the feed as the timestamp in the database, resulting in duplicated key errors being mailed to be every 5min.

Another way to reproduce:

Reproducible: Always

Fast way to reproduce:
1. Load the feed
2. Notice the pubDate in the feed

Actual results:  
pubDate is Thu, 14 Dec 2006 19:03:01 -0800

Expected results:
pubDate should only be seconds old.

Comment 2

[matthew zeier [:mrz]]

It eventually updates, right?  

Those xml files you mentioned are being cached for a long time (182 minutes left on firefox.xml).  

Would be best if the web server could send out correct expire headers - I'll look into that.

Comment 3

[Asbjørn Sloth Tønnesen [:a5n]]

(In reply to comment #2)
> It eventually updates, right?  

No, the count and pubDate has been the same since pubDate (over a week)

My last records:

date is in UTC

mysql> select * from counter order by id desc limit 1;
+-----------+---------------------+-----------+
| id        | date                | count     |
+-----------+---------------------+-----------+
| 651171862 | 2006-12-15 04:05:00 | 268430819 |
+-----------+---------------------+-----------+
1 row in set (0.00 sec)

mysql> select * from tb_counter order by id desc limit 1;
+-------+---------------------+----------+
| id    | date                | count    |
+-------+---------------------+----------+
| 22030 | 2006-12-15 04:05:00 | 37572403 |
+-------+---------------------+----------+
1 row in set (0.00 sec)

> Those xml files you mentioned are being cached for a long time (182 minutes
> left on firefox.xml).  
> 
> Would be best if the web server could send out correct expire headers - I'll
> look into that.

I supose this is done to minimize the load and traffic on the server, since the feed used at a lot of pages, some extensions, and other programs (eg. iTunes, Dashboard)

Comment 4

[Jeremy Orem [:oremj]]

Cronjob broke when osadm crashed a little bit ago.  It is fixed now.

Comment 5

[Chris L]

Hm... Now the SFX homepage says there are only 193 million downloads?

Comment 6

[Jeremy Orem [:oremj]]

Oops, the script was set to use the wrong database.  Fixed now.

Comment 7

[Asbjørn Sloth Tønnesen [:a5n]]

The thunderbird feed is still broken.

Comment 8

[Asbjørn Sloth Tønnesen [:a5n]]

They both works now. Thanks.

Merry Christmas