[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-13600:
-
Resolution: Not A Problem
Status: Resolved (was: Open)
I'm not sure when this was fixed but it is no longer a problem on 3.11.10.
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/Tools
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
>Assignee: Varun Barala
>Priority: Normal
> Labels: patch
> Fix For: 3.11.x
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-13600:
-
Status: Open (was: Patch Available)
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/Tools
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
>Assignee: Varun Barala
>Priority: Normal
> Labels: patch
> Fix For: 3.11.x
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
C. Scott Andreas updated CASSANDRA-13600:
-
Component/s: Tools
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
>Assignee: Varun Barala
>Priority: Major
> Labels: patch
> Fix For: 3.11.x
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Shuler updated CASSANDRA-13600:
---
Fix Version/s: (was: 3.10)
3.11.x
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
>Assignee: Varun Barala
>Priority: Major
> Labels: patch
> Fix For: 3.11.x
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Varun Barala updated CASSANDRA-13600:
-
Labels: patch (was: )
Reproduced In: 3.10
Status: Patch Available (was: Open)
sstabledump tool does not handle the cases where a partition goes through
{{insert, delete, and re-insert}} cycle.
This is fixed in
https://github.com/apache/cassandra/commit/883c9f0f743139d78996f5faf191508a9be338b5
for {{trunk}} and {{3.0.11}}
{{partition.staticRow() != null}} instead of null checking, should be checking
for {{!partition.staticRow().isEmpty()}}
{code:java}
/**
* The static part corresponding to this partition (this can be an empty
* row but cannot be {@code null}).
*/
public Row staticRow();
{code}
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
> Labels: patch
> Fix For: 3.10
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
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
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Varun Barala updated CASSANDRA-13600:
-
Attachment: CASSANDRA-13600.patch
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Environment: Official cassandra docker image (last) under Win10
>Reporter: a8775
> Labels: patch
> Fix For: 3.10
>
> Attachments: CASSANDRA-13600.patch
>
>
> 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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
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
[jira] [Updated] (CASSANDRA-13600) sstabledump possible problem
[
https://issues.apache.org/jira/browse/CASSANDRA-13600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
a8775 updated CASSANDRA-13600:
--
Environment: Official cassandra docker image (last) under Win10
Summary: sstabledump possible problem (was: sstabledump posisible
problem)
> sstabledump possible problem
>
>
> Key: CASSANDRA-13600
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13600
> Project: Cassandra
> Issue Type: Bug
> Environment: Official cassandra docker image (last) under Win10
>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
> {noformat}
> 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','');
> insert into test_data(PK,Data) values('1','');
> insert into test_data(PK,Data) values('2','');
> delete from test_data where PK='1';
> insert into test_data(PK,Data) values('1','');
> {noformat}
> h2. Execute the following commands
> {noformat}
> nodetool flush
> nodetool compact
> sstabledump mc-2-big-Data.db
> sstabledump -d mc-2-big-Data.db
> {noformat}
> h3. default dump - missing data for partiotion key = "1"
> {noformat}
> [
> {
> "partition" : {
> "key" : [ "0" ],
> "position" : 0
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 15,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.529389Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "2" ],
> "position" : 26
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 41,
> "liveness_info" : { "tstamp" : "2017-06-14T12:23:13.544132Z" },
> "cells" : [
> { "name" : "data", "value" : "" }
> ]
> }
> ]
> },
> {
> "partition" : {
> "key" : [ "1" ],
> "position" : 53,
> "deletion_info" : { "marked_deleted" : "2017-06-14T12:23:13.545988Z",
> "local_delete_time" : "2017-06-14T12:23:13Z" }
> }
> }
> ]
> {noformat}
> h3. dump with -d option - correct data for partiotion key = "1"
> {noformat}
> [0]@0 Row[info=[ts=1497442993529389] ]: | [data= ts=1497442993529389]
> [2]@26 Row[info=[ts=1497442993544132] ]: | [data= ts=1497442993544132]
> [1]@53 deletedAt=1497442993545988, localDeletion=1497442993
> [1]@53 Row[info=[ts=1497442993550159] ]: | [data= ts=1497442993550159]
> {noformat}
--
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
