|Think about Loose Coupling|
apache2 mod_perl DBD/DBI postgres connection problemsby otter117 (Initiate)
|on Oct 12, 2011 at 01:07 UTC||Need Help??|
otter117 has asked for the
wisdom of the Perl Monks concerning the following question:
We are running Apache/2.2.10 (Linux/SUSE) mod_ssl/2.2.10 OpenSSL/0.9.8h mod_perl/2.0.4 Perl/v5.10.0 wirh DBD::Pg 2.18.1 and Apache::DBI 1.11 on SLES11 SP1.
Postgres 8.3.14 listens on TCP port 5432 and named socket /tmp/.s.PGSQL.5432
I see intermittent messages in my web server error log which occur under light or heavy load.
-e: DBD::Pg::st execute failed: could not receive data from server: Socket operation on non-socket at ...(my module)...
It is as if the httpd2-prefork processes are trying to use connections that have "gone stale".
Restarting apache2 will stop the messages but they sometimes come back within minutes, most times it will be hours before the problem recurs. Anyone, seen this?