Attempt to edit a tast failed with error message

"Query failed with message 'Lock wait timeout exceeded; try restarting transaction'"

Hi,

I'm having the same problem. The first time it happens, I restart mysql and everything back to normal.

But now, even after restarting the problem still exist.

Any clue how to solve this?

Below are my log.php details;

<?php die(); ?>
Session "default" started at 2007-03-02T09:13:36+0000
#1 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Lock wait timeout exceeded; try restarting transaction'' in /var/www/html/webteam/web/task/environment/library/database/adapters/AbstractDBAdapter.class.php:371
Stack trace:
#0 /var/www/html/webteam/web/task/environment/library/database/adapters/AbstractDBAdapter.class.php(371): AbstractDBAdapter::prepareAndExecute()
#1 /var/www/html/webteam/web/task/environment/library/database/adapters/AbstractDBAdapter.class.php(257): MysqlDBAdapter->prepareAndExecute('UPDATE `ac_user...', NULL)
#2 /var/www/html/webteam/web/task/environment/library/database/DB.class.php(139): MysqlDBAdapter->execute('UPDATE `ac_user...', NULL)
#3 /var/www/html/webteam/web/task/environment/classes/dataaccess/DataObject.class.php(594): DB::execute('UPDATE `ac_user...')
#4 /var/www/html/webteam/web/task/environment/classes/dataaccess/DataObject.class.php(408): User->doSave()
#5 /var/www/html/webteam/web/task/application/models/CompanyWebsite.class.php(218): User->save()
#6 /var/www/html/webteam/web/task/application/models/CompanyWebsite.class.php(123): CompanyWebsite->setLoggedUser(Object(User), false, true)
#7 /var/www/html/webteam/web/task/application/models/CompanyWebsite.class.php(47): CompanyWebsite->initLoggedUser()
#8 /var/www/html/webteam/web/task/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#9 /var/www/html/webteam/web/task/application/application.php(21): CompanyWebsite::init()
#10 /var/www/html/webteam/web/task/init.php(125): require_once('/var/www/html/w...')
#11 /var/www/html/webteam/web/task/index.php(9): require('/var/www/html/w...')
#12 {main}
Time since start: 51.136203050613 seconds
-------------------------------------------------------------------------------