cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-3820) Columns missing after upgrade from 0.8.5 to 1.0.7.
Date Mon, 05 Mar 2012 16:35:58 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-3820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222440#comment-13222440
] 

Jonathan Ellis commented on CASSANDRA-3820:
-------------------------------------------

Yes, scrub and upgradesstables both fix the problem w/o data loss.
                
> 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

        

Mime
View raw message