[CASSANDRA-3820] Columns missing after upgrade from 0.8.5 to 1.0.7.

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Severity: Normal
• Assignee: Unassigned
• Reporter: Jason Harvey
• Created: 31/Jan/12 23:25
• Updated: 16/Apr/19 09:32
• Resolved: 25/Jan/13 23:16

Description

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:

[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)

1.0 results:

[default@reddit] get CommentVote[36353467625f63333837336f32];
=> (column=ip, value=REDACTED, timestamp=1327048432717348, ttl=2592000)
=> (column=name, value=31, timestamp=1327048433000740)

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.