Re: [7.0.2] problems with spinlock under FreeBSD?
От | Oleg Bartunov |
---|---|
Тема | Re: [7.0.2] problems with spinlock under FreeBSD? |
Дата | |
Msg-id | Pine.GSO.3.96.SK.1000825115749.25186Q-100000@ra обсуждение исходный текст |
Ответ на | Re: [7.0.2] problems with spinlock under FreeBSD? (The Hermit Hacker <scrappy@hub.org>) |
Список | 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 по дате отправления: