Cannot find workunit

Author	Message
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 · 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 · Reply Quote

Ulrich Metzner 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 · 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 · Reply Quote

littleBouncer 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 · Reply Quote

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 · 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 · Reply Quote

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 · Reply Quote

LHC@home