From: ch+php at 1111-internet dot com Operating system: freebsd 7.0 PHP version: 5.2.9 PHP Bug Type: Zlib Related Bug description: issue w/ zlib.output_compression + mysql.trace_mode + "result set not freed"
Description: ------------ Seeing some unexpected behavior when getting a mysql "result set not freed" warning while using zlib.output_compression + mysql.trace_mode - the warning is not displayed, and getting some intermittent reload behavior in IE6 if the page also has a large amount of content Reproduce code: --------------- <?php // php.ini or other valid ini locations: // zlib.output_compression on // mysql.trace_mode on // nothing wrong with this - just sets up the scenario mysql_connect("valid_host", "valid_username", "valid_password"); mysql_select_db("valid_db"); // large amount of content - enables intermittent IE6 reload behavior for ($x=1; $x<=250000; $x++) {echo htmlentities(chr(rand(32, 126)));} // trigger "result set not freed" warning // assume valid_table has at least two records $query=mysql_query("select valid_field from valid_table limit 2"); list($value)=mysql_fetch_row($query); ?> Expected result: ---------------- 250000 random ASCII characters followed by: Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0 Actual result: -------------- Firefox: 250000 random ASCII characters, no warning IE6: same, plus intermittent reload behavior -- Edit bug report at http://bugs.php.net/?id=47670&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47670&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47670&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47670&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47670&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47670&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47670&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47670&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47670&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47670&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47670&r=support Expected behavior: http://bugs.php.net/fix.php?id=47670&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47670&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47670&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47670&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47670&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=47670&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47670&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47670&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47670&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47670&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47670&r=mysqlcfg