logo  Collatz Conjecture
log in

Powered by BOINC

User of the day

User profile Profile DVo
i let my gtx980 do some sciencing when i'm not using it.

News

Corrupt Index Caused Authentication Errors
Summary:
An index on the user table in the database was corrupt and has been fixed. If you have issues or notice something that is out of sync somehow, please let me know.

Details:
The email address index on the user table was corrupted. This kept people from being able to authenticate when connecting. Ever heard that the definition of lunacy is doing the same thing over and over and expecting different results? If that is true, some of you need some serious counselling. ;-)

When people couldn't connect, they attempted to authenticate and BOINC's logic is that if it can't find you, you must be new. So, it created another record because the index used to look up your existing record was corrupt -- or for some lunatics, another and another and another and another... That resulted in multiple user records with the same email address and because of that, I couldn't just drop and re-create the corrupt index because there were now duplicate data values that needed to first be removed.

So, after cleaning up hundreds of records each of which had to be manually evaluated to determine whether any other data was associated with the user record (since BOINC doesn't have any data integrity between tables because it uses no foreign key relationships in the database it will allow me to delete records that do have data associated with them which means I have to be very careful when fixing things). Once they were all removed, I was able to rebuild the index and allow everyone to access the project again.
5 Mar 2015, 23:58:18 UTC · Comment


Android 5, aka Lolipop or Android L not getting work
Android 5 was recently released but it is not currently working - mainly due to work fetch issues. We are working to identify and fix the issues as soon as possible. 12 Feb 2015, 0:50:11 UTC · Comment


Prepping for Android 5
Because Android 5 requires PIE support, the android app has been split into two plan classes, one for Android 4.1 and later (a new app), and another for earlier versions (the existing app). Please let me know if you run into any issues. 2 Feb 2015, 21:00:17 UTC · Comment


Database Is Back Online
During the nightly backup process, the database once again stopped responding and had to be restarted this morning. Rather than bring it back online as I have been doing, I spent the day trying to duplicate the issue, but to no avail. Before bringing it back online, the database tables were optimized and I checked to make sure the database is in sync with the BOINC file system. 21 Jan 2015, 2:50:24 UTC · Comment


Murphy's Law
Naturally, on the opening morning of hunting season, the server decided to hang while doing the backups. That left the project in a "down" status. Everything should be back up and running now. 21 Nov 2014, 20:13:47 UTC · Comment


... more

News is available as an RSS feed   RSS





Copyright © 2015 Jon Sonntag; All rights reserved.