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.

Reply via email to