Calcudoku puzzle forum
http://www.calcudoku.org/forum/

Number of days solving puzzles, II
http://www.calcudoku.org/forum/viewtopic.php?f=18&t=972
Page 1 of 1

Author:  pnm  [ Fri Sep 22, 2017 10:08 am ]
Post subject:  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..

Author:  dango  [ Fri Sep 22, 2017 1:37 pm ]
Post subject:  Re: Number of days solving puzzles, II

Thanks Patrick, for your quick response. [biggrin]

Author:  pnm  [ Fri Sep 22, 2017 1:49 pm ]
Post subject:  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)

Author:  pnm  [ Fri Sep 22, 2017 10:28 pm ]
Post subject:  Re: Number of days solving puzzles, II

The consecutive days counts have been recomputed, I'll keep a close eye on
the update tomorrow..

Author:  paulv66  [ Sat Sep 23, 2017 10:10 am ]
Post subject:  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.

Author:  pnm  [ Sat Sep 23, 2017 10:41 am ]
Post subject:  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

Page 1 of 1 All times are UTC + 1 hour [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/