Mysql error help

Manuel Suárez 7 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 salgado 7 years ago

SELECT LOCKED FROM Webinoly_yIUXOZy1.DATABASECHANGE LOGLOCK WHERE ID=1

set it to - 0, then restart

Anton Tananaev 7 years ago

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

Manuel Suárez 7 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árez 7 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árez 7 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 Tananaev 7 years ago

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