liquibase on infinetoop waiting for change lock

[sangeethdba]

trafficstars

Im using liquibase to create some cassandra objects.

when i run liquibase update ,it created lock and changelog table and inserted a row in lock table

and giving the error

[2021-07-09 15:57:35] FINE [liquibase.executor] Create Database Lock Table [2021-07-09 15:57:35] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:35] FINE [liquibase.executor] -1 row(s) affected [2021-07-09 15:57:35] FINE [liquibase.ext] Created database lock table with name: comconfigs_test.DATABASECHANGELOGLOCK [2021-07-09 15:57:35] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:35] INFO [liquibase.ext] Waiting for changelog lock.... [2021-07-09 15:57:45] INFO [liquibase.ext] No DATABASECHANGELOGLOCK available in cassandra. [2021-07-09 15:57:45] FINE [liquibase.executor] Create Database Lock Table [2021-07-09 15:57:45] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:45] FINE [liquibase.executor] -1 row(s) affected [2021-07-09 15:57:45] FINE [liquibase.ext] Created database lock table with name: comconfigs_test.DATABASECHANGELOGLOCK [2021-07-09 15:57:45] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:45] INFO [liquibase.ext] Waiting for changelog lock.... [2021-07-09 15:57:55] INFO [liquibase.ext] No DATABASECHANGELOGLOCK available in cassandra. [2021-07-09 15:57:55] FINE [liquibase.executor] Create Database Lock Table [2021-07-09 15:57:55] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:55] FINE [liquibase.executor] -1 row(s) affected [2021-07-09 15:57:55] FINE [liquibase.ext] Created database lock table with name: comconfigs_test.DATABASECHANGELOGLOCK [2021-07-09 15:57:55] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:57:56] INFO [liquibase.ext] Waiting for changelog lock.... [2021-07-09 15:58:06] INFO [liquibase.ext] No DATABASECHANGELOGLOCK available in cassandra. [2021-07-09 15:58:06] FINE [liquibase.executor] Create Database Lock Table [2021-07-09 15:58:06] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:58:06] FINE [liquibase.executor] -1 row(s) affected [2021-07-09 15:58:06] FINE [liquibase.ext] Created database lock table with name: comconfigs_test.DATABASECHANGELOGLOCK [2021-07-09 15:58:06] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 15:58:06] INFO [liquibase.ext] Waiting for changelog lock....

going on infinite waiting . am i missing any thing

┆Issue is synchronized with this Jira Bug by Unito

[sangeethdba]

[2021-07-09 16:01:58] FINE [liquibase.executor] -1 row(s) affected [2021-07-09 16:01:58] FINE [liquibase.ext] Created database lock table with name: comconfigs_test.DATABASECHANGELOGLOCK [2021-07-09 16:01:58] FINE [liquibase.executor] Executing with the 'jdbc' executor [2021-07-09 16:01:58] INFO [liquibase.ext] Waiting for changelog lock.... [2021-07-09 16:02:08] INFO [liquibase.ext] No DATABASECHANGELOGLOCK available in cassandra. [2021-07-09 16:02:08] INFO [liquibase.ext] No DATABASECHANGELOGLOCK available in cassandra. [2021-07-09 16:02:08] INFO [liquibase.ext] Successfully released change log lock [2021-07-09 16:02:08] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 6 thread-local buffer(s) from thread: cluster1-nio-worker-9 [2021-07-09 16:02:08] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 6 thread-local buffer(s) from thread: cluster1-nio-worker-8 [2021-07-09 16:02:08] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 6 thread-local buffer(s) from thread: cluster1-nio-worker-7 [2021-07-09 16:02:08] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 6 thread-local buffer(s) from thread: cluster1-nio-worker-10 [2021-07-09 16:02:08] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 6 thread-local buffer(s) from thread: cluster1-nio-worker-11 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 14 thread-local buffer(s) from thread: cluster1-nio-worker-3 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 12 thread-local buffer(s) from thread: cluster1-nio-worker-2 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 12 thread-local buffer(s) from thread: cluster1-nio-worker-6 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 14 thread-local buffer(s) from thread: cluster1-nio-worker-1 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 25 thread-local buffer(s) from thread: cluster1-nio-worker-0 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 13 thread-local buffer(s) from thread: cluster1-nio-worker-5 [2021-07-09 16:02:10] FINE [com.simba.cassandra.shaded.io.netty.buffer.PoolThreadCache free] Freed 12 thread-local buffer(s) from thread: cluster1-nio-worker-4 [2021-07-09 16:02:10] SEVERE [liquibase.integration] Could not acquire change log lock. Currently locked by UNKNOWN liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Could not acquire change log lock. Currently locked by UNKNOWN at liquibase.command.CommandScope.execute(CommandScope.java:153) at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:45) at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:15) at picocli.CommandLine.executeUserObject(CommandLine.java:1953) at picocli.CommandLine.access$1300(CommandLine.java:145) at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352) at picocli.CommandLine$RunLast.handle(CommandLine.java:2346) at picocli.CommandLine$RunLast.handle(CommandLine.java:2311) at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179) at picocli.CommandLine.execute(CommandLine.java:2078) at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:306) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:151) at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:289) at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:83) Caused by: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Could not acquire change log lock. Currently locked by UNKNOWN at liquibase.integration.commandline.Main$1.run(Main.java:444) at liquibase.integration.commandline.Main$1.run(Main.java:222) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:151) at liquibase.integration.commandline.Main.run(Main.java:222) at liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32) at liquibase.command.CommandScope.execute(CommandScope.java:147) ... 14 more Caused by: liquibase.exception.LockException: Could not acquire change log lock. Currently locked by UNKNOWN at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:232) at liquibase.hub.HubUpdater.register(HubUpdater.java:395) at liquibase.Liquibase.lambda$update$1(Liquibase.java:237) at liquibase.Scope.lambda$child$0(Scope.java:166) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:165) at liquibase.Scope.child(Scope.java:144) at liquibase.Liquibase.runInScope(Liquibase.java:2363) at liquibase.Liquibase.update(Liquibase.java:211) at liquibase.Liquibase.update(Liquibase.java:197) at liquibase.integration.commandline.Main.doMigration(Main.java:1881) at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:399) at liquibase.Scope.lambda$child$0(Scope.java:166) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:165) at liquibase.Scope.child(Scope.java:144) at liquibase.integration.commandline.Main$1.run(Main.java:398) ... 20 more

Unexpected error running Liquibase: Could not acquire change log lock. Currently locked by UNKNOWN

liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Could not acquire change log lock. Currently locked by UNKNOWN at liquibase.command.CommandScope.execute(CommandScope.java:153) at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:45) at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:15) at picocli.CommandLine.executeUserObject(CommandLine.java:1953) at picocli.CommandLine.access$1300(CommandLine.java:145) at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352) at picocli.CommandLine$RunLast.handle(CommandLine.java:2346) at picocli.CommandLine$RunLast.handle(CommandLine.java:2311) at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179) at picocli.CommandLine.execute(CommandLine.java:2078) at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:306) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:151) at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:289) at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:83) Caused by: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Could not acquire change log lock. Currently locked by UNKNOWN at liquibase.integration.commandline.Main$1.run(Main.java:444) at liquibase.integration.commandline.Main$1.run(Main.java:222) at liquibase.Scope.child(Scope.java:175) at liquibase.Scope.child(Scope.java:151) at liquibase.integration.commandline.Main.run(Main.java:222) at liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32) at liquibase.command.CommandScope.execute(CommandScope.java:147) ... 14 more

[sangeethdba]

@nvoxland ^^