cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-2600) CQL: Range query throws errors when run thru cqlsh but passes in system test
Date Wed, 04 May 2011 23:26:03 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13029043#comment-13029043
] 

Brandon Williams commented on CASSANDRA-2600:
---------------------------------------------

If you are using RandomPartioner, what is happening is it's comparing the md5 value of 'ad'
against 'ag' and it turns out 'ad' is higher when hashed.  This isn't a useful query to perform
with RP (it will never do what you want) so CQL should probably just throw a better error
here to let the user know that.

> CQL: Range query throws errors when run thru cqlsh but passes in system test 
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2600
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2600
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8 beta 1
>            Reporter: Cathy Daw
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>              Labels: cql
>             Fix For: 0.8.0
>
>
> *It appears the following nose test breaks when run via cqlsh*
> {code}
> CREATE COLUMNFAMILY StandardLongA (KEY text PRIMARY KEY) WITH comparator = bigint AND
default_validation = ascii;
> UPDATE StandardLongA SET 1='1', 2='2', 3='3', 4='4' WHERE KEY='aa';
> UPDATE StandardLongA SET 5='5', 6='6', 7='8', 9='9' WHERE KEY='ab';
> UPDATE StandardLongA SET 9='9', 8='8', 7='7', 6='6' WHERE KEY='ac';
> UPDATE StandardLongA SET 5='5', 4='4', 3='3', 2='2' WHERE KEY='ad';
> UPDATE StandardLongA SET 1='1', 2='2', 3='3', 4='4' WHERE KEY='ae';
> UPDATE StandardLongA SET 1='1', 2='2', 3='3', 4='4' WHERE KEY='af';
> UPDATE StandardLongA SET 5='5', 6='6', 7='8', 9='9' WHERE KEY='ag';
> cqlsh> SELECT 4 FROM StandardLongA WHERE KEY > 'ad' AND KEY < 'ag';
> Internal application error
> cqlsh> SELECT * FROM StandardLongA WHERE KEY > 'ad' AND KEY < 'ag';
> Internal application error
> {code}
> {code}
> ERROR 21:43:16,880 Internal error processing execute_cql_query
> java.lang.AssertionError: [109302822465993666080409141220504733189,104027502549504462599318918375258179002]
> 	at org.apache.cassandra.dht.Bounds.<init>(Bounds.java:40)
> 	at org.apache.cassandra.dht.Bounds.<init>(Bounds.java:33)
> 	at org.apache.cassandra.cql.QueryProcessor.multiRangeSlice(QueryProcessor.java:142)
> 	at org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:507)
> 	at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1127)
> 	at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.process(Cassandra.java:4072)
> 	at org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2889)
> 	at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> 	at java.lang.Thread.run(Thread.java:636)
> {code}
> *This test case runs nightly in the system tests and passes*
> [http://173.203.89.16:8080/job/CassandraSystem/]
> {code}
> jenkins@mallen2:~/jobs/Cassandra/workspace$ nosetests test/system/test_cql.py
> ..................................
> ----------------------------------------------------------------------
> Ran 34 tests in 147.040s
> OK
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message