Bug #36875 main.sort_buffer_size_basic_32 fails on some systems
Submitted: 22 May 2008 8:30 Modified: 21 Jan 17:16
Reporter: Konstantin Osipov
Status: Closed
Category:Server: Tests Severity:S1 (Critical)
Version:6.0 OS:Any
Assigned to: Horst Hunger Target Version:6.0
Tags: test
Triage: Triaged: D3 (Medium)

[22 May 2008 8:30] Konstantin Osipov 
Description:
The symptoms are:

main.sort_buffer_size_basic_32 [ fail ]

---
/export/home/pushbuild/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/sort_
buffer_size_basic_32.result	Wed May 21 23:19:02 2008
+++
/export/home/pushbuild/pb/mysql-6.0-runtime/277/mysql-6.0.6-alpha-pb277/mysql-test/r/sort_
buffer_size_basic_32.reject	Thu May 22 02:34:17 2008
@@ -32,14 +32,10 @@
 1
 '#--------------------FN_DYNVARS_151_03-------------------------#'
 SET @@global.sort_buffer_size = 32776;
-Warnings:
-Warning	1292	Truncated incorrect sort_buffer_size value: '32776'
 SELECT @@global.sort_buffer_size= 32776 OR @@global.sort_buffer_size= 32804;
 @@global.sort_buffer_size= 32776 OR @@global.sort_buffer_size= 32804
 1
 SET @@global.sort_buffer_size = 32777;
-Warnings:
-Warning	1292	Truncated incorrect sort_buffer_size value: '32777'
 SELECT @@global.sort_buffer_size= 32777 OR @@global.sort_buffer_size= 32804;
 @@global.sort_buffer_size= 32777 OR @@global.sort_buffer_size= 32804
 1
@@ -54,14 +50,10 @@
 'Bug# 34877: Invalid Values are showing in variable on assigning valid values.';
 '#--------------------FN_DYNVARS_151_04-------------------------#'
 SET @@session.sort_buffer_size = 32776;
-Warnings:
-Warning	1292	Truncated incorrect sort_buffer_size value: '32776'
 SELECT @@session.sort_buffer_size= 32776 OR @@session.sort_buffer_size= 32804;
 @@session.sort_buffer_size= 32776 OR @@session.sort_buffer_size= 32804
 1
 SET @@session.sort_buffer_size = 32777;
-Warnings:
-Warning	1292	Truncated incorrect sort_buffer_size value: '32777'
 SELECT @@session.sort_buffer_size= 32777 OR @@session.sort_buffer_size= 32804;
 @@session.sort_buffer_size= 32777 OR @@session.sort_buffer_size= 32804
 1
@@ -173,10 +165,10 @@
 Warning	1292	Truncated incorrect sort_buffer_size value: '9100'
 SELECT @sort_buffer_size= 32776 OR @@sort_buffer_size= 32804;
 @sort_buffer_size= 32776 OR @@sort_buffer_size= 32804
-1
+NULL
 SELECT @@sort_buffer_size;
 @@sort_buffer_size
-32804
+32776
 SELECT local.sort_buffer_size;
 ERROR 42S02: Unknown table 'local' in field list
 SELECT session.sort_buffer_size;

How to repeat:
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-runtime&entry=kosipov@
bodhi.none-20080521215149&name=test_ps_stm_threadpool&plat=sol10-sparc-a

Repeatable on my own box (intel 32-bit, 2 core, compile-pentium-valgrind-max)

Suggested fix:
The server apparently is performing some platform-specific rounding before
setting this variable. Either we should agree to change the server behavior
or make the test platform-idependent
[1 Dec 2008 9:31] 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/60256

2715 Horst Hunger	2008-12-01
      Fix for Bug#36875: Problem was, that there some warnings has been written containing
values,
      which were determined by the server depending on the os. The solution is to disable
warnings in general.
      The check of the values only have been done for Linux and Windows. Now, the check
has been changed to the check of
      ranges (not more concrete values) being near by the expected (set) values.
[8 Jan 19: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/62735

2733 Horst Hunger	2009-01-08
      Patch for bug#36875: Inserted review results.
[14 Jan 10:33] 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/63197

2748 He Zhenxing	2009-01-14 [merge]
      Auto merge
[15 Jan 7:33] Bugs System 
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source
revid:davi.arnaut@sun.com-20090113150631-y84w12o2zmh7j3qd) (merge vers: 5.1.31) (pib:6)
[16 Jan 4:38] Paul DuBois 
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[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 16:16] Jon Stephens 
Setting status back to NDI pending merge to 6.0 tree.
[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)
[20 Jan 19:52] Bugs System 
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version
source revid:mats@sun.com-20090109123108-m97xwc0c1048bxik) (merge vers: 6.0.10-alpha)
(pib:6)
[21 Jan 17:16] Paul DuBois 
Test case changes. No changelog entry needed.