Troubleshooting

Auto-generated Keyspaces

If you encounter issues with automatically generated Keyspaces through ORS startup when the Keyspace name does not exist, perform the following:

• On one Cassandra instance execute the following with cqlsh. Log in:

…>DROP KEYSPACE “Orchestration”;

This will take several minutes to propagate to all Cassandra instances. During this time ORS will lose connection with the Cassandra cluster. Once the Keyspace has been dropped by Cassandra, the instances will accept client (ORS) connections. ORS will then reconnect and auto generate the schema.

• To verify that ORS has reconnected and set the schema, check with cqlsh:

…>use “Orchestration”;

(if ORS has reconnected the above command will be successful).

…>describe schema;

(this will be the ORS auto-generated schema)

• Quit cqlsh.

• Run the following query to alter the auto-generated schema:

cqlsh -f cassandra_ors_schema_alter.cql