#48363 [NEW]: PHP is slow to close after generating pages due to outdated MySQL client dll
From: chris at crgs dot co dot uk
Operating system: Windows Server 2003
PHP version: 5.2.9
PHP Bug Type: MySQL related
Bug description: PHP is slow to close after generating pages due to outdated MySQL client dll
Description:
------------
Ever since PHP 5.2.6, php.exe on Win32 can take a long time to close after
generating a page when using the php_mysql.dll extension and the copy of
libmysql.dll supplied with the Win32 distribution of PHP (currently version
5.0.51a).
This can be resolved by updating libmysql.dll to a later version (e.g. the
one supplied with MySQL 5.0.77), or downgrading to a lower version (e.g.
the one supplied with PHP 5.2.1). MySQL 5.0.70+ contains the fix for
http://bugs.mysql.com/bug.php?id=37226, which
seems to be causing this
issue.
This is related to PHP bug #41350 - the error message described in that
bug is no longer displayed in new versions of PHP, but the delay described
by many others is still an issue. A number of people have asked in that bug
for the copy of libmysql.dll supplied with PHP to be updated to 5.0.70+,
but nothing has happened.
Reproduce code:
---------------
<? phpinfo();?>
(Make sure the php_mysql.dll extension is enabled in php.ini)
Run C:\PHP\php.exe C:\test.php
Expected result:
----------------
PHP should close immediately after generating the phpinfo page.
Actual result:
--------------
PHP generates the phpinfo page, but hangs for 5 seconds before closing.
--
Edit bug report at http://bugs.php.net/?id=48363&edit=1
--
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=48363&r=trysnapshot52
Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=48363&r=trysnapshot53
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=48363&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=48363&r=fixedcvs
Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=48363&r=needdocs
Fixed in release: http://bugs.php.net/fix.php?id=48363&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=48363&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=48363&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=48363&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=48363&r=support
Expected behavior: http://bugs.php.net/fix.php?id=48363&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=48363&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=48363&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=48363&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48363&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=48363&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=48363&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=48363&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=48363&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=48363&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=48363&r=mysqlcfg
Thread (4 messages)
- chris at crgs dot co dot uk