[ https://issues.apache.org/jira/browse/CASSANDRA-9729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-9729. --------------------------------------- Resolution: Invalid Fix Version/s: (was: 2.1.x) > 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: Improvement > Components: Tools > Environment: OSX 10.10.2 > Reporter: Chandran Anjur Narasimhan > Labels: cqlsh > > 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 > ------------------------------------- > {noformat} > 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> > {noformat} > CQLSH - cassandra 2.1.5 - python exception > ------------------------------------- > {noformat} > 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> > {noformat} > CQLSH - cassandra 2.1.7 - python exception > ------------------------------------- > {noformat} > 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> > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)