Bug #77495 [Fbk->NoF]: STMT execute memory leak
| From: | php-bugs at lists dot php dot net | Date: | Sun, 27 Dec 2020 04:22:10 +0000 |
| Subject: | Bug #77495 [Fbk->NoF]: STMT execute memory leak | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-231262@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=77495&edit=1
ID: 77495
Updated by: php-bugs@lists.php.net
Reported by: istvan at dupai dot hu
Summary: STMT execute memory leak
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: MySQLi related
Operating System: Windows
PHP Version: 7.3.1
Private report: N
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2020-12-18 09:42:55] nikic@php.net
I can't reproduce this. I think early 7.3 versions did have issues with result set leaks, so I
suspect this has already been fixed in the meantime. Do you still see this issue?
------------------------------------------------------------------------
[2020-01-07 11:05:31] thomas dot kosel at aspera dot com
I can reproduce this on 7.3.6 in a docker environment
The issue did not apply, when the prepare and bind parts are in the loop too.
------------------------------------------------------------------------
[2019-01-21 00:47:19] istvan at dupai dot hu
Description:
------------
MySQLi prepared statement execution in a loop increases memory consumption rapidly constantly.
Test script:
---------------
$now = microtime(true);
$db = new \Mysqli("localhost", "root", "password",
"database", 3306);
$stmt = $db->prepare("SELECT * FROM someTable WHERE id=?");
$stmt->bind_param("i", $id);
for( $id=1; $id<1000; $id++ ) {
$stmt->execute();
$result = $stmt->get_result();
$stmt->free_result();
}
echo "Time taken: ".(microtime(true)-$now)." seconds\n";
echo "Peak memory usage: ".number_format(memory_get_peak_usage())." bytes\n";
Expected result:
----------------
Memory usage should peak and stay around 400 KBs.
Actual result:
--------------
Memory usage constantly grows.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=77495&edit=1