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: | |
| 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
[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.