Are you running the migration to create the flapalarmcache table from more than one client concurrently?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso> On 16 August 2016 at 10:51, Kamal C <kamaltar...@gmail.com> wrote: > Hi all, > > I'm using cassandra-3.7 version, JRE 1.8, centos- 6.5 in standalone > mode. (only one cassandra node). > Cassandra clients are in JRE - 1.7. Once in a while, I'm getting the below > exceptions in the cassandra > but the data (put / get) is fine. I've searched to find the root-cause but > unable to conclude it. > > > INFO 07:24:53 Create new table: org.apache.cassandra.config.CF > MetaData@64b34445[cfId=b2b1bcd0-5f94-11e6-867a-cb7beeeeb92c, > ksName=fms,cfName=flapalarmcache,flags=[COMPOUND],params=TableParams{comment=, > read_repair_chance=0.0, dclocal_read_repair_chance=0.1, > bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=864000, > default_time_to_live=0, memtable_flush_period_in_ms=0, > min_index_interval=128, max_index_interval=2048, > speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', > 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class= > org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, > options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassand > ra.schema.CompressionParams@baaacb37, > extensions={}},comparator=comparator(),partitionColumns=[[] > | [alarm]],partitionKeyColumns=[ColumnDefinition{name=key, > type=org.apache.cassandra.db.marshal.BytesType, kind=PARTITION_KEY, > position=0}],clusteringColumns=[],keyValidator=org.apache.ca > ssandra.db.marshal.BytesType,columnMetadata=[ColumnDefinition{name=alarm, > type=org.apache.cassandra.db.marshal.BytesType, kind=REGULAR, > position=-1}, ColumnDefinition{name=key, > type=org.apache.cassandra.db.marshal.BytesType, > kind=PARTITION_KEY, position=0}],droppedColumns={},triggers=[],indexes=[]] > INFO 07:24:53 Create new table: org.apache.cassandra.config.CF > MetaData@641c948a[cfId=b2b47bf0-5f94-11e6-867a-cb7beeeeb92c, > ksName=fms,cfName=flapalarmcache,flags=[COMPOUND],params=TableParams{comment=, > read_repair_chance=0.0, dclocal_read_repair_chance=0.1, > bloom_filter_fp_chance=0.01, crc_check_chance=1.0, gc_grace_seconds=864000, > default_time_to_live=0, memtable_flush_period_in_ms=0, > min_index_interval=128, max_index_interval=2048, > speculative_retry=99PERCENTILE, caching={'keys' : 'ALL', > 'rows_per_partition' : 'NONE'}, compaction=CompactionParams{class= > org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy, > options={min_threshold=4, max_threshold=32}}, compression=org.apache.cassand > ra.schema.CompressionParams@baaacb37, > extensions={}},comparator=comparator(),partitionColumns=[[] > | [alarm]],partitionKeyColumns=[ColumnDefinition{name=key, > type=org.apache.cassandra.db.marshal.BytesType, kind=PARTITION_KEY, > position=0}],clusteringColumns=[],keyValidator=org.apache.ca > ssandra.db.marshal.BytesType,columnMetadata=[ColumnDefinition{name=alarm, > type=org.apache.cassandra.db.marshal.BytesType, kind=REGULAR, > position=-1}, ColumnDefinition{name=key, > type=org.apache.cassandra.db.marshal.BytesType, > kind=PARTITION_KEY, position=0}],droppedColumns={},triggers=[],indexes=[]] > INFO 07:24:55 Initializing fms.flapalarmcache > ERROR 07:24:57 Exception in thread Thread[MigrationStage:1,5,main] > org.apache.cassandra.exceptions.ConfigurationException: Column family ID > mismatch (found b2b47bf0-5f94-11e6-867a-cb7beeeeb92c; expected > b2b1bcd0-5f94-11e6-867a-cb7beeeeb92c) > at > org.apache.cassandra.config.CFMetaData.validateCompatibility(CFMetaData.java:789) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:749) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.config.Schema.updateTable(Schema.java:663) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.schema.SchemaKeyspace.updateKeyspace(SchemaKeyspace.java:1347) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.schema.SchemaKeyspace.mergeSchema(SchemaKeyspace.java:1303) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.schema.SchemaKeyspace.mergeSchemaAndAnn > ounceVersion(SchemaKeyspace.java:1253) ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.service.MigrationManager$1.runMayThrow(MigrationManager.java:532) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-3.7.jar:3.7] > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_45] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_45] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_45] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_45] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > ERROR 07:24:57 Unexpected error during query > java.lang.RuntimeException: java.util.concurrent.ExecutionException: > org.apache.cassandra.exceptions.ConfigurationException: Column family ID > mismatch (found b2b47bf0-5f94-11e6-867a-cb7beeeeb92c; expected > b2b1bcd0-5f94-11e6-867a-cb7beeeeb92c) > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:384) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:514) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.service.MigrationManager.announceNewCol > umnFamily(MigrationManager.java:343) ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.service.MigrationManager.announceNewCol > umnFamily(MigrationManager.java:313) ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.cql3.statements.CreateTableStatement.an > nounceMigration(CreateTableStatement.java:89) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.cql3.statements.SchemaAlteringStatement > .execute(SchemaAlteringStatement.java:93) ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:208) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:239) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:224) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:115) > ~[apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:507) > [apache-cassandra-3.7.jar:3.7] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:401) > [apache-cassandra-3.7.jar:3.7] > at io.netty.channel.SimpleChannelInboundHandler.channelRead(Sim > pleChannelInboundHandler.java:105) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext.invokeChannel > Read(AbstractChannelHandlerContext.java:292) > [netty-all-4.0.36.Final.jar:4.0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext.access$600(Ab > stractChannelHandlerContext.java:32) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext$7.run(Abstrac > tChannelHandlerContext.java:283) [netty-all-4.0.36.Final.jar:4.0.36.Final] > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_45] > at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorSe > rvice$FutureTask.run(AbstractLocalAwareExecutorService.java:164) > [apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) > [apache-cassandra-3.7.jar:3.7] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > > Is anyone faced similar exceptions ? How to resolve it ? > > Regards, > Kamal C >