Re: [7.0.2] problems with spinlock under FreeBSD? - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [7.0.2] problems with spinlock under FreeBSD?
Date
Msg-id Pine.GSO.3.96.SK.1000825115749.25186Q-100000@ra
Whole thread Raw
In response to Re: [7.0.2] problems with spinlock under FreeBSD?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: AW: How Do You Pronounce "PostgreSQL"?
Next
From: "Finn Kettner"
Date:
Subject: RE: libpq.dll and VB