Bug #38164 Test "query_prealloc_size_basic_64" corrupts 64 bit system if main mem not> 4GB.
Submitted: 16 Jul 2008 11:02 Modified: 28 Jul 2008 17:29
Reporter: Horst Hunger
Status: Closed
Category:Server: Tests Severity:S2 (Serious)
Version:5.1.28-debug OS:Linux (64 bit)
Assigned to: Horst Hunger Target Version:5.1+
Triage: D3 (Medium)

[16 Jul 2008 11:02] Horst Hunger 
Description:
On 64 bit system having not more than 4GB main memory the test program
"query_prealloc_size_basic_64.test" corrupts the operating system, as the test tries to
allocate more than 4GB of main memory. That leads to very long run times of that test or
to system exceptions.

How to repeat:
Don't try.

Suggested fix:
Take out the values > 4GB. Use also smaller values on 64 bit platforms. Larger values may
be used in a separate test running on selected 64 bit machines only, which have more than
4GB RAM.
[16 Jul 2008 11:12] 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/49804

2701 Horst Hunger	2008-07-16
      Fix for bug#38164. Removed test of values larger than max int for 32 bits.
[16 Jul 2008 17:55] 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/49862

2702 Horst Hunger	2008-07-16
      Result of review of fix for bug#38164.
[16 Jul 2008 17:55] 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/49863

2702 Horst Hunger	2008-07-16
      Result of review of fix for bug#38164.
[16 Jul 2008 17:55] 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/49864

2702 Horst Hunger	2008-07-16
      Result of review of fix for bug#38164.
[16 Jul 2008 22:46] 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/49890

2702 Horst Hunger	2008-07-16
      Result of review of fix for bug#38164.
[18 Jul 2008 9: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/49999

2702 Horst Hunger	2008-07-17
      Fix for bug#38164. Removed test of values larger than max int for 32 bits.
[18 Jul 2008 9:01] 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/50001

2702 Horst Hunger	2008-07-17
      Fix for bug#38164. Removed test of values larger than max int for 32 bits.
[18 Jul 2008 9:01] 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/50002

2719 Horst Hunger	2008-07-17
      Fix for bug#38164. Removed test of values larger than max int for 32 bits.
[18 Jul 2008 9:01] 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/50004

2701 Horst Hunger	2008-07-17
      Fix for bug#38164. Removed test of values larger than max int for 32 bits.
[22 Jul 2008 20:37] Bugs System 
Pushed into 5.1.28
[22 Jul 2008 22:09] Paul DuBois 
Test case change. No changelog entry needed.

Setting report to Patch queued pending push into 6.0.x
[28 Jul 2008 15:25] Georgi Kodinov 
Pushed into 6.0.7-alpha
[28 Jul 2008 16:46] Bugs System 
Pushed into 6.0.7-alpha  (revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (version
source revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (pib:3)
[28 Jul 2008 17:29] Paul DuBois 
Test case change. No changelog entry needed.
[28 Jul 2008 18:45] Bugs System 
Pushed into 5.1.28  (revid:davi.arnaut@sun.com-20080722182431-0i2f1yc4uocime9q) (version
source revid:davi.arnaut@sun.com-20080722182431-0i2f1yc4uocime9q) (pib:3)
[14 Sep 2008 6:16] Bugs System 
Pushed into 6.0.7-alpha  (revid:horst@mysql.com-20080717090317-w6lsyz8qxb4bhevo) (version
source revid:hakan@mysql.com-20080721095625-h2pyxb88uwtjeavf) (pib:3)