MySQL Bugs: #48646: mysql-test main.log_tables-big fails on 5.1.40

Bug #48646	mysql-test main.log_tables-big fails on 5.1.40
Submitted:	9 Nov 2009 18:33	Modified:	2 Dec 2013 17:00
Reporter:	Aleksandr Kuzminsky	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1.40, 5.1.42-bzr, 5.1.41	OS:	Any (Centos5, Debian, Mac OS X)
Assigned to:		CPU Architecture:	Any
Tags:	disabled

Description:
The test fails with output (May be related to http://bugs.mysql.com/bug.php?id=47924, but sympthoms are different):

Logging: ./mtr  --big-test main.log_tables-big
MySQL Version 5.1.40
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /mnt/data1/home/buildbot/src/mysql-5.1.40/mysql-test/var
Checking leftover processes...
 - found old pid 22515 in 'mysqld.1.pid', killing it...
   process did not exist!
Removing old var directory...
Creating var directory '/mnt/data1/home/buildbot/src/mysql-5.1.40/mysql-test/var'...
Installing system database...
Using server port 59842

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.log_tables-big                      [ fail ]
        Test ended at 2009-11-09 10:20:40

CURRENT_TEST: main.log_tables-big
--- /mnt/data1/home/buildbot/src/mysql-5.1.40/mysql-test/r/log_tables-big.result        2009-10-06 21:21:44.000000000 +0300
+++ /mnt/data1/home/buildbot/src/mysql-5.1.40/mysql-test/r/log_tables-big.reject        2009-11-09 21:20:40.000000000 +0300
@@ -9,21 +9,18 @@
 0
 select if (query_time between '00:00:01' and '00:00:10', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt     sql_text
-OK     select get_lock('bug27638', 2)
 truncate table mysql.slow_log;
 select get_lock('bug27638', 60);
 get_lock('bug27638', 60)
 0
 select if (query_time between '00:00:59' and '00:01:10', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt     sql_text
-OK     select get_lock('bug27638', 60)
 truncate table mysql.slow_log;
 select get_lock('bug27638', 101);
 get_lock('bug27638', 101)
 0
 select if (query_time between '00:01:40' and '00:01:50', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt     sql_text
-OK     select get_lock('bug27638', 101)
 select release_lock('bug27638');
 release_lock('bug27638')
 1

mysqltest: Result content mismatch

 - saving '/mnt/data1/home/buildbot/src/mysql-5.1.40/mysql-test/var/log/main.log_tables-big/' to '/mnt/data1/home/buildbot/src/mysql-5.1.40
/mysql-test/var/log/main.log_tables-big/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 164 seconds executing testcases

Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.log_tables-big

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

How to repeat:
# ./configure --with-plugins=innobase && make all
# cd mysql-test && ./mtr --big-test main.log_tables-big

Verified just as described also with latest 5.1.42 from bzr on Mac OS X:

77-52-7-73:mysql-test openxs$ ./mtr  --big-test main.log_tables-big
Logging: ./mtr  --big-test main.log_tables-big
091109 20:44:46 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/ZBpnDIg2c6/ is case insensitive
091109 20:44:46 [Note] Plugin 'FEDERATED' is disabled.
091109 20:44:46 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.1.42
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /Users/openxs/dbs/5.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/Users/openxs/dbs/5.1/mysql-test/var'...
Installing system database...
Using server port 60832

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.log_tables-big                      [ fail ]
        Test ended at 2009-11-09 20:47:34

CURRENT_TEST: main.log_tables-big
--- /Users/openxs/dbs/5.1/mysql-test/r/log_tables-big.result	2009-11-06 21:23:01.000000000 +0300
+++ /Users/openxs/dbs/5.1/mysql-test/r/log_tables-big.reject	2009-11-09 21:47:34.000000000 +0300
@@ -9,21 +9,18 @@
 0
 select if (query_time between '00:00:01' and '00:00:10', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt	sql_text
-OK	select get_lock('bug27638', 2)
 truncate table mysql.slow_log;
 select get_lock('bug27638', 60);
 get_lock('bug27638', 60)
 0
 select if (query_time between '00:00:59' and '00:01:10', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt	sql_text
-OK	select get_lock('bug27638', 60)
 truncate table mysql.slow_log;
 select get_lock('bug27638', 101);
 get_lock('bug27638', 101)
 0
 select if (query_time between '00:01:40' and '00:01:50', 'OK', 'WRONG') as qt, sql_text from mysql.slow_log;
 qt	sql_text
-OK	select get_lock('bug27638', 101)
 select release_lock('bug27638');
 release_lock('bug27638')
 1

mysqltest: Result content mismatch

The same applies to 5.1.41 release

Likely a duplicate of Bug#47924

Fixed in 5.7.4. Changes to test suite. No changelog entry needed.