Applies to:
- Liquibase Pro
- Liquibase Open Source (Community)
Conditions:
- Liquibase Pro or Open Source version 4.25.0+
- ING Cassandra driver
- Cassandra
Issue Summary:
When attempting to use any Liquibase command against a target Cassandra database, an error for no nodes available occurs.
Error Message:
Unexpected error running Liquibase: Error...: com.datastax.oss.driver.api.core.NoNodeAvailableException: No node was available to execute the query
Root Cause:
Liquibase v4.25.0 changed the default supported driver to the ING driver, which requires the localdatacenter
to be set in the URL.
Resolution:
The standard URL to connect to a Cassandra database using the ING driver is:
jdbc:cassandra://:/?localdatacenter=&compliancemode=Liquibase
The localdatacenter
value will vary depending on your Cassandra database.
If you don’t know what your localdatacenter
is called, you can easily find this out by using the nodetool status
command (automatically installed on Cassandra servers). You will need to access your server via a CLI and run nodetool status
, which will give the localdatacenter
name. If you are unsure how to obtain this information, please contact your Cassandra DBA.
Related Article(s):
N/A
Comments
0 comments
Article is closed for comments.