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
