Bug #39369 execution of "variables.test" with "check-testcases" show differences.
Submitted: 10 Sep 2008 10:39 Modified: 4 Feb 2009 18:28
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:Ver 5.1.30-debug, 6.0 bzr OS:Linux
Assigned to: Patrick Crews CPU Architecture:Any

[10 Sep 2008 10:39] Horst Hunger
Description:
When I run the test "variables.test" in the mysql-5.1-rpl team tree I got the following result though I set both system variables back to their initial values which have not had the desired effect:

hhunger@hh-nb:/work/bzr/mysql-5.1-rpl-2/mysql-test> ./mtr variables
Logging: ./mtr  variables
MySQL Version 5.1.30
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /work/bzr/mysql-5.1-rpl-2/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/work/bzr/mysql-5.1-rpl-2/mysql-test/var'...
Installing system database...
Using parallel: 1
Using server port 4094
worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509

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

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

main.variables                           [ pass ]  19761

The check of testcase 'main.variables' failed, this is the
diff between before and after:
--- /work/bzr/mysql-5.1-rpl-2/mysql-test/var/tmp/check-mysqld_1.result  2008-09-10 13:37:23.000000000 +0300
+++ /work/bzr/mysql-5.1-rpl-2/mysql-test/var/tmp/check-mysqld_1.reject  2008-09-10 13:37:43.000000000 +0300
@@ -133,14 +133,14 @@
 MAX_USER_CONNECTIONS   0
 NDB_INDEX_STAT_CACHE_ENTRIES   0
 OLD_PASSWORDS  OFF
-MAX_BINLOG_CACHE_SIZE  4294967295
+MAX_BINLOG_CACHE_SIZE  4294963200
 QUERY_PREALLOC_SIZE    8192
 SLAVE_NET_TIMEOUT      120
 READ_RND_BUFFER_SIZE   262144
 SLAVE_TRANSACTION_RETRIES      10
 SQL_LOG_BIN    ON
 LOCAL_INFILE   ON
-MYISAM_MAX_SORT_FILE_SIZE      2147483647
+MYISAM_MAX_SORT_FILE_SIZE      2146435072
 GENERAL_LOG    ON
 QUERY_CACHE_WLOCK_INVALIDATE   OFF
 TABLE_TYPE     MyISAM

mysqltest: Result content mismatch

------------------------------------------------------------
The servers were restarted 0 times
Spent 19.761 of 22 seconds executing testcases

Check of testcase failed for: main.variables

All 1 tests were successful.

In the rpl team tree the new mtr run with check-testcases is switched on by default. 

How to repeat:
execute the test in the rpl team tree with the new mtr

Suggested fix:
Should be fixed in the new mtr or in SET statement of that system variable to see the expected value.
[10 Sep 2008 12:01] Sveta Smirnova
Thank you for the report.

Verified as described using main trees and option --check-testcases
[12 Sep 2008 1:39] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53907

2695 He Zhenxing	2008-09-12 [merge]
      Auto merge
[12 Sep 2008 1:44] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53908

2695 He Zhenxing	2008-09-12 [merge]
      Auto merge
[23 Sep 2008 11:13] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54481

2694 He Zhenxing	2008-09-22 [merge]
      Auto Merge
[23 Jan 2009 0:33] Patrick Crews
This is *not* a test bug, though the test will need cleaning up once the issue is fixed.

My observations:
myisam_max_sort_file_size is not initialized to the proper default value (per the manual)
initial values:
myisam_max_sort_file_size:  2147483647, should be 21474833648

myisam_max_sort_file_size and max_binlog_cache_size have the wrong default values:
myisam_max_sort_file_size: 2146435072 should be 21474833648
max_binlog_cache_size:  4294963200 should be 4294967295

You can set myisam_max_sort_file_size to the proper default value, but you *cannot* set max_binlog_cache to 4294967295, it will truncate to 4294963200

Might there be a disconnect between global_system_variables and max_system_variables?
[23 Jan 2009 0:59] Patrick Crews
See the following bugs:
Bug #31177	Server variables can't be set to their current values
Bug #42287	max_binlog_cache_size has differing initial, DEFAULT, and max values (likely a duplicate that has been fixed by Bug#31177 that hasn't made it to rpl trees)
Bug #42286	myisam_max_sort_file_size has incorrect initial and DEFAULT values (similar to Bug#31177, but manual and server disagree on default / initial value...at least on Mac OS X)

However, running the test on -bugteam, produces the following --check failure:
-max_allowed_packet	1048576
+max_allowed_packet	1024

Will correct this, then leave the other symptoms to be corrected by the bugs referenced above.
[23 Jan 2009 1:37] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63859

2750 Patrick Crews	2009-01-22
      Bug#39369:  execution of variables.test with "check-testcases" show differences.
      
      The original symptoms of this bug can be attributed to other bugs (see this bug report).
      I did find that max_allowed_packet_size wasn't being reset properly and corrected that.
      
      Other symptoms will be corrected with the other bug fixes.
[30 Jan 2009 13:28] Bugs System
Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)
[30 Jan 2009 15:08] Bugs System
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:hezx@mysql.com-20080929053642-b2mfvfhzisrzj274) (merge vers: 5.1.30) (pib:6)
[2 Feb 2009 22:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64949

2776 Patrick Crews	2009-02-02
      Bug#39369: execution of "variables.test" with "check-testcases" show differences
      
      The initial symptoms of this bug have been taken care of by other bug reports and the test
      now passes without incident.
      
      This patch replaces error numbers with the error name and does some minor format changes.
[2 Feb 2009 22:30] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64950

2736 Patrick Crews	2009-02-02
      Bug#39369: execution of "variables.test" with "check-testcases" show differences.
      
      The original symptoms of this bug have been fixed as a consequence of other bug fixes.
      Taking this time to correct some formatting, such as replacing error numbers with names.
      Beginning this with 5.0
[3 Feb 2009 9:12] Bugs System
Pushed into 5.0.78 (revid:joro@sun.com-20090203090422-v91rh3gmx2ulhbu9) (version source revid:patrick.crews@sun.com-20090202223002-xgm2hwq823892a2e) (merge vers: 5.0.78) (pib:6)
[3 Feb 2009 9:39] Bugs System
Pushed into 5.1.32 (revid:joro@sun.com-20090203090549-gos3v4320vimrzg6) (version source revid:patrick.crews@sun.com-20090202225645-y4pf5xsmfq2xc2nh) (merge vers: 5.1.32) (pib:6)
[4 Feb 2009 11:15] Bugs System
Pushed into 6.0.10-alpha (revid:kostja@sun.com-20090204104420-mw1i2u9lum4bxjo6) (version source revid:patrick.crews@sun.com-20090202232817-4f27ugyb2qcnr9hw) (merge vers: 6.0.10-alpha) (pib:6)
[4 Feb 2009 18:28] Paul DuBois
Test suite changes. No changelog entry needed.
[17 Feb 2009 14:55] Bugs System
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 16:43] Bugs System
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 18:19] Bugs System
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090203064601-uyuzm4mielj3fz76) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)