'Liquibase with Percona. Long queries fail

I try to use Liquibase migration with Percona plugin.

Liquibase 4.7.1 in command line mode with Docker with Jenkins

There is no problem with small tables. But when I want to update a big table (the usual ALTER on it goes in 10 minutes), the migration succeeds, but I get an error at the lock release stage.

[2022-02-25 10:27:53] SEVERE [liquibase] Could not release lock

liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE DATABASECHANGELOGLOCK SET `LOCKED` = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1: No operations allowed after connection closed.

...

Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure



The last packet successfully received from the server was 1,324,583 milliseconds ago. The last packet sent successfully to the server was 1,324,583 milliseconds ago.

Mysql server timeout settings:

| connect_timeout            | 3000     |
| wait_timeout               | 28800    |
mysqlliquibasepercona


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions