ID: 41350
Comment by: daniel dot gaddis at tlc dot state dot tx dot us
Reported By: graham at directhostinguk dot com
Status: Feedback
Bug Type: MySQL related
Operating System: Windows 2003
PHP Version: 5.2.3
Assigned To: scottmac
New Comment:
php -v returned the error using PHP 5.2.5-dev (cli) (built: Sep 9 2007
12:04:32). See mysql and apache version info below.
F:\php>php -v
PHP 5.2.5-dev (cli) (built: Sep 9 2007 12:04:32)
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
F:\MySQL\bin>mysqladmin --user=xxxx --password=xxxx version
mysqladmin Ver 8.41 Distrib 5.0.45, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL
license
Server version 5.0.45-community-nt-log
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 9 min 57 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1
Open tabl
es: 6 Queries per second avg: 0.007
F:\Program Files\Apache Group\Apache>apache.exe -v
Server version: Apache/1.3.37 (Win32)
Server built: Jul 27 2006 15:23:00
Previous Comments:
------------------------------------------------------------------------
[2007-09-25 17:54:52] daniel dot gaddis at tlc dot state dot tx dot us
php -v returned the error using PHP 5.2.5-dev (cli) (built: Sep 9 2007
12:04:32). See mysql and apache version info below.
F:\php>php -v
PHP 5.2.5-dev (cli) (built: Sep 9 2007 12:04:32)
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
F:\MySQL\bin>mysqladmin --user=xxxx --password=xxxx version
mysqladmin Ver 8.41 Distrib 5.0.45, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL
license
Server version 5.0.45-community-nt-log
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 9 min 57 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1
Open tabl
es: 6 Queries per second avg: 0.007
F:\Program Files\Apache Group\Apache>apache.exe -v
Server version: Apache/1.3.37 (Win32)
Server built: Jul 27 2006 15:23:00
------------------------------------------------------------------------
[2007-09-19 21:27:36] [EMAIL PROTECTED]
ctrl+c causes a SIGINT which isn't handled by PHP so the module
shutdown isn't run and we can't clean up. So that would be expected
behaviour.
libmysql for 6.0 doesn't work yet as far as I know.
Those seeing the error on CGI / FCGI should try a 5.2.5 snapshot as
there was another bug that caused module shutdown now to be executed for
-v and -i.
I need a consistent reproduce case to look further at this. I can't
reproduce this with 5.2.5-dev with MySQL 5.0.45 with MySQL, MySQLi and
pdo_mysql loaded.
Test cases if you please.
------------------------------------------------------------------------
[2007-09-19 19:45:15] phpbug at povaddict dot com dot ar
I forgot to mention:
MySQL Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
I tried renaming the libmysql.dll inside PHP folder and replacing it
with the one from MySQL folder, didn't help. I also read somewhere that
5.0.42 should have the fix; obviously that's not the case.
Also, derick said on another PHP bug that "We don't call
my_thread_init, or anything starting with my_thread." A reply from mysql
bug comments: "my_thread_init() is called indirectly from mysql_init()".
------------------------------------------------------------------------
[2007-09-19 19:36:03] phpbug at povaddict dot com dot ar
I'm running:
PHP 5.2.4 (cli) (built: Aug 30 2007 07:06:31)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with mysqli enabled, on a Windows XP machine.
A simple way to reproduce it is running php -r "sleep(60);" and
pressing Ctrl-C before it quits on its own. It takes over 5 seconds to
actually quit, and then displays "Error in my_thread_global_end(): 1
threads didn't exit". Of course, you need some MySQL library enabled in
php.ini...
------------------------------------------------------------------------
[2007-09-18 18:58:25] chadworsham at hotmail dot com
Error in my_thread_global_end(): 3 threads didn't exit
D:\>ver
Microsoft Windows XP [Version 5.1.2600]
C:\php5>php.exe -v
PHP 5.2.4 (cli) (built: Aug 30 2007 07:06:31)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
Error in my_thread_global_end(): 3 threads didn't exit
mysql> status
--------------
mysql Ver 14.13 Distrib 6.0.2-alpha, for Win32 (ia32)
Does anyone know of a REAL fix?
------------------------------------------------------------------------
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
