Re: Strange error (Socket command option unknown)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlos Moreno <moreno(at)mochima(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange error (Socket command option unknown)
Date: 2003-02-23 16:52:37
Message-ID: 5874.1046019157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carlos Moreno <moreno(at)mochima(dot)com> writes:
> Nothing relevant; there are about a dozen logged messages
> "Socket command type e unknown", and the line before is
> either another identical message, or a failed insert (a
> foreign key referential integrity violation).

You should look very hard at the part of your code that deals with
error reports from the server.

It might be worth logging the whole session between client and
server with tcpdump --- that'd be tedious to wade through, but
it might give some evidence of what's happening. It seems pretty
clear that the client is sending an incomplete message, but knowing
only one character of the broken message isn't much to help you
debug it. With a tcpdump trace you could see the whole packet ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dima Tkach 2003-02-23 17:30:40 Re: 1 to many relationships
Previous Message Tom Lane 2003-02-23 16:39:58 Re: How to update rows from a cursor in PostgreSQL