Bug #97713 Some MTR tests are skipped because of missing slave-parallel-type=LOGICAL_CLOCK

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

Description:
Some MTR tests are skipped because of missing slave-parallel-type=LOGICAL_CLOCK

[ 75%] rpl.rpl_multi_source_mts_recovery 'row'  w3  [ skipped ]  The test needs slave_parallel_type=logical_clock
[ 83%] rpl.rpl_mts_logical_clock_assertion_failure 'row' w4  [ skipped ]  Test makes sense only to run with MTS slave-parallel-type LOGICAL_CLOCK
[ 91%] rpl.rpl_parallel_recovery 'row'          w5  [ skipped ]  The test needs slave_parallel_type=logical_clock
[100%] rpl.rpl_mts_slave_preserve_commit_order_deadlock_error 'stmt' w8  [ skipped ]  Test makes sense only to run with MTS slave-parallel-type LOGICAL_CLOCK

How to repeat:
./mysql-test/mtr --parallel=auto --big-test rpl_mts_slave_preserve_commit_order_deadlock_error rpl_mts_logical_clock_assertion_failure rpl_multi_source_mts_recovery rpl_parallel_recovery

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

[21 Nov 2019 6:23] MySQL Verification Team

Hello Przemysław,

Thank you for the report and feedback.

Thanks,
Umesh