Two /stats/ exports with the same data?

Questions and Answers : Web site : Two /stats/ exports with the same data?
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 886350 - Posted: 18 Apr 2009, 19:57:50 UTC

Dates are in GMT+1

17-04-2009 19:41 my stats-script detected a new export
18-04-2009 00:15 my stats-script detected another new export

But as far as I can see, both exports containe exactly the same data!

The update routine is triggered by a newer "<update_time>1240006528</update_time>" in tables.xml

Has this to do with the SQL-problems earlier, is it a "bo bo".. or have I done something wrong?
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 886350 · Report as offensive
John McLeod VII
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jul 99
Posts: 24806
Credit: 790,712
RAC: 0
United States
Message 886366 - Posted: 18 Apr 2009, 20:47:25 UTC - in response to Message 886350.  

Dates are in GMT+1

17-04-2009 19:41 my stats-script detected a new export
18-04-2009 00:15 my stats-script detected another new export

But as far as I can see, both exports containe exactly the same data!

The update routine is triggered by a newer "<update_time>1240006528</update_time>" in tables.xml

Has this to do with the SQL-problems earlier, is it a "bo bo".. or have I done something wrong?

Triggering from the Update Time is what you are supposed to do. Unless there is a bug in your code that detects identical numbers as worthy of update, you have not done anything wrong.

As to exactly why the update times might have changed, I really don't know. It might be related to the DB problems, you might have caught it in the middle of an update (the timestamp cannot be written exactly at the same time as the data, but it will be close), it might be caused by something else.


BOINC WIKI
ID: 886366 · Report as offensive
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 886375 - Posted: 18 Apr 2009, 20:57:15 UTC - in response to Message 886366.  
Last modified: 18 Apr 2009, 21:13:04 UTC

As you can see by the dates / times there is a 4.5 hour difference. My script checks every 30 minutes.. (and offcourse does only an update at greater then..)

The strange thing is, that my "history-updater" refused an update, so I could (partly, because I thought Hey another update.. ) check the values of the first update and check them with the second.. and they do really look the same!

This new stats-system has been running for months now.. and this is the first time it/I detected this strange thing.. so I thought it was worth mentioning ;)

[edit]
The "update times" I mentioned are the "<update_time>....</update_time>" times in GMT+1 notation... (I red my post again, and I didn't put that very clearly..)
[/edit]
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 886375 · Report as offensive
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 886590 - Posted: 20 Apr 2009, 7:13:01 UTC

Same thing with the last export, I have made another check, that:

<total_credit>45481396218.213196</total_credit>

must be at least 10 credits larger then the previous update (in tables.xml).

It looks like the export script is running periodically, but the exported data is obtained from a "frozen" database/table.


The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 886590 · Report as offensive
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 886695 - Posted: 20 Apr 2009, 15:56:11 UTC

Rats, we in the Netherlands are now at GMT/UTC +2 (CEST)

(sorry for the confusion)
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 886695 · Report as offensive
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 887237 - Posted: 22 Apr 2009, 9:07:44 UTC

The new stats update is there, thanx for fixing this (also)!
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 887237 · Report as offensive

Questions and Answers : Web site : Two /stats/ exports with the same data?


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.