That error is caused because there are 2 processes trying to update 1 row of a table at the same time. A lock is put on it but the wait time was exceeded. Perhaps, you might want to try to increase the wait timeout for the lock.
Regards, Hien Nguyen ________________________________ From: Kunsheng Chen <[email protected]> To: BOINC Dev Mailing List <[email protected]> Sent: Monday, October 5, 2009 7:58:52 PM Subject: [boinc_dev] Database error shown in assimilator I got the following reminder in assimilator sometimes in the past few days. db_purge is running and the database is totally 80 mb only. so it should not be caused by size problem. Anyone has some idea ? Thanks, ------------------------------------------------------------------------ Database error: Lock wait timeout exceeded; try restarting transaction query=update workunit set assimilate_state=2, transition_time=1254702554 where id=325763 2009-10-04 20:30:05.4685 [CRITICAL] [anansi_1254497698_12382] update failed: 1 ------------------------------------------------------------------------ _______________________________________________ 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.
