Edit report at https://bugs.php.net/bug.php?id=69381&edit=1
ID: 69381
Updated by: ab@php.net
Reported by: JLH at Dataplan dot co dot uk
Summary: out of memory with sage odbc driver (ok in 5.6.5)
Status: Feedback
Type: Bug
Package: ODBC related
Operating System: Windows 2012r2 nts
PHP Version: 5.6.7
Block user comment: N
Private report: N
New Comment:
@JLH, you've already shown the error messages and confirmed the bug is still present, no need
to just see that again.
What I'm asking for is to be able to debug and recompile PHP using your driver and data, and
then make a fix and a unit test. So it were probably easier the other way round - if you could
please supply the test db and the driver. Maybe they have some trial of the driver?
Thanks.
Previous Comments:
------------------------------------------------------------------------
[2015-04-14 17:15:06] JLH at Dataplan dot co dot uk
Other than the code above, it requires sage accounts be installed on the machine (or its odbc driver
at least) which is not free software.
I could provide you access to a test virtual machine for you to see the problem on with a demo data
set in sage if that is ok?
------------------------------------------------------------------------
[2015-04-14 06:30:21] ab@php.net
Ok, in this case, please provide the exact instructions how to reproduce this.
Thanks.
------------------------------------------------------------------------
[2015-04-13 09:51:44] JLH at Dataplan dot co dot uk
I tried using php from php-master-nts-windows-vc11-x86-rf265928.zip as requested and still have an
error
VirtualAlloc() failed: [0x00000008] Not enough storage is available to process t
his command.
PHP Fatal error: Out of memory (allocated 2097152) (tried to allocate 195376781
3 bytes) in C:\inetpub\wwwroot\sage.php on line 3
------------------------------------------------------------------------
[2015-04-06 15:25:23] ab@php.net
Could you please check with the latest snapshots as in bug #69354? Looks very similar to it.
Thanks.
------------------------------------------------------------------------
[2015-04-05 20:13:43] JLH at Dataplan dot co dot uk
Description:
------------
On upgrading from php 5.6.5 nts (server 2012r2 64bit) to 5.6.7, our odbc_exec is no longer working.
we are using the sage line 50 odbc driver to extract data from the accounts software we use.
I suspect this is related to bug id 68964
Test script:
---------------
c:\inetpub\php\php.exe c:\inetpub\wwwroot\sage.php
sage.php contains:
<?php
$odbcconn=odbc_connect("SageLine50v20","user","pass");
$query=odbc_exec($odbcconn,"SELECT ACCOUNT_REF, NAME FROM sales_ledger");
?>
Expected result:
----------------
in the 5.6.5 version, the code will display no errors
Actual result:
--------------
in the 5.6.7 version we get:
PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 1956365745
bytes) in C:\inetpub\wwwroot\sage.php on line 3
So i changed the memory limit from 512M to 3G to see what would happen:
PHP Fatal error: Out of memory (allocated 262144) (tried to allocate 1956365745
bytes) in C:\inetpub\wwwroot\sage.php on line 3
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=69381&edit=1