Message boards :
Number crunching :
Old work still stuck in
Message board moderation
Author | Message |
---|---|
Send message Joined: 18 Sep 04 Posts: 35 Credit: 250,303 RAC: 0 |
These go way back! Is there anyway 0 credit can be manually granted just to clear these from my pending list. http://lhcathome.cern.ch/result.php?resultid=167586 http://lhcathome.cern.ch/result.php?resultid=295028 http://lhcathome.cern.ch/result.php?resultid=472473 http://lhcathome.cern.ch/result.php?resultid=472869 http://lhcathome.cern.ch/result.php?resultid=472874 <img src="http://www.boincstats.com/stats/teambanner.php?teamname=GasBuddy"> <img src="http://www.boincstats.com/stats/banner.php?cpid=84c0cf7846cbf28338406e54b3eb8a83"> |
Send message Joined: 2 Sep 04 Posts: 36 Credit: 90,806 RAC: 0 |
I have one as well: http://lhcathome.cern.ch/result.php?resultid=295422 |
Send message Joined: 27 Sep 04 Posts: 282 Credit: 1,415,417 RAC: 0 |
> I have one as well: > http://lhcathome.cern.ch/result.php?resultid=295422 > go ahead, make my day.. I've got 17 still pending: *snipp* here's just one! http://lhcathome.cern.ch/workunit.php?wuid=91991 *snipp* *hoping that LeMans 24 was more fun than formula 1* :-) |
Send message Joined: 3 Sep 04 Posts: 212 Credit: 4,545 RAC: 0 |
I invalidated these manually, I hope I got it right now (on the first try I crashed the whole database:( ) Markku Degerholm LHC@home admin |
Send message Joined: 27 Sep 04 Posts: 282 Credit: 1,415,417 RAC: 0 |
> I invalidated these manually, I hope I got it right now (on the first try I > crashed the whole database:( ) > > :-O be careful with your SQL "update" commands! ;-) |
Send message Joined: 2 Sep 04 Posts: 352 Credit: 1,393,150 RAC: 0 |
> I invalidated these manually, I hope I got it right now (on the first try I > crashed the whole database:( ) ========= Thanks Markku for cleaning out the old WU's ... :) |
Send message Joined: 2 Sep 04 Posts: 545 Credit: 148,912 RAC: 0 |
That is one feature I liked in Oracle, no autocommit. So, you could do a select to test the rows you thought you would affect, then run the update, then rerun the select to make sure only the right number of rows were affected. then do a separate commit to save the updates ... |
Send message Joined: 27 Sep 04 Posts: 282 Credit: 1,415,417 RAC: 0 |
> That is one feature I liked in Oracle, no autocommit. So, you could do a > select to test the rows you thought you would affect, then run the update, > then rerun the select to make sure only the right number of rows were > affected. then do a separate commit to save the updates ... > yup... nice... :-) but it can also have downsides.... imagine doing that via ssh oracle console... just before you commit, your connection drops...!!! *panic* ;-) |
Send message Joined: 2 Sep 04 Posts: 545 Credit: 148,912 RAC: 0 |
> yup... nice... :-) but it can also have downsides.... imagine doing that via > ssh oracle console... just before you commit, your connection drops...!!! > *panic* ;-) Then the session times out and the transations pending roll back to the state they were in prior to the change. No commit, no change .... |
Send message Joined: 2 Sep 04 Posts: 36 Credit: 90,806 RAC: 0 |
> I invalidated these manually, I hope I got it right now (on the first try I > crashed the whole database:( ) > > Thanks! :-) |
Send message Joined: 3 Sep 04 Posts: 212 Credit: 4,545 RAC: 0 |
> be careful with your SQL "update" commands! ;-) I was, but not careful enough... This one was actually in C code, like: snprintf(buf, sizeof(buf), "UPDATE result" " SET (stuff) ", " WHERE id=%d", stuff); See where it goes wrong? :) The one extra comma between SET and WHERE which wasn't even this clearly visible due to overlong row... Well, from this lesson I learned to always printf() the SQL queries before executing them on the production database... Markku Degerholm LHC@home admin |
©2024 CERN