validate errors

Anonymous
Topic 13608

Here is a quick summary of what happened in the past 8 hours:

An admin mistake (SQL command update result set outcome=6;validate_state=2 where id=84114386;) accidentally set all the results in the database into an outcome=validate error state (the first semicolon in the command should be a comma!).

I have corrected these as best as I could. There may be a few hundred results which are not quite in the correct state. Please bear with me while I correct these over the next few days.

I have modified the reporting deadlines for any results that were due in the past 8 hours or the next 4 hours, advancing these deadlines by 12 hours. So results will not be marked as late because of this project downtime.

Hopefully my database repairs will be effective and most Einstein@Home contributors should not notice any problems or unusual behavior with the project.

Cheers,
Bruce

Bruce Allen
Bruce Allen
Joined: 15 Oct 04
Posts: 958
Credit: 170,849,008
RAC: 0

validate errors

Quote:

Is this one of those errors? Notice I got no credit while 2 others have some, but my results seem ok.

http://einstein.phys.uwm.edu//workunit/34957517

Yes, that was my mistake. This was one of 131 results that I should have left as 'outcome=validation errors' but in my haste I changed this to 'outcome=success'.

I have fixed these 131 results (including yours).

Thanks for pointing it out!

Cheers,
Bruce

Bruce Allen
Bruce Allen
Joined: 15 Oct 04
Posts: 958
Credit: 170,849,008
RAC: 0

RE: Is this one of the

Quote:
Is this one of the mistakes? http://einstein.phys.uwm.edu//workunit/34921280

This appears to be a genuine error in the result.

Bruce

Bernd Machenschalk
Bernd Machenschalk
Joined: 15 Oct 04
Posts: 2,684
Credit: 25,950,161
RAC: 34,820

RE: RE: Is this one of

Message 3287 in response to message 3286

Quote:
Quote:
Is this one of the mistakes? http://einstein.phys.uwm.edu//workunit/34921280

This appears to be a genuine error in the result.


Actually this looks like a bug in the 4.07 App, probably related to the "new checkpointing code", so the 4.09 might have it, too.

BM

BM

Bruce Allen
Bruce Allen
Joined: 15 Oct 04
Posts: 958
Credit: 170,849,008
RAC: 0

RE: RE: An admin mistake

Quote:
Quote:

An admin mistake (SQL command update result set outcome=6;validate_state=2 where id=84114386;) accidentally set all the results in the database into an outcome=validate error state (the first semicolon in the command should be a comma!).

Show me someone who say's they have not done that kind of thing and I'll show you a liar.

Looks like you have done a good job of recovery and also a big thanks from me for
running such a stable and trouble free project - From the crunchers point of view.

Thank you very much for the kind comments. We try hard not to make mistakes, but we're human!

Cheers,
Bruce

Bruce Allen
Bruce Allen
Joined: 15 Oct 04
Posts: 958
Credit: 170,849,008
RAC: 0

RE: You'll get to love the

Quote:

You'll get to love the --i-am-a-dummy mysql client setting. Also available with a less offensive name under --safe-updates. If you do an UPDATE without a WHERE clause, it will give an error. Saved my a** a couple of times.

I think you can set it in my.ini under the [client] section, to make it the default.

Good idea -- I will pass this on to our admin!

Bruce

Bernd Machenschalk
Bernd Machenschalk
Joined: 15 Oct 04
Posts: 2,684
Credit: 25,950,161
RAC: 34,820

RE: One of my WU's got hit

Quote:
One of my WU's got hit too:
http://einstein.phys.uwm.edu//workunit/34956676


Ouch!

The trouble is that with this bug there are very few workunits that can't be finished valid with the 4.07 App (probably the 4.09 Linux Beta had the same problem, which should be fixed in 4.12).

BM

BM

Bernd Machenschalk
Bernd Machenschalk
Joined: 15 Oct 04
Posts: 2,684
Credit: 25,950,161
RAC: 34,820

My intention is to manually

My intention is to manually grant credit for the validate errors that result from the bug in the 4.07 App (and only those). Please be patient with me while I find out how to do this without messing up the database. And keep reporting them!

BM

BM

Bernd Machenschalk
Bernd Machenschalk
Joined: 15 Oct 04
Posts: 2,684
Credit: 25,950,161
RAC: 34,820

I have begun to manually

I have begun to manually grant credit for validation errors from the 4.07 App that resulted from the "sorting bug" in 4.07. As a first step this applies to workunits with more than one validation error from 4.07, I still have 55 single results on my list that need further investigation.

BM

BM

Bernd Machenschalk
Bernd Machenschalk
Joined: 15 Oct 04
Posts: 2,684
Credit: 25,950,161
RAC: 34,820

RE: I have begun to

Message 3293 in response to message 3292

Quote:
I have begun to manually grant credit for validation errors from the 4.07 App that resulted from the "sorting bug" in 4.07. As a first step this applies to workunits with more than one validation error from 4.07, I still have 55 single results on my list that need further investigation.


I guess I got all of them that dropped in by now. I'll look for more of these results in a few days again.

BM

BM

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.