Bug #36876 main.key_buffer_size_basic_32 fails on some systems
Submitted: 22 May 2008 6:37 Modified: 4 Feb 2009 18:29
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1,6.0 OS:Any
Assigned to: Horst Hunger CPU Architecture:Any

[22 May 2008 6:37] Konstantin Osipov 
Description:
The symptoms are:

main.key_buffer_size_basic_32  [ fail ]

--- /export/home/pushbuild/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/key_buffer_size_basic_32.result	Wed May 21 23:18:55 2008
+++ /export/home/pushbuild/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/key_buffer_size_basic_32.reject	Thu May 22 02:19:59 2008
@@ -9,7 +9,7 @@
 'Bug# 34878: This variable has default value according to documentation';
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 '#---------------------FN_DYNVARS_055_02-------------------------#'
 SET @@global.key_buffer_size = @start_value;
 SELECT @@global.key_buffer_size = @start_value;
@@ -19,13 +19,13 @@
 SET @@global.key_buffer_size = @min_key_buffer_size;
 SELECT @@global.key_buffer_size= @min_key_buffer_size;
 @@global.key_buffer_size= @min_key_buffer_size
-1
+0
 SET @@global.key_buffer_size = 1800;
 Warnings:
 Warning	1292	Truncated incorrect key_buffer_size value: '1800'
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 SET @@global.key_buffer_size = 65535;
 SELECT @@global.key_buffer_size;
 @@global.key_buffer_size
@@ -42,24 +42,24 @@
 Warning	1292	Truncated incorrect key_buffer_size value: '4'
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 'Bug # 34837: Errors are not coming on assigning invalid values to variable';
 SET @@global.key_buffer_size = ON;
 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 SET @@global.key_buffer_size = 'test';
 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 '#-------------------FN_DYNVARS_055_05----------------------------#'
 SET @@session.key_buffer_size = 0;
 ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable and should be set with SET GLOBAL
 SELECT @@key_buffer_size = @min_key_buffer_size;
 @@key_buffer_size = @min_key_buffer_size
-1
+0
 '#----------------------FN_DYNVARS_055_06------------------------#'
 SELECT @@global.key_buffer_size = VARIABLE_VALUE 
 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
@@ -77,13 +77,13 @@
 Warning	1292	Truncated incorrect key_buffer_size value: '1'
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 SET @@global.key_buffer_size = FALSE;
 Warnings:
 Warning	1438	Cannot drop default keycache
 SELECT @@global.key_buffer_size = @min_key_buffer_size;
 @@global.key_buffer_size = @min_key_buffer_size
-1
+0
 '#---------------------FN_DYNVARS_055_08----------------------#'
 SET @@global.key_buffer_size = @min_key_buffer_size;
 SELECT @@key_buffer_size = @@global.key_buffer_size;
@@ -94,7 +94,7 @@
 ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable and should be set with SET GLOBAL
 SELECT @@key_buffer_size = @min_key_buffer_size;
 @@key_buffer_size = @min_key_buffer_size
-1
+0
 SET local.key_buffer_size = 10;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key_buffer_size = 10' at line 1
 SELECT local.key_buffer_size;

How to repeat:
The failure is repeatable, the test constantly fails on my own box (intel 32 bit, 2 cores, compile-pentium-valgrind-max)

Suggested fix:
The platform-dependent behavior needs investigation.
Maybe a server bug.
[2 Dec 2008 10:05] 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/60358

2716 Horst Hunger	2008-12-02
      Fix for Bug#36876: 
      The minimum value differs depending on the OS and mysqld build, so that the test fail spradically.
      The check of this value has been changed from check of concrete values to the check of a range that is near by the expected value.
[15 Jan 2009 6:33] Bugs System 
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:azundris@mysql.com-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)
[19 Jan 2009 11:21] Bugs System 
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 12:59] Bugs System 
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:05] Bugs System 
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[19 Jan 2009 16:07] 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/63567

2748 Horst Hunger	2009-01-19
      Modified fix for bug#36876 due to reviews: See bug report.
[19 Jan 2009 19:36] 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/63574

2748 Horst Hunger	2009-01-19
      Modified fix for bug#36876 due to reviews: See bug report.
[19 Jan 2009 20:38] 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/63575

2968 Horst Hunger	2009-01-19 [merge]
      Fix for bug#36876 for mysql 6.0 including post fix merge.
[20 Jan 2009 18:53] Bugs System 
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)
[26 Jan 2009 15:36] 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/64038

2750 Horst Hunger	2009-01-26
      Modified fix for bug#36876 due to reviews: See bug report.
[26 Jan 2009 15:57] 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/64042

2980 Horst Hunger	2009-01-26 [merge]
      Fix for bug#36876 for mysql 6.0 including post fix merge
[3 Feb 2009 9:39] Bugs System 
Pushed into 5.1.32 (revid:joro@sun.com-20090203090549-gos3v4320vimrzg6) (version source revid:chad@mysql.com-20090126170653-cxruoryaasjkh73o) (merge vers: 5.1.32) (pib:6)
[4 Feb 2009 11:14] Bugs System 
Pushed into 6.0.10-alpha (revid:kostja@sun.com-20090204104420-mw1i2u9lum4bxjo6) (version source revid:joro@sun.com-20090128151745-pfmwvldqshy3ia5y) (merge vers: 6.0.10-alpha) (pib:6)
[4 Feb 2009 18:29] Paul DuBois 
Test suite changes. No changelog entry needed.
[17 Feb 2009 14:52] 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:40] 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:16] 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-20090202111723-1zzwax187rtls913) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)