Cqlsh describe is missing a column visible in system.schema_columns

0
votes

After playing with Cassandra (many DROP KEYSPACE, CREATE KEYSPACE, ALTER TABLE, CREATE TABLE operations), for the second time I've ended up with following strange situation:

Describe x.logs: Describe x.logs

System.schema_columns: System.schema_columns

Alter table: Alter table

Nodetool repair doesn't fix it. After dropping the keyspace everything goes back to normal.

My configuration:

  • 1 Cassandra node cluster
  • cqlsh 5.0.1
  • Cassandra 2.2.0
  • CQL spec 3.3.0 | Native protocol v4

Questions:

  • What happened?
  • Why that happened? Is it dangerous?
  • How can I fix it?
1
cassandracqlcassandra-2.0cql3cqlsh
If you have reproduction steps for how you got to this state, we would appreciate seeing them. – Adam Holmberg
Unfortunately, this happened to me second time and I haven't figured out the reproduction steps yet. – piotrwest

1 Answers

0
votes

It seems like the driver metadata model (used by cqlsh) is out of sync. This is not expected since the driver refreshes schema synchronously with DDL statements.

If you stop and restart cqlsh it will DESC what's there.