From: | Joel Richard <postgresql(at)joelrichard(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Socket command type I unknown |
Date: | 2006-02-04 06:06:03 |
Message-ID: | D16B527E-B1E1-454D-81A2-B64AFEF24113@joelrichard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good evening,
I hope that I am posting this to the right place. If not, please
direct me to the appropriate mailing list and I will send to that one
instead.
Background Info:
Debian Linux (Sarge)
Server A -- Apache 2.0.54 + mod_perl + DBD::Pg
Server B -- PostgreSQL 7.3.4, Compiled, not debian package
(yes, I know we should upgrade)
Although I haven't been able to pay much attention to it until
recently, we occasionally get the following message in our apache log
file. I'm looking for information on what it means:
DBD::Pg::db selectrow_array failed: FATAL: Socket command type I
unknown
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
DBD::Pg::db selectrow_array failed: no connection to the server
After this, we get a series of errors like this:
DBD::Pg::db selectrow_array failed: no connection to the server
DBD::Pg::db selectrow_array failed: no connection to the server
DBD::Pg::db selectrow_array failed: no connection to the server
And I -know- that's causing trouble on my web server. :) A restart of
the web server 'corrects' the problem by reestablishing the
connections to the database. I suspect this might be caused by a
mismatch between the client libraries on Server A (7.4.X) whereas
Server B is a 7.3.X install. (I'm working on correcting this ASAP,
which will also get us on 7.4.)
Basically my question is this: What does this error indicate? I can't
seem to find much about it on the net and to be honest, I have become
rather illiterate in C over the past several years, so reading the
source is not really a viable option.
Any info would be appreciated. Thank you for your time.
--Joel
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-02-04 06:16:55 | Re: Socket command type I unknown |
Previous Message | Tyler MacDonald | 2006-02-04 03:32:25 | Should I use PL/PGSQL or Perl/PGSQL? |