You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2016/02/02 17:35:40 UTC
[jira] [Commented] (CASSANDRA-10922) Inconsistent query results
[ https://issues.apache.org/jira/browse/CASSANDRA-10922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15128501#comment-15128501 ]
Sylvain Lebresne commented on CASSANDRA-10922:
----------------------------------------------
bq. we can run any commands and provide all info that can help you
The schema and the result of both tracing and scrubbing would be a good start
bq. Could you please describe how to run scrub, or turn on tracing
For scrub, see https://docs.datastax.com/en/cassandra/2.2/cassandra/tools/toolsScrub.html. For tracing, just do {{TRACING ON}} in cqlsh before issuing the query and you'll get a trace printed with the result of the query.
> Inconsistent query results
> --------------------------
>
> Key: CASSANDRA-10922
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10922
> Project: Cassandra
> Issue Type: Bug
> Reporter: Maxim Podkolzine
> Priority: Critical
>
> I have a DB created with Cassandra 2.2.3. And currently I'm running it by Cassandra 3.0.2.
> The value of a particular cell is returned depending on the query I run (in cqlsh):
> - returned when iterate all columns, i.e.
> SELECT value FROM "3xupsource".Content WHERE databaseid=0x21120000 LIMIT 2
> (I can see the columns 0x00000000 and 0x01000000 there, the values seem correct)
> - not returned when I specify a particular column
> SELECT value FROM "3xupsource".Content WHERE databaseid=0x21120000 AND columnid=0x01000000
> Other queries like SELECT value FROM "3xupsource".Content WHERE databaseid=0x21120000 AND columnid=0x00000000 work consistently.
> There is nothing in Cassandra error log, so it does not look like a corruption.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)