[ https://issues.apache.org/jira/browse/CASSANDRA-8795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14318706#comment-14318706 ]
Darren Warner commented on CASSANDRA-8795: ------------------------------------------ You're using CREATE IF NOT EXISTS, when the error is thrown, did the table exist or not? - Yes Are you dropping/recreating the same table in quick succession? - Quite likely We're in early stages of establishing a CI process - I'll research your second question some more > Cassandra (possibly under load) occasionally throws an exception during CQL > create table > ---------------------------------------------------------------------------------------- > > Key: CASSANDRA-8795 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8795 > Project: Cassandra > Issue Type: Bug > Reporter: Darren Warner > Fix For: 2.1.4 > > > CQLSH will return the following: > {code} > { name: 'ResponseError', > message: 'java.lang.RuntimeException: > java.util.concurrent.ExecutionException: java.lang.NullPointerException', > info: 'Represents an error message from the server', > code: 0, > query: 'CREATE TABLE IF NOT EXISTS roles_by_users( userid TIMEUUID, role > INT, entityid TIMEUUID, entity_type TEXT, enabled BOOLEAN, PRIMARY KEY > (userid, role, entityid, entity_type) );' } > {code} > Cassandra system.log shows: > {code} > ERROR [MigrationStage:1] 2015-02-11 14:38:48,610 CassandraDaemon.java:153 - > Exception in thread Thread[MigrationStage:1,5,main] > java.lang.NullPointerException: null > at > org.apache.cassandra.db.DefsTables.addColumnFamily(DefsTables.java:371) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:293) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchemaInternal(DefsTables.java:194) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:166) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:393) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_31] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_31] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31] > ERROR [SharedPool-Worker-2] 2015-02-11 14:38:48,620 QueryMessage.java:132 - > Unexpected error during query > java.lang.RuntimeException: java.util.concurrent.ExecutionException: > java.lang.NullPointerException > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:398) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:374) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager.announceNewColumnFamily(MigrationManager.java:249) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.statements.CreateTableStatement.announceMigration(CreateTableStatement.java:113) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.statements.SchemaAlteringStatement.execute(SchemaAlteringStatement.java:80) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:226) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:248) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439) > [apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335) > [apache-cassandra-2.1.2.jar:2.1.2] > at > io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_31] > at > org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164) > [apache-cassandra-2.1.2.jar:2.1.2] > at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) > [apache-cassandra-2.1.2.jar:2.1.2] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31] > Caused by: java.util.concurrent.ExecutionException: > java.lang.NullPointerException > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > ~[na:1.8.0_31] > at java.util.concurrent.FutureTask.get(FutureTask.java:192) > ~[na:1.8.0_31] > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:394) > ~[apache-cassandra-2.1.2.jar:2.1.2] > ... 17 common frames omitted > Caused by: java.lang.NullPointerException: null > at > org.apache.cassandra.db.DefsTables.addColumnFamily(DefsTables.java:371) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:293) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchemaInternal(DefsTables.java:194) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:166) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:393) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_31] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > ~[na:1.8.0_31] > ... 1 common frames omitted > ERROR [SharedPool-Worker-2] 2015-02-11 14:38:48,621 ErrorMessage.java:243 - > Unexpected exception during request > java.lang.RuntimeException: java.util.concurrent.ExecutionException: > java.lang.NullPointerException > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:398) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:374) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager.announceNewColumnFamily(MigrationManager.java:249) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.statements.CreateTableStatement.announceMigration(CreateTableStatement.java:113) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.statements.SchemaAlteringStatement.execute(SchemaAlteringStatement.java:80) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:226) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:248) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439) > [apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335) > [apache-cassandra-2.1.2.jar:2.1.2] > at > io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324) > [netty-all-4.0.23.Final.jar:4.0.23.Final] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_31] > at > org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164) > [apache-cassandra-2.1.2.jar:2.1.2] > at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) > [apache-cassandra-2.1.2.jar:2.1.2] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31] > Caused by: java.util.concurrent.ExecutionException: > java.lang.NullPointerException > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > ~[na:1.8.0_31] > at java.util.concurrent.FutureTask.get(FutureTask.java:192) > ~[na:1.8.0_31] > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:394) > ~[apache-cassandra-2.1.2.jar:2.1.2] > ... 17 common frames omitted > Caused by: java.lang.NullPointerException: null > at > org.apache.cassandra.db.DefsTables.addColumnFamily(DefsTables.java:371) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:293) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchemaInternal(DefsTables.java:194) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:166) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:393) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_31] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > ~[na:1.8.0_31] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > ~[na:1.8.0_31] > ... 1 common frames omitted > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)