SELECT LOCKED FROM Webinoly_yIUXOZy1.DATABASECHANGE LOGLOCK WHERE ID=1
set it to - 0, then restart
Looks like your database is locked. It has been discussed several times before. Please use search.
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
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
->
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
Looks like it's not Liquibase lock, but your actual MariaDB lock. Try restarting database service.
Hi, I have a problem, my server woke up today with this error in the data.