Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleDrop SDC keyspaces from shared Cassandra
collapsetrue
root@release-rancher:~# kubectl -n onap exec -it dev-cassandra-cassandra-0 -- cqlsh -u cassandra -p cassandra -e "describe keyspaces"

sdccomponent  system_auth  sdcaudit     system_distributed  sdctitan     
workflow      system       dox          system_traces       sdcrepository
zusammen_dox  aaigraph     sdcartifact  zusammen_workflow 

root@sb00-rancher:~/oom# kubectl -n onap exec -it dev-cassandra-cassandra-0 bash
root@dev-cassandra-cassandra-0:/# cqlsh -u cassandra -p cassandra
Connected to cassandra at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 2.2.14 | CQL spec 3.3.1 | Native protocol v4]
Use HELP for help.
cassandra@cqlsh> describe keyspaces;

sdccomponent system_auth sdcaudit system_distributed sdctitan 
workflow system dox system_traces sdcrepository
zusammen_dox aaigraph sdcartifact zusammen_workflow

cassandra@cqlsh> drop keyspace sdccomponent;
OperationTimedOut: errors={'127.0.0.1': 'Request timed out while waiting for schema agreement. See Session.execute[_async](timeout) and Cluster.max_schema_agreement_wait.'}, last_host=127.0.0.1
cassandra@cqlsh> drop keyspace sdcaudit;
OperationTimedOut: errors={'127.0.0.1': 'Request timed out while waiting for schema agreement. See Session.execute[_async](timeout) and Cluster.max_schema_agreement_wait.'}, last_host=127.0.0.1

cassandra@cqlsh> 
cassandra@cqlsh> drop keyspace sdctitan;
cassandra@cqlsh> drop keyspace sdcrepository;
cassandra@cqlsh> drop keyspace sdcartifact;
cassandra@cqlsh> 
cassandra@cqlsh> 
cassandra@cqlsh> describe keyspaces;

workflow system_auth aaigraph dox system_traces
zusammen_dox system zusammen_workflow system_distributed

...