Bug #97715 MTR tests are using --slave-parallel-workers=0

• Submitted: 20 Nov 2019 15:27
• Modified: 21 Nov 2019 6:42
• 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 15:27] Przemysław Skibiński

Description:
I found some MTR tests with "parallel" and "mts" in the name that are using "--slave-parallel-workers=0" (default), which disables MTS:

rpl_mts_execute_partial_trx_wit h_auto_pos_off
rpl_mts_execute_partial_trx_with_auto_pos_on_binlogless_slave rpl_mts_execute_partial_trx_with_auto_pos_on
rpl_mts_submode_switch_without_reset_slave
rpl_parallel_innodb
rpl_parallel_show_binlog_events_purge_logs
rpl_parallel

How to repeat:
./mysql-test/mtr --parallel=auto --big-test rpl_mts_execute_partial_trx_wit h_auto_pos_off rpl_mts_execute_partial_trx_with_auto_pos_on_binlogless_slave rpl_mts_execute_partial_trx_with_auto_pos_on rpl_mts_submode_switch_without_reset_slave rpl_parallel_innodb rpl_parallel_show_binlog_events_purge_logs rpl_parallel
Add --slave-parallel-workers=2 to *-slave.opt files

Suggested fix:
Add --slave-parallel-workers=2 to *-slave.opt files

[21 Nov 2019 6:42] MySQL Verification Team

Hello Przemysław,

Thank you for the report and feedback.

Thanks,
Umesh