Changes in connection system

Post by **Carlos** » Thu Dec 28, 2006 4:08 am

In the meeting last Tuesday we decided to completely change connection system for MySQL data. That would solve some of the problems we have.

That change has been 90% developped, and it's running in an alpha version. This alpha version has completely replaced prior buggy version.

Apart from some minor bugs, it solves the RC status bug. If you notice any of them, please report it. It also includes a tracking system, so that if anything fails we'll be able to see where it went wrong.

The missing 10% corresponds to the ranking system. I hope to finish it by tomorrow, but it depends how much free time I have (you know, christmas...).

After that, we'll have to regenerate all statistics (again). That will cause the judge system to be down for about 2/3 hour. I hope to be doing it by 31th, anyway, who's using the judge in new year's eve?

After this little while, rankings will seem ok again. Authors ranklist will be done in the first days of January.

Thanks for your patience!!

Post by **Carlos** » Fri Dec 29, 2006 3:23 am

Ok, ranking system is working properly now. I've deleted information on rankings, so that I could properly debug the system, so don't worry about don't seeing it. Also, some user information related to number of problems tried/solved might be wrong. The same with number of users who tried/solved the problem in problem statistics.

The last step of the change is to make the script that builds up the rankings. As we discovered last time, launching the ranking system for the 5.2M submission takes too long, so we'll statically biuld statistics (judge down for 2/3 hours), and then we'll let the system continue its work. I hope everything is ok in a couple of days...

Thanks for your patience!

Post by **Carlos** » Sun Dec 31, 2006 4:16 pm

I've just finished the script to regenerate statistics. It will be launched tomorrow. We'll prevent all users from sending their codes, submitomatic page will be disabled.

Until then, statistics might look funny, strange, or reset. That's temporary. Please, be patient.

Post by **Carlos** » Tue Jan 02, 2007 1:56 am

Finally, today I didn't have the time to perform the statistics rebuilt. As tomorrow I'm have a meeting with Miguel Revilla, I'll do it live from judge's machine. This means that judge will not accept submissions from about 9:30am and for about 3 hours.

After this operation, everything will look normal again. If you find any wrong statistic, please inform us via forum or via email.

Sorry for any inconvenience you might have.

Btw...in opposition to PE issue, we've finally decided to consider old "Submission Error" status as not linked to any user, nor any problem, nor any language. So, the number of submissions you might have might decrease. I wasn't fair that a not-judged submission counted against your or a problem's statistics. It wasn't fair either that all unrecognized submissions increased the number of submissions of c (the default language).

Post by **Carlos** » Sat Jan 06, 2007 1:27 pm

We're stopping the judge this afternoon, so that statistics can be rebuilt with the script that solve the bugs. It will take about 3 hours.

Post by **Carlos** » Sat Jan 06, 2007 11:11 pm

Everything is working now. If you notice any bug, please report it in the forum