Database Error


Advanced search

Message boards : Number crunching : Database Error
Message board moderation

To post messages, you must log in.

AuthorMessage
-Bert-

Send message
Joined: 23 Mar 02
Posts: 152
Credit: 412,754
RAC: 0
Netherlands
Message 901114 - Posted: 29 May 2009, 20:23:45 UTC

When I click View Tasks and then choose Invalid, the page shows "Database Error" in the left top corner. I never have Invalid results, but still, I just wanted the mention this.
ID: 901114 · Report as offensive
Alinator
Volunteer tester

Send message
Joined: 19 Apr 05
Posts: 4178
Credit: 4,647,982
RAC: 0
United States
Message 901226 - Posted: 30 May 2009, 1:24:55 UTC
Last modified: 30 May 2009, 1:25:12 UTC

Confirmed.

Now we need someone who does have an invalid task on the books to give it a try and see what happens. ;-)

Alinator
ID: 901226 · Report as offensive
Profile jrusling
Avatar

Send message
Joined: 8 Sep 02
Posts: 37
Credit: 4,764,889
RAC: 0
United States
Message 901240 - Posted: 30 May 2009, 1:48:19 UTC - in response to Message 901226.  

Confirmed.

Now we need someone who does have an invalid task on the books to give it a try and see what happens. ;-)

Alinator

I can confirm the error and I am pretty sure I have some invalid task.
http://boincstats.com/signature/-1/user/18390/sig.png
ID: 901240 · Report as offensive
Cosmic_Ocean
Avatar

Send message
Joined: 23 Dec 00
Posts: 3027
Credit: 13,516,867
RAC: 13
United States
Message 901249 - Posted: 30 May 2009, 2:08:54 UTC

I had an invalid task a few days ago. One of those cases where there's no canonical result to compare to. I don't have any more now though.
Linux laptop:
record uptime: 1511d 20h 19m (ended due to the power brick giving-up)
ID: 901249 · Report as offensive
Profile skildude
Avatar

Send message
Joined: 4 Oct 00
Posts: 9541
Credit: 50,759,529
RAC: 60
Yemen
Message 901318 - Posted: 30 May 2009, 4:02:56 UTC

I'd bet that this is just another side effect of the server issues


In a rich man's house there is no place to spit but his face.
Diogenes Of Sinope
ID: 901318 · Report as offensive
Alinator
Volunteer tester

Send message
Joined: 19 Apr 05
Posts: 4178
Credit: 4,647,982
RAC: 0
United States
Message 901644 - Posted: 30 May 2009, 19:18:48 UTC - in response to Message 901318.  

Agreed, probably just a syntax error or typo when they rewrote the query targets.

Alinator
ID: 901644 · Report as offensive
Alinator
Volunteer tester

Send message
Joined: 19 Apr 05
Posts: 4178
Credit: 4,647,982
RAC: 0
United States
Message 903579 - Posted: 4 Jun 2009, 13:12:57 UTC

Just an FYI update on this.

The problem is not SAH specific. I'm helping to Alpha test DrugDiscovery which is using a recent server build of BOINC, and it has the same problem.

Alinator
ID: 903579 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 14690
Credit: 200,643,578
RAC: 874
United Kingdom
Message 903611 - Posted: 4 Jun 2009, 15:07:47 UTC

That could have been my fault ;-)

I requested an upgrade via boinc_alpha:

> Tonight we are seeing some "Validate error" statuses on SETI results:

http://boinc.berkeley.edu/trac/changeset/18104

Thanks.

Anybody see the error in that code, so we can get DA to (re-)fix it?

I call 'not enough closing brackets'.
ID: 903611 · Report as offensive
Profile S@NL - Eesger - www.knoop.nl
Avatar

Send message
Joined: 7 Oct 01
Posts: 385
Credit: 50,200,038
RAC: 0
Netherlands
Message 903618 - Posted: 4 Jun 2009, 15:29:13 UTC
Last modified: 4 Jun 2009, 15:30:34 UTC

And indeed..... :
trunk/boinc/html/inc/result.inc
.................................1.............2..............3....................................32
line 76 " and server_state=5 and (outcome=6 or (outcome=1 and (validate_state=2 or validate_state=5)) ",


missing another closing bracket!
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS
ID: 903618 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 14690
Credit: 200,643,578
RAC: 874
United Kingdom
Message 903668 - Posted: 4 Jun 2009, 17:57:12 UTC

That seems to have done it - working OK now.
ID: 903668 · Report as offensive
kittyman Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 9 Jul 00
Posts: 51529
Credit: 1,018,363,574
RAC: 1,004
United States
Message 903677 - Posted: 4 Jun 2009, 18:22:33 UTC
Last modified: 4 Jun 2009, 18:23:32 UTC

May be related, there is a formatted table error showing up as well.....

See this post in the Mini City News thread in the Cafe....
"Time is simply the mechanism that keeps everything from happening all at once."

ID: 903677 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 14690
Credit: 200,643,578
RAC: 874
United Kingdom
Message 903681 - Posted: 4 Jun 2009, 18:34:25 UTC - in response to Message 903677.  

May be related, there is a formatted table error showing up as well.....

See this post in the Mini City News thread in the Cafe....

Dave A was messing with that as well - http://boinc.berkeley.edu/trac/changeset/18285.

It's ruined Joe Segur's signature.....

Do you want to tell David, or shall I?
ID: 903681 · Report as offensive
Josef W. Segur
Volunteer developer
Volunteer tester

Send message
Joined: 30 Oct 99
Posts: 4504
Credit: 1,414,761
RAC: 0
United States
Message 903732 - Posted: 4 Jun 2009, 21:02:00 UTC - in response to Message 903681.  

May be related, there is a formatted table error showing up as well.....

See this post in the Mini City News thread in the Cafe....

Dave A was messing with that as well - http://boinc.berkeley.edu/trac/changeset/18285.

It's ruined Joe Segur's signature.....

Do you want to tell David, or shall I?

The difficulty is that the change to main.css hasn't made it onto the server yet, so div.pre isn't defined. I think the change should be good, looks like it will finally allow posting tables and such without getting double line spacing. 
                                                                  Joe
ID: 903732 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 14690
Credit: 200,643,578
RAC: 874
United Kingdom
Message 903735 - Posted: 4 Jun 2009, 21:13:48 UTC - in response to Message 903732.  

The difficulty is that the change to main.css hasn't made it onto the server yet, so div.pre isn't defined. I think the change should be good, looks like it will finally allow posting tables and such without getting double line spacing. 
                                                                  Joe

Joe - your sig is back!

Good to see.
ID: 903735 · Report as offensive
Josef W. Segur
Volunteer developer
Volunteer tester

Send message
Joined: 30 Oct 99
Posts: 4504
Credit: 1,414,761
RAC: 0
United States
Message 903746 - Posted: 4 Jun 2009, 22:15:32 UTC - in response to Message 903735.  

The difficulty is that the change to main.css hasn't made it onto the server yet, so div.pre isn't defined. I think the change should be good, looks like it will finally allow posting tables and such without getting double line spacing. 
                                                                  Joe

Joe - your sig is back!

Good to see.

Except I have real preformatted text set in Opera to display in a different font, but I won't complain since tables work:

FFTLen  Stepsize  NumCfft
     8 17.072753       11
    16  8.536377       23
    32  4.268188       47
    64  2.134094       93
   128  1.067047      187
   256  0.533524      375
   512  0.266762      749
  1024  0.133381     1499
  2048  0.066690     2999
  4096  0.033345     5997
  8192  0.016673    11995


FFTLen  AR<=0.05      AR=0.08        AR=0.16
        ------------- -------------- -------------
     8                               462(@40960)
    16                1035(@40960)   2070(@20480)
    32  1457(@32768)  4371(@20480)   8742(@10240)
    64  5859(@16384)  17577(@10240)  35154(@5120)
   128  23749(@8192)  71247(@5120)   142494(@2560)
   256  95625(@4096)  286875(@2560)  573750(@1280)
   512  382739(@2048) 1148217(@1280) 2296434(@640)
  1024  1.53e6(@1024) 4.6e6(@640)    9.2e6(@320)
  2048  6.14e6(@512)  1.84e7(@320)   3.68e7(@160)
  4096  2.46e7(@256)  7.37e7(@160)   1.47e8(@80)
  8192  9.83e7(@128)  2.95e8(@80)    5.9e8(@40)


                                             Joe
ID: 903746 · Report as offensive
Profile peanut
Avatar

Send message
Joined: 1 Feb 07
Posts: 372
Credit: 1,951,576
RAC: 0
United States
Message 905044 - Posted: 8 Jun 2009, 0:27:20 UTC

For what its worth, I got Database error when I looked up a wingman's compter a day or so ago.

ID: 905044 · Report as offensive
Profile Dr. C.E.T.I.
Avatar

Send message
Joined: 29 Feb 00
Posts: 16019
Credit: 794,685
RAC: 0
United States
Message 905089 - Posted: 8 Jun 2009, 4:43:36 UTC



1229766930 444165998 17 May 2009 4:43:52 UTC 17 May 2009 5:49:17 UTC Error while downloading 0.00 0.00 ---

1229765701 444158495 17 May 2009 4:43:52 UTC 17 May 2009 5:49:17 UTC Error while downloading 0.00 0.00 ---

BOINC Wiki . . .

Science Status Page . . .
ID: 905089 · Report as offensive

Message boards : Number crunching : Database Error


 
©2025 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.