Error: unable to connect to cassandra server. Unconfigured table

Olzhabay picture Olzhabay · Aug 5, 2015 · Viewed 14.1k times · Source

I am trying to connect to cassandra, which is running on local desktop, via cassandra-driver for python using this simple code.

 from cassandra.cluster import Cluster
 cluster = Cluster()
 session = cluster.connect()

and getting this error: NoHostAvailable: ('Unable to connect to any servers', {'127.0.0.1': InvalidRequest(u'code=2200 [Invalid query] message="unconfigured table schema_keyspaces"',)})

From the logs of cassandra, I see how it does establish connection, but it gets this errors:

DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_columnfamilies, v=4
DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_usertypes, v=4
DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_columns, v=4
DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_functions, v=4
DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_aggregates, v=4
DEBUG 05:51:00 Responding: ERROR INVALID: unconfigured table schema_triggers, v=4

Any help to solve this problem with unconfigured tables will be appreciated.

Answer

Adam Holmberg picture Adam Holmberg · Aug 5, 2015

Are you possibly using the driver to connect to Cassandra 3.0.0-alpha1? If so, you'd need to be running the driver installed from this commit:

https://github.com/datastax/python-driver/tree/1a480f196ade42798596f5257d2cbeffcadf154f

Alternatively:

  • If you're just experimenting, the released drivers as of today work with all Cassandra versions 1.2 - 2.2.0
  • DataStax is readying a 3.0.0a1 version of the driver for use with Cassandra 3.0.0-alpha1, which will be available in pypi soon.

  • install the 3.0.0 alpha version of the driver as follows:

    pip install --pre cassandra-driver

    pip install --pre --upgrade cassandra-driver