[
https://issues.apache.org/jira/browse/CASSANDRA-3820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13197498#comment-13197498
]
Peter Schuller commented on CASSANDRA-3820:
-------------------------------------------
And to be clear, I also discovered this when loading sstables from our 0.8 onto
1.0, and certain counter shards not being read from some sstables for a given
row key as a result. As you indicate, I also were able to fix it by scrubbing
on 1.0.
Presumably (unverified) the meta data is treated correctly on 1.0 but in the
0.8 version there is still some kind of 2^31 overflow, such that 0.8 can
successfully reads its own (but will suffer elevated bloom filter false
positives) eve though it's buggy (because it's buggy consistently), while 1.0
reads them correctly - but then suffers from the buggy behavior. This paragraph
is speculation, and *not* confirmed.
> Columns missing after upgrade from 0.8.5 to 1.0.7.
> --------------------------------------------------
>
> Key: CASSANDRA-3820
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3820
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.0.7
> Reporter: Jason Harvey
>
> After an upgrade, one of our CFs had a lot of rows with missing columns. I've
> been able to reproduce in test conditions. Working on getting the tables to
> DataStax(data is private).
> 0.8 results:
> {code}
> [default@reddit] get CommentVote[36353467625f63333837336f32];
> => (column=date, value=313332333932323930392e3531, timestamp=1323922909506508)
> => (column=ip, value=REDACTED, timestamp=1327048432717348, ttl=2592000)
> => (column=name, value=31, timestamp=1327048433000740)
> => (column=REDACTED, value=30, timestamp=1323922909506432)
> => (column=thing1_id, value=REDACTED, timestamp=1323922909506475)
> => (column=thing2_id, value=REDACTED, timestamp=1323922909506486)
> => (column=REDACTED, value=31, timestamp=1323922909506518)
> => (column=REDACTED, value=30, timestamp=1323922909506497)
> {code}
> 1.0 results:
> {code}
> [default@reddit] get CommentVote[36353467625f63333837336f32];
> => (column=ip, value=REDACTED, timestamp=1327048432717348, ttl=2592000)
> => (column=name, value=31, timestamp=1327048433000740)
> {code}
> A few notes:
> * The rows with missing data were fully restored after scrubbing the sstables.
> * The row which I reproduced on happened to be split across multiple sstables.
> * When I copied the first sstable I found the row on, I was able to 'list'
> rows from the sstable, but any and all 'get' calls failed.
> * These SStables were natively created on 0.8.5; they did not come from any
> previous upgrade.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
