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)