[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438677#comment-15438677
]
Stefania commented on CASSANDRA-12479:
--
Multiplexing 200 times
[here|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-dtest-multiplex/40/]
with output of cqlsh COPY commands shown.
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to import 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpeXLPtz\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpeXLPtz' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:11.681829 to export 10 records\n-
> >> end captured logging << -"
> {cod
[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1583#comment-1583
]
Stefania commented on CASSANDRA-12479:
--
Multiplexed run above completed without failures, repeating another 500 times
[here|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-dtest-multiplex/42/].
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to import 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpeXLPtz\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpeXLPtz' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:11.681829 to export 10 records\n-
> >> end captured logging <<
[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15444870#comment-15444870
]
Stefania commented on CASSANDRA-12479:
--
There were 4 failures in the latest run, they were all due to timeouts, see
sample
[here|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-dtest-multiplex/42/testReport/junit/node_1_iter_020.cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements/]:
{code}
OperationTimedOut - errors={'127.0.0.1': 'Client request timeout. See
Session.execute[_async](timeout)'}, last_host=127.0.0.1
Processed: 67739 rows; Rate: 18201 rows/s; Avg. rate:6556 rows/s
{code}
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to
[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15444898#comment-15444898
]
Stefania commented on CASSANDRA-12479:
--
I've fixed the page size to 1000 rows and the page timeout to 60 seconds (by
default it is 10 seconds per 1000 rows), repeating multiplexed run
[here|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-dtest-multiplex/44/].
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to import 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpeXLPtz\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpeXLPtz' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:11.681829 to export 10 records\n-
[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15445196#comment-15445196
]
Stefania commented on CASSANDRA-12479:
--
I mistakenly added the page timeout to COPY FROM rather than COPY TO in the
previous run, fixed and relaunched
[here|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-dtest-multiplex/48/].
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to import 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpeXLPtz\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpeXLPtz' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:11.681829 to export 10 records\n-
> >> end ca
[jira] [Commented] (CASSANDRA-12479) dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
[
https://issues.apache.org/jira/browse/CASSANDRA-12479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15447678#comment-15447678
]
Stefania commented on CASSANDRA-12479:
--
The latest run completed 500 iterations without failures, pull request
[here|https://github.com/riptano/cassandra-dtest/pull/1286].
> dtest failure in
> cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_bulk_round_trip_non_prepared_statements
>
>
> Key: CASSANDRA-12479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12479
> Project: Cassandra
> Issue Type: Test
> Components: Testing
>Reporter: Craig Kodman
>Assignee: Stefania
> Labels: dtest
> Attachments: node1.log, node1_debug.log, node1_gc.log, node2.log,
> node2_debug.log, node2_gc.log, node3.log, node3_debug.log, node3_gc.log
>
>
> example failure:
> http://cassci.datastax.com/job/cassandra-2.2_offheap_dtest/447/testReport/cqlsh_tests.cqlsh_copy_tests/CqlshCopyTest/test_bulk_round_trip_non_prepared_statements
> {code}
> Error Message
> 10 != 96848
> >> begin captured logging <<
> dtest: DEBUG: cluster ccm directory: /tmp/dtest-BryYNs
> dtest: DEBUG: Done setting configuration options:
> { 'initial_token': None,
> 'memtable_allocation_type': 'offheap_objects',
> 'num_tokens': '32',
> 'phi_convict_threshold': 5,
> 'range_request_timeout_in_ms': 1,
> 'read_request_timeout_in_ms': 1,
> 'request_timeout_in_ms': 1,
> 'truncate_request_timeout_in_ms': 1,
> 'write_request_timeout_in_ms': 1}
> dtest: DEBUG: Running stress without any user profile
> dtest: DEBUG: Generated 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpREOhBZ'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:04.598829 to export 10 records
> dtest: DEBUG: Truncating keyspace1.standard1...
> dtest: DEBUG: Importing from csv file: /tmp/tmpREOhBZ
> dtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ' WITH
> PREPAREDSTATEMENTS = False
> dtest: DEBUG: COPY FROM took 0:00:10.348123 to import 10 records
> dtest: DEBUG: Exporting to csv file: /tmp/tmpeXLPtz
> dtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO '/tmp/tmpeXLPtz'
> WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000
> dtest: DEBUG: COPY TO took 0:00:11.681829 to export 10 records
> - >> end captured logging << -
> {code}
> {code}
> Stacktrace
> File "/usr/lib/python2.7/unittest/case.py", line 329, in run
> testMethod()
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2482, in test_bulk_round_trip_non_prepared_statements
> copy_from_options={'PREPAREDSTATEMENTS': False})
> File "/home/automaton/cassandra-dtest/cqlsh_tests/cqlsh_copy_tests.py",
> line 2461, in _test_bulk_round_trip
> sum(1 for _ in open(tempfile2.name)))
> File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
> assertion_func(first, second, msg=msg)
> File "/usr/lib/python2.7/unittest/case.py", line 506, in _baseAssertEqual
> raise self.failureException(msg)
> "10 != 96848\n >> begin captured logging <<
> \ndtest: DEBUG: cluster ccm directory:
> /tmp/dtest-BryYNs\ndtest: DEBUG: Done setting configuration options:\n{
> 'initial_token': None,\n'memtable_allocation_type': 'offheap_objects',\n
> 'num_tokens': '32',\n'phi_convict_threshold': 5,\n
> 'range_request_timeout_in_ms': 1,\n'read_request_timeout_in_ms':
> 1,\n'request_timeout_in_ms': 1,\n
> 'truncate_request_timeout_in_ms': 1,\n'write_request_timeout_in_ms':
> 1}\ndtest: DEBUG: Running stress without any user profile\ndtest: DEBUG:
> Generated 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpREOhBZ' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:04.598829 to export 10 records\ndtest: DEBUG:
> Truncating keyspace1.standard1...\ndtest: DEBUG: Importing from csv file:
> /tmp/tmpREOhBZ\ndtest: DEBUG: COPY keyspace1.standard1 FROM '/tmp/tmpREOhBZ'
> WITH PREPAREDSTATEMENTS = False\ndtest: DEBUG: COPY FROM took 0:00:10.348123
> to import 10 records\ndtest: DEBUG: Exporting to csv file:
> /tmp/tmpeXLPtz\ndtest: DEBUG: CONSISTENCY ALL; COPY keyspace1.standard1 TO
> '/tmp/tmpeXLPtz' WITH PAGETIMEOUT = 10 AND PAGESIZE = 1000\ndtest: DEBUG:
> COPY TO took 0:00:11.681829 to export 10 records\n-
> >> end captured logging << -"
