a8775 created CASSANDRA-13600:
---------------------------------
Summary: sstabledump posisible problem
Key: CASSANDRA-13600
URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
Project: Cassandra
Issue Type: Bug
Reporter: a8775
Fix For: 3.10
# Possible bug in sstabledump
```
cqlsh> show version
[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
```
## Execute script in cqlsh in new keyspace
```
CREATE TABLE IF NOT EXISTS test_data (
// partitioning key
PK TEXT,
// data
Data TEXT,
PRIMARY KEY (PK)
);
insert into test_data(PK,Data) values('0','aaaa');
insert into test_data(PK,Data) values('1','bbbb');
insert into test_data(PK,Data) values('2','cccc');
delete from test_data where PK='1';
insert into test_data(PK,Data) values('1','dddd');
```
## Execute the following commands
```
nodetool flush
nodetool compact
sstabledump mc-2-big-Data.db
sstabledump -d mc-2-big-Data.db
```
### default dump - missing data for partiotion key = "1"
```
[
{
"partition" : {
"key" : [ "0" ],
"position" : 0
},
"rows" : [
{
"type" : "row",
"position" : 15,
"liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
"cells" : [
{ "name" : "data", "value" : "aaaa" }
]
}
]
},
{
"partition" : {
"key" : [ "2" ],
"position" : 26
},
"rows" : [
{
"type" : "row",
"position" : 41,
"liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
"cells" : [
{ "name" : "data", "value" : "cccc" }
]
}
]
},
{
"partition" : {
"key" : [ "1" ],
"position" : 53,
"deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
"local_delete_time" : "2017-06-14T12:23:13Z" }
}
}
]
```
### dump with -d option - correct data for partiotion key = "1"
```
[0]@0 Row[info=[ts=1497442993529389] ]: | [data=aaaa ts=1497442993529389]
[2]@26 Row[info=[ts=1497442993544132] ]: | [data=cccc ts=1497442993544132]
[1]@53 deletedAt=1497442993545988, localDeletion=1497442993
[1]@53 Row[info=[ts=1497442993550159] ]: | [data=dddd ts=1497442993550159]
```
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
