liquibase/liquibase-cassandra

liquibase on infinetoop waiting for change lock

sangeethdba opened this issue · 2 comments

sangeethdba commented

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 commented

[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