summaryrefslogtreecommitdiff
path: root/mysql-test/t/status.test
diff options
context:
space:
mode:
authorPhilip Stoev <pstoev@mysql.com>2009-06-10 11:58:36 +0300
committerPhilip Stoev <pstoev@mysql.com>2009-06-10 11:58:36 +0300
commitd98dee2c3b79d6a98978a732b29c2726474e325e (patch)
tree7c06be0459b9691d09ad48750be7436b2b280133 /mysql-test/t/status.test
parent403b08342da4905fe0f2be29495ce1d134504038 (diff)
downloadmariadb-git-d98dee2c3b79d6a98978a732b29c2726474e325e.tar.gz
Bug #29971 status.test fails
This test uses SHOW STATUS and the like, which may be unstable in the face of logging to table, since the CSV handler is actively executing operations and thus incrementing the counters. Fixed by disabling logging to table for the duration of the test and restoring it afterwards. This causes various counters to properly start counting from zero and never advance due to CSV operations.
Diffstat (limited to 'mysql-test/t/status.test')
-rw-r--r--mysql-test/t/status.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/status.test b/mysql-test/t/status.test
index 5842f59af5c..5da210f5a69 100644
--- a/mysql-test/t/status.test
+++ b/mysql-test/t/status.test
@@ -12,6 +12,12 @@
set @old_concurrent_insert= @@global.concurrent_insert;
set @@global.concurrent_insert= 0;
+# Disable logging to table, since this will also cause table locking and unlocking, which will
+# show up in SHOW STATUS and may cause sporadic failures
+
+SET @old_log_output = @@global.log_output;
+SET GLOBAL LOG_OUTPUT = 'FILE';
+
# PS causes different statistics
--disable_ps_protocol
@@ -350,6 +356,7 @@ DROP FUNCTION f1;
# Restore global concurrent_insert value. Keep in the end of the test file.
--connection default
set @@global.concurrent_insert= @old_concurrent_insert;
+SET GLOBAL log_output = @old_log_output;
# Wait till we reached the initial number of concurrent sessions
--source include/wait_until_count_sessions.inc