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

[9 Nov 2009 18:33] Aleksandr Kuzminsky
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
[9 Nov 2009 18:52] Valeriy Kravchuk
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
[12 Dec 2009 19:55] Aleksandr Kuzminsky
The same applies to 5.1.41 release
[13 Oct 2010 11:39] Davi Arnaut
Likely a duplicate of Bug#47924
[2 Dec 2013 17:00] Paul DuBois
Fixed in 5.7.4. Changes to test suite. No changelog entry needed.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.