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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.18, 5.7.28 OS:Any
Assigned to: 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