Mysql error help

Manuel Suárez6 years ago

Hi, I have a problem, my server woke up today with this error in the data.

root@u21176342:/opt/traccar/logs# tail tracker-server.log
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
        ... 10 more

2019-05-14 16:19:54  INFO: HikariPool-1 - Starting...
2019-05-14 16:19:54  INFO: HikariPool-1 - Start completed.
2019-05-14 16:19:55  INFO: Clearing database change log checksums
2019-05-14 16:19:55  INFO: SELECT COUNT(*) FROM Webinoly_yIUXOZy1.DATABASECHANGE                                     LOGLOCK
2019-05-14 16:19:55  INFO: SELECT COUNT(*) FROM Webinoly_yIUXOZy1.DATABASECHANGE                                     LOGLOCK
2019-05-14 16:19:55  INFO: SELECT `LOCKED` FROM Webinoly_yIUXOZy1.DATABASECHANGE                                     LOGLOCK WHERE ID=1
2019-05-14 16:20:46 ERROR: Main method error - Lock wait timeout exceeded; try r                                     estarting transaction - MySQLTransactionRollbackException (... < DataManager:310                                      < *:90 < Context:292 < Main:110 < ...)
luis salgado6 years ago
SELECT LOCKED FROM Webinoly_yIUXOZy1.DATABASECHANGE LOGLOCK WHERE ID=1

set it to - 0, then restart

Anton Tananaev6 years ago

Looks like your database is locked. It has been discussed several times before. Please use search.

Manuel Suárez6 years ago

Hello thank you for the help, if I saw post regarding this problem but to be honest I do not have any knowledge of database and I have not been able to solve it.

luis salgado apologize how should I use this command? inside Mysql or on the command line of ubuntu I already use the linux but I get this:

root @ u21176342: ~ # SELECT LOCKED FROM Webinoly_yIUXOZy1.DATABASECHANGE LOGLOCK WHERE ID = 0
SELECT: command not found
Manuel Suárez6 years ago

and in MySQL you can not help anything please?

Type 'help;' or '\ h' for help. Type '\ c' to clear the current input statement.

MariaDB [(none)]> SELECT LOCKED FROM Webinoly_yIUXOZy1.DATABASECHANGE LOGLOCK WHERE ID = 0
    ->
Manuel Suárez6 years ago

use this command to modify the DATABASECHANGELOGLOCK table and change the value ID = 1 to ID = 0 but I get this error

MariaDB [Webinoly_yIUXOZy1]> UPDATE DATABASECHANGELOGLOCK SET ID = 0;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Anton Tananaev6 years ago

Looks like it's not Liquibase lock, but your actual MariaDB lock. Try restarting database service.