Postgresql connection failures

From: Date: Thu, 20 Jul 2000 03:47:42 +0000
Subject: Postgresql connection failures
Groups: php.db 
Request: Send a blank email to php-db+get-1311@lists.php.net to get a copy of this message
We're having an unusually odd problem with our PHP to PostgreSQL 7.0.2 server from only 1 server. Other servers work without any problems. Issue: connections to the db server using pg_pconnect() abnormally terminate. After about 3 minutes (w/the same browser), a new connection will establish and work for a very short period of time. Seems to have something to do with new browser output, as we have created a test script that processes over 200 re-connects in a burst. Each time this script is run, all output either succeeds or fails on each refresh. pg_connect() seems to either not fail at all, or only occasionally. Starting a new browser (and effectively a new connection), the connections will work from 1 to 20 or so times successfully and then fail - even though the original browser continues to fail. It has been noted that when this connect fails, there is no further network traffic to the db server. All other servers with identical configuration (as far as we can tell) have no problems with this. Log results below: PostgreSQL log data: 000719.19:21:03.443 [7891] CommitTransactionCommand pq_recvbuf: unexpected EOF on client connection 000719.19:21:03.445 [7891] proc_exit(0) 000719.19:21:03.445 [7891] shmem_exit(0) 000719.19:21:03.445 [7891] exit(0) PHP Error log: [19-Jul-2000 04:19:38] PHP Warning: PostgreSQL query failed: pqReadData() -- read() failed: errno=9 Bad file descriptor in search_results.html on line 14 [19-Jul-2000 04:19:38] PHP Warning: Supplied argument is not a valid PostgreSQL result resource in search_results.html on line 15 [19-Jul-2000 04:19:38] PHP Warning: Supplied argument is not a valid PostgreSQL result resource in search_results.html on line 31 PHP pg_errormessage(): pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request -----&&&---- pqReadData() -- read() failed: errno=32 Broken pipe -----&&&---- PQsendQuery() -- There is no connection to the backend PHP_ERRORMessage(): Apache error log has no report. Please CC me at dbryant@adpak.com

« previous php.db (#1311) next »