Bug #64511 [Opn->Csd]: 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 +Status: Closed Type: Bug Package: PDO DBlib Operating System: ubuntu 12.10 PHP Version: 5.4.13 Block user comment: N Private report: N New Comment: Automatic comment on behalf of ssufficool Revision: http://git.php.net/?p=php-src.git;a=commit;h=83144a72817775f793407d23f2701e9cdabb36cc Log: Fixed bug #64511 - pdo_dblib segfaults or leaks on nextRowset() Previous Comments: ------------------------------------------------------------------------ [2014-10-21 04:03:46] ssufficool@php.net $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. ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ 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