Skip to main content

[Error] NoNodeAvailableException: No node was available to execute the query

Tylor Graves
Updated

Applies to: 

  • Liquibase Secure (Pro)
  • Liquibase Community (Open Source)

Conditions:

  • Liquibase Secure (Pro) or Community version 4.25.0+
  • ING Cassandra driver
  • Cassandra

Issue Summary:

When attempting to use any Liquibase command against a target Cassandra database, an error that no nodes are 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

 
 

Related to

Related articles

Comments

0 comments

Article is closed for comments.