CODEWITHSUNDEEP
cassandracassandra-3.0
rupesh
rupesh

Reputation: 433

How to resolve issue in Cassandra "ConfigurationException: Column family ID mismatch"

We tried adding a new column to an existing table in Cassandra. It ended up giving an exception "org.apache.cassandra.exceptions.ConfigurationException: Column family ID mismatch".

  1. When we execute the command "describe " --> New columns was added.
  2. when we tried to insert the data --> it throws an exception that "the newly added column does NOT exist".
  3. We tried to recreate the table by dropping it --> Table gets dropped but while recreating it says table already exists.

Seems like some issue with Cassandra sync.

I want this issue to be resolved without any need to restart the Cassandra Nodes.

Can someone suggest the right approach to resolve this?

Thanks.

Upvotes: 1

Views: 612

Answers (2)

rupesh
rupesh

Reputation: 433

The rolling restart of the cluster resolved this issue. Thanks.

Upvotes: 1

Alex Tbk
Alex Tbk

Reputation: 2104

Flushing memtables (nodetool flush) should resolve the issue. Flushing does not require restarting cassandra whereas draining does.

See: Column family ID mismatch during ALTER TABLE

Upvotes: 0

Related Questions