php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #47670 issue w/ zlib.output_compression + mysql.trace_mode + "result set not freed"
Submitted: 2009-03-16 07:35 UTC Modified: 2009-05-15 01:00 UTC
From: ch+php at 1111-internet dot com Assigned:
Status: No Feedback Package: Zlib related
PHP Version: 5.2.9 OS: freebsd 7.0
Private report: No CVE-ID: None
 [2009-03-16 07:35 UTC] ch+php at 1111-internet dot com
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


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-05-07 13:26 UTC] jani@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/

And please provide a proper reproduce script without any mysql stuff.
 [2009-05-15 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 02 10:01:30 2024 UTC