[
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
{noformat}
cqlsh> show version
[cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
{noformat}
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
> {noformat}
> cqlsh> show version
> [cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4]
> {noformat}
> 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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
