:: 07-Oct-1999 15:37 (Thursday) ::
OK, It looks like x-empt was right… There’s definitely a problem in
stats that’s preventing new participants from being properly added to the
database. You’ve probably noticed that the past several days have shown
“(and 0 of them are brand-new)” on the main rc5-64 stats page.
The strange aspect to this is that not only has the code in question not
changed, but when I run the sql manually I’m unable to reproduce the
problem.
I just ran the sql code by hand on the 6-Oct daytables and it added
the new 6-Oct participants in without a hitch. Yet for some reason when
that exact same code ran last night during the update, it didn’t work.
Very odd.
So far, all I’ve done is just add a bunch of logging to the suspect code
to see if I can isolate the exact spot where it’s falling down. It
just doesn’t make any sense.
I’m going to kick off a re-ranking, which is necessary for the affected
emails to be searchable and appear in on the stats web site. One
side-effect of a re-ranking is that the ranking offsets (the green and red
numbers showing your change from the day before) will all be affected by
this.
I’ll post more information as I figure out what’s going on. There’s no
reason to assume that the code will start working tonight, I’m just hoping
to get a few clues on why it’s failing.