[
https://issues.apache.org/jira/browse/CASSANDRA-9729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14622777#comment-14622777
]
Adam Holmberg commented on CASSANDRA-9729:
------------------------------------------
[~reach.nchan] that confirms that we are working with timestamp types, which is
what I suspected. Perhaps we could determine if you have incorrectly-encoded
timestamps as follows:
{code}
select time, timestampAsBlob(time), start_time, timestampAsBlob(start_time),
from task_result where submissionid='40f89a3d1f4711e5ac2b005056bb0e8b';
{code}
Running this in Cassandra 2.0 cqlsh should show us if the raw values are scaled
incorrectly.
If scaling is the issue, we'll need to determine if this workaround is safe and
worth putting in the new driver/cqlsh. How you handle this in the application
tier depends on what clients you have in use.
Please let me know what you find out.
> 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)
