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-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?
------------------------------------------------------------------------
[2007-09-18 06:13:54] wangyi6854 at sohu dot com
I got the problem on Win2k3, IIS6, php5.2.4
PHP Version 5.2.4
System Windows NT BANDAO-17 5.2 build 3790
Build Date Aug 30 2007 07:05:48
Configure Command cscript /nologo configure.js
"--enable-snapshot-build" "--with-gd=shared"
Server API CGI/FastCGI
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\WINDOWS
Loaded Configuration File F:\PHP5\php.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp
Registered Stream Filters convert.iconv.*, string.rot13,
string.toupper, string.tolower, string.strip_tags, convert.*, consumed,
zlib.*
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli
MysqlI Support enabled
Client API library version 5.0.45
Client API header version 5.0.45
MYSQLI_SOCKET /tmp/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
Error in my_thread_global_end(): 1 threads didn't exit
------------------------------------------------------------------------
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
