[CASSANDRA-14025] test_simple_strategy_counters - consistency_test.TestAccuracy always fails code=2000 [Syntax error in CQL query] message="line 7:14 mismatched input 'AND' expecting EOF (... text, age int ) [AND]...)

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Component/s: Legacy/Testing
• Severity: Normal
• Assignee: Joel Knighton
• Reporter: Michael Kjellman

Authors

Joel Knighton

Reviewers

Jeff Jirsa

• Created: 15/Nov/17 22:15
• Updated: 16/Apr/19 09:29
• Resolved: 16/Nov/17 19:31

Description

test_simple_strategy_counters - consistency_test.TestAccuracy always fails code=2000 [Syntax error in CQL query] message="line 7:14 mismatched input 'AND' expecting EOF (... text, age int ) [AND]...)

<Error from server: code=2000 [Syntax error in CQL query] message="line 7:14 mismatched input 'AND' expecting EOF (... text, age int ) [AND]...)">
-------------------- >> begin captured logging << --------------------
dtest: DEBUG: cluster ccm directory: /tmp/dtest-dYXpHm
dtest: DEBUG: Done setting configuration options:

{ 'initial_token': None, 'memtable_allocation_type': 'offheap_objects', 'num_tokens': '256', '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: Testing single dc, counters
dtest: DEBUG: Changing snitch for single dc case
cassandra.cluster: INFO: New Cassandra host <Host: 127.0.0.3 dc1> discovered
cassandra.cluster: INFO: New Cassandra host <Host: 127.0.0.2 dc1> discovered
--------------------- >> end captured logging << ---------------------
File "/usr/lib/python2.7/unittest/case.py", line 329, in run
testMethod()
File "/home/cassandra/cassandra-dtest/consistency_test.py", line 704, in test_simple_strategy_counters
self._run_test_function_in_parallel(TestAccuracy.Validation.validate_counters, [self.nodes], [self.rf], combinations)
File "/home/cassandra/cassandra-dtest/consistency_test.py", line 535, in _run_test_function_in_parallel
self._start_cluster(save_sessions=True, requires_local_reads=requires_local_reads)
File "/home/cassandra/cassandra-dtest/consistency_test.py", line 147, in _start_cluster
self.create_tables(session, requires_local_reads)
File "/home/cassandra/cassandra-dtest/consistency_test.py", line 156, in create_tables
self.create_users_table(session, requires_local_reads)
File "/home/cassandra/cassandra-dtest/consistency_test.py", line 178, in create_users_table
session.execute(create_cmd)
File "cassandra/cluster.py", line 2122, in cassandra.cluster.Session.execute
return self.execute_async(query, parameters, trace, custom_payload, timeout, execution_profile, paging_state).result()
File "cassandra/cluster.py", line 3982, in cassandra.cluster.ResponseFuture.result
raise self._final_exception
'<Error from server: code=2000 [Syntax error in CQL query] message="line 7:14 mismatched input \'AND\' expecting EOF (... text, age int ) [AND]...)">\n-------------------- >> begin captured logging << --------------------\ndtest: DEBUG: cluster ccm directory: /tmp/dtest-dYXpHm\ndtest: DEBUG: Done setting configuration options:\n

{ \'initial_token\': None,\n \'memtable_allocation_type\': \'offheap_objects\',\n \'num_tokens\': \'256\',\n \'phi_convict_threshold\': 5,\n \'range_request_timeout_in_ms\': 10000,\n \'read_request_timeout_in_ms\': 10000,\n \'request_timeout_in_ms\': 10000,\n \'truncate_request_timeout_in_ms\': 10000,\n \'write_request_timeout_in_ms\': 10000}

\ndtest: DEBUG: Testing single dc, counters\ndtest: DEBUG: Changing snitch for single dc case\ncassandra.cluster: INFO: New Cassandra host <Host: 127.0.0.3 dc1> discovered\ncassandra.cluster: INFO: New Cassandra host <Host: 127.0.0.2 dc1> discovered\n--------------------- >> end captured logging << ---------------------'