Bug #9816 Updated: FATAL: emalloc(): Unable to allocate

ID: 9816 Updated by: kalowsky Reported By: shazlista@usa.net Status: Open Bug Type: ODBC related PHP Version: 4.0.4pl1 Assigned To: Comments: Another user commented: I just have read the bug-report 9816 at php.net and want to answer your email. Yes, the users are right: I had the same problems with FATAL:emalloc() using the same odbc-queries to get information out of two ms access tables. The first table only contains Customer-ID and pasword, the second contains customer adress and a remark-field (data type memo) Tests: user authentication for login taken from table 1 -> OK hello text for user from table 2 -> FATAL:emalloc() Result of Test enviroment - after some nights of installation :-) : 1) Win2000, MS Access2000, IIS5 and PHP4.0.4 : FATAL:emalloc() 2) Win2000, MS Access2000 SP1, IIS5 and PHP4.0.4 : FATL:emalloc() 3) Win2000, MS Access2000 SP1, Apache 1.3 and PHP 4.0.4 : FATAL:emalloc() 4) Win NT 4, MS Access2000, IIS4 and PHP 4.0.4: OK, no errors 5) Win NT 4, MS Access2000, Apache 1.3 and PHP 4.0.4: OK, no errors The next days I try to debug the source code to find out what the trigger of emalloc() realy is. Our new Webserver should be a Win2000 Server with Apache and PHP. Therefore we need to know where the emalloc() error comes from. If you want know our results of debugging please send me an email to joerg.andreas@matrix-computer.com. Previous Comments: --------------------------------------------------------------------------- [2001-04-16 22:54:23] kalowsky@php.net Can someone with access to Windows2000 please test this out and either confirm or deny this report? User reports this won't happen under Win98SE and that is currently all I have access to... --------------------------------------------------------------------------- [2001-04-03 07:50:46] shazlista@usa.net I am sorry but I have no coments on you ... In all versions from 4.0.2 till 4.0.4pl1. Only in win2000 with srvice pack 1 installed. Only, not in 95,98,me,nt and win2000 with out service pack 1. This script <? $a=odbc_connect("oh","",""); $r=odbc_prepare($a,"SELECT 'a' FROM xx"); odbc_execute($r); odbc_free_result($r); odbc_close($a); ?> where xx is a table whith 1 integer field and 1 row. and oh is odbc system dsn for ms access file with only one table (xx). I get FATAL: emalloc(): Unable to allocate 2147483599 bytes --------------------------------------------------------------------------- [2001-04-01 20:40:00] kalowsky@php.net A) Unable to reproduce locally on Win98SE, and MSAccess with 4.0.5RC4 B) which version of PHP are you using? Bug report says 4.0.4pl1, but your sample script suggests 4.0.2 - 4.0.1pl1... which is it? --------------------------------------------------------------------------- [2001-03-23 03:32:10] shazlista@usa.net win2000 sp1 php4.0.2 - 4.0.4pl1 <? $a=odbc_connect("oh","",""); $r=odbc_prepare($a,"SELECT 'a' FROM xx"); odbc_execute($r); odbc_free_result($r); odbc_close($a); ?> xx is a table whith 1 integer field and 1 row. I try to select constant literal. ("select * from xx" works fine!!!) I get FATAL: emalloc(): Unable to allocate 2147483599 bytes !!! all so 2147483599 bytes --------------------------------------------------------------------------- [2001-03-18 00:00:17] shazlista@usa.net When I query a "Query" from access with only 2087 rows( each row is 210 bytes size), I get this error: FATAL: emalloc(): Unable to allocate 2147483599 bytes please help! --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9816&edit=2