[jira] [Comment Edited] (CASSANDRA-6004) Performing a "Select count(*)" when replication factor < node count causes assertion error and timeout

["Ngoc Minh Vo (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-6004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13769406#comment-13769406 ] 

Ngoc Minh Vo edited comment on CASSANDRA-6004 at 9/17/13 10:27 AM:
-------------------------------------------------------------------

Hello,

We got the same issue on our 4-node cluster on normal "SELECT *" query but changing replication_factor to 4 did not help.

I rolled back our dev cluster to 1.2.9 while waiting for the patch. Everything is working now but we don't have Batch for PreparedStatements (CASSANDRA-4693).

Could you please confirm that the bugfix is not related to the condition (replication_factor < node_count)? and not specific to "SELECT COUNT(1)" either?

Thanks for your help.
Best regards,
Minh
                
      was (Author: vongocminh):
    Hello,

We got the same issue on our 4-node cluster on normal "SELECT *" query but changing replication_factor to 4 did not help.

I rolled back our dev cluster to 1.2.9 while waiting for the patch. Everything is working now but we don't have Batch for PreparedStatements (CASSANDRA-4693).

Could you please confirm that the bugfix is not related to the condition (replication_factor < node_count)? and not specific to "SELECT COUNT(*)" either?

Thanks for your help.
Best regards,
Minh
                  
> Performing a "Select count(*)" when replication factor < node count causes assertion error and timeout
> ------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6004
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6004
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API
>         Environment: Two node setup
> Ubuntu Server 12.04
> Tested on JDK 1.6 and 1.7
>            Reporter: James P
>            Assignee: Sylvain Lebresne
>             Fix For: 2.0.1
>
>         Attachments: 6004.txt
>
>
> When performing a "Select Count()" query on a table belonging to a keyspace with a replication factor less than the total node count, the following error is encountered which ultimately results in an rpc_timeout for the request:
> ERROR 18:47:54,660 Exception in thread Thread[Thread-5,5,main]
> java.lang.AssertionError
> 	at org.apache.cassandra.db.filter.IDiskAtomFilter$Serializer.deserialize(IDiskAtomFilter.java:116)
> 	at org.apache.cassandra.db.RangeSliceCommandSerializer.deserialize(RangeSliceCommand.java:247)
> 	at org.apache.cassandra.db.RangeSliceCommandSerializer.deserialize(RangeSliceCommand.java:156)
> 	at org.apache.cassandra.net.MessageIn.read(MessageIn.java:99)
> 	at org.apache.cassandra.net.IncomingTcpConnection.receiveMessage(IncomingTcpConnection.java:148)
> 	at org.apache.cassandra.net.IncomingTcpConnection.handleModernVersion(IncomingTcpConnection.java:125)
> 	at org.apache.cassandra.net.IncomingTcpConnection.run(IncomingTcpConnection.java:73)
> The issue is not encountered when the replication factor is >= node count
> To replicate the issue:
> 1) Create the keyspace: CREATE KEYSPACE demodb WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor': 1};
> 2) Create the table CREATE TABLE users (
>   user_name varchar,
>   password varchar,
>   gender varchar,
>   session_token varchar,
>   state varchar,
>   birth_year bigint,
>   PRIMARY KEY (user_name));
> 3) Do a CQL query: "SELECT count( * ) FROM demodb.users" ;
> The issue is reproducible even if the table is empty. Both CQLSH and client (astyanax) api calls are affected. Tested on two different clusters (2-node and 8-node)

--
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