Ok cool, glad you found the issue. Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 August 2016 at 09:48, Kamal C <[email protected]> wrote: > 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, <[email protected]> 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 <[email protected]> >> To: [email protected], >> 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.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 >> > >
