OpsCenter releases prior to 6.5 still use the
COMPACT STORAGE clause. Upgrading to 6.5 does not remove this.
DSE6.0.0 and OpsCenter releases 6.0.x and 6.1.x
If the tables are not altered in DSE prior to upgrading to 6.0 the user will not be able to start the node and will observe the following error in their Cassandra
ERROR [main]:40:14,450 CassandraDaemon.java:820 - Compact Tables are not allowed in Cassandra starting with 4.0 version. In order to migrate off Compact Storage, downgrade to the latest DSE 5.0/5.1, start the node with `-Dcassandra.commitlog.ignorereplayerrors=true` and run the following commands: ALTER TABLE OpsCenter.bestpractice_results DROP COMPACT STORAGE; ALTER TABLE OpsCenter.events DROP COMPACT STORAGE; ALTER TABLE OpsCenter.events_timeline DROP COMPACT STORAGE; ALTER TABLE OpsCenter.pdps DROP COMPACT STORAGE; ALTER TABLE OpsCenter.rollups300 DROP COMPACT STORAGE; ALTER TABLE OpsCenter.rollups60 DROP COMPACT STORAGE; ALTER TABLE OpsCenter.rollups7200 DROP COMPACT STORAGE; ALTER TABLE OpsCenter.rollups86400 DROP COMPACT STORAGE; ALTER TABLE OpsCenter.settings DROP COMPACT STORAGE;
OpsCenter tables prior to 6.5 use the
COMPACT STORAGE clause to maintain thrift client compatibility. DSE6.0 dropped any further support for thrift clients.
- Downgrade the node to DSE5.1.6 or higher
- Restart the node with
- Issue the correct
ALTER TABLE...statements to correct the schema. Remember to quote the Table names if they are case sensitive.
Important: Support for Thrift-compatible tables (COMPACT STORAGE) is dropped in DSE 6.0. Before upgrading to DSE 6.0, all tables that have COMPACT STORAGE to CQL table format must be migrated. Use the ALTER TABLE DROP COMPACT STORAGE command to migrate Thrift-compatible tables to CQL table format. This command is available in DSE 5.1.6 or later.