Lock Wait Timeout Issue ?

Anisha Vishnoi 7 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 Tananaev 7 years ago

I would recommend upgrading to the latest version.

Anisha Vishnoi 7 years ago

Is 3.17 is ok ?

Anton Tananaev 7 years ago

You can try.

MSingh 2 years 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 Tananaev 2 years ago

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

MSingh 2 years 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 Tananaev 2 years ago

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