FIX :: Error in my_thread_global_end 1 threads didn't exit

**Rock** · 23-08-2008, 15:09

Error in my_thread_global_end 1 threads didn't exit

This error is actually a bug in the latter PHP/MySQL release, which is generated when the MySQL's InnoDB database storage engine's connection handlers while exiting properly did not decrement the server's thread count. It can be fixed easily by changing/switching the PHP Server API from CGI/FastCGI to ISAPI.

Or if you want to use CGI/FastCGI PHP Server API, you can do the following to get this sorted out permanently :

1) Go to the directory where PHP is installed.. [C:\PHP on Plain & X:\Parallels\Plesk\Additional\PleskPHP5 on Plesk control panel servers]
2) Rename libmysql.dll to libmysql.bad
3) Download the PHP 5.2.1 binary from here & extract it to a folder.
4) Copy the libmysql.dll from this folder to the PHP installation directory ( check point 1 & 2 ).
5) Finally restart the web server to reflect the changes..

You'd be all good now

**lisvane** · 15-11-2008, 10:48

Originally Posted by Rock

Error in my_thread_global_end 1 threads didn't exit

This error is actually a bug in the latter PHP/MySQL release, which is generated when the MySQL's InnoDB database storage engine's connection handlers while exiting properly did not decrement the server's thread count. It can be fixed easily by changing/switching the PHP Server API from CGI/FastCGI to ISAPI.

Or if you want to use CGI/FastCGI PHP Server API, you can do the following to get this sorted out permanently :
You'd be all good now

Rock

I see the date on this is 2006. Is this reply still valid. I am getting the error described and want to avoid chasing other possible faults!

Thanks

**Rock** · 16-11-2008, 01:58

Originally Posted by lisvane

Rock

I see the date on this is 2006. Is this reply still valid. I am getting the error described and want to avoid chasing other possible faults!

Thanks

I think you misread my joining date [Dec 2006] with the post date [23-08-2008]

Yes, this reply is valid & this mysterious bug in PHP/MySQL remains unsolved. If you provide me your domain name here or in the ticket, I can get the issue sorted out quickly..

**lisvane** · 16-11-2008, 04:38

Originally Posted by Rock

I think you misread my joining date [Dec 2006] with the post date [23-08-2008]

Yes, this reply is valid & this mysterious bug in PHP/MySQL remains unsolved. If you provide me your domain name here or in the ticket, I can get the issue sorted out quickly..

Ah yes - that's the date that is most visible!

My domain name is [domain removed]

Appreciate if you can sort that out as I am trying to work through a proxy that doesn't even allow me to access CPanel - IT man paranoid about security!

Thanks again.

**eUKhost.com** · 16-11-2008, 16:58

Thanks Jack

You have helped MySQL debugging team to close the 2 year old bug located at :-

bugs.mysql.com/bug.php?id=25621

**Jack** · 16-11-2008, 18:34

Well Done Jack. You are simply Great

Its good to see that our forum is referred by big websites

**eUKhost.com** · 16-11-2008, 20:48

His another achievement is his article on BSOD ( Blue Screen of death ) which has been appreciated on Wikipedia, Microsoft support, ASP.NET forum as well as IIS forum.

http://www.eukhost.com/forums/f15/tr...h-errors-5608/

His articles on types of RAID and their features is much better than any other article on RAID which you can find on web.

**Rock** · 17-11-2008, 04:22

Originally Posted by lisvane

Ah yes - that's the date that is most visible!

My domain name is [domain removed]

Appreciate if you can sort that out as I am trying to work through a proxy that doesn't even allow me to access CPanel - IT man paranoid about security!
Thanks again.

The necessary changes have been done on the server your account is hosted on. You shouldn't face the error/problem henceforth.. please verify to confirm..

Originally Posted by eUKhost.com

Thanks Jack

You have helped MySQL debugging team to close the 2 year old bug located at :-
bugs.mysql.com/bug.php?id=25621

His another achievement is his article on BSOD ( Blue Screen of death ) which has been appreciated on Wikipedia, Microsoft support, ASP.NET forum as well as IIS forum.

http://www.eukhost.com/forums/f15/tr...h-errors-5608/

His articles on types of RAID and their features is much better than any other article on RAID which you can find on web.

Originally Posted by Jack

Well Done Jack. You are simply Great

Its good to see that our forum is referred by big websites

Thank you very much for appreciating my work.. it helps me continue with even more vigor...

**lisvane** · 17-11-2008, 11:04

Jack

All now working well. Many Thanks

**webdirectory** · 06-01-2009, 14:52

Thanks a-lot.

I had this problem with Joomla 1.5 than done as you described and it is working great!!! I also checked other php applications all work fine.

Great job!!!

Aris @ My Blog

**Rock** · 07-01-2009, 00:35

Originally Posted by webdirectory

Thanks a-lot.

I had this problem with Joomla 1.5 than done as you described and it is working great!!! I also checked other php applications all work fine.

Great job!!!

Aris @ My Blog

Hello Aris !

to the forums ! We're glad that your problem is sorted.. Good luck..

**steveste** · 10-02-2009, 22:28

When I try to replace the .dll with 5.2.1 all I see is a blank screen. When I move it back, I get the error. Is there something I need to do to restart the PHP server?

**Rock** · 10-02-2009, 23:42

Originally Posted by steveste

When I try to replace the .dll with 5.2.1 all I see is a blank screen. When I move it back, I get the error. Is there something I need to do to restart the PHP server?

There's nothing such as PHP server, you need to restart the IIS Web Server after the DLL changes...
Also, try testing the PHPinfo(); in your website.. if that helps

**eUK-Martin** · 11-02-2009, 05:13

If all this does not help you can just run PHP as ISAPI rather.. If you have Plesk Control panel then this can be done from the Setup options but if you are using a plain server then you will have to go to IIS >> site properties >> Home Directory Tab >> Configuration >> Mapping >> Edit PHP extension and change the path to php5isapi.dll

This should sort that out.