You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Игорь С <ki...@gmail.com> on 2016/07/01 17:04:10 UTC
Fwd: Schema change issue
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