Comment 4 for bug 1163680

Yura Sorokin (yura-sorokin) wrote :

The bug can no longer be reproduced on neither 5.1, nor 5.5, nor 5.6.

The following scripts were used

1. All "percona_log_slow_*" test run in parallel
*******************************************************
run_mixed.sh
*******************************************************
./mtr \
 --parallel=16 \
 --repeat=16 \
 percona_log_slow_admin_statements-config_false \
 percona_log_slow_admin_statements-config_foo \
 percona_log_slow_admin_statements-config \
 percona_log_slow_admin_statements-config_true \
 percona_log_slow_admin_statements \
 percona_log_slow_filter-cl \
 percona_log_slow_global_control_default \
 percona_log_slow_innodb \
 percona_log_slow_query_plan_qc \
 percona_log_slow_query_plan \
 percona_log_slow_slave_statements-cl \
 percona_log_slow_slave_statements-innodb \
 percona_log_slow_slave_statements \
 percona_log_slow_sp_statements-cl \
 percona_log_slow_sp_statements \
 percona_log_slow_verbosity-cl \
 percona_log_slow_verbosity
*****************************************************

2. The same test "percona_log_slow_sp_statements" run in parallel
*******************************************************
run_single.sh
*******************************************************
./mtr \
 --parallel=16 \
 --repeat=128 \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements \
 percona_log_slow_sp_statements
*******************************************************

These scripts were also run on 5.1, 5.5 and 5.6 with "./mtr --debug" option enabled in order to slow down code execution and provoke different set of race conditions.

For 5.5 and 5.6 "run_single.sh" were also run with original "percona_log_slow_sp_statements .test" (an older version of this file corresponding to the code when the bug was submitted).