ID:               41350
 Comment by:       amoo_miki at yahoo 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:

This is caused by windows security:

to be sure:
1) Check if the drive where PHP is installed is an NTFS partition.
2) If yes, "Read & Execute" for "Everyone" for the "ext" folder.

php -v at the command-line should not show you the error anymore.


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

[2008-01-07 12:14:01] jaco at jump dot co dot za

I was able to reproduce this on a very basic instalation:

Apache 2.2.4
PHP 5.2.5
Windows 2003 Server
NO Database installed

<?
$fp = fsockopen("192.168.1.105", 3312);
fclose($fp)
echo "DONE";
exit;
?> 

This executes 100%, and gives no errors, but as soon as I stop apache,
it gives me the message in the apache error log

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

So it seems to me more of a sockets problem than a mysql problem.

When I run the same script in CLI, I get no error.

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

[2008-01-04 21:44:17] jaco at jump dot co dot za

I am having the same and more problems. 

I am running:

Apache 2.2.6
MySQL 5.0.45
PHP 5.2.5
Windows Server 2003 R2 Standard SP2

2 x Quad Core Xeon
4Gb RAM

IIS Installed for SMTP, FTP and WWW on port 443 for a single .NET
Webservice access (NO PHP connectors installed for IIS). But I am sure
this is not IIS related, becuase it still happens even with IIS stopped



Whenever apache tries to recycle threads I get:

** Apache Error Log **

[Fri Jan 04 22:37:38 2008] [notice] Child 324: All worker threads have
exited.
Error in my_thread_global_end(): 1 threads didn't exit
exiting because it reached MaxRequestsPerChild. Signaling the parent to
restart a new child process.
[Fri Jan 04 22:37:42 2008] [notice] Parent: Received restart signal --
Restarting the server.

************************

Note the time difference between the first log and the last log

This then causes my Apache to crash and restart.

Then I tried to download the latest snapshot of PHP, installed it, but
then Apache woould not start at all, just gives me a starting status,
but does not het out of it.

My problem is also that there is hundreds of php files running and our
site is very active, and I have NO idea what is causing this problem.
The PHP error log is clean, but the following also shows up AFTER apache
crashes.

080104 11:24:26 [Warning] Aborted connection 16865 to db: '********'
user: '*****' host: 'localhost' (Got an error reading communication
packets)

But I am sure that this is just caused by apache that have crashed and
the already open calls to the database that was not terminated by the
php script.


These messages apears in the event log after the crash:

Faulting application httpd.exe, version 2.2.6.0, faulting module
libapr-1.dll, version 1.2.11.0, fault address 0x000079a0.

Faulting application httpd.exe, version 2.2.6.0, faulting module
php5ts.dll, version 5.2.5.5, fault address 0x0000acb9.

We are using both mysql and mysqli connectors and I have tried to
download the ones from the mysql site and again apache refused to start.


This is quite serious for us at the moment, becuase its in a live
enviroment and the dev servers never had this problem. 

Hope we can find a solution soon.

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

[2008-01-04 18:28:12] jcmelcher at gmail dot com

This worked for me... IIS 6.0 with PHP 5.2.5 on Win2K3 SP2

If you download the latest PHP - MySQL connector files direct from
MySQL
this problem goes away:-

http://dev.mysql.com/downloads/connector/php/

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

[2008-01-04 14:30:55] benjamin dot azan at gmail dot com

I could not find the new version of mysql connector but I changed the
PHP mode from CGI/fastCGI to  Apache 2.0 Handler and it fixed the
problem.

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

[2008-01-04 11:54:05] benjamin dot azan at gmail dot com

The mySQL bug http://bugs.mysql.com/bug.php?id=25621 says :

" MySQL 5.0.54BK on WinXP localhost does not exhibit the error. "

and the PHP 5.2.5 show Client API version 	5.0.45

So I think the next version of PHP should contain this new version of
the MySQL connector.

I'm gonna try to upgrade the mySQL connector on a 5.2.5 PHP version to
see if it fixs the bug

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

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