Bug #64511 [Opn]: Strange memory allocation error message spamming

Edit report at https://bugs.php.net/bug.php?id=64511&edit=1 ID: 64511 Updated by: ssufficool@php.net Reported by: psiek at mscgva dot ch Summary: Strange memory allocation error message spamming Status: Open Type: Bug -Package: MSSQL related +Package: PDO DBlib Operating System: ubuntu 12.10 PHP Version: 5.4.13 Block user comment: N Private report: N New Comment: $rowset = $query->fetchAll(PDO::FETCH_ASSOC); This will cache the entire recordset in memory. The pdo dblib driver was updated way back to specifcally allow iteration through a very large recordset (e.g. while($row=$query->fetch()) {} ) without memory exhaustion, However by calling fetchAll() there is no optimization that can be done. How many rows with how many bytes each are you fetching from the server? Are there varbinary, text or image fields involved? Those can be quite large. Previous Comments: ------------------------------------------------------------------------ [2014-10-02 02:15:37] michael at alphageek dot com dot au I'm getting the same result in my log files for a wordpress site, but I haven't yet determined what statement is causing it. Here's my PHP info: PHP 5.5.9-1ubuntu4.4 (cli) (built: Sep 4 2014 06:56:34) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies ------------------------------------------------------------------------ [2014-09-09 06:30:01] isulic at hotmail dot com I have same problem :( PHP 5.5.9-1ubuntu4.3 (cli) (built: Jul 7 2014 16:36:58) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies with Xdebug v2.2.3, Copyright (c) 2002-2013, by Derick Rethans ------------------------------------------------------------------------ [2014-05-12 14:09:41] psiek at mscgva dot ch So ad, I'm using 5.4.21. Thanks anyway. ------------------------------------------------------------------------ [2014-05-12 14:01:14] d dot vergini at gameprog dot it PHP Version 5.4.4-14+deb7u9 ------------------------------------------------------------------------ [2014-05-12 13:53:22] psiek at mscgva dot ch Thanks for the report, which version are you using so ? ------------------------------------------------------------------------ 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=64511 -- Edit this bug report at https://bugs.php.net/bug.php?id=64511&edit=1