Results 1 to 2 of 2

Thread: Collatz Conjecture News

  1. #1
    AMDave's Avatar
    AMDave is offline Seeker of the exit clause Moderator
    Site Admin
    Join Date
    Jun 2004
    Location
    Deep in a while loop
    Posts
    9,609

    Collatz Conjecture 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.

    More...

  2. #2
    NeoGen's Avatar
    NeoGen is offline AMD Users Alchemist Moderator
    Site Admin
    Join Date
    Oct 2003
    Location
    North Little Rock, AR (USA)
    Posts
    8,451
    Ah... so that's what happened to me this morning!

    Yes, I tried logging in a number of times through different methods until I gave up... I might have to recheck myself given that definition on lunacy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •