Kamran - please check the thread - I think you've over-cooked it http://aqua.dwavesys.com/forum_thread.php?id=603&nowrap=true#7939
Others - please don't follow this recipe just yet - needs checking. ----- Original Message ----- From: "Kamran Karimi" <[email protected]> To: <[email protected]>; <[email protected]> Sent: Tuesday, July 06, 2010 9:55 PM Subject: [boinc_dev] The "stuck workunits" problem seems solved > Hi all, > > We finally managed to get rid of our hundreds of thousands of stuck > workunits and results (some would show under users' accounts as "Not > needed" but would not be removed no matter what we tried). > > Here is what we did: > > 1) Ran a MySQL query like: update workunit w,result r set > w.file_delete_state=1,r.file_delete_state=1 where r.workunitid = w.id and > r.file_delete_state = 0 and r.server_state = 5; > > 2) Then ran the command: bin/file_deleter -one_pass > > 3) Then ran the command: bin/db_purge -no_archive > > > -Kamran > > > > > _______________________________________________ > boinc_dev mailing list > [email protected] > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
