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

Edit report at https://bugs.php.net/bug.php?id=75013&edit=1 ID: 75013 Updated by: php-bugs@lists.php.net Reported by: ymtene at gmail dot com Summary: Fatal error: Allowed memory size -Status: Feedback +Status: No Feedback Type: Bug Package: ODBC related Operating System: CentOS Linux 7.2.1511 (Core) PHP Version: 7.1.7 Assigned To: cmb Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2020-10-05 09:11:26] cmb@php.net 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> ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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