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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ch+php at 1111-internet dot com
New email:
PHP Version: OS:

 

 [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: Sun Dec 22 01:01:30 2024 UTC