Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11, 11.4, 11.8, 12.2
-
None
-
Not for Release Notes
Description
Test failure:
CURRENT_TEST: perfschema.user_var_func
|
--- /home/buildbot/amd64-ubuntu-2204-fulltest/build/mysql-test/suite/perfschema/r/user_var_func.result 2026-01-09 22:04:21.000000000 +0000
|
+++ /home/buildbot/amd64-ubuntu-2204-fulltest/build/mysql-test/suite/perfschema/r/user_var_func.reject 2026-01-09 22:46:35.163781256 +0000
|
@@ -40,9 +40,13 @@
|
order by VARIABLE_NAME;
|
VARIABLE_NAME VARIABLE_VALUE
|
v1a Hello
|
+v1b Salut
|
v2a World
|
+v2b La compagnie
|
v3a 65
|
+v3b 12
|
v4a NULL
|
+v4b NULL
|
set @blob_under_16_bits=repeat("a", 65000);
|
set @blob_under_24_bits=repeat("a", 1000000);
|
select length(@blob_under_16_bits);
|
This particular failure is a regression after bead24b7f3d.
More failures can be reproduced by running e.g. mtr --repeat=2 perfschema.user_var_func or mtr perfschema.update_order-3837 perfschema.user_var_func:
perfschema.update_order-3837 [ pass ] 11
|
perfschema.user_var_func [ fail ]
|
Test ended at 2026-01-10 18:41:01
|
|
|
CURRENT_TEST: perfschema.user_var_func
|
--- 10.11/mysql-test/suite/perfschema/r/user_var_func.result 2025-05-26 17:37:27.242964799 +0400
|
+++ 10.11/mysql-test/suite/perfschema/r/user_var_func.reject 2026-01-10 18:41:00.889355578 +0400
|
@@ -9,6 +9,8 @@
|
from performance_schema.user_variables_by_thread
|
order by VARIABLE_NAME;
|
VARIABLE_NAME VARIABLE_VALUE
|
+num_warnings 0
|
+result 0
|
v1a Hello
|
v2a World
|
v3a 65
|
@@ -25,6 +27,8 @@
|
from performance_schema.user_variables_by_thread
|
order by VARIABLE_NAME;
|
VARIABLE_NAME VARIABLE_VALUE
|
+num_warnings 0
|
+result 0
|
v1a Hello
|
v1b Salut
|
v2a World
|
|
|
Result length mismatch
|
Reproducible with:
diff --git a/sql/sql_connect.cc b/sql/sql_connect.cc
|
index c279f2663c8..c227fee943e 100644
|
--- a/sql/sql_connect.cc
|
+++ b/sql/sql_connect.cc
|
@@ -1483,6 +1483,7 @@ void do_handle_one_connection(CONNECT *connect, bool put_in_cache)
|
if (thd->userstat_running)
|
update_global_user_stats(thd, create_user, time(NULL));
|
|
|
+ sleep(1);
|
unlink_thd(thd);
|
if (IF_WSREP(thd->wsrep_applier, false) || !put_in_cache ||
|
!(connect= thread_cache.park()))
|
Attachments
Issue Links
- is part of
-
MDEV-36647 No red leaves in the forest
-
- Open
-