From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [7.0.2] problems with spinlock under FreeBSD? |
Date: | 2000-08-25 08:59:50 |
Message-ID: | Pine.GSO.3.96.SK.1000825115749.25186Q-100000@ra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hub(dot)org>
> To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: pgsql-hackers(at)postgresql(dot)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(at)hub(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Jules Bean | 2000-08-25 11:19:04 | [jules@jellybean.co.uk: Performance on inserts] |
Previous Message | Chris Bitmead | 2000-08-25 03:58:02 | Re: AW: How Do You Pronounce "PostgreSQL"? |