Re: [7.0.2] problems with spinlock under FreeBSD?

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [7.0.2] problems with spinlock under FreeBSD?
Date: 2000-08-24 10:04:23
Message-ID: Pine.BSF.4.21.0008240559550.27442-100000@paprika.michvhf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)michvhf(dot)com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jules Bean 2000-08-24 10:04:25 Performance on inserts
Previous Message Jules Bean 2000-08-24 09:11:14 Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan