The stacktrace suggests that when a connection is being established, either the can_login or is_superuser attribute of the authenticated role is null, which is definitely a bug as there should be no way to create a role in that state.
Could you please open a ticket on https://issues.apache.org/jira/browse/CASSANDRA (including as much detail as possible)? If you could reply back to this with the ticket # that'd be helpful for anyone coming across a similar issue in future. Thanks, Sam On Fri, Sep 23, 2016 at 10:33 AM, Rajesh Radhakrishnan < rajesh.radhakrish...@phe.gov.uk> wrote: > Hi, > > > In one of our C* cluster we are using the latest Cassandra 3.7.0 > (datastax-ddc.3.70) with Python driver 3.7. We are trying to insert 2 > million row or more data into the database, it works but sometimes we are > getting "Null pointer Exception". I am quoting the Exception here. > Any help would be highly appreciated. > > We are using Python 2.7.11 and Java 1.8.0_73 in the Cassandra nodes and in > the client its Python 2.7.12. > > ============================================================ > ====================================================== > ERROR [SharedPool-Worker-6] 2016-09-23 09:42:55,002 Message.java:611 - > Unexpected exception during request; channel = [id: 0xc208da86, > L:/IP1.IP2.IP3.IP4:9042 - R:/IP5.IP6.IP7.IP8:58418] > > java.lang.NullPointerException: null > > at org.apache.cassandra.serializers.BooleanSerializer. > deserialize(BooleanSerializer.java:33) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.serializers.BooleanSerializer. > deserialize(BooleanSerializer.java:24) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.db.marshal.AbstractType.compose(AbstractType.java:113) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.cql3.UntypedResultSet$Row. > getBoolean(UntypedResultSet.java:273) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:85) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:81) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:503) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:485) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:298) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.service.ClientState.login(ClientState.java:227) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:79) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:507) > [apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:401) > [apache-cassandra-3.7.0.jar:3.7.0] > > at io.netty.channel.SimpleChannelInboundHandler.channelRead( > SimpleChannelInboundHandler.java:105) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead( > AbstractChannelHandlerContext.java:292) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext.access$600( > AbstractChannelHandlerContext.java:32) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext$7.run( > AbstractChannelHandlerContext.java:283) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_73] > > at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorServ > ice$FutureTask.run(AbstractLocalAwareExecutorService.java:164) > [apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) > [apache-cassandra-3.7.0.jar:3.7.0] > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_73] > > ERROR [SharedPool-Worker-1] 2016-09-23 09:42:56,238 Message.java:611 - > Unexpected exception during request; channel = [id: 0x8e2eae00, > L:/IP1.IP2.IP3.IP4:9042 - R:/IP5.IP6.IP7.IP8:58421] > > java.lang.NullPointerException: null > > at org.apache.cassandra.serializers.BooleanSerializer. > deserialize(BooleanSerializer.java:33) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.serializers.BooleanSerializer. > deserialize(BooleanSerializer.java:24) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.db.marshal.AbstractType.compose(AbstractType.java:113) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.cql3.UntypedResultSet$Row. > getBoolean(UntypedResultSet.java:273) ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:85) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:81) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:503) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:485) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:298) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.service.ClientState.login(ClientState.java:227) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:79) > ~[apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:507) > [apache-cassandra-3.7.0.jar:3.7.0] > > at > org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:401) > [apache-cassandra-3.7.0.jar:3.7.0] > > at io.netty.channel.SimpleChannelInboundHandler.channelRead( > SimpleChannelInboundHandler.java:105) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead( > AbstractChannelHandlerContext.java:292) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext.access$600( > AbstractChannelHandlerContext.java:32) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at io.netty.channel.AbstractChannelHandlerContext$7.run( > AbstractChannelHandlerContext.java:283) [netty-all-4.0.36.Final.jar:4. > 0.36.Final] > > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_73] > > at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorServ > ice$FutureTask.run(AbstractLocalAwareExecutorService.java:164) > [apache-cassandra-3.7.0.jar:3.7.0] > > at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) > [apache-cassandra-3.7.0.jar:3.7.0] > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_73] > ============================================================ > ====================================================== > > Thank you. > > > Kind regards, > Rajesh Radhakrishnan > > > ************************************************************************** > The information contained in the EMail and any attachments is confidential > and intended solely and for the attention and use of the named > addressee(s). It may not be disclosed to any other person without the > express authority of Public Health England, or the intended recipient, or > both. If you are not the intended recipient, you must not disclose, copy, > distribute or retain this message or any part of it. This footnote also > confirms that this EMail has been swept for computer viruses by > Symantec.Cloud, but please re-sweep any attachments before opening or > saving. http://www.gov.uk/PHE > ************************************************************************** >