Hi everyone, Got the issue on schema update.
Posted initially to Datastax Driver mail list, but looks like it could be internal cassandra issue. Could someone take a look please. For for more information see https://groups.google.com/a/lists.datastax.com/forum/#!topic/java-driver-user/0Fejc0DTUX0 1. Schema version before create table vagrant@node3:/var/log/cassandra$ date Fri Jul 1 14:49:33 UTC 2016 vagrant@node3:/var/log/cassandra$ nodetool describecluster Cluster Information: Name: c_cluster Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Schema versions: 0b57acd3-7650-3a1c-9bd8-d2f426781997: [10.1.1.113, 10.1.1.115, 10.1.1.114] 2. Run create table from app, wasApplied and schemaInAgreement are true in result's ExecutionInfo : <https://lh3.googleusercontent.com/-y4q5nmDU8D4/V3aKYWFueWI/AAAAAAAABI8/E9r1UQIwWlUnG0BjVHXH5Et8BFOsdJpOACLcB/s1600/02%2BCreate%2Bon%2Bnode3.JPG> 3. Cassandara log contains new info about create table issued, however schema version remains the same as before DEBUG [MigrationStage:1] 2016-07-01 14:49:24,291 MigrationManager.java:493 - Gossiping my schema version 89dc3713-d4c8-3cc7-8f83-ae1d58b7d1a5 DEBUG [GossipStage:1] 2016-07-01 14:49:24,423 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:24,423 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:25,400 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:25,400 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [MigrationStage:1] 2016-07-01 14:49:25,538 MigrationManager.java:493 - Gossiping my schema version 0b57acd3-7650-3a1c-9bd8-d2f426781997 DEBUG [GossipStage:1] 2016-07-01 14:49:26,385 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:26,486 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:27,369 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false INFO [SharedPool-Worker-1] 2016-07-01 14:49:47,491 MigrationManager.java:308 - Create new table: org.apache.cassandra.config.CFMetaData@75089720[cfId=0e5e2330-3f9b-11e6-8953-a120c4d78cc6,ksName=xxx,cfName=foo,cfType=Standard,comparator=org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type),comment=,readRepairChance=0.0,dcLocalReadRepairChance=0.1,gcGraceSeconds=864000,defaultValidator=org.apache.cassandra.db.marshal.BytesType,keyValidator=org.apache.cassandra.db.marshal.UUIDType,minCompactionThreshold=4,maxCompactionThreshold=32,columnMetadata=[ColumnDefinition{name=user_id, type=org.apache.cassandra.db.marshal.UUIDType, kind=PARTITION_KEY, componentIndex=null, indexName=null, indexType=null}, ColumnDefinition{name=name, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=null, indexType=null}],compactionStrategyClass=class org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy,compactionStrategyOptions={},compressionParameters={sstable_compression=org.apache.cassandra.io.compress.LZ4Compressor},bloomFilterFpChance=0.01,memtableFlushPeriod=0,caching={"keys":"ALL", "rows_per_partition":"NONE"},defaultTimeToLive=0,minIndexInterval=128,maxIndexInterval=2048,speculativeRetry=99.0PERCENTILE,droppedColumns={},triggers=[],isDense=false] DEBUG [MigrationStage:1] 2016-07-01 14:49:47,542 MigrationManager.java:493 - Gossiping my schema version 0b57acd3-7650-3a1c-9bd8-d2f426781997 DEBUG [GossipStage:1] 2016-07-01 14:49:48,053 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false DEBUG [GossipStage:1] 2016-07-01 14:49:48,500 MigrationManager.java:96 - Not pulling schema because versions match or shouldPullSchemaFrom returned false 4. Check schema version - the same as before vagrant@node3:/var/log/cassandra$ date Fri Jul 1 14:49:53 UTC 2016 vagrant@node3:/var/log/cassandra$ nodetool describecluster Cluster Information: Name: c_cluster Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Schema versions: 0b57acd3-7650-3a1c-9bd8-d2f426781997: [10.1.1.113, 10.1.1.115, 10.1.1.114] 5. Try to use table created vagrant@node3:/var/log/cassandra$ cqlsh -e "select * from xxx.foo;" node3 <stdin>:1:InvalidRequest: code=2200 [Invalid query] message="unconfigured table foo" Driver 3.0.0 Cassandra 2.2.4 Thanks, Igor S
