MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Philip Stoev Date:June 10 2009 8:59am
Subject:bzr push into mysql-5.1-bugteam branch (pstoev:2933 to 2934) Bug#29971
View as plain text  
 2934 Philip Stoev	2009-06-10
      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.

    modified:
      mysql-test/r/status.result
      mysql-test/t/status.test
 2933 Davi Arnaut	2009-06-09
      Define MASTER_MYSOCK for ndb tests.
      Needed for substitution in some tests.
     @ mysql-test/suite/funcs_1/t/ndb_storedproc_06.tes
        Remove unused file.
     @ mysql-test/suite/funcs_1/t/ndb_storedproc_08.tes
        Remove unused file.
     @ mysql-test/suite/ndb/my.cnf
        Export the socket path.

    removed:
      mysql-test/suite/funcs_1/t/ndb_storedproc_06.tes
      mysql-test/suite/funcs_1/t/ndb_storedproc_08.tes
    modified:
      mysql-test/suite/ndb/my.cnf
=== modified file 'mysql-test/r/status.result'
--- a/mysql-test/r/status.result	2009-02-05 16:48:47 +0000
+++ b/mysql-test/r/status.result	2009-06-10 08:58:36 +0000
@@ -1,13 +1,15 @@
 set @old_concurrent_insert= @@global.concurrent_insert;
 set @@global.concurrent_insert= 0;
+SET @old_log_output = @@global.log_output;
+SET GLOBAL LOG_OUTPUT = 'FILE';
 flush status;
 show status like 'Table_lock%';
 Variable_name	Value
-Table_locks_immediate	1
+Table_locks_immediate	0
 Table_locks_waited	0
 select * from information_schema.session_status where variable_name like 'Table_lock%';
 VARIABLE_NAME	VARIABLE_VALUE
-TABLE_LOCKS_IMMEDIATE	2
+TABLE_LOCKS_IMMEDIATE	0
 TABLE_LOCKS_WAITED	0
 # Switched to connection: con1
 set sql_log_bin=0;
@@ -154,7 +156,7 @@ Variable_name	Value
 Com_show_status	3
 show status like 'hand%write%';
 Variable_name	Value
-Handler_write	5
+Handler_write	0
 show status like '%tmp%';
 Variable_name	Value
 Created_tmp_disk_tables	0
@@ -162,7 +164,7 @@ Created_tmp_files	0
 Created_tmp_tables	0
 show status like 'hand%write%';
 Variable_name	Value
-Handler_write	7
+Handler_write	0
 show status like '%tmp%';
 Variable_name	Value
 Created_tmp_disk_tables	0
@@ -237,3 +239,4 @@ SELECT 9;
 DROP PROCEDURE p1;
 DROP FUNCTION f1;
 set @@global.concurrent_insert= @old_concurrent_insert;
+SET GLOBAL log_output = @old_log_output;

=== modified file 'mysql-test/t/status.test'
--- a/mysql-test/t/status.test	2009-03-06 14:56:17 +0000
+++ b/mysql-test/t/status.test	2009-06-10 08:58:36 +0000
@@ -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


Attachment: [text/bzr-bundle] bzr/pstoev@mysql.com-20090610085836-2fwbqou6ftta10fb.bundle
Thread
bzr push into mysql-5.1-bugteam branch (pstoev:2933 to 2934) Bug#29971Philip Stoev12 Jun