ID: 41350 Comment by: nick dot dixon at gmail dot com Reported By: graham at directhostinguk dot com Status: Assigned Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.3 Assigned To: scottmac New Comment:
I see the same with 5.2.3 on Windows 2000 whenever php_mysql or php_mysqli (or both) are enabled So either the fault is in both php_mysql.dll AND php_mysqli.dll, or it's a problem with the MySQL client library (libmySQL.dll). Setting mysql.allow_persistent = Off makes no difference. MySQL version is 5.0.45, with the libmySQL.dll copied to a directory that's in the PATH (the PHP ext directory) Minimal test case using PHP cli: php -v PHP 5.2.3 (cli) (built: May 31 2007 09:37:22) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies Now if I run the CLI and send EOF: php ^Z (...pause of about 6 seconds...) Error in my_thread_global_end(): 1 threads didn't exit Previous Comments: ------------------------------------------------------------------------ [2007-07-19 11:16:47] ng dot sick dot no at gmail dot com Tried the latest CVS snaps today (php5.2-win32-200707120030.zip) with php5apache22.dll, MySQL 5.0.45 Server on Windows XP, but Apache 2.2.4's log still shows up: Error in my_thread_global_end(): 1 threads didn't exit ------------------------------------------------------------------------ [2007-07-18 23:27:32] aaronbair at hotmail dot com CLI and FAST-CGI can not handle persistent MySQL connections. How can an unloaded processes remember a connection? Turn that option off in php.ini and the error goes away. mysql.allow_persistent = Off The real problem here is that this option is set On in php.ini-recommended ------------------------------------------------------------------------ [2007-07-13 10:16:00] [EMAIL PROTECTED] So that we won't forget. http://server.macvicar.net/patches/php-bug41350.patch ------------------------------------------------------------------------ [2007-06-28 10:02:15] chris at crgs dot co dot uk Scott is already aware of this, but I tried the snapshot from 12:30 27-06-2007 and it didn't fix the problem. However this might be because the fix from the MySQL bug is necessary as well, and currently the PHP snapshots contain libmysql.dll from PHP 5.0.37 rather than 5.0.45 (which is apparently the one we need). We may need to wait for MySQL to release their new version, and for the new libmysql.dll to make its way across to PHP, before the bug will be 'properly' fixed. ------------------------------------------------------------------------ [2007-06-26 12:00:57] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi I've committed a fix that should have resolved this. ------------------------------------------------------------------------ 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 http://bugs.php.net/41350 -- Edit this bug report at http://bugs.php.net/?id=41350&edit=1
