[
https://issues.apache.org/jira/browse/CASSANDRA-4220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Ellis resolved CASSANDRA-4220.
---------------------------------------
Resolution: Cannot Reproduce
> IntegerType secondary index returns no rows
> -------------------------------------------
>
> Key: CASSANDRA-4220
> URL: https://issues.apache.org/jira/browse/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
>
> Hi,
> there is something wrong with IntegerType secondary index. It's the 3rd time
> this happend. See this example:
> {noformat}
> [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).
> [default@rfTest3]
> {noformat}
> GroupUrlPatternI is defined like this:
> {noformat}
> 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
> {noformat}
> 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 was sent by Atlassian JIRA
(v6.2#6252)
