Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0(EOL), 10.1(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-yakkety-x86/builds/39/steps/test_4/logs/stdio
sys_vars.thread_cache_size_func w4 [ fail ]
|
Test ended at 2016-10-25 11:59:28
|
|
CURRENT_TEST: sys_vars.thread_cache_size_func
|
--- /usr/share/mysql/mysql-test/suite/sys_vars/r/thread_cache_size_func.result 2016-10-25 09:52:02.000000000 -0400
|
+++ /dev/shm/var/4/log/thread_cache_size_func.reject 2016-10-25 11:59:28.820780019 -0400
|
@@ -18,7 +18,7 @@
|
** Disconnecting conn1,conn2,conn3,conn4 **
|
SHOW STATUS LIKE 'Threads_cached';
|
Variable_name Value
|
-Threads_cached 3
|
+Threads_cached 1
|
3 Expected
|
SET @@GLOBAL.thread_cache_size= 1;
|
** Connecting conn1 using username 'root' **
|
|
mysqltest: Result content mismatch
|
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
This is caused by incorrect testcase sync: the testcase disconnects, waits for the threads disappear from the processlist, then checks the status variable. But a disconnecting thread first removes itself from the processlist, and becomes cached only later, creating a race condition.
A proper fix appears to drop processlist checks and SHOW STATUS, and wait for Threads_cached to become desired value by wait_for_status_var.inc, see https://github.com/percona/percona-server/pull/1337