Bug #36876 main.key_buffer_size_basic_32 fails on some systems
Submitted: 22 May 2008 8:37 Modified: 4 Feb 19:29
Reporter: Konstantin Osipov
Status: Closed
Category:Server: Tests Severity:S1 (Critical)
Version:5.1,6.0 OS:Any
Assigned to: Horst Hunger Target Version:5.1+
Triage: Triaged: D3 (Medium) / R2 (Low) / E2 (Low)

[22 May 2008 8: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 11: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 7: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 12: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 13: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 17: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 17: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 20: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 21: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 19: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 16: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 16: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 10: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 12: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 19:29] Paul DuBois 
Test suite changes. No changelog entry needed.
[17 Feb 15: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 17: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 19: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)