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: darwincabaro at gmail dot com Reported by: ymtene at gmail dot com Summary: Fatal error: Allowed memory size Status: No Feedback Type: Bug Package: ODBC related Operating System: CentOS Linux 7.2.1511 (Core) PHP Version: 7.1.7 Assigned To: cmb Block user comment: N Private report: N New Comment: Hi! i have same problem ODBC 64 BITS PHP 7.3 the error occurs when I use prepare and execute $conn = odbc_connect("Driver={IBM INFORMIX ODBC DRIVER (64-bit)}; Server=SERVERNAME; Database=MYDB;","userdb", "pwdhash"); if (!($conn)) { echo "<p>Connection to DB via ODBC failed: "; echo odbc_errormsg ($conn ); echo "</p>\n"; } $sql = "SELECT FIRST 1 * FROM test"; $rs = odbc_exec($conn,$sql); //problem here odbc_result_all($rs); Previous Comments: ------------------------------------------------------------------------ [2020-12-15 18:22:56] cmb@php.net Jon, please provide a minimal reproduce script, and an ODBC trace. Also note that we do no longer support PHP 7.2, and that even PHP 7.3 won't receive bug fixes anymore. ------------------------------------------------------------------------ [2020-12-15 18:02:54] jon at donnasaxby dot com I am getting this problem with php 7.2 x64 running on Windows 2016 My SQL should return a short string (a UUID), but it crashes after demanding several terabytes of memory. Allowed memory size of 2147483648 bytes exhausted (tried to allocate 2074469204224 bytes) I can test the SQL call directly via an IDE, and it is correct and definitely returns just a UUID. ------------------------------------------------------------------------ [2020-10-18 04:22:14] php-bugs at lists dot php dot net 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. ------------------------------------------------------------------------ [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! ------------------------------------------------------------------------ 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