Bug #12705: persistent connections don't go away when the database server dies
| From: | patrick at kia dot net | Date: | Sun, 12 Aug 2001 07:03:01 +0000 |
| Subject: | Bug #12705: persistent connections don't go away when the database server dies | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-62969@lists.php.net to get a copy of this message | ||
From: patrick@kia.net
Operating system: FreeBSD 3.4
PHP version: 4.0.5
PHP Bug Type: MySQL related
Bug description: persistent connections don't go away when the database server dies
As in bug #1441. mysql_pconnect().
To replicate:
1. use mysql_pconnect() to open a connection to a mysql database.
2. use the connection to run a query.
3. shut down the database.
4. try to use the connection; notice that it's bad.
5. ask for another connection to the mysql database; notice that it doesn't
work (not surprisingly)
6. restart the mysql database.
7. use mysql_pconnect() to open a connection to a mysql database.
8. notice that the connection does not work, though the database is now
available.
It seems the problem is in the connection pool. Bad connections should be
thrown away so they can be used by good ones.
--
Edit bug report at: http://bugs.php.net/?id=12705&edit=1