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
==========================================================================
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 |