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

Re: [PORTS] Re: [HACKERS] backend closed the channel unexpectedly

From: David Wetzel <dave(at)turbocat(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-ports(at)postgreSQL(dot)org, gerald(at)lucky(dot)turbocat(dot)de
Subject: Re: [PORTS] Re: [HACKERS] backend closed the channel unexpectedly
Date: 1999-05-12 23:41:29
Message-ID: 199905122341.BAA00340@cat.turbocat.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-ports
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Sender: owner-pgsql-ports(at)postgreSQL(dot)org
>
> David Wetzel <dave(at)turbocat(dot)de> writes:
> > I have found a bug that is very easy to reprouduce here:
>
> > [ backend crash after many attempts to insert same data into a
> > uniquely-indexed table ]
>
> This may be the same bug that was discussed earlier today on the hackers

I cc'ed the mail to pgsql-hackers(at)postgreSQL(dot)org, pgsql-ports(at)postgreSQL(dot)org  
But I only subscribe to pgsql-ports(at)postgreSQL(dot)org(dot)

(...)
> I'm hoping to look into the cause of the memory leak shortly, but
> no guarantees about how soon it might be fixed ;-).
>
> 			regards, tom lane

Great. What we did as bugfix in our importer program is to close and reopen  
the connection to the backend each 1000 rows. This is very ugly but seems to  
work until someone with the backend-knowlege has fixed the bug.

First we thought that we made a mistake in our EOAdaptor*) for PSQL and  
debugged that beast for many hours...

Dave

*) For EOF and WebObjects from Apple/NeXT see www.turbocat.de
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave(at)turbocat(dot)de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION

In response to

pgsql-ports by date

Next:From: Unprivileged userDate: 1999-05-13 07:49:40
Subject: Port Bug Report: undocumented error
Previous:From: Tom LaneDate: 1999-05-12 23:15:24
Subject: Re: [HACKERS] backend closed the channel unexpectedly

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-05-13 00:33:36
Subject: Re: [HACKERS] backend dies suddenly after a lot of error messages
Previous:From: Tom LaneDate: 1999-05-12 23:15:24
Subject: Re: [HACKERS] backend closed the channel unexpectedly

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