On Thu, 24 Aug 2000, The Hermit Hacker wrote:
> Date: Thu, 24 Aug 2000 16:26:07 -0300 (ADT)
> From: The Hermit Hacker <scrappy@hub.org>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [7.0.2] problems with spinlock under FreeBSD?
>
>
> okay, I just doubled my FDs to 8192 from 4136 and will watch things
> ... anyone know of a way of telling how many are currently in use, and
> where they peaked? somethign similar to 'netstat -m' showing mbufs?
I have on rather busy site running FreeBSD
12:57:38[info]:/home/megera$ sysctl kern.maxfiles
kern.maxfiles: 16424
Did you try systat -vm ?
Regards,
Oleg
>
> thanks tom ...
>
> On Thu, 24 Aug 2000, Tom Lane wrote:
>
> > The Hermit Hacker <scrappy@hub.org> writes:
> > > you still have your account on that machine if you want to take a quick
> > > look around ... else, anything else I should be looking at?
> >
> > I poked around and couldn't learn much of anything --- the logfiles from
> > yesterday are already gone, apparently. I did find some interesting
> > entries in today's logfiles:
> >
> > %grep Lru *
> > 5432.61820:FATAL 1: ReleaseLruFile: No open files available to be closed
> > postmaster.5437.36290:FATAL 1: ReleaseLruFile: No open files available to be closed
> > postmaster.5437.62218:FATAL 1: ReleaseLruFile: No open files available to be closed
> >
> > What we see here are backends choking because there are no free kernel
> > file descriptor slots, even after they've closed *all* of their own
> > discretionary FDs. So you've definitely got a serious problem with
> > insufficient FD slots. Time to tweak those kernel parameters.
> >
> > I still don't see a linkage between too few FDs and the stuck-spinlock
> > crashes, but maybe there is one.
> >
> > regards, tom lane
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83