Liquibase with DataStax Astra is not working

General Discussion
1

Hi I am using Liquibase and Datastax astra and followed this document

https://contribute.liquibase.com/extensions-integrations/directory/database-tutorials/cassandra/datastax-astra-db/

But it seems the things are not working.

The liquibase status works.
But when I do update it just hanged

[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DisableCheckConstraintGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.DropCheckConstraintGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.checkconstraint.change.EnableCheckConstraintGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageBodyGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.CreatePackageGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageBodyGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.databasepackage.change.DropPackageGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.CreateFunctionGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.function.change.DropFunctionGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.CreateTriggerGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DisableTriggerGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.DropTriggerGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.EnableTriggerGenerator
[2024-04-24 12:17:57] FINE [liquibase.servicelocator] Loaded liquibase.sqlgenerator.SqlGenerator instance com.datical.liquibase.ext.storedlogic.trigger.change.RenameTriggerGenerator
[2024-04-24 12:17:57] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:17:57] FINE [liquibase.configuration] No configuration value for liquibase.changelogLockPollRate aka liquibase.changeLogLockPollRate found
[2024-04-24 12:17:57] FINE [liquibase.configuration] Configuration liquibase.changelogLockPollRate is using the default value of 10
[2024-04-24 12:18:07] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:18:17] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:18:27] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:18:37] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:18:47] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:18:57] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:07] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:17] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:28] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:38] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:48] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:19:58] INFO [liquibase.ext] Waiting for changelog lock....                                                    [2024-04-24 12:20:08] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:20:18] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:20:28] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:20:38] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:20:48] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:20:58] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:08] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:18] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:28] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:38] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:48] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:21:59] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:22:09] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:22:19] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:22:29] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:22:39] INFO [liquibase.ext] Waiting for changelog lock....
[2024-04-24 12:22:49] INFO [liquibase.ext] Waiting for changelog lock....

what it is waiting for change lock ?

Can someone confirm if Liquibase works with Astra Database and give me the steps ??

2

This typically indicates that Liquibase is already running, so if that is not the case (you can check the contents of the databasechangeloglock table) I would say that this platform is not directly supported.

3 

https://contribute.liquibase.com/extensions-integrations/directory/database-tutorials/cassandra/datastax-astra-db/

Can you please verify the liquibase documentation of the above and validate if this is working ? We followed everything step by step but things are not working. If you say " this platform is not directly supported." then the liquibase documentation should be corrected.

4

That page indicates that a Liquibase extension is required to use this DBMS platform:

  1. Download the jar files
5

Hi,
I have tried using the " Cassandra JDBC wrapper" and " Liquibase Cassandra extension (liquibase-cassandra-<version>.jar ) from GitHub" and didn’t get any luck.

Can you or someone from Liquibase test the connectivity with Astra and confirm that it is working ??

If this is working also let me know the steps…