[
https://issues.apache.org/jira/browse/CASSANDRA-9729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14622881#comment-14622881
]
Chandran Anjur Narasimhan commented on CASSANDRA-9729:
------------------------------------------------------
Here is the output of the command:
Please not that there are some junk values in the start_time row 16 & 20. Is
this is the one causing the issue?
cqlsh:ccc> select time, timestampAsBlob(time), start_time,
timestampAsBlob(start_time) from task_result where
submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';
time | timestampAsBlob(time) | start_time
| timestampAsBlob(start_time)
--------------------------+-----------------------+-------------------------------+-----------------------------
2015-06-30 09:44:23-0700 | 0x0000014e455aed9a | 2015-06-30
09:44:23-0700 | 0x0000014e455aea58
2015-06-30 09:44:58-0700 | 0x0000014e455b737a | 2015-06-30
09:44:58-0700 | 0x0000014e455b7310
2015-06-30 09:45:15-0700 | 0x0000014e455bb867 | 2015-06-30
09:45:15-0700 | 0x0000014e455bb578
2015-06-30 09:46:02-0700 | 0x0000014e455c6de0 | 2015-06-30
09:45:15-0700 | 0x0000014e455bb578
2015-06-30 09:46:03-0700 | 0x0000014e455c7342 | 2015-06-30
09:46:03-0700 | 0x0000014e455c70f8
2015-06-30 09:46:18-0700 | 0x0000014e455caf72 | 2015-06-30
09:46:03-0700 | 0x0000014e455c70f8
2015-06-30 09:46:23-0700 | 0x0000014e455cc180 | 2015-06-30
09:46:19-0700 | 0x0000014e455caf78
2015-06-30 09:48:24-0700 | 0x0000014e455e9847 | 2015-06-30
09:48:23-0700 | 0x0000014e455e965c
2015-06-30 09:48:30-0700 | 0x0000014e455eb0d4 | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 09:48:34-0700 | 0x0000014e455ec04c | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 09:48:35-0700 | 0x0000014e455ec3fb | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 10:06:55-0700 | 0x0000014e456f8bee | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 10:06:56-0700 | 0x0000014e456f8f96 | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 10:11:00-0700 | 0x0000014e45734b99 | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 10:11:02-0700 | 0x0000014e45735155 | 2015-06-30
09:48:24-0700 | 0x0000014e455e9940
2015-06-30 09:49:59-0700 | 0x0000014e45600cf0 | 266574838-06-29
18:08:16-0800 | 0x74be3c152aa4ed80
2015-06-30 09:50:01-0700 | 0x0000014e4560146a | 2015-06-30
09:48:57-0700 | 0x0000014e455f18a8
2015-06-30 09:50:01-0700 | 0x0000014e4560162a | 2015-06-30
09:48:57-0700 | 0x0000014e455f18a8
2015-06-30 10:09:07-0700 | 0x0000014e4571928b | 2015-06-30
09:48:57-0700 | 0x0000014e455f18a8
2015-06-30 09:48:54-0700 | 0x0000014e455f0d23 | 266574820-06-28
18:08:16-0800 | 0x74be3b90e6700980
2015-06-30 09:48:55-0700 | 0x0000014e455f1113 | 2015-06-30
09:48:39-0700 | 0x0000014e455ed258
2015-06-30 09:48:55-0700 | 0x0000014e455f12aa | 2015-06-30
09:48:39-0700 | 0x0000014e455ed258
2015-06-30 10:09:02-0700 | 0x0000014e45717d12 | 2015-06-30
09:48:39-0700 | 0x0000014e455ed258
2015-06-30 10:09:03-0700 | 0x0000014e45718124 | 2015-06-30
09:48:39-0700 | 0x0000014e455ed258
2015-06-30 10:09:07-0700 | 0x0000014e45718f62 | 2015-06-30
09:48:39-0700 | 0x0000014e455ed258
(25 rows)
cqlsh:ccc>
> 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
> 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
> -------------------------------------
> 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)
