pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers:
3+ messages / 2 participants
[nested] [flat]

* Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers:
@ 2004-06-16 20:16  David F. Skoll <dfs@roaringpenguin.com>
  0 siblings, 1 reply; 3+ messages in thread

From: David F. Skoll @ 2004-06-16 20:16 UTC (permalink / raw)
  To: Jochen Wiedmann <jochen.wiedmann@freenet.de>; +Cc: pgsql-admin; support@roaringpenguin.com; netmaster@euwid.de

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?

Two things might help:

1) Upgrade to the latest CanIt (2.1a), because earlier versions seemed
to trigger this bug in PostgreSQL.

2) Upgrade to the latest version of PostgreSQL (7.4.3 as of this writing.)
If you upgrade from PostgreSQL earlier than 7.4, be aware that you must
dump all your databases with the old version *before* starting the upgrade.

Regards,

David.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers:
@ 2004-06-18 15:22  Tom Lane <tgl@sss.pgh.pa.us>
  parent: David F. Skoll <dfs@roaringpenguin.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2004-06-18 15:22 UTC (permalink / raw)
  To: David F. Skoll <dfs@roaringpenguin.com>; +Cc: Jochen Wiedmann <jochen.wiedmann@freenet.de>; pgsql-admin; support@roaringpenguin.com; netmaster@euwid.de

"David F. Skoll" <dfs@roaringpenguin.com> 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.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers:
@ 2004-06-19 21:43  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-06-19 21:43 UTC (permalink / raw)
  To: Jochen Wiedmann <jochen.wiedmann@freenet.de>; +Cc: David F. Skoll <dfs@roaringpenguin.com>; pgsql-admin; support@roaringpenguin.com; netmaster@euwid.de

Jochen Wiedmann <jochen.wiedmann@freenet.de> writes:
> 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.

?? I thought I'd pushed out a 7.3.6 RPM for RHEL3.  Where exactly are
you finding 7.3.4 as still the latest?

There are several nasty problems in 7.3.4, so I don't want to see you
settling for that ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-06-19 21:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-16 20:16 Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers: David F. Skoll <dfs@roaringpenguin.com>
2004-06-18 15:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-19 21:43   ` Tom Lane <tgl@sss.pgh.pa.us>

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