Carlos, Yes, I'm running multiple clients simultaneously. Each one of them tries to create table if it doesn't exists in the cassandra.
Ali, I've cleared the data directory. Next time, If it reoccurs, I'll follow the steps listed and come here again. Thanks for the information. Regards, Kamal C On Tue, Aug 16, 2016 at 3:29 PM, <ali.hub...@petrolink.com> wrote: > It seems that the table was created twice (concurrently). One with > b2b1bcd0-5f94-11e6-867a-cb7beeeeb92c id and the other with > b2b47bf0-5f94-11e6-867a-cb7beeeeb92c. > If you programmatically create tables, it's generally a bad idea, > especially with multiple clients. > > Anyways, execute the following and see what you have in there > select * from system_schema.tables where id = > b2b47bf0-5f94-11e6-867a-cb7beeeeb92c > allow filtering; > select * from system_schema.tables where id = > b2b1bcd0-5f94-11e6-867a-cb7beeeeb92c > allow filtering; > > Go to your data directory, and inside your keyspace, you should see your > table followed by a uuid, how many directories of your table do you have > there? and what's inside them? do both of them have data, or just one. > > -Ali H > > > > From: Kamal C <kamaltar...@gmail.com> > To: user@cassandra.apache.org, > Date: 08/16/2016 11:51 AM > Subject: Cassandra Exception > ------------------------------ > > > > 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. > CFMetaData@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. > cassandra.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. > cassandra.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. > CFMetaData@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. > cassandra.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. > cassandra.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. > mergeSchemaAndAnnounceVersion(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. > announceNewColumnFamily(MigrationManager.java:343) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.service.MigrationManager. > announceNewColumnFamily(MigrationManager.java:313) > ~[apache-cassandra-3.7.jar:3.7] > at org.apache.cassandra.cql3.statements.CreateTableStatement. > announceMigration(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( > SimpleChannelInboundHandler.java:105) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead( > AbstractChannelHandlerContext.java:292) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext.access$600( > AbstractChannelHandlerContext.java:32) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > at io.netty.channel.AbstractChannelHandlerContext$7.run( > AbstractChannelHandlerContext.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.AbstractLocalAwareExecutorServ > ice$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 >