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

Re: Postmaster crashes

From: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
To: Mike Field <mike(at)fieldco(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postmaster crashes
Date: 2000-07-06 15:57:32
Message-ID: 3964AC6C.7F4E2F7@club-internet.fr (view raw or flat)
Thread:
Lists: pgsql-admin
i figured out in launching strace postmaster :)
and seeing some open failing, causing the master postmaster to crash and
with it all it's sons. It was with a PG 6.5.3, and I haven't seen it happen
again since a added an 
echo 16384 > /proc/sys/fs/file-max
in my rc.local.

Mike Field wrote:
> 
> Thanks for the tips.  A few questions:  how does the lack of filehandles
> relate to the postmaster crashing?  Filehandles to what files?  How did you
> figure it out? (ie.  did you look at logs?  If so, which and how?)
> 
> Thanks in advance for the help.
> 
> Mike
> mike(at)fieldco(dot)com
> 
> ----- Original Message -----
> From: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
> To: Mike Field <mike(at)fieldco(dot)com>
> Cc: <pgsql-admin(at)postgresql(dot)org>
> Sent: Thursday, July 06, 2000 9:49 AM
> Subject: Re: [ADMIN] Postmaster crashes
> 
> > I've had quite the same thing on a busy server, it was due to a lack of
> > filehandles.
> >
> > Mike Field wrote:
> > >
> > >     Hi-
> > >
> > > My php website interacts with a postrgres database, and every now and
> then,
> > > postgres just seems to crash.  A simple restart of postmaster fixes the
> > > problem, until it crashes again.  However, I have no idea EXACTLY when
> it
> > > crashes (what the website users are doing at the time, if anything) and
> WHY.
> > > If someone has any ideas as to why it might be crashing, or how I can
> find
> > > out why, and what to do about it, I would appreciate the help.
> > >
> > > Thanks,
> > >
> > > Mike
> > > mike(at)fieldco(dot)com
> >
> > --
> > Mathieu Arnold
> >
> >

-- 
Mathieu Arnold


In response to

pgsql-admin by date

Next:From: Anthony E. GreeneDate: 2000-07-06 18:13:59
Subject: Re: how do I set DateStyle = European in postmaster ?
Previous:From: Mike FieldDate: 2000-07-06 15:21:15
Subject: Re: Postmaster crashes

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