The total number of locks exceeds the lock table size
This error is coming directly from your database. You should probably check on the database side to see what's happening.
But there is no lock table.
According to some information here on the forum, it seems that Traccar limits the size of some tables, and if there are many devices it is necessary to increase them.
Does it continue?
Once again, the error is coming directly from the database. It is not some kind of Traccar limit.
maybe try change innodb_buffer_pool_size
check this
https://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size
Slawek
This is exactly my friend. Buffer size
2 more links that helped me.
https://www.traccar.org/optimization/
https://stackoverflow.com/questions/6901108/the-total-number-of-locks-exceeds-the-lock-table-size/50235106
Thank you very much for your willingness to help!
The link I sent above traccar is wrong. Although it is relevant as well.
But the correct linik for the buffer settings is: https://www.traccar.org/mysql-optimization/
You helped me a lot!
I'm very grateful!
System with more than 4 thousand devices and 1 month of history, this message started to appear constantly in the edition or registration of vehicles:
"The total number of locks exceeds the lock table size"
IMG: https://ibb.co/YDHPjnn
It is a dedicated 32gb ram and ssd server. There is almost no use of hardware resources.
I believe it is something related to vehicle limit or size of tables.
But there is no such blocking table ....
Can someone help me?