Chandran Anjur Narasimhan created CASSANDRA-9729:
----------------------------------------------------

             Summary: CQLSH exception - OverflowError: normalized days too 
large to fit in a C int
                 Key: CASSANDRA-9729
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9729
             Project: Cassandra
          Issue Type: Bug
          Components: Tools
         Environment: OSX 10.10.2
            Reporter: Chandran Anjur Narasimhan


Running a select command using CQLSH 2.1.5, 2.1.7 throws exception. This works 
nicely in 2.0.14 version.

Environment:
============
JAVA - 1.8
Python - 2.7.6
Cassandra Server - 2.1.7
CQLSH - 5.0.1

Logs:
======

CQLSH - cassandra 2.0.14 - working with no issues
-------------------------------------
NCHAN-M-D0LZ:apache nchan$ cd apache-cassandra-2.0.14/
NCHAN-M-D0LZ:apache-cassandra-2.0.14 nchan$ bin/cqlsh
Connected to CCC Multi-Region Cassandra Cluster at <myip>:9160.
[cqlsh 4.1.1 | Cassandra 2.1.7 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
Use HELP for help.
cqlsh> use ccc;
cqlsh:ccc> select count(*) from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';

 count
-------
    25

(1 rows)

cqlsh:ccc> select * from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';
< i get all the 25 values>

CQLSH - cassandra 2.1.5  - python exception
-------------------------------------
NCHAN-M-D0LZ:apache-cassandra-2.1.5 nchan$ bin/cqlsh
Connected to CCC Multi-Region Cassandra Cluster at <ip-address>:9042.
[cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh> use ccc;
cqlsh:ccc> select count(*) from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';

 count
-------
    25

(1 rows)
cqlsh:ccc> select * from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';
Traceback (most recent call last):
  File "bin/cqlsh", line 1001, in perform_simple_statement
    rows = self.session.execute(statement, trace=self.tracing_enabled)
  File 
"/Users/nchan/Programs/apache/apache-cassandra-2.1.5/bin/../lib/cassandra-driver-internal-only-2.5.0.zip/cassandra-driver-2.5.0/cassandra/cluster.py",
 line 1404, in execute
    result = future.result(timeout)
  File 
"/Users/nchan/Programs/apache/apache-cassandra-2.1.5/bin/../lib/cassandra-driver-internal-only-2.5.0.zip/cassandra-driver-2.5.0/cassandra/cluster.py",
 line 2974, in result
    raise self._final_exception
OverflowError: normalized days too large to fit in a C int

cqlsh:ccc> 

CQLSH - cassandra 2.1.7 - python exception
-------------------------------------
NCHAN-M-D0LZ:apache-cassandra-2.1.7 nchan$ bin/cqlsh
Connected to CCC Multi-Region Cassandra Cluster at 171.71.189.11:9042.
[cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh> use ccc;
cqlsh:ccc> select count(*) from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';

 count
-------
    25

(1 rows)
cqlsh:ccc> select * from task_result where 
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';
Traceback (most recent call last):
  File "bin/cqlsh", line 1041, in perform_simple_statement
    rows = self.session.execute(statement, trace=self.tracing_enabled)
  File 
"/Users/nchan/Programs/apache/apache-cassandra-2.1.7/bin/../lib/cassandra-driver-internal-only-2.5.1.zip/cassandra-driver-2.5.1/cassandra/cluster.py",
 line 1405, in execute
    result = future.result(timeout)
  File 
"/Users/nchan/Programs/apache/apache-cassandra-2.1.7/bin/../lib/cassandra-driver-internal-only-2.5.1.zip/cassandra-driver-2.5.1/cassandra/cluster.py",
 line 2976, in result
    raise self._final_exception
OverflowError: normalized days too large to fit in a C int

cqlsh:ccc> 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to