You're viewing **Apigee Edge** documentation.  
[Go to the
**Apigee X** documentation](http://cloud.google.com/apigee/docs/api-platform/troubleshoot/playbooks/cassandra/ts-cassandra). info

> [!NOTE]
> **Note:** This topic applies to Edge Private Cloud only.

### Diagnostic information


This section explains the diagnostic information that needs to be gathered for Cassandra
problems on the Private Cloud setup.

| Diagnostic information | Where can I gather this information? | How do I gather this information? |
|---|---|---|
| Cassandra configuration files | Cassandra | ``` cp /opt/apigee/apigee-cassandra/conf/cassandra-rackdc.properties /tmp/cassandra_rackdc_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).properties ``` ``` cp /opt/apigee/apigee-cassandra/conf/cassandra-env.sh /tmp/cassandra_envsh_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).sh ``` ``` cp /opt/apigee/apigee-cassandra/conf/jvm-server.options /tmp/jvm_server_options_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).options ``` ``` cp /opt/apigee/apigee-cassandra/conf/cassandra.yaml /tmp/cassandra_conf_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).yaml ``` For Edge for Private Cloud 4.54.00 or later (Cassandra 5.0.x), copy `jvm17-server.options`: ``` cp /opt/apigee/apigee-cassandra/conf/jvm17-server.options /tmp/jvm17_server_options_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).options ``` For Edge for Private Cloud 4.53.00 or 4.53.01 (Cassandra 4.0.x), copy `jvm8-server.options` instead: ``` cp /opt/apigee/apigee-cassandra/conf/jvm8-server.options /tmp/jvm8_server_options_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).options ``` |
| Nodetool commands output | Cassandra | ``` alias nodetool=/opt/apigee/apigee-cassandra/bin/nodetool ``` Get the current Cassandra version: ``` nodetool version 2>&1 | tee /tmp/nodetool_version_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get the current Cassandra datacenter status: ``` nodetool status 2>&1 | tee /tmp/nodetool_status_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get the current ring/token status across the datacenter: ``` nodetool ring 2>&1 | tee /tmp/nodetool_ring_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get more information about heap usage, uptime, exceptions, and so on: ``` nodetool info 2>&1 | tee /tmp/nodetool_info_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get gossip info: ``` nodetool gossipinfo 2>&1 | tee /tmp/nodetool_gossipinfo_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get status of the current Cassandra operations: ``` nodetool compactionstats -H 2>&1 | tee /tmp/nodetool_compactionstats_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` ``` nodetool tpstats 2>&1 | tee /tmp/nodetool_tpstats_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` ``` nodetool netstats -H 2>&1 | tee /tmp/nodetool_netstats_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` ``` nodetool tablestats -H 2>&1 | tee /tmp/nodetool_tablestats_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` Get proxy histograms (shows the full request latency recorded by the coordinator): ``` nodetool proxyhistograms 2>&1 | tee /tmp/nodetool_proxyhistograms_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` |
| Cassandra logs | Cassandra | ``` tar cvzf /tmp/cassandra_logs_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).tar.gz /opt/apigee/var/log/apigee-cassandra/system* /opt/apigee/var/log/apigee-cassandra/config* ``` ``` tail -2000 /opt/apigee/var/log/apigee-cassandra/apigee-cassandra.log > /tmp/cassandra_apigee-cassandra_log_$(hostname)_$(date +%Y.%m.%d_%H.%M.%S).log ``` |
| Version and status of components | Cassandra | ``` apigee-all version 2>&1 | tee /tmp/apigee_all_version_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` ``` apigee-all status 2>&1 | tee /tmp/apigee_all_status_$(hostname)-$(date +%Y.%m.%d_%H.%M.%S).txt ``` |
| Compress all the diagnostic data | Cassandra | ``` tar -cvzf /tmp/data_CASE_NUMBER_$(hostname).tar.gz /tmp/nodetool* /tmp/cassandra_* /tmp/jvm* /tmp/apigee_all* ``` > [!NOTE] > **Note:** Replace `CASE_NUMBER` with the specific case number for which you are providing these documents. |