Message boards : Number crunching : Cannot find workunit
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile cyclistgb

Send message
Joined: 22 Oct 04
Posts: 6
Credit: 3,413,714
RAC: 0
Message 7761 - Posted: 20 May 2005, 1:26:20 UTC

Is there a DB [roblem, when I tried to see the details of a work unit, I received a "Cannot find work unit" message

Guy
[img src="http://www.boincstats.com/signature/user_10138.gif"]
ID: 7761 · Report as offensive     Reply Quote
Jayargh

Send message
Joined: 24 Oct 04
Posts: 79
Credit: 257,762
RAC: 0
Message 7765 - Posted: 20 May 2005, 3:24:54 UTC

It Appears all finished workunits going to pending, getting same answer when I access db on all workunits now...also had 3 results on a workunit a few hours ago nothing granted... seems like this sort of thing happens as they load database for next run... we shall see
ID: 7765 · Report as offensive     Reply Quote
Ulrich Metzner
Avatar

Send message
Joined: 27 Sep 04
Posts: 36
Credit: 29,315
RAC: 0
Message 7768 - Posted: 20 May 2005, 8:22:45 UTC

Me too, got two of them:

The result is there, but if you click on workunit, it's not found :?

Same with this one


greetz, Uli

ID: 7768 · Report as offensive     Reply Quote
STE\/E

Send message
Joined: 2 Sep 04
Posts: 352
Credit: 1,393,150
RAC: 0
Message 7770 - Posted: 20 May 2005, 9:19:13 UTC
Last modified: 20 May 2005, 9:22:44 UTC

The Server has been like this since about 7 PM EST last night, all the WU's are going into the Pending Account's. I hope this isn't going to be like the last time my pending credit jumped over 3000 credits and no Credit was or will be granted for any of them that are dumped into the pending accounts ... Since last night my Pending Credit has gone up over 1000 credits again ...
ID: 7770 · Report as offensive     Reply Quote
Profile littleBouncer
Avatar

Send message
Joined: 23 Oct 04
Posts: 358
Credit: 1,439,205
RAC: 0
Message 7771 - Posted: 20 May 2005, 9:43:45 UTC - in response to Message 7770.  
Last modified: 20 May 2005, 10:23:22 UTC

> The Server has been like this since about 7 PM EST last night, all the WU's
> are going into the Pending Account's. I hope this isn't going to be like the
> last time my pending credit jumped over 3000 credits and no Credit was or will
> be granted for any of them that are dumped into the pending accounts ... Since
> last night my Pending Credit has gone up over 1000 credits again ...
>

IMO: I think it is like the 'last time', when you still want credit for the 'Monkey-WU's', you will waste CPU-cycles. Wait for the new 1 Mio WU's!

greetz littleBouncer

[EDIT: 10:15 UTC]
Sorry , I was a little bit wrong, the db has crashed ... :-(
They have fixed it... :-)
I'm waiting for the next release of work..........
[/EDIT]
ID: 7771 · Report as offensive     Reply Quote
Profile Chrulle

Send message
Joined: 27 Jul 04
Posts: 182
Credit: 1,880
RAC: 0
Message 7773 - Posted: 20 May 2005, 9:56:58 UTC
Last modified: 20 May 2005, 9:57:05 UTC

The workunit table had chrashed again. Something very bad is going on, but we have no idea what is creating the chrashes. Whatever it is it seems to only involve the Workunit table.

The table should be working, so please check again.

Chrulle
Research Assistant & Ex-LHC@home developer
Niels Bohr Institute
ID: 7773 · Report as offensive     Reply Quote
STE\/E

Send message
Joined: 2 Sep 04
Posts: 352
Credit: 1,393,150
RAC: 0
Message 7774 - Posted: 20 May 2005, 10:00:43 UTC - in response to Message 7773.  
Last modified: 20 May 2005, 10:17:13 UTC

> The workunit table had chrashed again. Something very bad is going on, but we
> have no idea what is creating the chrashes. Whatever it is it seems to only
> involve the Workunit table.
>
> The table should be working, so please check again
=========

My Pending Credit has dropped a little bit so something is working again ... :)

@LB ... Whats wrong with wanting Credit for WU's that are turned in before the Deadline & are Valid WU's & Request the Proper amount of Credit, I can't help it if the Server sends the same WU's out to 6 Dozen people and only the first 3 or 4 people that turn in the WU will get Credit & the rest can go Kiss the Sky ... Thats a hell of a way to run a Project and attract new Clients IMO ... Any body that asks me about the LHC Project I just tell them to go buy a big jar of Vaseline because their going to need it ... :P
ID: 7774 · Report as offensive     Reply Quote
Profile Paul D. Buck

Send message
Joined: 2 Sep 04
Posts: 545
Credit: 148,912
RAC: 0
Message 7778 - Posted: 20 May 2005, 13:56:52 UTC - in response to Message 7773.  

> The workunit table had chrashed again. Something very bad is going on, but we
> have no idea what is creating the chrashes. Whatever it is it seems to only
> involve the Workunit table.
>
> The table should be working, so please check again.

Not being a physical DBA I don't know all about how MySQL lays data out. But my first thoughts are the following questions:

1) have you located the table in a seperate physical file (I know Oracle can do this, but am not sure with MySQL)?
2) Do you run maintenance on the tables on a scheduled basis?
3) are you moveing the results to an off-line database and purging the on-line database of these work units?
4) does MySQL give details about what goes wrong with the table?
5) Has any other project experienced similar problems?
6) Have you given thought to moving the datafiles to another physical media?
7) Does the event have periodicity?
8) Does the event seem to correlate with project events, like the end of a data run?

You don't have to answer, I was just trying to suggest some thoughts as part of a brain storming thing. Unfortunately, I found enough to occupy my thinking in the field of logical design of relational databases so I am only passingly interested in the physical, um, junk. I mean, I had to stay aware of some things to not make the physical DBA's job impossible, but it was never my thing, sorry. :(
ID: 7778 · Report as offensive     Reply Quote

Message boards : Number crunching : Cannot find workunit


©2022 CERN