View unanswered posts | View active topics It is currently Thu Mar 28, 2024 10:26 pm



← Back to the Calcudoku puzzle page




Reply to topic  [ 6 posts ] 
 Number of days solving puzzles, II 
Author Message
User avatar

Posted on: Fri Sep 22, 2017 10:08 am




Posts: 3296
Joined: Thu May 12, 2011 11:58 pm
Post Number of days solving puzzles, II
dango alerted me to a new problem with the number of consecutive days solving puzzles count.

After some digging, I found the cause:
To make this computation more efficient, certain "hourly markers" are stored in the database.
Since August 19th, these markers are sometimes incorrect, I'm thinking because of the database
query that gets the last solved puzzle sometimes fails.

I found a possibly related bug: when someone is logged in and solves a puzzle, all relevant database tables
are locked (so read/writes don't conflict with each other). But this wasn't happening for solved puzzles
of people who are not logged in (!) [scared] Fixed now.

I'll do a recompute of the consecutive days count, and will monitor this issue..


Profile

Posted on: Fri Sep 22, 2017 1:37 pm




Posts: 1
Joined: Thu May 12, 2011 11:43 pm
Post Re: Number of days solving puzzles, II
Thanks Patrick, for your quick response. [biggrin]


Profile
User avatar

Posted on: Fri Sep 22, 2017 1:49 pm




Posts: 3296
Joined: Thu May 12, 2011 11:58 pm
Post Re: Number of days solving puzzles, II
The numbers should be recomputed later this afternoon
(large compute job, will run this on a separate server)


Profile
User avatar

Posted on: Fri Sep 22, 2017 10:28 pm




Posts: 3296
Joined: Thu May 12, 2011 11:58 pm
Post Re: Number of days solving puzzles, II
The consecutive days counts have been recomputed, I'll keep a close eye on
the update tomorrow..


Profile

Posted on: Sat Sep 23, 2017 10:10 am




Posts: 956
Location: Ukraine
Joined: Tue Mar 01, 2016 10:03 pm
Post Re: Number of days solving puzzles, II
The number of consecutive days shown for me increased by 6 as a result of the update. The difference between the number of days membership and the number of consecutive days reduced from 10 to 4.

So I decided to go back over my history to check the revised figures. I joined on 1 March 2016 and solved puzzles on each of the first three days, then skipped a day and have solved puzzles every day since then. So the update worked correctly in my case.

One thing I noticed when doing this check was that the number of days shown does not include today. As I joined on 1 March 2016, today is my 572nd day of membership, but the number shown is 571. I presume this is because the count is not updated until the roll over at midnight.


Profile
User avatar

Posted on: Sat Sep 23, 2017 10:41 am




Posts: 3296
Joined: Thu May 12, 2011 11:58 pm
Post Re: Number of days solving puzzles, II
paulv66 wrote:
One thing I noticed when doing this check was that the number of days shown does not include today. As I joined on 1 March 2016, today is my 572nd day of membership, but the number shown is 571. I presume this is because the count is not updated until the roll over at midnight.


Yes, at the moment this update runs at 6.30am CET/CDT

I suppose I could move this forward a bit, I'll move it to 1.30am.

Patrick


Profile
Display posts from previous:  Sort by  
Reply to topic   [ 6 posts ] 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
All forum contents © Patrick Min, and by the post authors.

Forum software phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.