Hi all, We had a problem with old workunits and results that would not be removed from the DB. Different measures, including invoking "Transition all WUs" from the web interface, had no effect.
In our case the problem mainly applied to workunits that were aborted using the following two SQL statements: mysql> update workunit set target_nresults = 0, transition_time = now() where appid = 1 and name regexp "some_name"; mysql> update result set server_state = 5, outcome = 5 where server_state = 2 and appid = 1 and name regexp "some_name"; The solution I found was to issue the following SQL command: mysql> update workunit w set file_delete_state = 1 where 5 = all (select server_state from result r where r.workunitid = w.id) After this, file_deleter removed the workunit files from the file system, and then db_purge removed the records from the DB. -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.
