Bug #75013 [Opn->Fbk]: Fatal error: Allowed memory size

Edit report at https://bugs.php.net/bug.php?id=75013&edit=1 ID: 75013 Updated by: cmb@php.net Reported by: ymtene at gmail dot com Summary: Fatal error: Allowed memory size -Status: Open +Status: Feedback Type: Bug Package: ODBC related Operating System: CentOS Linux 7.2.1511 (Core) PHP Version: 7.1.7 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: The relevant test code provided by jeroen at vdmi dot nl work fine for me with the Microsoft Access Driver (Windows). If anybody can still reproduce this with any of the actively supported PHP versions[1], please provide a minimal self-contained reproduce script, and an ODBC trace of running that script. [1] <https://www.php.net/supported-versions.php> Previous Comments: ------------------------------------------------------------------------ [2018-11-27 10:44:45] marcel dot utz at uniklinik-freiburg dot de Dear all, same issue on SLE 12.3, PHP 7.2, Driver: libmdbodbc.so.1, MS Access Database. When odbc_exec($connection, "SELECT id FROM table"), I got an error "Allowed memory size of 2097152 bytes exhausted (tried to allocate 140 Tbytes)". When trying via "isql" in command line with same driver I got data from database. Is there still any solution for this issue? Would be nice to get some response! Thank you and best! ------------------------------------------------------------------------ [2017-11-11 17:00:29] giany at x83 dot org Hi, Any update regarding this issue? Any workaround? ------------------------------------------------------------------------ [2017-08-15 15:22:30] jeroen at vdmi dot nl Relevant test code: <?php $connection = odbc_connect("Driver=MDBTools;DBQ=/var/www/accessdb/Books_be.mdb", '', ''); $result = odbc_exec($connection, "SELECT * FROM Authors"); while (odbc_fetch_row($result)) { for ($i = 1; $i <= odbc_num_fields($result); $i++) { echo "Result is " . odbc_result($result, $i); } } ------------------------------------------------------------------------ [2017-08-15 15:18:10] jeroen at vdmi dot nl This issue also happens to me, but I happen to connect to an MDB (Access) database. PHP version: PHP 7.1.4 (cli) (built: Apr 25 2017 03:23:01) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies with Xdebug v2.5.5, Copyright (c) 2002-2017, by Derick Rethans with Zend OPcache v7.1.4, Copyright (c) 1999-2017, by Zend Technologies Other versions libodbc1: 2.3.1-3 unixodbc: 2.3.1-3 unixodbc-dev: 2.3.1-3 libmdbodbc1: 0.7.1-2 I'm able to reproduce it with the following MDB (both tables in it): http://www.rogersaccesslibrary.com/download3.asp?SampleName=Books.mdb Error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 139968689209376 bytes It might have to do with some field type though. I am able to read some of my tables. I have one table in my MDB with just 2 text columns and that one reads fine. ------------------------------------------------------------------------ [2017-08-02 17:27:02] cmb@php.net > the reaosn why you get it with PHP7 is that the stuff allocating > mekory previously did not use then Zend memory manager and never > was affected by the limits and now that bug is fixed > (tried to allocate 140325171494924 bytes) That would be 140TB! ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=75013 -- Edit this bug report at https://bugs.php.net/bug.php?id=75013&edit=1