[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406360#comment-16406360
]
Pranav Jindal edited comment on CASSANDRA-12700 at 3/20/18 1:59 PM:
Using cassandra 3.10, facing below issue.
[~jjirsa]
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:517)
[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:410)
[apache-cassandra-3.10.jar:3.10]
at
io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:366)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.access$600(AbstractChannelHandlerContext.java:35)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext$7.run(AbstractChannelHandlerContext.java:357)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[na:1.8.0_121]
at
org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:162)
[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:109)
[apache-cassandra-3.10.jar:3.10]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: java.lang.NullPointerException: null
at
org.apache.cassandra.cql3.UntypedResultSet$Row.getBoolean(UntypedResultSet.java:273)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:88)
~[apache-cassandra-3.10.jar:3.10]
... 16 common frames omitted
{code}
was (Author: prnvjndl):
Using cassandra 3.10, facing below issue.
[~jjirsa]
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406360#comment-16406360
]
Pranav Jindal edited comment on CASSANDRA-12700 at 3/20/18 1:59 PM:
Using cassandra 3.10, facing below issue.
[~jjirsa] [~jasonstack]
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:517)
[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:410)
[apache-cassandra-3.10.jar:3.10]
at
io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:366)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.access$600(AbstractChannelHandlerContext.java:35)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext$7.run(AbstractChannelHandlerContext.java:357)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[na:1.8.0_121]
at
org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:162)
[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:109)
[apache-cassandra-3.10.jar:3.10]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: java.lang.NullPointerException: null
at
org.apache.cassandra.cql3.UntypedResultSet$Row.getBoolean(UntypedResultSet.java:273)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:88)
~[apache-cassandra-3.10.jar:3.10]
... 16 common frames omitted
{code}
was (Author: prnvjndl):
Using cassandra 3.10, facing below issue.
[~jjirsa]
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406360#comment-16406360
]
Pranav Jindal edited comment on CASSANDRA-12700 at 3/20/18 1:58 PM:
Using cassandra 3.10, facing below issue.
[~jjirsa]
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:517)
[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:410)
[apache-cassandra-3.10.jar:3.10]
at
io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:366)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext.access$600(AbstractChannelHandlerContext.java:35)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at
io.netty.channel.AbstractChannelHandlerContext$7.run(AbstractChannelHandlerContext.java:357)
[netty-all-4.0.39.Final.jar:4.0.39.Final]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[na:1.8.0_121]
at
org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:162)
[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:109)
[apache-cassandra-3.10.jar:3.10]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: java.lang.NullPointerException: null
at
org.apache.cassandra.cql3.UntypedResultSet$Row.getBoolean(UntypedResultSet.java:273)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:88)
~[apache-cassandra-3.10.jar:3.10]
... 16 common frames omitted
{code}
was (Author: prnvjndl):
Using cassandra 3.10, facing below issue.
{code:java}
WARN [Native-Transport-Requests-1] 2018-03-20 13:37:17,894
CassandraRoleManager.java:96 - An invalid value has been detected in the roles
table for role utorjwcnruzzlzafxffgyqmlvkxiqcgb. If you are unable to login,
you may need to disable authentication and confirm that values in that table
are accurate
ERROR [Native-Transport-Requests-1] 2018-03-20 13:37:17,895 Message.java:623 -
Unexpected exception during request; channel = [id: 0xdfc3604f,
L:/10.180.0.150:9042 - R:/10.180.0.150:51668]
java.lang.RuntimeException: Invalid metadata has been detected for role
utorjwcnruzzlzafxffgyqmlvkxiqcgb
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:99)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager$1.apply(CassandraRoleManager.java:82)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:528)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:503)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager.java:310)
~[apache-cassandra-3.10.jar:3.10]
at org.apache.cassandra.service.ClientState.login(ClientState.java:271)
~[apache-cassandra-3.10.jar:3.10]
at
org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:80)
~[apache-cassandra-3.10.jar:3.10]
at
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15530143#comment-15530143
]
Jeff Jirsa edited comment on CASSANDRA-12700 at 9/28/16 4:25 PM:
-
[~beobal] thanks for the feedback - the decision in my mind was "make it work
safely" or "make it fail nicer" - I went with "make it work safely", but since
we don't understand how it got this way, I agree with you that we should be
noisy about it.
Pushed a new change to be more conservative - instead of silently correcting
(by inferring false), we'll throw an RTE and log a message at {{WARN}} to let
the operator know that something's very wrong. This is the new behavior:
{code}
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh
Connection error: ('Unable to connect to any servers', {'127.0.0.1':
AuthenticationFailed('Remote end requires authentication.',)})
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh -u cassandra -p cassandra
Connected to test at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol v4]
Use HELP for help.
cassandra@cqlsh> select * from system_auth.roles;
role | can_login | is_superuser | member_of | salted_hash
---+---+--+---+--
cassandra | True | True | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
(1 rows)
cassandra@cqlsh> insert into system_auth.roles(role, salted_hash)
values('test', '$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.');
cassandra@cqlsh> select * from system_auth.roles;
role | can_login | is_superuser | member_of | salted_hash
---+---+--+---+--
test | null | null | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
cassandra | True | True | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
(2 rows)
cassandra@cqlsh> ^D
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh -u test -p cassandra
Connection error: ('Unable to connect to any servers', {'127.0.0.1':
AuthenticationFailed('Failed to authenticate to 127.0.0.1: Error from server:
code= [Server error] message="java.lang.RuntimeException: Invalid metadata
has been detected for role test"',)})
MLSEA-JJIRSA01:~ jjirsa$
{code}
I'll update the dtest to match shortly.
[~beobal] - if you guys have resources to try to repro, I won't mind seeing
that Assignee field change to you or your test engineering folks.
was (Author: jjirsa):
[~beobal] thanks for the feedback - the decision in my mind was "make it work
safely" or "make it fail nicer" - I went with "make it work safely", but since
we don't understand how it got this way, I agree with you that we should be
noisy about it.
Pushed a new change to be more conservative - instead of silently correcting
(by inferring false), we'll throw an RTE and log a message at {{WARN}} to let
the operator know that something's very wrong. This is the new behavior:
{quote}
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh
Connection error: ('Unable to connect to any servers', {'127.0.0.1':
AuthenticationFailed('Remote end requires authentication.',)})
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh -u cassandra -p cassandra
Connected to test at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol v4]
Use HELP for help.
cassandra@cqlsh> select * from system_auth.roles;
role | can_login | is_superuser | member_of | salted_hash
---+---+--+---+--
cassandra | True | True | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
(1 rows)
cassandra@cqlsh> insert into system_auth.roles(role, salted_hash)
values('test', '$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.');
cassandra@cqlsh> select * from system_auth.roles;
role | can_login | is_superuser | member_of | salted_hash
---+---+--+---+--
test | null | null | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
cassandra | True | True | null |
$2a$10$2.WsdTj8JoDCUHuVVe367Oth8XA3JYn1jTDX03eaEBkxwRTOuQKB.
(2 rows)
cassandra@cqlsh> ^D
MLSEA-JJIRSA01:~ jjirsa$ ccm node1 cqlsh -u test -p cassandra
Connection error: ('Unable to connect to any servers', {'127.0.0.1':
AuthenticationFailed('Failed to authenticate to 127.0.0.1: Error from server:
code= [Server error] message="java.lang.RuntimeException: Invalid metadata
has been detected for role test"',)})
MLSEA-JJIRSA01:~ jjirsa$
{quote}
I'll update the dtest to match shortly.
[~beobal] - if you
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15528139#comment-15528139
]
Jeff Jirsa edited comment on CASSANDRA-12700 at 9/28/16 2:24 AM:
-
[~rajesh_con] - just to be clear - do you recall what mechanism you used to
create these users/roles? Did you perhaps use {{CREATE ROLE}} , or {{INSERT
INTO system_auth.roles...}} ?
was (Author: jjirsa):
[~rajesh_con] - just to be clear - do you recall what mechanism you used to
create these users/roles?
> During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes
> Connection get lost, because of Server NullPointerException
> --
>
> Key: CASSANDRA-12700
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12700
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra cluster with two nodes running C* version
> 3.7.0 and Python Driver 3.7 using Python 2.7.11.
> OS: Red Hat Enterprise Linux 6.x x64,
> RAM :8GB
> DISK :210GB
> Cores: 2
> Java 1.8.0_73 JRE
>Reporter: Rajesh Radhakrishnan
>Assignee: Jeff Jirsa
> Fix For: 3.x
>
>
> In our C* cluster we are using the latest Cassandra 3.7.0 (datastax-ddc.3.70)
> with Python driver 3.7. Trying to insert 2 million row or more data into the
> database, but sometimes we are getting "Null pointer Exception".
> 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.
> {code:title=cassandra server log}
> 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.AbstractLocalAwareExecutorService$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,
>
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15525125#comment-15525125
]
Jeff Jirsa edited comment on CASSANDRA-12700 at 9/27/16 4:01 PM:
-
[~rajesh_con] - As a workaround, try executing (via cqlsh):
{code}
> CONSISTENCY ALL;
> UPDATE system_auth.roles SET is_superuser=True where role='cassandra_test';
{code}
That should work around the NPE until it's fixed (the NPE is coming from a
missing is_superuser field).
was (Author: jjirsa):
[~rajesh_con] - As a workaround, try executing (via cqlsh):
{code}
> CONSISTENCY ALL;
> UPDATE system_auth SET is_superuser=True where role='cassandra_test';
{code}
That should work around the NPE until it's fixed (the NPE is coming from a
missing is_superuser field).
> During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes
> Connection get lost, because of Server NullPointerException
> --
>
> Key: CASSANDRA-12700
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12700
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra cluster with two nodes running C* version
> 3.7.0 and Python Driver 3.7 using Python 2.7.11.
> OS: Red Hat Enterprise Linux 6.x x64,
> RAM :8GB
> DISK :210GB
> Cores: 2
> Java 1.8.0_73 JRE
>Reporter: Rajesh Radhakrishnan
>Assignee: Jeff Jirsa
> Fix For: 3.x
>
>
> In our C* cluster we are using the latest Cassandra 3.7.0 (datastax-ddc.3.70)
> with Python driver 3.7. Trying to insert 2 million row or more data into the
> database, but sometimes we are getting "Null pointer Exception".
> 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.
> {code:title=cassandra server log}
> 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.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:164)
> [apache-cassandra-3.7.0.jar:3.7.0]
> at
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15525408#comment-15525408
]
Rajesh Radhakrishnan edited comment on CASSANDRA-12700 at 9/27/16 10:15 AM:
Thank you Jeff!
I will set the consistency / update system_auth too and let you know how it
went by!
In between did you ment to update system_auth.roles table?
was (Author: rajesh_con):
Thank you Jeff!
I will set the consistency / update system_auth too and let you know how it
went by!
> During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes
> Connection get lost, because of Server NullPointerException
> --
>
> Key: CASSANDRA-12700
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12700
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra cluster with two nodes running C* version
> 3.7.0 and Python Driver 3.7 using Python 2.7.11.
> OS: Red Hat Enterprise Linux 6.x x64,
> RAM :8GB
> DISK :210GB
> Cores: 2
> Java 1.8.0_73 JRE
>Reporter: Rajesh Radhakrishnan
>Assignee: Jeff Jirsa
> Fix For: 3.x
>
>
> In our C* cluster we are using the latest Cassandra 3.7.0 (datastax-ddc.3.70)
> with Python driver 3.7. Trying to insert 2 million row or more data into the
> database, but sometimes we are getting "Null pointer Exception".
> 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.
> {code:title=cassandra server log}
> 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.AbstractLocalAwareExecutorService$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,
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15525408#comment-15525408
]
Rajesh Radhakrishnan edited comment on CASSANDRA-12700 at 9/27/16 10:15 AM:
Thank you Jeff!
I will set the consistency / update system_auth too and let you know how it
went by!
In between did you meant to update system_auth.roles table?
was (Author: rajesh_con):
Thank you Jeff!
I will set the consistency / update system_auth too and let you know how it
went by!
In between did you ment to update system_auth.roles table?
> During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes
> Connection get lost, because of Server NullPointerException
> --
>
> Key: CASSANDRA-12700
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12700
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra cluster with two nodes running C* version
> 3.7.0 and Python Driver 3.7 using Python 2.7.11.
> OS: Red Hat Enterprise Linux 6.x x64,
> RAM :8GB
> DISK :210GB
> Cores: 2
> Java 1.8.0_73 JRE
>Reporter: Rajesh Radhakrishnan
>Assignee: Jeff Jirsa
> Fix For: 3.x
>
>
> In our C* cluster we are using the latest Cassandra 3.7.0 (datastax-ddc.3.70)
> with Python driver 3.7. Trying to insert 2 million row or more data into the
> database, but sometimes we are getting "Null pointer Exception".
> 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.
> {code:title=cassandra server log}
> 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.AbstractLocalAwareExecutorService$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 -
>
[jira] [Comment Edited] (CASSANDRA-12700) During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes Connection get lost, because of Server NullPointerException
[
https://issues.apache.org/jira/browse/CASSANDRA-12700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15516749#comment-15516749
]
Rajesh Radhakrishnan edited comment on CASSANDRA-12700 at 9/23/16 3:30 PM:
---
Thank you Jeff for looking into this!
DESCRIBE TABLE system_auth.roles;
---
CREATE TABLE system_auth.roles (
role text PRIMARY KEY,
can_login boolean,
is_superuser boolean,
member_of set,
salted_hash text
) WITH bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = 'role definitions'
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.0
AND default_time_to_live = 0
AND gc_grace_seconds = 7776000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 360
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
---
was (Author: rajesh_con):
DESCRIBE TABLE system_auth.roles;
---
CREATE TABLE system_auth.roles (
role text PRIMARY KEY,
can_login boolean,
is_superuser boolean,
member_of set,
salted_hash text
) WITH bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = 'role definitions'
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.0
AND default_time_to_live = 0
AND gc_grace_seconds = 7776000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 360
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
---
> During writing data into Cassandra 3.7.0 using Python driver 3.7 sometimes
> Connection get lost, because of Server NullPointerException
> --
>
> Key: CASSANDRA-12700
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12700
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra cluster with two nodes running C* version
> 3.7.0 and Python Driver 3.7 using Python 2.7.11.
> OS: Red Hat Enterprise Linux 6.x x64,
> RAM :8GB
> DISK :210GB
> Cores: 2
> Java 1.8.0_73 JRE
>Reporter: Rajesh Radhakrishnan
> Fix For: 3.7
>
>
> In our C* cluster we are using the latest Cassandra 3.7.0 (datastax-ddc.3.70)
> with Python driver 3.7. Trying to insert 2 million row or more data into the
> database, but sometimes we are getting "Null pointer Exception".
> 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.
> {code:title=cassandra server log}
> 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)
>
