Cannot Connect to Cassandra-compatible YCQL API

AttentionThis page documents an earlier version. Go to the latest (v2.1)version.

1. Are YugabyteDB processes running?

First, ensure that the expected YugabyteDB processes on the current node.At a minimum, the tserver process needs to be running to be able to connect to this node with a CQL client or application.Additionally, depending on the setup, you might expect a master process to also be running on this node.Follow the instructions on the Check Processes page.

2. Is the YugabyteDB Cassandra server running?

If the tserver process is running, make sure the Yugabyte CQL server is enabled and listening on the CQL port (default 9042).

  1. $ lsof -i :9042
  1. COMMAND     PID   USER   FD   TYPE     DEVICE SIZE/OFF NODE NAME
  2. yb-tserve 81590 centos  131u  IPv4 0xdeadbeef      0t0  TCP localhost:9042 (LISTEN)

Note: You may need to install lsof first.

When running a local cluster with yb-ctl you should see all the nodes here with different IPs. For instance:

  1. $ lsof -i :9042
  1. COMMAND     PID   USER   FD   TYPE     DEVICE SIZE/OFF NODE NAME
  2. yb-tserve 81590 centos  131u  IPv4 0xdeadbeef      0t0  TCP localhost:9042 (LISTEN)
  3. yb-tserve 81593 centos  131u  IPv4 0xdeadbeef      0t0  TCP 127.0.0.2:9042 (LISTEN)
  4. yb-tserve 81596 centos  131u  IPv4 0xdeadbeef      0t0  TCP 127.0.0.3:9042 (LISTEN)

If there is another process using this port you might need to stop that and restart the tserver process.Otherwise, if no process is listening but the tserver is running, check the value of the —cql_proxy_bind_address flag passed to thetserver process.

3. Can the CQL shell connect locally?

Once on the machine where YugabyteDB is running, use cqlsh to connect to the local YugabyteDB instance.Depending on your installation, you may need to install cqlsh, otherwise you can find it in the Yugabyte bin directory.Try running:

  1. cqlsh <yb-local-address>

where <yb-local-address> is the address where the Yugabyte CQL server is listening (e.g. as returned by lsof). For instance, in the example above, it is localhost (or, additionally, 127.0.0.2 and 127.0.0.3 for the yb-ctl case).

If cqlsh can connect, the issue is likely a network issue with the original client not being able to access this node where YugabyteDB is running. See also Are Master or TServer Endpoints Accessible?.