php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #48363 PHP is slow to close after generating pages due to outdated MySQL client dll
Submitted: 2009-05-22 14:17 UTC Modified: 2009-05-22 15:27 UTC
From: chris at crgs dot co dot uk Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 5.2.9 OS: Windows Server 2003
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: chris at crgs dot co dot uk
New email:
PHP Version: OS:

 

 [2009-05-22 14:17 UTC] chris at crgs dot co dot uk 
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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-05-22 15:06 UTC] pajoye@php.net 
Complain to mysql instead. They change the compiler minimum versions and the latest 5.0.x are not compatible anymore with VC6 (which is what we use for PHP 5.2). They also break the binary compatibility.
 [2009-05-22 15:11 UTC] chris at crgs dot co dot uk 
In that case why not downgrade to the last version of MySQL that doesn't have this bug (5.0.22, supplied with PHP 5.2.1), so that everyone trying to set up PHP inside Windows doesn't have to jump through this extra hoop of copying DLLs around just to get the thing to work properly without hanging or error messages?
 [2009-05-22 15:27 UTC] pajoye@php.net 
5.3.0 does not use libmysql anymore.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun May 05 03:01:29 2024 UTC