Bug #28865 PB: Out of memory on Windows test platform
Submitted: 4 Jun 2007 7:14 Modified: 15 Feb 2010 14:20
Reporter: Lars Thalmann Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Bjørn Munch CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[4 Jun 2007 7:14] Lars Thalmann 
Description:
The pushbuild test framework sometimes can't delete files/have too little
memory and this causes the tests to fail.

rpl_insert_ignore              [ pass ]           4469
Can't remove directory e:/var-n_mix-100/slave-data/mysql: Directory not empty at ./mysql-test-run.pl line 3170
Can't remove directory e:/var-n_mix-100/slave-data: Directory not empty at ./mysql-test-run.pl line 3170
mysql-test-run: WARNING: Process 7680 died
rpl_insert_select              [ fail ]

ERROR: Failed to start slave mysqld 0

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

-------------------------------------------------
From slave.err

C:\cygwin\home\pushbuild\pb1\pb\mysql-5.1\1514\mysql-5.1.20-beta-pb1514\sql\release\mysqld.exe: Can't get stat of '.\mysql\general_log.CSV' (Errcode: 2)
C:\cygwin\home\pushbuild\pb1\pb\mysql-5.1\1514\mysql-5.1.20-beta-pb1514\sql\release\mysqld.exe: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
C:\cygwin\home\pushbuild\pb1\pb\mysql-5.1\1514\mysql-5.1.20-beta-pb1514\sql\release\mysqld.exe: Can't get stat of '.\mysql\slow_log.CSV' (Errcode: 2)
C:\cygwin\home\pushbuild\pb1\pb\mysql-5.1\1514\mysql-5.1.20-beta-pb1514\sql\release\mysqld.exe: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space

How to repeat:
Platform:
'vm-win2003-32-a' Win32 VS2003 -max-nt
Push:
Fri Jun 1 21:21:15 2007 kosipov [C=123] (17514 lines)
Tree:
mysql-5.1

Suggested fix:
'vm-win2003-32-a' Win32 VS2003 -max-nt
[5 Jun 2007 10:40] Daniel Fischer 
PB believes everything mysql-test-run says. It is not reasonable to check for out-of-disk-space conditions during test runs in pushbuild, this is something mysql-test-run should do if at all.

The "can't remove directory" messages look suspicious. They would explain why 1G of RAM disk isn't sufficient for a test run.
[16 Mar 2009 12:50] Daniel Fischer 
Bjørn, assigning to you because if we want any kind of checking for requirements, it has to happen in MTR.
[19 Mar 2009 9:03] Bjørn Munch 
Unclear what MTR needs to do, can't prioritze this now
[15 Feb 2010 14:20] Bjørn Munch 
This is just a special case of the more general Bug #38908 (which I'm unsure how much mtr can do about anyway)