Edit report at https://bugs.php.net/bug.php?id=55334&edit=1
ID: 55334 Updated by: johan...@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] johan...@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] johan...@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
