X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 368C1D1B1BC for ; Sat, 19 Jun 2004 18:05:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41866-07 for ; Sat, 19 Jun 2004 21:05:12 +0000 (GMT) Received: from server8.software-ag.de (server8.software-ag.de [193.26.193.23]) by svr1.postgresql.org (Postfix) with ESMTP id E4424D1B174 for ; Sat, 19 Jun 2004 18:05:08 -0300 (ADT) Received: from localhost.localdomain by server8.software-ag.de; (8.11.6/8.9.3) id i5JL4Rc01155; Sat, 19 Jun 2004 23:04:31 +0200 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i5JL63xM004349; Sat, 19 Jun 2004 23:06:24 +0200 Received: (from jwi@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i5JL5BtC004346; Sat, 19 Jun 2004 23:05:11 +0200 X-Authentication-Warning: localhost.localdomain: jwi set sender to jochen.wiedmann@freenet.de using -f Subject: Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of From: Jochen Wiedmann To: Tom Lane Cc: "David F. Skoll" , pgsql-admin@postgresql.org, support@roaringpenguin.com, netmaster@euwid.de In-Reply-To: <20710.1087572132@sss.pgh.pa.us> References: <1087416970.2555.4.camel@localhost.localdomain> <20710.1087572132@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1087679111.4321.1.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Sat, 19 Jun 2004 23:05:11 +0200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/244 X-Sequence-Number: 13904 Tom, David, thanks for the hints. Following you, I have upgraded to 7.3.4 (the last version for which an RPM by Red Hat is provided) and the problem seems gone now. Regards, Jochen On Fr, 2004-06-18 at 17:22, Tom Lane wrote: > "David F. Skoll" writes: > > Hi, Jochen. > >> However, we frequently observe the following message in the log files: > >> PGRES\_FATAL_ERROR : ERROR: out of free buffers: time to abort! > >> Any hints what's going on? Suggestion? > > IIRC, there was a problem in 7.3 - 7.3.2 that tended to provoke this > failure. It's repaired in 7.3.3 and later. If you want to stay in > the 7.3 series rather than upgrade to 7.4, I would *strongly* recommend > moving to 7.3.6.