[jira] [Created] (CASSANDRA-13600) sstabledump posisible problem

["a8775 (JIRA)" <ji...@apache.org>]

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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org