[
https://issues.apache.org/jira/browse/CASSANDRA-11654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15257467#comment-15257467
]
Chris Lohfink commented on CASSANDRA-11654:
-------------------------------------------
reproducing your steps you get the following for the Data file (i disabled
compaction though for ease of reading):
{code}
00 04 00 00 00 01 7F FF FF FF 80 00 00 00 00 00 00 00 34 00
02 63 31 0F 12 E0 92 7C FE E0 4D C1 82 00 08 00 00 00 64 01
{code}
{code}
PARTITION
-------------------
Partition key size: 00 04
Partition key: 00 00 00 01
local deletion time: 7F FF FF FF
marked for deletion at: 80 00 00 00 00 00 00 00
ROW @18
-------------------
Flags: 34 - HAS_TIMESTAMP, HAS_DELETION, HAS_ALL_COLUMNS
Size: 00 02
Key: 63 31 (c1)
Row Size: 0F
Prev: 12
timestamp (delta from minTimestamp in encoding): E0 92 7C FE - 9600254
deletion time: E0 4D C1 82 00
COLUMN
-------------
Flags: 08 hasValue, useRowTimestamp
Value: 00 00 00 64
-----
I dont know what this is for: 01
{code}
So the sstabledump is printing out whats in the sstable. What is it your
expecting to see?
> sstabledump is not able to properly print out SSTable that may contain
> historical (but "shadowed") row tombstone
> ----------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-11654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11654
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Reporter: Wei Deng
> Assignee: Yuki Morishita
> Labels: Tools
> Fix For: 3.0.x, 3.x
>
>
> It is pretty trivial to reproduce. Here are the steps I used (on a single
> node C* 3.x cluster):
> {noformat}
> echo "CREATE KEYSPACE IF NOT EXISTS testks WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': '1'};" | cqlsh
> echo "CREATE TABLE IF NOT EXISTS testks.testcf ( k int, c text, val0_int int,
> PRIMARY KEY (k, c) );" | cqlsh
> echo "INSERT INTO testks.testcf (k, c, val0_int) VALUES (1, 'c1', 100);" |
> cqlsh
> echo "DELETE FROM testks.testcf where k=1 and c='c1';" | cqlsh
> echo "INSERT INTO testks.testcf (k, c, val0_int) VALUES (1, 'c1', 100);" |
> cqlsh
> nodetool flush testks testcf
> echo "SELECT * FROM testks.testcf;" | cqlsh
> {noformat}
> The last step from above will confirm that there is one live row in the
> testks.testcf table. However, if you now go to the actual SSTable file
> directory and run sstabledump like the following, you will see the row is
> still marked as deleted and no row content is shown:
> {noformat}
> $ sstabledump ma-1-big-Data.db
> [
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 18,
> "clustering" : [ "c1" ],
> "liveness_info" : { "tstamp" : 1461633248542342 },
> "deletion_info" : { "deletion_time" : 1461633248212499, "tstamp" :
> 1461633248 }
> }
> ]
> }
> ]
> {noformat}
> This is reproduced in both latest 3.0.5 and 3.6-snapshot (i.e. trunk as of
> Apr 25, 2016).
> Looks like only row tombstone is affecting sstabledump. If you generate cell
> tombstones, even if you delete all non-PK & non-static columns in the row, as
> long as there is no explicit row delete (so the clustering is still
> considered alive), sstabledump will work just fine, see the following example
> steps:
> {noformat}
> echo "CREATE KEYSPACE IF NOT EXISTS testks WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': '1'};" | cqlsh
> echo "CREATE TABLE IF NOT EXISTS testks.testcf ( k int, c text, val0_int int,
> val1_int int, PRIMARY KEY (k, c) );" | cqlsh
> echo "INSERT INTO testks.testcf (k, c, val0_int, val1_int) VALUES (1, 'c1',
> 100, 200);" | cqlsh
> echo "DELETE val0_int, val1_int FROM testks.testcf where k=1 and c='c1';" |
> cqlsh
> echo "INSERT INTO testks.testcf (k, c, val0_int, val1_int) VALUES (1, 'c1',
> 300, 400);" | cqlsh
> nodetool flush testks testcf
> echo "select * from testks.testcf;" | cqlsh
> $ sstabledump ma-1-big-Data.db
> [
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 18,
> "clustering" : [ "c1" ],
> "liveness_info" : { "tstamp" : 1461634633566479 },
> "cells" : [
> { "name" : "val0_int", "value" : "300" },
> { "name" : "val1_int", "value" : "400" }
> ]
> }
> ]
> }
> ]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
