XF 1.4 Problem with MYSQL after upgrade from 1.3.2 to 1.4.2

[gotski]

First time after upgrade I have a problems.... Don't work spam cleaner, don't work user delete,
I can't create posts in some threads.



Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
5 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
6 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
7 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
10 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
11 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
11 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
12 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction


Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Admin, 30 minutes ago
Stack Trace
#0 /home/**********/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/**********/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/**********/community/library/XenForo/Model/User.php(2782): Zend_Db_Adapter_Abstract->query('???????UPDATE I...', 56659)
#3 /home/**********/community/library/XenForo/DataWriter/User.php(1339): XenForo_Model_User->changeContentUser(56659, 'Bignasty69', NULL, 0)
#4 /home/**********/community/library/XenForo/DataWriter.php(1779): XenForo_DataWriter_User->_postDelete()
#5 /home/**********/community/library/XenForo/Controller.php(1019): XenForo_DataWriter->delete()
#6 /home/**********/community/library/XenForo/ControllerAdmin/User.php(606): XenForo_Controller->_deleteData('XenForo_DataWri...', 'user_id', 'admin.php?users...')
#7 /home/**********/community/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_User->actionDelete()
#8 /home/**********/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/**********/community/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(73) "http://**********/community/admin.php?users/bignasty69.56659/delete"
["_GET"] => array(1) {
["users/bignasty69_56659/delete"] => string(0) ""
}
["_POST"] => array(2) {
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}

 

[gotski]

I wrote to my hoster, he checked and fixed database, but it not helped to me ;(

 

[gotski]

Hoster not helped me, I'm create dump a forum database, then created new empty database and loaded dump, it helped me....
I don't know why it work, but I very glad.

 

[Insy]

According to me, it is a problem of configuration on the MySQL server. I recommend you to ask your hoster to increase the innodb_lock_wait_timeout global variable.
By creating a new database, you just empty out the transaction log. This error may come back later.
=> https://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout