Could you give me more details on doing that ? It seems not just some configurations can make that.
Thanks, -Kun --- On Mon, 10/5/09, Nx Hien <[email protected]> wrote: > From: Nx Hien <[email protected]> > Subject: Re: [boinc_dev] Database error shown in assimilator > To: "Kunsheng Chen" <[email protected]> > Cc: [email protected] > Date: Monday, October 5, 2009, 2:40 PM > 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.
