[jira] [Commented] (CASSANDRA-7120) Bad paging state returned for prepared statements for last page
[ https://issues.apache.org/jira/browse/CASSANDRA-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14006128#comment-14006128 ] Tyler Hobbs commented on CASSANDRA-7120: +1 Bad paging state returned for prepared statements for last page --- Key: CASSANDRA-7120 URL: https://issues.apache.org/jira/browse/CASSANDRA-7120 Project: Cassandra Issue Type: Bug Components: Core Reporter: Tyler Hobbs Assignee: Tyler Hobbs Fix For: 2.1 rc1 Attachments: 7120-alternative.txt, 7120.txt When executing a paged query with a prepared statement, a non-null paging state is sometimes being returned for the final page, causing an endless paging loop. Specifically, this is the schema being used: {noformat} CREATE KEYSPACE test3rf WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}'; USE test3rf; CREATE TABLE test3rf.test ( k int PRIMARY KEY, v int ) {noformat} The inserts are like so: {noformat} INSERT INTO test3rf.test (k, v) VALUES (?, 0) {noformat} With values from [0, 99] used for k. The query is {{SELECT * FROM test3rf.test}} with a fetch size of 3. The final page returns the row with k=3, and the paging state is {{000400420004000176007fa2}}. This matches the paging state from three pages earlier. When executing this with a non-prepared statement, no paging state is returned for this page. This problem doesn't happen with the 2.0 branch. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-7120) Bad paging state returned for prepared statements for last page
[ https://issues.apache.org/jira/browse/CASSANDRA-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13996768#comment-13996768 ] Tyler Hobbs commented on CASSANDRA-7120: [~rhatch] yes, this reproduces 100% of the time. You could make a version of the {{test_paging()}} method here: https://github.com/datastax/python-driver/blob/master/tests/integration/standard/test_query_paging.py#L48 Bad paging state returned for prepared statements for last page --- Key: CASSANDRA-7120 URL: https://issues.apache.org/jira/browse/CASSANDRA-7120 Project: Cassandra Issue Type: Bug Components: Core Reporter: Tyler Hobbs Fix For: 2.1 rc1 When executing a paged query with a prepared statement, a non-null paging state is sometimes being returned for the final page, causing an endless paging loop. Specifically, this is the schema being used: {noformat} CREATE KEYSPACE test3rf WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}'; USE test3rf; CREATE TABLE test3rf.test ( k int PRIMARY KEY, v int ) {noformat} The inserts are like so: {noformat} INSERT INTO test3rf.test (k, v) VALUES (?, 0) {noformat} With values from [0, 99] used for k. The query is {{SELECT * FROM test3rf.test}} with a fetch size of 3. The final page returns the row with k=3, and the paging state is {{000400420004000176007fa2}}. This matches the paging state from three pages earlier. When executing this with a non-prepared statement, no paging state is returned for this page. This problem doesn't happen with the 2.0 branch. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (CASSANDRA-7120) Bad paging state returned for prepared statements for last page
[ https://issues.apache.org/jira/browse/CASSANDRA-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13995839#comment-13995839 ] Russ Hatch commented on CASSANDRA-7120: --- If there's a way to repro this 100% of the time, I'd like to add it to the jython paging tests (https://github.com/riptano/cassandra-dtest-jython). Bad paging state returned for prepared statements for last page --- Key: CASSANDRA-7120 URL: https://issues.apache.org/jira/browse/CASSANDRA-7120 Project: Cassandra Issue Type: Bug Components: Core Reporter: Tyler Hobbs Fix For: 2.1 rc1 When executing a paged query with a prepared statement, a non-null paging state is sometimes being returned for the final page, causing an endless paging loop. Specifically, this is the schema being used: {noformat} CREATE KEYSPACE test3rf WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}'; USE test3rf; CREATE TABLE test3rf.test ( k int PRIMARY KEY, v int ) {noformat} The inserts are like so: {noformat} INSERT INTO test3rf.test (k, v) VALUES (?, 0) {noformat} With values from [0, 99] used for k. The query is {{SELECT * FROM test3rf.test}} with a fetch size of 3. The final page returns the row with k=3, and the paging state is {{000400420004000176007fa2}}. This matches the paging state from three pages earlier. When executing this with a non-prepared statement, no paging state is returned for this page. This problem doesn't happen with the 2.0 branch. -- This message was sent by Atlassian JIRA (v6.2#6252)