#41350 [Com]: Error in my_thread_global_end()

From: Date: Tue, 24 Jul 2007 10:24:19 +0000
Subject: #41350 [Com]: Error in my_thread_global_end()
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-115370@lists.php.net to get a copy of this message 
 ID:               41350
 Comment by:       nick dot dixon at gmail dot com
 Reported By:      graham at directhostinguk dot com
 Status:           Assigned
 Bug Type:         MySQL related
 Operating System: Windows 2003
 PHP Version:      5.2.3
 Assigned To:      scottmac
 New Comment:

I see the same with 5.2.3 on Windows 2000 whenever php_mysql or
php_mysqli (or both) are enabled

So either the fault is in both php_mysql.dll AND php_mysqli.dll, or
it's a problem with the MySQL client library (libmySQL.dll).

Setting mysql.allow_persistent = Off makes no difference.

MySQL version is 5.0.45, with the libmySQL.dll copied to a directory
that's in the PATH (the PHP ext directory)

Minimal test case using PHP cli:
php -v
PHP 5.2.3 (cli) (built: May 31 2007 09:37:22)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

Now if I run the CLI and send EOF:

php
^Z
   (...pause of about 6 seconds...)
Error in my_thread_global_end(): 1 threads didn't exit


Previous Comments:
------------------------------------------------------------------------

[2007-07-19 11:16:47] ng dot sick dot no at gmail dot com

Tried the latest CVS snaps today (php5.2-win32-200707120030.zip) with
php5apache22.dll, MySQL 5.0.45 Server on Windows XP, but Apache 2.2.4's
log still shows up:

Error in my_thread_global_end(): 1 threads didn't exit

------------------------------------------------------------------------

[2007-07-18 23:27:32] aaronbair at hotmail dot com

CLI and FAST-CGI can not handle persistent MySQL connections.  How can
an unloaded processes remember a connection?

Turn that option off in php.ini and the error goes away.

mysql.allow_persistent = Off

The real problem here is that this option is set On in
php.ini-recommended

------------------------------------------------------------------------

[2007-07-13 10:16:00] tony2001@php.net

So that we won't forget.
http://server.macvicar.net/patches/php-bug41350.patch

------------------------------------------------------------------------

[2007-06-28 10:02:15] chris at crgs dot co dot uk

Scott is already aware of this, but I tried the snapshot from 12:30
27-06-2007 and it didn't fix the problem. However this might be because
the fix from the MySQL bug is necessary as well, and currently the PHP
snapshots contain libmysql.dll from PHP 5.0.37 rather than 5.0.45 (which
is apparently the one we need).

We may need to wait for MySQL to release their new version, and for the
new libmysql.dll to make its way across to PHP, before the bug will be
'properly' fixed.

------------------------------------------------------------------------

[2007-06-26 12:00:57] scottmac@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows (zip):
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

For Windows (installer):

  http://snaps.php.net/win32/php5.2-win32-installer-latest.msi

I've committed a fix that should have resolved this.

------------------------------------------------------------------------

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

Thread (157 messages)

« previous php.bugs (#115370) next »