cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Игорь С <kiberne...@gmail.com>
Subject Fwd: Schema change issue
Date Fri, 01 Jul 2016 17:04:10 GMT
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

Mime
View raw message