#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: No Feedback Bug Type: MySQL related Operating System: * PHP Version: 5.2.6 Assigned To: scottmac New Comment: Libmysql.dll from Mysql 5.0.77 seems to work fine and doesn't have the problems detailed in bug #46842. Libmysql.dll from Mysql 5.1.32 still doesn't work. I don't know why the PHP folks have closed #46842 as Bogus when it quite clearly is not. Previous Comments: [2009-03-03 00:12:17] chaz_meister_rock at yahoo dot com Same error in PHP 5.2.9. [2009-02-20 03:14:23] kram0815 at gmx dot net have this bug too on my system uname -a = 2.6.26-1-amd64 Debian Lenny php -v = PHP 5.2.6-1+lenny2 mysql -V = Ver 14.12 Distrib 5.0.51a msg in /var/log/apache2/error.log = Error in my_thread_global_end(): 41 threads didn't exit [2009-02-12 01:40:30] dbmuller at gmail dot com I had this problem on a Windows 2003 server running PHP 5.2.5 as CGI with hsphere. I would copy the 5.2.1 DLL in and the error would persist. The fix was to delete the old DLL, refresh the page to produce a new error and then copy up the 5.2.1 libmysql.dll. [2009-01-23 16:35:24] onehourlate at hotmail dot com Unfortunately, libmysql.dll 5.1.30 seems crash. see #46842. I don't know if this crash is necesserally php related, but it's still useful to investigate because trying to ship a version of libmysql.dll that finally solves this bug would be a good thing [2008-12-29 18:18:42] chaz_meister_rock at yahoo dot com In case anyone is wondering how to fix this, comments above give a workaround. I'll lay out the steps for the newbies: 1) Download PHP v5.1.6 from http://museum.php.net/php5/php-5.1.6-Win32.zip 2) Extract that zip and replace the libmysql.dll in your production PHP directory (probably c:\php) with the newly downloaded libmysql.dll. This worked successfully on Windows2003 PHP v5.2.8 Threadsafe. Also, for some reason, many other versions of libmysql.dll (either bundled with PHP or released with MySQL server) do not work correctly. Cheers 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=41350edit=1
#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: No Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.6 Assigned To: scottmac New Comment: Sadly, the clueless PHP folks have distributed the still broken 5.0.51a version of LIBMYSQL.DLL with PHP 5.2.8 LIBMYSQL.DLL 5.1.30 had been out for 3 weeks before this. You would have thought they'd have got a grip on this by now. How pathetic. Previous Comments: [2008-11-30 11:07:38] paul at orac dot clara dot co dot uk This seems fixed at long last by copying over the Libmysql.dll file supplied with MySQL 5.1.30 Hopefully that will be in the next PHP release. [2008-11-26 21:27:45] cahlquist at yesco dot com We have the same problem, 5 to 6 second delay. We have commented out every single extension except php_mysql.dll and we get the delay. Then as soon as we comment out php_mysql.dll the problem goes away. PHP 5.2.6 Running on Microsoft Windows Server 2003 R2 IIS 6.0 CGI (NOT Fast CGI) [2008-10-15 07:38:19] supp0rt_24x7 at yahoo dot com Has this been fixed yet ? http://www.eukhost.com/forums/f15/fix-error-my_thread_global_end-1-threads-didnt-exit-5612/ [2008-09-15 09:06:48] chris at crgs dot co dot uk According to the MySQL bug: http://bugs.mysql.com/bug.php?id=37226 the patch for this bug has now been created, and will be released in MySQL 5.0.70. When this happens, it would be great if the PHP people could release a new distribution with the updated libmysql.dll file inside it, so that everyone can benefit from this release without having to copy files around [2008-07-29 14:58:48] marcin dot slowinski at keratronik dot pl I solved problem by copying libMySQL from my MySQL server to PHP dir. Windows XP SP2 Apache 2.2.9 with mod_ssl PHP 5.2.6 (crashed with oryginal libmysql.dll) MySQL 5.0.27-community-nt Regards Marcin 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=41350edit=1
#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: No Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.6 Assigned To: scottmac New Comment: This seems fixed at long last by copying over the Libmysql.dll file supplied with MySQL 5.1.30 Hopefully that will be in the next PHP release. Previous Comments: [2008-11-26 21:27:45] cahlquist at yesco dot com We have the same problem, 5 to 6 second delay. We have commented out every single extension except php_mysql.dll and we get the delay. Then as soon as we comment out php_mysql.dll the problem goes away. PHP 5.2.6 Running on Microsoft Windows Server 2003 R2 IIS 6.0 CGI (NOT Fast CGI) [2008-10-15 07:38:19] supp0rt_24x7 at yahoo dot com Has this been fixed yet ? http://www.eukhost.com/forums/f15/fix-error-my_thread_global_end-1-threads-didnt-exit-5612/ [2008-09-15 09:06:48] chris at crgs dot co dot uk According to the MySQL bug: http://bugs.mysql.com/bug.php?id=37226 the patch for this bug has now been created, and will be released in MySQL 5.0.70. When this happens, it would be great if the PHP people could release a new distribution with the updated libmysql.dll file inside it, so that everyone can benefit from this release without having to copy files around [2008-07-29 14:58:48] marcin dot slowinski at keratronik dot pl I solved problem by copying libMySQL from my MySQL server to PHP dir. Windows XP SP2 Apache 2.2.9 with mod_ssl PHP 5.2.6 (crashed with oryginal libmysql.dll) MySQL 5.0.27-community-nt Regards Marcin [2008-07-20 19:58:29] froggywillneverdie at msn dot com I'm using PHP 5.2.6 on Windows Vista SP1. My scripts take around 5 seconds to exit if php_mysql.dll is enabled in php.ini. 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=41350edit=1
#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.6 Assigned To: scottmac New Comment: Brand new install of Win XP, with IIS (5.1). Installed PHP 5.2.6 (IIS set to use PHP in CGI mode not ISAPI). MySQL is NOT installed on the machine. The only version of libmysql.dll anywhere is the one supplied with php (version 5.00.51a). With either or both of extension=php_mysql.dll or extension=php_mysqli.dll enabled, running php-cgi -v results in the 5 second delay about 25% of the time (5 times out of 20 - very repeatable). The same happens running a browser to a local web page containing just a call to phpinfo(). With both the extension lines commented, the problem does not occur, ever. Running php -v I never see the problem occur, ever, even with the extensions enabled. Replacing libmysql.dll with the one from php 5.2.1 (version 5.00.22) causes the above 5 second delay to disappear in ALL cases. The first version of libmysql.dll that caused the problem was that supplied with php 5.2.2. Surely it can't be too hard to start back with those two versions and work out what changed between them? Previous Comments: [2008-06-09 11:47:13] Computer dot Pers at gmail dot com OK. I've upgraded PHP to latest 5.2.6 Message: Error in my_thread_global_end(): 1 threads didn't exit is disappeared. but delay of 5 seconds is here. I've disabled ALL plugins and there's no any delay. 1. Then i've enabled extension=php_mysql.dll 2. i've created script, which shows curent time before and after php -v commnad and launched it several times here is result: 1. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:16 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:16 2. Delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:18 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:23 3. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:26 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:26 4. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:28 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:28 5. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:29 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:29 6. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:30 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:30 7. Delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:31 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:36 . 1 of 3 or 4 times i see a delay of 5 secs. and this is on a machine Intel Xeon E5335 @2Ghz 4Gb Ram at Idle state MySql for test reason was STOPPED. [2008-06-09 10:55:35] [EMAIL PROTECTED] First you need 5.2.6 and secondly you need to check for old libmysql.dll files lurking around in your path, I can't reproduce this with MySQL 5.0.51. Can you reproduce this when you disable all extensions and just enable MySQL? If you start enabling extensions which one causes the problem? On phpinfo() what version of libmysql does it show? If you don't have PHP 5.2.6 and MySQL 5.0.51 or newer then please upgrade before you consider replying. [2008-06-09 10:12:06] Computer dot Pers at gmail dot com So... Is there's any solution??? C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5php -v PHP 5.2.5 (cli) (built: Nov 8 2007 23:18:51) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies Error in my_thread_global_end(): 1 threads didn't exit [2008-06-09 02:33:33] kneekoo at yahoo dot com As indicated in some of the above messages, I tried some advices
#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.6 Assigned To: scottmac New Comment: At last, someone seems to have a clue: http://bugs.mysql.com/bug.php?id=25621 http://bugs.mysql.com/bug.php?id=37226 Previous Comments: [2008-06-11 21:20:31] paul at orac dot clara dot co dot uk Brand new install of Win XP, with IIS (5.1). Installed PHP 5.2.6 (IIS set to use PHP in CGI mode not ISAPI). MySQL is NOT installed on the machine. The only version of libmysql.dll anywhere is the one supplied with php (version 5.00.51a). With either or both of extension=php_mysql.dll or extension=php_mysqli.dll enabled, running php-cgi -v results in the 5 second delay about 25% of the time (5 times out of 20 - very repeatable). The same happens running a browser to a local web page containing just a call to phpinfo(). With both the extension lines commented, the problem does not occur, ever. Running php -v I never see the problem occur, ever, even with the extensions enabled. Replacing libmysql.dll with the one from php 5.2.1 (version 5.00.22) causes the above 5 second delay to disappear in ALL cases. The first version of libmysql.dll that caused the problem was that supplied with php 5.2.2. Surely it can't be too hard to start back with those two versions and work out what changed between them? [2008-06-09 11:47:13] Computer dot Pers at gmail dot com OK. I've upgraded PHP to latest 5.2.6 Message: Error in my_thread_global_end(): 1 threads didn't exit is disappeared. but delay of 5 seconds is here. I've disabled ALL plugins and there's no any delay. 1. Then i've enabled extension=php_mysql.dll 2. i've created script, which shows curent time before and after php -v commnad and launched it several times here is result: 1. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:16 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:16 2. Delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:18 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:23 3. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:26 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:26 4. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:28 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:28 5. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:29 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:29 6. No delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:30 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:30 7. Delay C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5phpinfo.bat 09.06.2008 14:33:31 PHP 5.2.6 (cli) (built: May 2 2008 18:02:07) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies 09.06.2008 14:33:36 . 1 of 3 or 4 times i see a delay of 5 secs. and this is on a machine Intel Xeon E5335 @2Ghz 4Gb Ram at Idle state MySql for test reason was STOPPED. [2008-06-09 10:55:35] [EMAIL PROTECTED] First you need 5.2.6 and secondly you need to check for old libmysql.dll files lurking around in your path, I can't reproduce this with MySQL 5.0.51. Can you reproduce this when you disable all extensions and just enable MySQL? If you start enabling extensions which one causes the problem? On phpinfo() what version of libmysql does it show? If you don't have PHP 5.2.6 and MySQL 5.0.51 or newer then please upgrade before you consider replying. [2008-06-09 10:12:06] Computer dot Pers at gmail dot com So... Is there's any solution??? C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5php -v PHP 5.2.5 (cli) (built: Nov 8 2007 23:18:51) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend
#41350 [Com]: Error in my_thread_global_end()
ID: 41350 Comment by: paul at orac dot clara dot co dot uk Reported By: graham at directhostinguk dot com Status: Assigned Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.2 Assigned To: georg New Comment: This IS a bug - it is in the libmysql.dll library. If you replace the copy from 5.2.2 with the one from 5.2.1, then the problem goes away. That guy [EMAIL PROTECTED] says that the error message is not in PHP. He might be right about that, but that doesn't mean the PHP isn't the cause of it, which it quite clearly is. Closing bugs without any discussion doesn't help the situation either. Previous Comments: [2007-05-10 12:12:10] graham at directhostinguk dot com Description: This closed PHP bug: http://bugs.php.net/bug.php?id=41316 MySQL Bug: http://bugs.mysql.com/bug.php?id=25621 Error in my_thread_global_end(): 1 threads didn't exit I have the same issue even when the script doesn't call any MySQL, but this error only happens when using fast-cgi If I run php 5.2.2 ISAPI the problem goes away. I think this is a php bug It seems to me that the problem lies in the PHP dll php_mysql.dll as it is opening the threads but not telling MySql to close them. -- Edit this bug report at http://bugs.php.net/?id=41350edit=1