Re: Loosing connection with the database - Mailing list pgsql-general

From Tom Lane
Subject Re: Loosing connection with the database
Date
Msg-id 4544.1112461207@sss.pgh.pa.us
Whole thread Raw
In response to Loosing connection with the database  (Poul Møller Hansen <freebsd@pbnet.dk>)
Responses Re: Loosing connection with the database  (Poul Møller Hansen <freebsd@pbnet.dk>)
List pgsql-general
=?UTF-8?B?UG91bCBNw7hsbGVyIEhhbnNlbg==?= <freebsd@pbnet.dk> writes:
> I'm experiencing some strange problems with a Java application which I
> have made.
> Suddently it looses connection with the database, and in the server log
> i can find:

> 2005-04-02 00:09:01 ERROR:  invalid string enlargement request size
> 1358954492
> 2005-04-02 00:09:01 WARNING:  AbortTransaction and not in in-progress
> state
> 2005-04-02 00:09:01 FATAL:  invalid frontend message type 82

This indicates the client code didn't follow the protocol properly,
ie, it sent garbage where a message length word ought to be.

This sort of thing has been seen to occur when multiple client-side
threads try to use the same database connection without proper locking
to ensure only one thread uses it at a time.  See for example
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00104.php

            regards, tom lane

pgsql-general by date:

Previous
From: TJ O'Donnell
Date:
Subject: varbit functions
Next
From: Poul Møller Hansen
Date:
Subject: Re: Loosing connection with the database