We are connecting to MSSQL server DB via GitLab pipeline. I checked DATABASECHANGELOGLOCK table & it shows locked=0 But when we try to apply the changes to the DB, it’s giving error as liquibase.exception.LockException: Could not acquire change log lock. Currently locked by runner-mftxrtxr-projec…

[image] spbendekar: liquibase.exception.LockException: Could not acquire change log lock. By running the following command: select * from DATABASECHANGELOGLOCK; You should be able to check the lockedby column to see who locked the table. Generally, the lock will be from the local machine. A…

Quick question: how is GitLab pipeline configured? Is it by any chance (unintended) running two Liquibase deploys in the same time, over the same target DB ? Also, could you try unlocking the databasechangeloglock table with the more “official” way, via release-locks command (and then re-try the de…

Thanks for your response, No its executing only one Liquibase instance on target DB. Yes, now I’ve added extra job to release-lock (irrespective of locks) before execution/update.

@spbendekar , did that addressed the issue or it still persists? (Normally this should not be required, any Liquibase deploy, at the end, automatically releases that lock(for clean setup on next deploy)). Thanks, Eduard

Hi @EduardUta , @tabbyfoo I am new to liquibase I want to run the liquibase for cassandra and mysql from one liquibase server, cassandra and mysql are in different servers. At first it works fine for mysql when I tried with liquibase with cassandra , it stopped working for mysql due to lock.excep…

@Hemu0609 , Welcome to Liquibase! One question: Are the liquibase calls to the different two RDBMSs (MySQL and Cassandra) made from the same tool/session or different ? If you can give further details on this setup it would be useful. Thanks, Eduard

@EduardUta Thanks for your help, Yes, liquibase calls to two different RDBMS’s ( MYSQL and Cassandra ) both are in different VM’s, and I installed Liquibase in another VM, from there only I will communicate to MySQL and Cassandra (installed liquibase in only one VM). I wrote a script that automate…

Ok, understood, thanks for the extra info! First of all, one VM for running both deploys should be fine, no need to add another one. While is still difficult to pinpoint a root cause for this, I would advise to try something: Run the two deploys in separate sessions (on the same VM). Try to intro…

@EduardUta , I think they are running as separate sessions , and i tried to release the lock but it is showing that there is no lock on that table DATABASECHANGELOGLOCK. My automation runs schema one after the another only.

@EduardUta below log file will help you liquibase update --log-level=SEVERE #################################################### ## _ _ _ _ ## ## | | (_) (_) | ## ## | | _ __ _ _ _ _| |__ __ _ ___ ___ ## ## | | |…

liquibase.exception.LockException: Could not acquire change log lock

General Discussion

Hemu0609 October 18, 2022, 4:22am 13

@EduardUta
I have two jar in my liquibase lib folders
Cassnadra : CassandraJDBC42.jar
mysql : mysql-connector-java-8.0.30.jar

After deleting atleast one jar then only it is working fine for me.
Liquibase Version: 4.15.0

Unexpected error running Liquibase: Error executing SQL UPDATE

Topic		Replies	Views
Unexpected error running Liquibase: Error executing SQL UPDATE Liquibase Development	2	1294	October 20, 2022
listUnrunChangeSets throws JDBC error from WaitForLock method Liquibase Development	16	1959	February 12, 2021
There is already an object named 'DATABASECHANGELOGLOCK' in the database. General Discussion	1	424	December 24, 2013
Using liquibase 4.6.2 on GitlabCI error SEVERE [liquibase.integration] Unexpected error running Liquibase: ../update.log.lck Liquibase Development	1	874	April 13, 2022
There is already an object named 'DATABASECHANGELOGLOCK' in the database when i update Liquibase Development	2	3146	December 24, 2013

Free Tools

Cheat Sheets

eBooks

Comparison Guides

liquibase.exception.LockException: Could not acquire change log lock

Free Tools

Cheat Sheets

eBooks

Comparison Guides

liquibase.exception.LockException: Could not acquire change log lock

Related topics