Edit report at https://bugs.php.net/bug.php?id=55334&edit=1
ID: 55334
Updated by: johannes@php.net
Reported by: bruno at chalopin dot fr
Summary: MySQLi make mod_php crash on stress test
-Status: Feedback
+Status: Assigned
Type: Bug
Package: MySQLi related
Operating System: Windows 2008r2 x64
PHP Version: 5.3.7RC4
-Assigned To:
+Assigned To: mattficken
Block user comment: N
Private report: N
New Comment:
13:58 <@johannes> Pierre: can you check 5.3 in your stress tests regarding 55334? On Linux and
Solaris I can't hit it in threaded context anymore. 5.4/trunk seems to be fixed by
dmitry's property refactoring work (svn r299692)
14:05 <@Pierre> johannes, add a comment to the bug and assign it to matt.
Previous Comments:
------------------------------------------------------------------------
[2012-03-08 12:55:25] johannes@php.net
Seems like this was a bug from very old times in mysqli. I've applied a fix to PHP_5_3 and
couldn't trigger an issue anymore with lots of concurrency over a longer period.
A fix for 5.4 and trunk is not needed as the code had been refactored before. Please run your tests,
too.
------------------------------------------------------------------------
[2012-03-08 12:52:03] johannes@php.net
Automatic comment from SVN on behalf of johannes
Revision: http://svn.php.net/viewvc/?view=revision&revision=324022
Log: Use correct property ctor, should fix threading issue in bug #55334
# The code was refactored in 5_4/trunk, no need to merge
------------------------------------------------------------------------
[2012-01-19 07:40:46] ninzya at inbox dot lv
Got apache crashing due to MySQLi as well. Here's the bug report:
https://bugs.php.net/bug.php?id=55334
------------------------------------------------------------------------
[2011-10-21 14:47:09] doug at sevone dot com
I have been able to reproduce a similar (if not the same) crash by this SIMPLER
script:
<?php
mysqli_init();
?>
On another machine, I have about 12 threads doing GET requests to that page
simultaneously. I usually see a crash after about 1-2 seconds.
As far as I can tell, this is a "mysqli" issue only (involving thread-safety).
If I disable mysqlnd, then I still see the same problem. I see this on MySQL
5.5 and 5.1. However, the MySQL version should NOT matter, since I can
reproduce the problem without EVER connecting to a MySQL box, and since it
crashes using mysqlnd.
OS: gentoo (x86_64)
Apache: www-servers/apache-2.2.14-r1
Apache: www-servers/apache-2.2.21
PHP: dev-lang/php-5.3.6
PHP: dev-lang/php-5.3.8
------------------------------------------------------------------------
[2011-08-02 07:40:05] bruno at chalopin dot fr
More informations :
The test database :
-------------------
CREATE TABLE test (
id int(11) NOT NULL,
data text COLLATE latin1_general_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO test(id,data) VALUES
(1,'foo'),(2,'bar'),(3,'gru');
Software version :
------------------
MySql 5.5.14 x86
Apache 2.2.19 x86 VC9 (from apachelounge)
Both have default conf file.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=55334
--
Edit this bug report at https://bugs.php.net/bug.php?id=55334&edit=1