Bug #51909 [Opn->Fbk]: mysqli hangs after small request storms.

[felipe]

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

 ID:               51909
 Updated by:       fel...@php.net
 Reported by:      ixti at member dot fsf dot org
 Summary:          mysqli hangs after small request storms.
-Status:           Open
+Status:           Feedback
 Type:             Bug
 Package:          MySQLi related
 Operating System: Debian GNU/Linux
 PHP Version:      Irrelevant
-Assigned To:      
+Assigned To:      mysql

 New Comment:

Please try using this snapshot:

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

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




Previous Comments:
------------------------------------------------------------------------
[2010-05-25 22:46:51] ixti at member dot fsf dot org

Shortened URL of discussion thread: http://bit.ly/aNDeW4

------------------------------------------------------------------------
[2010-05-25 22:26:17] ixti at member dot fsf dot org

Description:
------------
The problem is that MySQLi completely hangs after a small storm of
requests. I 

have prepared a sample script (attached into bug report) with SQL script
used to 

create and populate table (see http://gist.github.com/413635). I also
used dummy 

http client written in ruby to storm it with requests. After ~ 130
requests 

proceded one after another MySQLi completely hangs out and stops working
until 

Apache2 is restarted. I was tested same storming with pdo_mysql and it
was 

working like a charm (more than 1024 continiously repeated requests).



This bug was found upon discussing strange problem in zend Framework
mailing 

list. Please refer to discussion for more details:
http://zend-framework-

community.634137.n4.nabble.com/Saving-many-Zend-Db-Table-Rows-in-for-loop-

td2220281.html

Test script:
---------------
<?php



$host = 'localhost';

$user = 'user';

$pass = 'pass';

$name = 'test';



header('Content-Type: text/plain');



$mysqli = mysqli_connect($host, $user, $pass, $name);

if ($result = $mysqli->query('SELECT * FROM `my_table`')) {

    while ($obj = $result->fetch_object()) {

        echo $obj->id . ' - ' . $obj->title . PHP_EOL;

    }

    mysqli_free_result($result);

    $result->close();

}



$mysqli->close();



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



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