percona_log_slow_query_plan.test fails randomly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Yura Sorokin | ||
5.5 |
Invalid
|
Medium
|
Yura Sorokin | ||
5.6 |
Fix Released
|
Medium
|
Yura Sorokin |
Bug Description
While testing fix for bug 1016991 I encountered several other random slow query log test failures. Failures seen in jenkins and reproduced locally. After reverting changes I was able to reproduce these same failures easily:
> ./mtr --parallel=12 ./t/percona_
[...]
CURRENT_TEST: main.percona_
--- /home/glorch/dev/bug1016991/5.6-548/
+++ /home/glorch/dev/bug1016991/5.6-548/
@@ -83,10 +83,10 @@
SELECT * FROM t2 ORDER BY a;
[log_stop.inc] percona_
[log_grep.inc] file: percona_
-[log_grep.inc] lines: 1
+[log_grep.inc] lines: 0
SHOW SESSION STATUS LIKE 'Sort_merge_
Variable_name Value
-Sort_merge_passes 8
+Sort_merge_passes 6
SET SESSION sort_buffer_
SHOW SESSION STATUS LIKE 'Select_scan';
Variable_name Value
mysqltest: Result content mismatch
tags: | added: ci slow-extended |
summary: |
- percona_log_slow_query_plan.test fails radomly + percona_log_slow_query_plan.test fails randomly |
I did not test 5.1 but reproduced against both 5.5 and 5.6 using debug builds.