For now have increased value for innodb_lock_wait_timeout from 50 to 300.
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout
On Thu, May 3, 2012 at 7:54 AM, varun bhansaly vbhans...@gmail.com wrote:
Hi,
I'm using ofbiz release10.04@1072382 with MySQL
Try running tuning-primer.sh on the DB host and make changes as recommended.
https://launchpad.net/mysql-tuning-primer
On Thu, May 3, 2012 at 7:59 AM, varun bhansaly vbhans...@gmail.com wrote:
For now have increased value for innodb_lock_wait_timeout from 50 to 300.
This change does not help - still getting the same exceptions.
On Thu, May 3, 2012 at 8:29 PM, varun bhansaly vbhans...@gmail.com wrote:
For now have increased value for innodb_lock_wait_timeout from 50 to 300.
Hi,
I'm using ofbiz release10.04@1072382 with MySQL database server (with
default settings).
Of late I have been observing lots of 'lock wait time out' exceptions in
the logs primarily while the system is trying to update entity OrderHeader.
If anyone has any suggestions please do share.
Below