Skip to main content
Skip table of contents

Troubleshooting Cassandra data sources


The following logs will help to diagnose dSource/VDB issues related to this plugin.

Cassandra dSource/VDB log files


Cassandra log files: Cassandra can write messages to log files. The files are named using the following format and can be found at location mentioned in file:

Verify CASSANDRA_LOG_DIR variable in {Cassandra_install_path}/resources/cassandra/conf/ file

For Example:


To make it easier to watch a Cassandra startup log without knowing the full filename, a symlink with the short filename cassandra.log is also created. This symlink points to the most recent log. The Cassandra startup log location on staging or target host can be found at below location:


Troubleshooting Queries

Identify DataStax Cassandra Version

{Cassandra_install_path}/bin/dse -v
For example: 
/u02/cassandra/node1/bin/dse -v

Identify Open-Source Apache Cassandra Version:

{Cassandra_install_path}/bin/cassandra -v
For example: 
/u01/cassandra/apache-cassandra-4.0.7/bin/cassandra -v

Start DataStax Enterprise Cassandra multi-node cluster:

{Cassandra_install_path}/bin/dse cassandra

Stop DataStax Enterprise Cassandra multi-node cluster:

{Cassandra_install_path}/bin/dse cassandra-stop -p {pid}

Start Open-Source Apache Cassandra multi-node cluster:


Stop Open-Source Apache Cassandra multi-node cluster:

# Terminate the active cassandra process using:
kill -9 {pid}

Start interactive Cassandra CQL shell:

{Cassandra_install_path}/bin/cqlsh {host} {port} --username {username} --password {password}"

Start interactive Cassandra CQL shell with SSL encryption:

{Cassandra_install_path}/bin/cqlsh {host} {port} --ssl --username {username} --password {password}"

Configure a cqlshrc file that contains CQL shell session settings that are used when the CQL shell starts.

  1. Copy the cqlshrc.sample.ssl file to the ~/.cassandra/ directory. If the Cassandra base installation directory is located at /u02/cassandra/dse-6.8.33, then the sample cqlshrc file will be located under resources/cassandra/conf/cqlshrc.sample.ssl

  2. Rename the file to cqlshrc copied in Step 1 under ~/.cassandra/cqlshrc directory.

  3. Modify or update the cqlshrc file as per your cluster configuration. For example:

    > cat .cassandra/cqlshrc 
    username = dlpxadmin
    password = *******
    hostname =
    port = 9042
    ; factory = cqlshlib.ssl.ssl_transport_factory
    certfile = /home/delphix/certs/rootca.crt
    ; optional - true by default.
    validate = true
    userkey = /home/delphix/certs/client_key.key
    usercert = /home/delphix/certs/client_cert.crt_signed
  4. Restart the CQL shell.

    > {Cassandra_install_path}/bin/cqlsh --ssl
    Connected to datastaxstg at
    [cqlsh 6.8.0 | DSE 6.8.33 | CQL spec 3.4.5 | DSE protocol v2 | TLSv1_2]
    Use HELP for help.
  5. Verify Cassandra Cluster Status:

    For example:
    /u02/cassandra/node1_delphix_dsestg_n_0/bin/nodetool status
    Datacenter: Cassandra
    |/ State=Normal/Leaving/Joining/Moving/Stopped
    --  Address    Load       Tokens       Owns (effective)  Host ID                               Rack
    UN  185.97 KiB  1            61.6%             35a2a647-f3b8-4f2d-ad25-ab8376bc12ad  rack1
    UN  148.97 KiB  1            44.9%             5f1b513e-6caf-4faa-bd26-4e9344689c80  rack1
    UN  148.86 KiB  1            93.5%             cf4a0f6f-ffe5-40a4-b68d-fec5e449f341  rack1
  6. Verify Cassandra Cluster setting across all nodes:

    {Cassandra_install_path}/bin/nodetool describecluster
    For example:
    /u02/cassandra/node1_delphix_dsestg_n_0/bin/nodetool describecluster
    Cluster Information:
        Name: dsestg
        Snitch: com.datastax.bdp.snitch.DseSimpleSnitch
        DynamicEndPointSnitch: enabled
        Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
        Schema versions:
            a100bba8-50a7-3c2f-959d-695342f1d061: [,,]
  7. Create Cassandra User to restrict access to Cassandra cluster:

    create role {username} with SUPERUSER = true AND LOGIN = true AND PASSWORD = '{password}';

For more information on common cassandra commands, please refer to Cassandra official documentation.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.