From: A.M. <agentm@themactionfaction.com>
To: pgsql-general@postgresql.org
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] help with error message from perl Pg
Date: Tue, 20 Jun 2006 13:10:40 -0400 (EDT)
Message-ID: <35195.216.41.12.254.1150823440.squirrel@webmail.webopticon.org> (raw)
In-Reply-To: <28009.1150814671@sss.pgh.pa.us>
References: <4497F919.7050203@3times25.net>
<28009.1150814671@sss.pgh.pa.us>
On Tue, June 20, 2006 10:44 am, Tom Lane wrote:
> 78 would be ASCII 'N', but that's not really significant AFAICS. The
> problem here is that the frontend and backend have lost sync: the server is
> expecting to find a message beginning at a place in the frontend data
> stream that evidently isn't the start of a message. In short, the
> frontend has sent corrupted data of some sort.
>
> Martijn's theory of inadequately locked threaded access is certainly one
> likely way this can happen, but it's not the only one. It might be useful
> for you to capture the data stream (with something like tcpdump) and try
> to get more information about the nature of the corruption. Frequently, if
> you can identify "ah-hah, THIS data is being inserted into the middle of
> THAT" or whatever, the cause becomes obvious.
>
>
> Also, before you spend too much time on this, make sure your DBI and
> DBD::Pg modules are up-to-date. If it's a bug in that level, it'd be
> foolish to waste much of your own time chasing it.
If you look at his example code, he's not even using DBI- he's using Pg.pm
which is for all practical purposes deprecated and supplanted by DBD::Pg.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: agentm@themactionfaction.com, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] help with error message from perl Pg
In-Reply-To: <35195.216.41.12.254.1150823440.squirrel@webmail.webopticon.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox