You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by tommaso barbugli <tb...@gmail.com> on 2014/10/12 13:05:43 UTC
alter table issues on 2.0.10
Hi,
I am seeing errors every time I make a schema migration of this kind on
cassandra 2.0.10
ALTER TABLE notifications add "unread_ids" set<timeuuid> static
<ErrorMessage code=0000 [Server error] message="java.lang.RuntimeException:
java.util.concurrent.ExecutionException: java.lang.RuntimeException:
org.apache.cassandra.exceptions.ConfigurationException: comparators do not
match or are not compatible.">
Weird enough DESCRIBE COLUMNFAMILY notifications; shows that the column
unread_ids is created after the error.
Any idea if this is an actual bug or if I am doing something wrong?
Tommaso
Re: alter table issues on 2.0.10
Posted by DuyHai Doan <do...@gmail.com>.
I found this JIRA with similar error message (
https://issues.apache.org/jira/browse/CASSANDRA-6276), not sure it applies
to your case, and especially the issue is supposed to be fixed in 2.0.10
(your current version).
Consider filling a new JIRA if you can reproduce the issue
On Mon, Oct 13, 2014 at 12:33 AM, tommaso barbugli <tb...@gmail.com>
wrote:
> Here is the full stack trace
>
> ERROR [Native-Transport-Requests:5802] 2014-10-12 22:48:12,237
> QueryMessage.java (line 131) Unexpected error during query
> java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException:
> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
> match or are not compatible.
> at
> org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:413)
> at
> org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:285)
> at
> org.apache.cassandra.service.MigrationManager.announceNewColumnFamily(MigrationManager.java:223)
> at
> org.apache.cassandra.cql3.statements.CreateTableStatement.announceMigration(CreateTableStatement.java:121)
> at
> org.apache.cassandra.cql3.statements.SchemaAlteringStatement.execute(SchemaAlteringStatement.java:79)
> at
> org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:158)
> at
> org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:175)
> at
> org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119)
> at
> org.apache.cassandra.transport.Message$Dispatcher.messageReceived(Message.java:306)
> at
> org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
> at
> org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
> at
> org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
> at
> org.jboss.netty.handler.execution.ChannelUpstreamEventRunnable.doRun(ChannelUpstreamEventRunnable.java:43)
> at
> org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEventRunnable.java:67)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException:
> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
> match or are not compatible.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:188)
> at
> org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:409)
> ... 16 more
> Caused by: java.lang.RuntimeException:
> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
> match or are not compatible.
> at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1052)
> at
> org.apache.cassandra.db.DefsTables.updateColumnFamily(DefsTables.java:377)
> at
> org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:318)
> at org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:183)
> at
> org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:303)
> at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> ... 3 more
> Caused by: org.apache.cassandra.exceptions.ConfigurationException:
> comparators do not match or are not compatible.
> at
> org.apache.cassandra.config.CFMetaData.validateCompatility(CFMetaData.java:1142)
> at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:1067)
> at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1048)
> ... 10 more
>
> 2014-10-12 23:59 GMT+02:00 DuyHai Doan <do...@gmail.com>:
>
>> Hello Tommaso
>>
>> Can you give the full exception stack trace? Consider also filing a
>> JIRA, it looks pretty fishy...
>>
>> On Sun, Oct 12, 2014 at 10:53 PM, tommaso barbugli <tb...@gmail.com>
>> wrote:
>>
>>> Hi,
>>> it actually seems to be worse than what I thought; I get an exception in
>>> cassandra logs every time I try to create a new table.
>>>
>>> Cql query:
>>> CREATE TABLE shard12 ("feed_id" ascii, "activity_id" timeuuid,
>>> "activities" blob, "created_at" timestamp, "group" ascii, "updated_at"
>>> timestamp, "seen_at" timestamp, "read_at" timestamp, PRIMARY KEY
>>> (("feed_id"), "activity_id")) WITH read_repair_chance = 0.1 AND clustering
>>> order by ("activity_id" desc) AND compaction = {'sstable_size_in_mb': 64,
>>> 'class': 'LeveledCompactionStrategy'};
>>>
>>> This is the error:
>>> java.lang.RuntimeException: java.util.concurrent.ExecutionException:
>>> java.lang.RuntimeException:
>>> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
>>> match or are not compatible.
>>>
>>> Tommaso
>>>
>>> 2014-10-12 13:05 GMT+02:00 tommaso barbugli <tb...@gmail.com>:
>>>
>>>> Hi,
>>>> I am seeing errors every time I make a schema migration of this kind on
>>>> cassandra 2.0.10
>>>>
>>>> ALTER TABLE notifications add "unread_ids" set<timeuuid> static
>>>>
>>>> <ErrorMessage code=0000 [Server error]
>>>> message="java.lang.RuntimeException:
>>>> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>>>> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
>>>> match or are not compatible.">
>>>>
>>>> Weird enough DESCRIBE COLUMNFAMILY notifications; shows that the column
>>>> unread_ids is created after the error.
>>>>
>>>> Any idea if this is an actual bug or if I am doing something wrong?
>>>>
>>>> Tommaso
>>>>
>>>
>>>
>>
>
Re: alter table issues on 2.0.10
Posted by tommaso barbugli <tb...@gmail.com>.
Here is the full stack trace
ERROR [Native-Transport-Requests:5802] 2014-10-12 22:48:12,237
QueryMessage.java (line 131) Unexpected error during query
java.lang.RuntimeException: java.util.concurrent.ExecutionException:
java.lang.RuntimeException:
org.apache.cassandra.exceptions.ConfigurationException: comparators do not
match or are not compatible.
at org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:413)
at
org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:285)
at
org.apache.cassandra.service.MigrationManager.announceNewColumnFamily(MigrationManager.java:223)
at
org.apache.cassandra.cql3.statements.CreateTableStatement.announceMigration(CreateTableStatement.java:121)
at
org.apache.cassandra.cql3.statements.SchemaAlteringStatement.execute(SchemaAlteringStatement.java:79)
at
org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:158)
at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:175)
at
org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119)
at
org.apache.cassandra.transport.Message$Dispatcher.messageReceived(Message.java:306)
at
org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
at
org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at
org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at
org.jboss.netty.handler.execution.ChannelUpstreamEventRunnable.doRun(ChannelUpstreamEventRunnable.java:43)
at
org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEventRunnable.java:67)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.util.concurrent.ExecutionException:
java.lang.RuntimeException:
org.apache.cassandra.exceptions.ConfigurationException: comparators do not
match or are not compatible.
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:188)
at org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:409)
... 16 more
Caused by: java.lang.RuntimeException:
org.apache.cassandra.exceptions.ConfigurationException: comparators do not
match or are not compatible.
at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1052)
at
org.apache.cassandra.db.DefsTables.updateColumnFamily(DefsTables.java:377)
at
org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:318)
at org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:183)
at
org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:303)
at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
... 3 more
Caused by: org.apache.cassandra.exceptions.ConfigurationException:
comparators do not match or are not compatible.
at
org.apache.cassandra.config.CFMetaData.validateCompatility(CFMetaData.java:1142)
at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:1067)
at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1048)
... 10 more
2014-10-12 23:59 GMT+02:00 DuyHai Doan <do...@gmail.com>:
> Hello Tommaso
>
> Can you give the full exception stack trace? Consider also filing a JIRA,
> it looks pretty fishy...
>
> On Sun, Oct 12, 2014 at 10:53 PM, tommaso barbugli <tb...@gmail.com>
> wrote:
>
>> Hi,
>> it actually seems to be worse than what I thought; I get an exception in
>> cassandra logs every time I try to create a new table.
>>
>> Cql query:
>> CREATE TABLE shard12 ("feed_id" ascii, "activity_id" timeuuid,
>> "activities" blob, "created_at" timestamp, "group" ascii, "updated_at"
>> timestamp, "seen_at" timestamp, "read_at" timestamp, PRIMARY KEY
>> (("feed_id"), "activity_id")) WITH read_repair_chance = 0.1 AND clustering
>> order by ("activity_id" desc) AND compaction = {'sstable_size_in_mb': 64,
>> 'class': 'LeveledCompactionStrategy'};
>>
>> This is the error:
>> java.lang.RuntimeException: java.util.concurrent.ExecutionException:
>> java.lang.RuntimeException:
>> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
>> match or are not compatible.
>>
>> Tommaso
>>
>> 2014-10-12 13:05 GMT+02:00 tommaso barbugli <tb...@gmail.com>:
>>
>>> Hi,
>>> I am seeing errors every time I make a schema migration of this kind on
>>> cassandra 2.0.10
>>>
>>> ALTER TABLE notifications add "unread_ids" set<timeuuid> static
>>>
>>> <ErrorMessage code=0000 [Server error]
>>> message="java.lang.RuntimeException:
>>> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>>> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
>>> match or are not compatible.">
>>>
>>> Weird enough DESCRIBE COLUMNFAMILY notifications; shows that the column
>>> unread_ids is created after the error.
>>>
>>> Any idea if this is an actual bug or if I am doing something wrong?
>>>
>>> Tommaso
>>>
>>
>>
>
Re: alter table issues on 2.0.10
Posted by DuyHai Doan <do...@gmail.com>.
Hello Tommaso
Can you give the full exception stack trace? Consider also filing a JIRA,
it looks pretty fishy...
On Sun, Oct 12, 2014 at 10:53 PM, tommaso barbugli <tb...@gmail.com>
wrote:
> Hi,
> it actually seems to be worse than what I thought; I get an exception in
> cassandra logs every time I try to create a new table.
>
> Cql query:
> CREATE TABLE shard12 ("feed_id" ascii, "activity_id" timeuuid,
> "activities" blob, "created_at" timestamp, "group" ascii, "updated_at"
> timestamp, "seen_at" timestamp, "read_at" timestamp, PRIMARY KEY
> (("feed_id"), "activity_id")) WITH read_repair_chance = 0.1 AND clustering
> order by ("activity_id" desc) AND compaction = {'sstable_size_in_mb': 64,
> 'class': 'LeveledCompactionStrategy'};
>
> This is the error:
> java.lang.RuntimeException: java.util.concurrent.ExecutionException:
> java.lang.RuntimeException:
> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
> match or are not compatible.
>
> Tommaso
>
> 2014-10-12 13:05 GMT+02:00 tommaso barbugli <tb...@gmail.com>:
>
>> Hi,
>> I am seeing errors every time I make a schema migration of this kind on
>> cassandra 2.0.10
>>
>> ALTER TABLE notifications add "unread_ids" set<timeuuid> static
>>
>> <ErrorMessage code=0000 [Server error]
>> message="java.lang.RuntimeException:
>> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
>> match or are not compatible.">
>>
>> Weird enough DESCRIBE COLUMNFAMILY notifications; shows that the column
>> unread_ids is created after the error.
>>
>> Any idea if this is an actual bug or if I am doing something wrong?
>>
>> Tommaso
>>
>
>
Re: alter table issues on 2.0.10
Posted by tommaso barbugli <tb...@gmail.com>.
Hi,
it actually seems to be worse than what I thought; I get an exception in
cassandra logs every time I try to create a new table.
Cql query:
CREATE TABLE shard12 ("feed_id" ascii, "activity_id" timeuuid, "activities"
blob, "created_at" timestamp, "group" ascii, "updated_at" timestamp,
"seen_at" timestamp, "read_at" timestamp, PRIMARY KEY (("feed_id"),
"activity_id")) WITH read_repair_chance = 0.1 AND clustering order by
("activity_id" desc) AND compaction = {'sstable_size_in_mb': 64, 'class':
'LeveledCompactionStrategy'};
This is the error:
java.lang.RuntimeException: java.util.concurrent.ExecutionException:
java.lang.RuntimeException:
org.apache.cassandra.exceptions.ConfigurationException: comparators do not
match or are not compatible.
Tommaso
2014-10-12 13:05 GMT+02:00 tommaso barbugli <tb...@gmail.com>:
> Hi,
> I am seeing errors every time I make a schema migration of this kind on
> cassandra 2.0.10
>
> ALTER TABLE notifications add "unread_ids" set<timeuuid> static
>
> <ErrorMessage code=0000 [Server error]
> message="java.lang.RuntimeException:
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> org.apache.cassandra.exceptions.ConfigurationException: comparators do not
> match or are not compatible.">
>
> Weird enough DESCRIBE COLUMNFAMILY notifications; shows that the column
> unread_ids is created after the error.
>
> Any idea if this is an actual bug or if I am doing something wrong?
>
> Tommaso
>