Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] help with error message from perl Pg

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Geoffrey <esoteric(at)3times25(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] help with error message from perl Pg
Date: 2006-06-20 14:44:31
Message-ID: 28009.1150814671@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Geoffrey <esoteric(at)3times25(dot)net> writes:
> ... Any subroutine that does a delete 
> or update runs fine, but the subsequent routine fails with the following 
> error:

> prgcaphlg: FATAL:  invalid frontend message type 78
> server closed the connection unexpectedly
> 	This probably means the server terminated abnormally
> 	before or while processing the request.

> Searching google for 'invalid frontend message type 78' returns no hits, 
> which is a scary thing.

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.

			regards, tom lane

In response to

Responses

pgsql-interfaces by date

Next:From: Martijn van OosterhoutDate: 2006-06-20 14:51:00
Subject: Re: help with error message from perl Pg
Previous:From: A.M.Date: 2006-06-20 14:43:32
Subject: Re: help with error message from perl Pg

pgsql-general by date

Next:From: Magnus HaganderDate: 2006-06-20 14:46:00
Subject: Re: psql for winxp?
Previous:From: A.M.Date: 2006-06-20 14:43:32
Subject: Re: help with error message from perl Pg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group