Re: How to simulate crashes of PostgreSQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to simulate crashes of PostgreSQL?
Date: 2009-08-25 18:07:16
Message-ID: 2051.1251223636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vick Khera <vivek(at)khera(dot)org> writes:
> On Tue, Aug 25, 2009 at 1:09 PM, Alvaro
> Herrera<alvherre(at)commandprompt(dot)com> wrote:
>> PG is not supposed to crash when it runs out of file descriptors. In
>> fact there's a whole abstraction layer to ensure this does not happen.

> From my syslog:
> Aug 21 15:11:13 d01 postgres[12037]: [156-1] PANIC: could not open
> file "pg_xlog/00000001000013E300000014" (log file 5091, segment 20):
> Too many open files in system

This is probably coming from walwriter, which might not have very much
of a cushion of "extra" open files to close.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcus Engene 2009-08-25 18:28:44 Re: somewhat slow query with subselect
Previous Message Vick Khera 2009-08-25 18:02:26 Re: How to simulate crashes of PostgreSQL?