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

From Vince Vielhaber
Subject Re: [7.0.2] problems with spinlock under FreeBSD?
Date
Msg-id Pine.BSF.4.21.0008240559550.27442-100000@paprika.michvhf.com
Whole thread Raw
In response to [7.0.2] problems with spinlock under FreeBSD?  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [7.0.2] problems with spinlock under FreeBSD?
List pgsql-hackers
On Wed, 23 Aug 2000, The Hermit Hacker wrote:

> 
> We had a crash this morning of our server ... not the machine, just the
> postmaster processes ... all three of them spread across three seperate
> ports ...
> 
> Just looking through logs now, I'm finding:

[snip]

> 
> looking in /var/log/messages, I'm seeing the following just before the
> crashes:
> 
> Aug 23 12:33:47 pgsql syslogd: /dev/console: Too many open files in system: Too many open files in system
> Aug 23 12:33:47 pgsql syslogd: /var/run/utmp: Too many open files in system
> Aug 23 12:33:47 pgsql /kernel: file: table is full
> 
> would this be the cause?  if so, I have to raise some limits, no problem
> there, but just want to confirm ...

What's maxusers set to in the kernel?  If you want to try raising it on
the fly, try  

# sysctl -w kern.maxfiles=abiggernumberthanitisnow

and set it to a bigger number than it is now.  

# sysctl kern.maxfiles

will tell you what it's currently set to.  Whether or not that has
anything to do with the spinlock problem, no idea.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net128K ISDN from $22.00/mo - 56K Dialup from
$16.00/moat Pop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop
Superstore   http://www.cloudninegifts.com
 
==========================================================================





pgsql-hackers by date:

Previous
From: Jules Bean
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Next
From: Vince Vielhaber
Date:
Subject: Re: Some gripes about BugTool