cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrik Modesto (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-4220) IntegerType secondary index returns no rows
Date Fri, 04 May 2012 12:44:50 GMT
Patrik Modesto created CASSANDRA-4220:

             Summary: IntegerType secondary index returns no rows
                 Key: CASSANDRA-4220
             Project: Cassandra
          Issue Type: Bug
          Components: Core
    Affects Versions: 1.0.9
         Environment: Debian Squeeze Linux, kernel 2.6.32, sun-java6-bin 6.26-0squeeze1
            Reporter: Patrik Modesto


there is something wrong with IntegerType secondary index. It's the 3rd time this happend.
See this example:
[default@rfTest3] get GroupUrlPatternI['25793:51113'];
=> (column=2012-03-04, value={"impressions":1,"avg_position":1}, timestamp=1336113412788000)
=> (column=patternId, value=51113, timestamp=1336113412788000)
Returned 2 results.
Elapsed time: 3 msec(s).
[default@rfTest3] get GroupUrlPatternI where patternId = 51113;                          

0 Row Returned.
Elapsed time: 9 msec(s).
GroupUrlPatternI is defined like this:
    ColumnFamily: GroupUrlPatternI
      Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
      Default column value validator: org.apache.cassandra.db.marshal.UTF8Type
      Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period in seconds / keys to save : 0.0/0/all
      Row Cache Provider: org.apache.cassandra.cache.SerializingCacheProvider
      Key cache size / save period in seconds: 200000.0/14400
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: true
      Bloom Filter FP chance: default
      Built indexes: [GroupUrlPatternI.GroupUrlPatternI_patternId_idx]
      Column Metadata:
        Column Name: patternId
          Validation Class: org.apache.cassandra.db.marshal.IntegerType
          Index Name: GroupUrlPatternI_patternId_idx
          Index Type: KEYS
      Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
I've created empty CF, inserted ~50mil quite small rows, run repair on all four nodes and
left the cluster for few hours idling (lunch, meetings, etc.) Now the secondary index returns
empty result.

I use Hadoop to fill the CF, the patternId value is generated using ByteBuferUtils.bytes(Integer.valueOf(patternId))

sstable2json on the index CF Data.db file shows a row with key: "0000c7a9" which is the hex
for 51113.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message