summaryrefslogtreecommitdiff
path: root/mysql-test/include/no_running_events.inc
diff options
context:
space:
mode:
authorMatthias Leich <Matthias.Leich@sun.com>2009-01-09 15:10:03 +0100
committerMatthias Leich <Matthias.Leich@sun.com>2009-01-09 15:10:03 +0100
commitf0d1d53335fa72a910201f15741b275afab8f67d (patch)
treebb03a760694a0b2543cca978de8ea8cb209098cd /mysql-test/include/no_running_events.inc
parent335e842d24083e8961b7f6b7e9563628dcb8956d (diff)
downloadmariadb-git-f0d1d53335fa72a910201f15741b275afab8f67d.tar.gz
1. Fix for Bug#41111 events_bugs fails sporadically on pushbuild
2. Avoid bad effects of bug 41925 Warning 1366 Incorrect string value: ... for column processlist.info 3. Add poll routines which ensure that subtests meet stable scenarios. This does not change the sense of the subtests.
Diffstat (limited to 'mysql-test/include/no_running_events.inc')
-rw-r--r--mysql-test/include/no_running_events.inc25
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/include/no_running_events.inc b/mysql-test/include/no_running_events.inc
new file mode 100644
index 00000000000..8090b2706b8
--- /dev/null
+++ b/mysql-test/include/no_running_events.inc
@@ -0,0 +1,25 @@
+########## include/no_running_events.inc ###################################
+# #
+# Wait till all event executors have finished their work. #
+# #
+# Different event executors share the characteristics that their entry within #
+# processlist contains command = 'Connect'. #
+# Of course the corresponding query will also catch other connections being #
+# within the connect phase. This is no problem since the connect phase is #
+# usually very short. #
+# #
+# A wait_timeout of >= 3 seconds was during experiments in case of "simple" #
+# SQL commands sufficient even on a testing box with heavy parallel load. #
+# "simple" = no sleeps, no long running commands, no waiting for lock ... #
+# We use here the default of 30 seconds because this wastes some time only in #
+# case of unexpected situations. #
+# #
+# Creation: #
+# 2008-12-19 mleich Implement this check needed for test bug fixes #
+# #
+################################################################################
+
+let $wait_condition=
+ SELECT COUNT(*) = 0 FROM information_schema.processlist
+ WHERE command = 'Connect';
+--source include/wait_condition.inc