From: Martijn van Oosterhout <kleptog@svana.org>
To: Geoffrey <esoteric@3times25.net>
Cc: pgsql-general@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: help with error message from perl Pg
Date: Tue, 20 Jun 2006 15:59:45 +0200
Message-ID: <20060620135945.GB25678@svana.org> (raw)
In-Reply-To: <4497F919.7050203@3times25.net>
References: <4497F919.7050203@3times25.net>
On Tue, Jun 20, 2006 at 09:33:13AM -0400, Geoffrey wrote:
> We have an unusual problem with some perl code that is processing data
> via DBD facility. Basically, the code consists of various subroutines
> that are identified in a hash. The primary script then references the
> subroutines through a &$prog(...) syntax. What appears to happen is
> that all subroutines will run just fine if they do not need to do any
> deletes or updates to the database. 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
Errors in the FE-BE protocol are usually caused by users trying to use
the same connection from multiple threads simultaneously. libpq doesn't
handle that and so ends up sending things out of order.
Are you using threads?
Also, the database connection, how is the handle passed around? Youre
not closing it accedently somewhere?
Have a ncie day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/> From each according to his ability. To each according to his ability to litigate.
Attachments:
[application/pgp-signature] signature.asc (188B, ../20060620135945.GB25678@svana.org/2-signature.asc)
download
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: kleptog@svana.org, esoteric@3times25.net, pgsql-general@postgresql.org
Subject: Re: help with error message from perl Pg
In-Reply-To: <20060620135945.GB25678@svana.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