cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-10922) Inconsistent query results
Date Tue, 02 Feb 2016 16:35:40 GMT


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
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:
>             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

View raw message