Bug #75013 [Com]: Fatal error: Allowed memory size

Edit report at https://bugs.php.net/bug.php?id=75013&edit=1 ID: 75013 Comment by: marcel dot utz at uniklinik-freiburg dot de Reported by: ymtene at gmail dot com Summary: Fatal error: Allowed memory size Status: Open Type: Bug Package: ODBC related Operating System: CentOS Linux 7.2.1511 (Core) PHP Version: 7.1.7 Block user comment: N Private report: N New Comment: 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! Previous Comments: ------------------------------------------------------------------------ [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! ------------------------------------------------------------------------ [2017-07-31 22:35:43] spam2 at rhsoft dot net when you get that error your value of -1 is not accepted php_admin_flag/php_admin_value in any config can't be changed with ini_set() by intention and when you edit php.ini you pretty sure overlook some vhost specific config 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 ------------------------------------------------------------------------ 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