ID: 41350
Comment by: jp at chicagowebexperts dot com
Reported By: graham at directhostinguk dot com
Status: No Feedback
Bug Type: MySQL related
Operating System: Windows 2003
PHP Version: 5.2.3
New Comment:
Windows XP, PHP 5.2.5, same issue: "Error in my_thread_global_end(): 1
threads didn't exit" Typically "1" thread, but sometimes 3. Running as
a CGI. Problem manifests even if no calls to any MySQL function are
made. Problem disappears if "extension=php_mysql.dll" is commented
out.
Noticed that the behavior becomes less frequent (or disappears
entirely) the more that your page outputs. Have a "controller.php" file
doing only back-end processing, no client output; bug appears 100% of
the time. Noticed that my index.php file never failed (about 60 lines
of HTML outputted), so for the heck of it, put in <? exit; ?> at the
very top. Problem occurs 100% of the time. Problem never occurs in a
PHP file consisting only of <? phpinfo(); ?> (short tags enabled in
php.ini).
Created a small test.php file consisting only of HTML (open and close
HTML tags, and 512 bytes of data). Problem occurs ~20-30% of the time.
Interestingly enough, I noticed that if I refresh the test.php page
quickly enough, I get back an HTTP 403.9: "The page cannot be displayed.
There are too many people accessing the Web site at this time." I've
never received that error before under any other condition. In
actuality, when this occurs, the number of times I'd refreshed the page
is really pretty low (five or six), and the refreshes aren't done all
that fast, relatively speaking.
Previous Comments:
------------------------------------------------------------------------
[2007-12-03 06:55:19] bjohnso1 at usc dot edu dot au
Don't know if anyone else can relate to this, but I had PHP (5.2.4)
working with Apache 2.2.4 with no problems. It was a little while ago
now so I'm not absolutely certain of the event sequence, but I'm
reasonably sure I installed mySQL 5.0.45 at the same time and saw it
come up in the <?php phpinfo(); ?> test script page I created. I've
since started working with mySQL AND installed mySQL Administrator (or
the whole tools collection) and now have the error referred to in this
bug.
So, I'm reasonably certain that this bug only affected me after
installing the Administrator/Query Browser/etc toolset.
Uninstalling the toolset (GUI tools) did not remedy the problem.
Hope this helps.
Ben Johnson.
------------------------------------------------------------------------
[2007-11-27 21:53:55] michael at chunkycow dot com dot au
Does anyone know if switching to the new ND driver will fix this?
------------------------------------------------------------------------
[2007-11-23 12:43:02] andrewm at rochester dot rr dot com
I tried every suggestion on this page to fix this problem (Error in
my_thread_global_end(): 1 threads didn't exit) and nothing helped me. It
was php_imap.dll that was ther culprit for me. I commented that out in
php.ini and everything works great now. Now hopefully I won't need imap
before this is fixed.
------------------------------------------------------------------------
[2007-11-20 16:40:49] dkeller at uh dot edu
I'm using php 5.2.5 through cgi on iis6 and windows 2003 server.
I still get the my_thread_global_end() error. Turning of mysql
persistent connections in php.ini had no effect.
Rolled back to libmysql.dll 5.0.22, but that obviously is not the
answer. Any ideas what should be done for this? My superiors are
starting to get a little antsy about this situation, and "php says it's
mysql's fault and vice versa" isn't helping.
I'll give any information that can help.
Thanks for all the work.
------------------------------------------------------------------------
[2007-11-14 18:38:35] jamesvl at trinitylight dot com
I'm experiencing this on PHP 5.2.5-nts on Windows 2003. Web server
doesn't matter since I see the bug just by running "php -m" on the
command line.
Enabling either php_mysql.dll or php_mysqli.dll in php.ini causes the
bug to appear. Sometimes it takes several runs for "php -m" before I get
the delay and then the "Error in my_thread_global_end(): 1 threads
didn't exit" message.
Can't use the "fix" to downgrade to an earlier version of libmysql.dll
unless a non-threadsafe compile is available somewhere...
------------------------------------------------------------------------
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
