cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "a8775 (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-13600) sstabledump posisible problem
Date Wed, 14 Jun 2017 12:50:00 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

a8775 updated CASSANDRA-13600:
------------------------------
    Description: 
h2. Possible bug in sstabledump

cqlsh> show version
[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]

h2. 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');


h2. Execute the following commands

nodetool flush
nodetool compact
sstabledump mc-2-big-Data.db
sstabledump -d mc-2-big-Data.db

h3. 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" }
    }
  }
]


h3. 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]


  was:
h2. Possible bug in sstabledump

{{cqlsh> show version
[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
}}

h2. 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');
}}

h2. Execute the following commands

{{nodetool flush
nodetool compact
sstabledump mc-2-big-Data.db
sstabledump -d mc-2-big-Data.db
}}

h3. 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" }
    }
  }
]
}}

h3. 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]}}



> 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
>
>
> h2. Possible bug in sstabledump
> cqlsh> show version
> [cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
> h2. 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');
> h2. Execute the following commands
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> h3. 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" }
>     }
>   }
> ]
> h3. 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


Mime
View raw message