[ https://issues.apache.org/jira/browse/CASSANDRA-10762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15134910#comment-15134910 ]
Ryan McGuire edited comment on CASSANDRA-10762 at 2/5/16 8:29 PM: ------------------------------------------------------------------ This is still failing on non vnode environments: {code} $ DISABLE_VNODES=yes KEEP_TEST_DIR=yes CASSANDRA_VERSION=git:cassandra-3.0 PRINT_DEBUG=true nosetests -s -v upgrade_tests/cql_tests.py:TestCQLNodes2RF1.select_distinct_with_deletions_test select_distinct_with_deletions_test (upgrade_tests.cql_tests.TestCQLNodes2RF1) ... cluster ccm directory: /tmp/dtest-UXb0un http://git-wip-us.apache.org/repos/asf/cassandra.git git:cassandra-3.0 Custom init_config not found. Setting defaults. Done setting configuration options: { 'num_tokens': None, 'phi_convict_threshold': 5, 'range_request_timeout_in_ms': 10000, 'read_request_timeout_in_ms': 10000, 'request_timeout_in_ms': 10000, 'truncate_request_timeout_in_ms': 10000, 'write_request_timeout_in_ms': 10000} getting default job version for 3.0.3 UpgradePath(starting_version='binary:2.2.3', upgrade_version=None) starting from 2.2.3 upgrading to {'install_dir': '/home/ryan/.ccm/repository/gitCOLONcassandra-3.0'} Querying upgraded node FAIL ====================================================================== FAIL: select_distinct_with_deletions_test (upgrade_tests.cql_tests.TestCQLNodes2RF1) ---------------------------------------------------------------------- Traceback (most recent call last): File "/home/ryan/git/datastax/cassandra-dtest/upgrade_tests/cql_tests.py", line 3360, in select_distinct_with_deletions_test self.assertEqual(9, len(rows)) AssertionError: 9 != 8 -------------------- >> begin captured logging << -------------------- dtest: DEBUG: cluster ccm directory: /tmp/dtest-UXb0un dtest: DEBUG: Custom init_config not found. Setting defaults. dtest: DEBUG: Done setting configuration options: { 'num_tokens': None, 'phi_convict_threshold': 5, 'range_request_timeout_in_ms': 10000, 'read_request_timeout_in_ms': 10000, 'request_timeout_in_ms': 10000, 'truncate_request_timeout_in_ms': 10000, 'write_request_timeout_in_ms': 10000} dtest: DEBUG: getting default job version for 3.0.3 dtest: DEBUG: UpgradePath(starting_version='binary:2.2.3', upgrade_version=None) dtest: DEBUG: starting from 2.2.3 dtest: DEBUG: upgrading to {'install_dir': '/home/ryan/.ccm/repository/gitCOLONcassandra-3.0'} dtest: DEBUG: Querying upgraded node --------------------- >> end captured logging << --------------------- ---------------------------------------------------------------------- Ran 1 test in 56.022s FAILED (failures=1) {code} I opened CASSANDRA-11126 for this was (Author: enigmacurry): This is still failing on non vnode environments: {code} $ DISABLE_VNODES=yes KEEP_TEST_DIR=yes CASSANDRA_VERSION=git:cassandra-3.0 PRINT_DEBUG=true nosetests -s -v upgrade_tests/cql_tests.py:TestCQLNodes2RF1.select_distinct_with_deletions_test select_distinct_with_deletions_test (upgrade_tests.cql_tests.TestCQLNodes2RF1) ... cluster ccm directory: /tmp/dtest-UXb0un http://git-wip-us.apache.org/repos/asf/cassandra.git git:cassandra-3.0 Custom init_config not found. Setting defaults. Done setting configuration options: { 'num_tokens': None, 'phi_convict_threshold': 5, 'range_request_timeout_in_ms': 10000, 'read_request_timeout_in_ms': 10000, 'request_timeout_in_ms': 10000, 'truncate_request_timeout_in_ms': 10000, 'write_request_timeout_in_ms': 10000} getting default job version for 3.0.3 UpgradePath(starting_version='binary:2.2.3', upgrade_version=None) starting from 2.2.3 upgrading to {'install_dir': '/home/ryan/.ccm/repository/gitCOLONcassandra-3.0'} Querying upgraded node FAIL ====================================================================== FAIL: select_distinct_with_deletions_test (upgrade_tests.cql_tests.TestCQLNodes2RF1) ---------------------------------------------------------------------- Traceback (most recent call last): File "/home/ryan/git/datastax/cassandra-dtest/upgrade_tests/cql_tests.py", line 3360, in select_distinct_with_deletions_test self.assertEqual(9, len(rows)) AssertionError: 9 != 8 -------------------- >> begin captured logging << -------------------- dtest: DEBUG: cluster ccm directory: /tmp/dtest-UXb0un dtest: DEBUG: Custom init_config not found. Setting defaults. dtest: DEBUG: Done setting configuration options: { 'num_tokens': None, 'phi_convict_threshold': 5, 'range_request_timeout_in_ms': 10000, 'read_request_timeout_in_ms': 10000, 'request_timeout_in_ms': 10000, 'truncate_request_timeout_in_ms': 10000, 'write_request_timeout_in_ms': 10000} dtest: DEBUG: getting default job version for 3.0.3 dtest: DEBUG: UpgradePath(starting_version='binary:2.2.3', upgrade_version=None) dtest: DEBUG: starting from 2.2.3 dtest: DEBUG: upgrading to {'install_dir': '/home/ryan/.ccm/repository/gitCOLONcassandra-3.0'} dtest: DEBUG: Querying upgraded node --------------------- >> end captured logging << --------------------- ---------------------------------------------------------------------- Ran 1 test in 56.022s FAILED (failures=1) {code} I opened #11126 for this > select_distinct_with_deletions_test failing in mixed version cluster > -------------------------------------------------------------------- > > Key: CASSANDRA-10762 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10762 > Project: Cassandra > Issue Type: Sub-task > Components: CQL > Reporter: Philip Thompson > Assignee: Sylvain Lebresne > Fix For: 3.0.3, 3.3 > > > The dtests > {{upgrade_tests.cql_tests.TestCQLNodes3RF3.select_distinct_with_deletions_test}} > and > {{upgrade_tests.cql_tests.TestCQLNodes2RF1.select_distinct_with_deletions_test}} > are failing. > While in a mixed node state, they do {{'SELECT DISTINCT k FROM t1'}} on this > table > {{CREATE TABLE t1 (k int PRIMARY KEY, c int, v int)}} > More rows than expected are returned. Here is the sample output of one of > those queries. As you can see, there are duplicate values of k returned in a > DISTINCT k query. Seems like a bug when communicating between the 2.2 and 3.0 > node. > {code} > [Row(k=5), Row(k=1), Row(k=1), Row(k=8), Row(k=8), Row(k=2), Row(k=2), > Row(k=4), Row(k=4), Row(k=7), Row(k=7), Row(k=6), Row(k=6), Row(k=9), > Row(k=9), Row(k=3), Row(k=3)] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)