Lock Wait Timeout Issue ?

Anisha Vishnoi6 years ago

Hi,
I am facing below mentioned issue when Traccar 3.12 server restart. Issue exist for 5 to 7 minutes. and Locking table is devices. Can anyone please help me how to resolve this issue ?

2018-09-04 00:01:01  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:02  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:02  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:02  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:52  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:53  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:53  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:01:53  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:02:43  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
2018-09-04 00:02:44  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:308 < DeviceManager:253 < ...)
2018-09-04 00:02:44  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:308 < DeviceManager:253 < ...)
2018-09-04 00:02:44  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:308 < DeviceManager:253 < ...)
2018-09-04 00:03:34  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:308 < DeviceManager:253 < ...)
2018-09-04 00:03:35  WARN: Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:475 < DataManager:223 < DeviceManager:222 < ...)
Anton Tananaev6 years ago

I would recommend upgrading to the latest version.

Anisha Vishnoi6 years ago

Is 3.17 is ok ?

Anton Tananaev6 years ago

You can try.

MSingh9 months ago

Error while starting server
Tracker Server Version 5.8

2024-03-12 14:21:41  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2024-03-12 14:22:48 ERROR: Main method error - Lock wait timeout exceeded; try restarting transaction - MySQLTransactionRollbackException (... < QueryBuilder:469 < DatabaseStorage:115 < DeviceUtil:39 < ...)
Anton Tananaev9 months ago

What troubleshooting have you done so far before asking for help? What information and resources have you found? Please share all the details.

MSingh9 months ago
  1. I am using EC2 container on AWS
  2. It retries and retries above 2 steps (Log level warning)
  3. Rebooting EC2 resolved the issue

Not able to find root cause of issue.

Anton Tananaev9 months ago

So you haven't done any troubleshooting? Then I don't think I would be able to help.