cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Hanna (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5732) Can not query secondary index
Date Mon, 10 Feb 2014 10:10:21 GMT

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

Jeremy Hanna commented on CASSANDRA-5732:
-----------------------------------------

FWIW, appears to also be a problem in Cassandra 1.1.

> Can not query secondary index
> -----------------------------
>
>                 Key: CASSANDRA-5732
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5732
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.2.5
>         Environment: Windows 8, Jre 1.6.0_45 32-bit
>            Reporter: Tony Anecito
>            Assignee: Sam Tunnicliffe
>             Fix For: 1.2.11, 2.0.2
>
>         Attachments: 5732-1.2, 5732-v2.txt, 5732-v3.txt
>
>
> Noticed after taking a column family that already existed and assigning to an IntegerType
index_type:KEYS and the caching was already set to 'ALL' that the prepared statement do not
return rows neither did it throw an exception. Here is the sequence.
> 1. Starting state query running with caching off for a Column Family with the query using
the secondary index for te WHERE clause.
> 2, Set Column Family caching to ALL using Cassandra-CLI and update CQL. Cassandra-cli
Describe shows column family caching set to ALL
> 3. Rerun query and it works.
> 4. Restart Cassandra and run query and no rows returned. Cassandra-cli Describe shows
column family caching set to ALL
> 5. Set Column Family caching to NONE using Cassandra-cli and update CQL. Rerun query
and no rows returned. Cassandra-cli Describe for column family shows caching set to NONE.
> 6. Restart Cassandra. Rerun query and it is working again. We are now back to the starting
state.
> Best Regards,
> -Tony



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message