Bug #97708 MTR tests are skipped because of missing --slave-parallel-workers=#

• Submitted: 20 Nov 2019 12:48
• Modified: 21 Nov 2019 6:17
• Reporter: Przemysław Skibiński (OCA)
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S7 (Test Cases)
• Version: 8.0.18, 5.7.28
• OS: Any
• CPU Architecture: Any

[20 Nov 2019 12:48] Przemysław Skibiński

Description:
Some MTR tests are skipped because of missing --slave-parallel-workers=#

[ 61%] rpl.rpl_multi_source_mts_slave_retry 'mix' w10 [ skipped ]  Test makes sense only to run with MTS
[ 66%] rpl.rpl_multi_source_mts_slave_retry 'row' w5  [ skipped ]  Test makes sense only to run with MTS
[ 71%] rpl_nogtid.rpl_parallel_worker_error 'stmt' w3  [ skipped ]  Test makes sense only to run with MTS
[ 76%] rpl_nogtid.rpl_mts_relay_log_post_crash_recovery 'stmt' w2  [ skipped ]  Test makes sense only to run with MTS
[ 80%] rpl.rpl_mts_stop_slave 'stmt'            w12 [ skipped ]  Test makes sense only to run with MTS
[ 85%] rpl.rpl_mts_relay_log_recovery_on_error 'stmt' w7  [ skipped ]  Test makes sense only to run with MTS
[ 90%] rpl.rpl_mts_stop_slave_report_pos 'row'  w9  [ skipped ]  Test makes sense only to run with MTS
[ 95%] rpl.rpl_multi_source_mts_slave_retry 'stmt' w1  [ skipped ]  Test makes sense only to run with MTS
[100%] rpl.rpl_multi_source_relay_log_recovery 'stmt' w11 [ skipped ]  Test makes sense only to run with MTS

How to repeat:
./mysql-test/mtr --parallel=auto --big-test rpl_multi_source_mts_slave_retry rpl_mts_stop_slave_report_pos rpl_mts_relay_log_post_crash_recovery rpl_parallel_worker_error rpl_mts_stop_slave rpl_mts_relay_log_recovery_on_error rpl_multi_source_relay_log_recovery

Suggested fix:
1. Add --slave-parallel-workers=2 to *-slave.opt files
2. slave_parallel_workers should be checked on slave therefore move
--source include/only_mts_slave_parallel_workers.inc
--source include/only_mts_slave_parallel_type_database.inc
after
--source include/rpl_connection_slave.inc

[21 Nov 2019 6:17] MySQL Verification Team

Hello Przemysław,

Thank you for the report and feedback.

Thanks,
Umesh