validate errors

Colin Porter
Colin Porter
Joined: 15 Feb 05
Posts: 21
Credit: 6479335
RAC: 0

RE: Here is a quick summary

Message 73855 in response to message 73846

Quote:

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!).

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. I can imagine it gives you a few headaches though.

Warning! This post contains atrocious spelling, and terrible grammar. Approach with extreme edginess.

It's not the speed, but the quality - Until I get a faster computer

Bikeman (Heinz-Bernd Eggenstein)
Bikeman (Heinz-...
Moderator
Joined: 28 Aug 06
Posts: 3522
Credit: 686042851
RAC: 592401

So true. This is the first

So true. This is the first downtime I can remember for quite some time, and most participants probably didn't even notice it because of work caches.

CU
H-BE

Bruce Allen
Bruce Allen
Moderator
Joined: 15 Oct 04
Posts: 1119
Credit: 172127663
RAC: 0

RE: RE: An admin mistake

Message 73857 in response to message 73855

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

Director, Einstein@Home

Annika
Annika
Joined: 8 Aug 06
Posts: 720
Credit: 494410
RAC: 0

It happens. Reminds me of

It happens. Reminds me of some server mistakes I made when I was really tired. Great job getting it fixed so quickly!

PovAddict
PovAddict
Joined: 31 Mar 05
Posts: 45
Credit: 2508915
RAC: 0

You'll get to love the

Message 73859 in response to message 73846

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.

Bruce Allen
Bruce Allen
Moderator
Joined: 15 Oct 04
Posts: 1119
Credit: 172127663
RAC: 0

RE: You'll get to love the

Message 73860 in response to message 73859

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

Director, Einstein@Home

moz6311_v2
moz6311_v2
Joined: 7 Nov 06
Posts: 2
Credit: 22267
RAC: 0

One of my WU's got hit

One of my WU's got hit too:
http://einsteinathome.org/workunit/34956676

So far it's been sent out six times. I know my machine is
stable (1 yr on EAH), and at least one other wingman
is stable too. Both got errors anyway. Help!

Bernd Machenschalk
Bernd Machenschalk
Moderator
Administrator
Joined: 15 Oct 04
Posts: 4265
Credit: 244922893
RAC: 16808

RE: One of my WU's got hit

Message 73862 in response to message 73861

Quote:
One of my WU's got hit too:
http://einsteinathome.org/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

tapir
tapir
Joined: 19 Mar 05
Posts: 23
Credit: 462935446
RAC: 0

My first validate

My first validate error:
wuid=35000079

tapir
tapir
Joined: 19 Mar 05
Posts: 23
Credit: 462935446
RAC: 0

Another one:wuid=35044433

Another one:
wuid=35044433

Comment viewing options

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