[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450281#comment-13450281
]
Anton Winter commented on CASSANDRA-4561:
-----------------------------------------
After applying this patch (1.1.5-tentative) I see the future timestamps being
detected and fixed:
{code}
INFO [main] 2012-09-07 02:24:00,090 DefsTable.java (line 202) Fixing timestamps
of schema ColumnFamily schema_keyspaces...
INFO [main] 2012-09-07 02:24:00,168 DefsTable.java (line 202) Fixing timestamps
of schema ColumnFamily schema_columnfamilies...
{code}
If I list schema_keyspaces I still see the old (future) timestamps.
Given the timestamps weren't actually updated I did go back and found the
following error shortly after the restarted node joined the ring (this may or
not be related):
{code}ERROR [InternalResponseStage:1] 2012-09-07 02:24:16,555
AbstractCassandraDaemon.java (line 135) Exception in thread
Thread[InternalResponseStage:1,5,main]
java.lang.NullPointerException
at
org.apache.cassandra.db.DefsTable.mergeColumnFamilies(DefsTable.java:468)
at org.apache.cassandra.db.DefsTable.mergeSchema(DefsTable.java:346)
at
org.apache.cassandra.db.DefsTable.mergeRemoteSchema(DefsTable.java:324)
at
org.apache.cassandra.service.MigrationManager$MigrationTask$1.response(MigrationManager.java:416)
at
org.apache.cassandra.net.ResponseVerbHandler.doVerb(ResponseVerbHandler.java:45)
at
org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:59)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
{code}
I have however assumed that the patch automatically fixes this across all
servers in a multi dc ring once this patch is applied. If there is a specific
series of steps required to fix this, such as the full ring outage, deletion of
system/schema_* etc can it please be documented here, the wiki or in the
NEWS.txt file under upgrading notes?
> update column family fails
> --------------------------
>
> Key: CASSANDRA-4561
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4561
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4
> Reporter: Zenek Kraweznik
> Assignee: Pavel Yaskevich
> Fix For: 1.1.5
>
> Attachments: CASSANDRA-4561.patch
>
>
> [default@test] show schema;
> create column family Messages
> with column_type = 'Standard'
> and comparator = 'AsciiType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'AsciiType'
> and read_repair_chance = 0.1
> and dclocal_read_repair_chance = 0.0
> and gc_grace = 864000
> and min_compaction_threshold = 2
> and max_compaction_threshold = 4
> and replicate_on_write = true
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'
> and caching = 'KEYS_ONLY'
> and compaction_strategy_options = {'sstable_size_in_mb' : '1024'}
> and compression_options = {'chunk_length_kb' : '64', 'sstable_compression'
> : 'org.apache.cassandra.io.compress.DeflateCompressor'};
> [default@test] update column family Messages with min_compaction_threshold =
> 4 and max_compaction_threshold = 32;
> a5b7544e-1ef5-3bfd-8770-c09594e37ec2
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@test] show schema;
> create column family Messages
> with column_type = 'Standard'
> and comparator = 'AsciiType'
> and default_validation_class = 'BytesType'
> and key_validation_class = 'AsciiType'
> and read_repair_chance = 0.1
> and dclocal_read_repair_chance = 0.0
> and gc_grace = 864000
> and min_compaction_threshold = 2
> and max_compaction_threshold = 4
> and replicate_on_write = true
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'
> and caching = 'KEYS_ONLY'
> and compaction_strategy_options = {'sstable_size_in_mb' : '1024'}
> and compression_options = {'chunk_length_kb' : '64', 'sstable_compression'
> : 'org.apache.cassandra.io.compress.DeflateCompressor'};
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
