#47670 [Opn->Fbk]: issue w/ zlib.output_compression + mysql.trace_mode + "result set not freed"

From: Date: Thu, 07 May 2009 13:26:55 +0000
Subject: #47670 [Opn->Fbk]: issue w/ zlib.output_compression + mysql.trace_mode + "result set not freed"
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-136937@lists.php.net to get a copy of this message 
 ID:               47670
 Updated by:       jani@php.net
 Reported By:      ch+php at 1111-internet dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         Zlib Related
 Operating System: freebsd 7.0
 PHP Version:      5.2.9
 New Comment:

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.


Previous Comments:
------------------------------------------------------------------------

[2009-03-16 07:35:55] 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



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=47670&edit=1

Thread (2 messages)

« previous php.bugs (#136937) next »