Bug #38164 Test "query_prealloc_size_basic_64" corrupts 64 bit system if main mem not> 4GB.
Submitted: 16 Jul 2008 9:02 Modified: 28 Jul 2008 15:29
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1.28-debug OS:Linux (64 bit)
Assigned to: Horst Hunger CPU Architecture:Any

[16 Jul 2008 9: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 9: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 15: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 15: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 15: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 20: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 7: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 7: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 7: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 7: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 18:37] Bugs System
Pushed into 5.1.28
[22 Jul 2008 20:09] Paul DuBois
Test case change. No changelog entry needed.

Setting report to Patch queued pending push into 6.0.x
[28 Jul 2008 13:25] Georgi Kodinov
Pushed into 6.0.7-alpha
[28 Jul 2008 14: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 15:29] Paul DuBois
Test case change. No changelog entry needed.
[28 Jul 2008 16: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 4: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)