[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452613#comment-13452613
]
Hudson commented on CASSANDRA-4561:
---
Integrated in Cassandra #2084 (See
[https://builds.apache.org/job/Cassandra/2084/])
change ColumnSerializer.deserialize to be able fix timestamps from future,
related to CASSANDRA-4561 (Revision 2c69e2ea757be9492a095aa22b5d51234c4b4102)
change ColumnSerializer.deserialize to be able fix timestamps from future,
related to CASSANDRA-4561 (Revision 429fa7a80e22757a55c03e99c27c157824a666af)
Result = ABORTED
xedin :
Files :
* src/java/org/apache/cassandra/db/ColumnSerializer.java
xedin :
Files :
* src/java/org/apache/cassandra/db/ColumnSerializer.java
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450746#comment-13450746
]
Pavel Yaskevich commented on CASSANDRA-4561:
Committed to cassandra-1.1 branch.
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450733#comment-13450733
]
Jonathan Ellis commented on CASSANDRA-4561:
---
+1 lgtm
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450670#comment-13450670
]
Anton Winter commented on CASSANDRA-4561:
-
Ring upgraded with the second patch and I am now able to perform schema
updates. Thanks!
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450604#comment-13450604
]
Anton Winter commented on CASSANDRA-4561:
-
I've patched & deployed to a couple of nodes where I now see the corrected
timestamps. The NPE appears to also be gone.
It will take me some time to deploy to the entire ring but it looks promising
so far.
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450548#comment-13450548
]
Zenek Kraweznik commented on CASSANDRA-4561:
When cassandra 1.1.5 will be available?
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450545#comment-13450545
]
Pavel Yaskevich commented on CASSANDRA-4561:
As I see from the log - timestamps were actually fixed to "7 september 2012 cl
10:58 GMT" but then overriten by remote migration, latest patch should help
with that.
> 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-CS.patch, 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450535#comment-13450535
]
Anton Winter commented on CASSANDRA-4561:
-
Debug log sent to [~xedin] privately.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450534#comment-13450534
]
Pavel Yaskevich commented on CASSANDRA-4561:
I understand, but we don't know if that is caused by the fix not working or by
something else as exception indicates that something was send to the node, this
could be a separate issue. I will work on the ColumnSerializer change I
mentioned and we'll see if it helps.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450531#comment-13450531
]
Sylvain Lebresne commented on CASSANDRA-4561:
-
Well, Anton still sees timestamp in the future and is still unable to do schema
updates, it does sound a lot like there is a problem and it's related to this
ticket. I just meant that I prefer keeping that in mind before releasing 1.1.5
into the wild too quickly.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450529#comment-13450529
]
Pavel Yaskevich commented on CASSANDRA-4561:
I just thought that a good addition to existing patch could be change in
ColumnSerializer.deserialize to fix timestamps from the future, that way
migrations from the remote locations would be deserialized with correct
timestamp even if they were sent with the wrong one...
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450526#comment-13450526
]
Pavel Yaskevich commented on CASSANDRA-4561:
We are not yet sure what is the problem so I think we should hold on reopening
for a bit.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450512#comment-13450512
]
Sylvain Lebresne commented on CASSANDRA-4561:
-
Maybe we should reopen this if that didn't fully fixed the problem? I'd better
hold on a bit on 1.1.5 if this is not fixed yet as this seem to hit quite a few
people.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450485#comment-13450485
]
Pavel Yaskevich commented on CASSANDRA-4561:
Interesting, why does it try to merge remote schema if all of your nodes are in
agreement, can you run in debug mode as attach the log? The thing is timestamps
are fixed long before the storage server is initialized and the process
involves truncate of the system.schema_* CFs so I don't see any other reason
why your schema still has old timestamps except some other node sent it
migration request...
NPE that you experience is also interesting, cfMetaData() is always not null as
CFs are copied from one map to another on KS initialization, and KS itself
could not be null or you would have the assertion error instead of NPE.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450479#comment-13450479
]
Anton Winter commented on CASSANDRA-4561:
-
My schema is in agreement, but the timestamps aren't fixed, even though the log
suggests otherwise (is that previously mentioned NPE related?).
{code}
[default@unknown] describe cluster;
Cluster Information:
Snitch: org.apache.cassandra.locator.PropertyFileSnitch
Partitioner: org.apache.cassandra.dht.RandomPartitioner
Schema versions:
89b22434-5e34-381d-83d1-2a3cde1482fe: [x, x, x, x, x, x, x, x, x, x, x,
x, x, x, x, x, x, x, x, x, x, x, x, x, x]
[default@unknown]
{code}
Schema updates continue to silently fail.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450475#comment-13450475
]
Pavel Yaskevich commented on CASSANDRA-4561:
Yes it does, but it assumes that you have schema in agreement across the nodes
before it tries to fix timestamps. I can put that into NEWS.txt
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13448119#comment-13448119
]
Hudson commented on CASSANDRA-4561:
---
Integrated in Cassandra #2035 (See
[https://builds.apache.org/job/Cassandra/2035/])
change SYSTEM_TABLE to SYSTEM_KS related to CASSANDRA-4561 merge (Revision
cf23bd0a0fd192d991e971bcae94c2447126f873)
Result = FAILURE
xedin :
Files :
* src/java/org/apache/cassandra/db/DefsTable.java
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13448002#comment-13448002
]
Pavel Yaskevich commented on CASSANDRA-4561:
good point, I would add that and commit, thanks!
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447990#comment-13447990
]
Jonathan Ellis commented on CASSANDRA-4561:
---
Don't you want to call cfs.truncate().get() to block for the truncate to
finish? Rest LGTM.
> 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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442809#comment-13442809
]
Pavel Yaskevich commented on CASSANDRA-4561:
Not yet but I'm working on it and soon as it's ready I will attach it here.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442744#comment-13442744
]
Arya Goudarzi commented on CASSANDRA-4561:
--
Do you have an ETA? I'll be happy to monkey apply it on my cluster and be the
guinea pig for it.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442726#comment-13442726
]
Pavel Yaskevich commented on CASSANDRA-4561:
if you still have such timestamps and messages that CF already exists means
that schema wasn't empty on restart and was reloaded from one of the nodes. I'm
currently working on the patch which would fix timestamp situation on node's
start up.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442722#comment-13442722
]
Arya Goudarzi commented on CASSANDRA-4561:
--
I am running 1.1.3 which was upgraded from 1.1.2. Schemas were created in
1.1.2. When nodes came up, I created the schemas in one node only.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442723#comment-13442723
]
Arya Goudarzi commented on CASSANDRA-4561:
--
As part of my process, I also removed saved_caches/system-*.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442595#comment-13442595
]
Pavel Yaskevich commented on CASSANDRA-4561:
What cassandra version are you running? Did you try to recreate a schema on all
of the nodes or just one of them?
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13442577#comment-13442577
]
Arya Goudarzi commented on CASSANDRA-4561:
--
I took my cluster down for 10 minutes. I took a snapshot of 'show schema' into
a text file and removed system KS from it so I will only have my KS schema
definition in it. Then I stop cassandra on all nodes. On each node, I removed
system/schema_* folders from system's keyspace folder in cassandra data dir. I
started all cassandra nodes. When I tried to reload the schema file using cli
to recreate my CFs, I kept getting the message that CFs already exist. When I
listed schema_columnfamilies in one of the node, I saws the same long
timestamps like 2705487066780774 on columns of that CF. So, the procedure
didn't quiet work out for me. What could have gone wrong here?
Please advice.
> 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
>
> [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
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13440776#comment-13440776
]
Arya Goudarzi commented on CASSANDRA-4561:
--
+1 I just ended up seeing this problem in our cluster which was upgraded from
1.1.2 to 1.1.3. Will probably have to find a workaround since I have to change
schema now.
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439607#comment-13439607
]
Pavel Yaskevich commented on CASSANDRA-4561:
Yes, I was about too :)
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439603#comment-13439603
]
Jonathan Ellis commented on CASSANDRA-4561:
---
bq. check system.schema_* CFs column's timestamp values I bet they are from the
future
Can we fix that on startup for other upgraders?
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439599#comment-13439599
]
Pavel Yaskevich commented on CASSANDRA-4561:
aha, so check system.schema_* CFs column's timestamp values I bet they are from
the future. The simplest fix for you would be to delete system/schema_*
SSTables and re-create a schema after restart.
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439455#comment-13439455
]
Zenek Kraweznik commented on CASSANDRA-4561:
I've upgraded cassandra from 8.7 to 1.0, then to 1.0.5 -> 1.0.6 -> 1.1.0 ->
1.1.1 -> 1.1.2 -> 1.1.0 -> 1.1.3 -> 1.1.4.
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439396#comment-13439396
]
Pavel Yaskevich commented on CASSANDRA-4561:
Did you upgrade directly to 1.1.4 or one of the previous 1.1 versions first?
Please check timestamps in your schema_* ColumnFamilies and see if they have
any future dates. The easiest way I see to fix this would be to re-create your
schema if you have timestamp problems from CASSANDRA-4432
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439394#comment-13439394
]
Zenek Kraweznik commented on CASSANDRA-4561:
I'm using 1.1.4, but schema was created in 0.8.5
Could you help me solve my problem step by step?
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439374#comment-13439374
]
Pavel Yaskevich commented on CASSANDRA-4561:
Zenek, what version are you using? It's possible if you are on version less
than 1.1.3 or if you have created your schema before 1.1.3 because of
CASSANDRA-4432...
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439328#comment-13439328
]
Zenek Kraweznik commented on CASSANDRA-4561:
Hmmm, it's possible. How have you rebuild system keyspace?
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439246#comment-13439246
]
Suguru Namura commented on CASSANDRA-4561:
--
I saw a similar case. In my case, columns of schema_keyspaces and
schema_columnfamilies in the system keyspace had future timestamp such as
2052-08-01 11:22:33. All operations of changing schemas were not affected. I do
not know why timestamps had future values. I fixed it with rebuilding system
keyspace.
> 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
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438685#comment-13438685
]
Zenek Kraweznik commented on CASSANDRA-4561:
oh, and it obviously happens when I'm trying to change anything else, not only
compaction treshhold, ex: sstable_size_in_mb
> 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
>Priority: Blocker
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4561) update column family fails
[
https://issues.apache.org/jira/browse/CASSANDRA-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13438558#comment-13438558
]
Zenek Kraweznik commented on CASSANDRA-4561:
in logfile I see only this:
INFO [MigrationStage:1] 2012-08-21 11:27:55,560 ColumnFamilyStore.java (line
659) Enqueuing flush of Memtable-schema_columnfamilies@970905946(1266/1582
serialized/live bytes, 20 ops)
INFO [FlushWriter:5] 2012-08-21 11:27:55,561 Memtable.java (line 264) Writing
Memtable-schema_columnfamilies@970905946(1266/1582 serialized/live bytes, 20
ops)
INFO [FlushWriter:5] 2012-08-21 11:27:55,587 Memtable.java (line 305)
Completed flushing
/var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-he-196-Data.db
(1336 bytes) for commitlog position ReplayPosition(segmentId=4914817711083622,
position=333055)
> 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
>Priority: Blocker
>
> [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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
