#2955 [Opn->]: Persistant Connection Gone Bad

ID: 2955 Updated by: sniper@php.net Reported By: dgarrett at acm dot org -Status: Open +Status: Wont Fix Bug Type: PostgreSQL related Operating System: RedHat Linux 5.2, and 6.0 PHP Version: 3.0.9 New Comment: We are sorry, but we can not support PHP 3 related problems anymore. Momentum is gathering for PHP 5, and we think supporting PHP 3 will lead to a waste of resources which we want to put into getting PHP 5 ready. Of course PHP 4 will continue to be supported for the forseeable future. Previous Comments: ------------------------------------------------------------------------ [1999-12-10 20:17:54] dgarrett at acm dot org On at least two servers which are running PHP 3.0.9 and 4.0 Beta 3 (respectively), persistant database connections don't notice if the connection has been dropped. This means that if you start the DB server, and then start the web server, when the connection is established, everything is fine and dandy. If something happens to the connection (for example, postgres is stopped and restarted) the web server keeps trying to use the connection. It displays errors saying that the connection is dead, but keeps trying to reuse it anyway on repeated loads of the page, anyway. 3 solutions present themselves to me. Test the connection before giving it to the script. Seems best, but would involve extra overhead. Automatically close and restart connections after certain types of errors. At least after the scripts complete. This would allow errors to appear, but not continue to repeat indefinatly. Reduce the value of 'MaxRequestsPerChild' in Apache, so the connections are not reused for as lengthy a period. This avoids PHP changes, but reduces high load efficiency. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=2955&edit=1