RE: [GENERAL] Several PostGreSQL questions.

From: Matthew <matt(at)ctlno(dot)com>
To: "'Warren Vanichuk'" <pyber(at)street-light(dot)com>, pgsql-general(at)postgresql(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: RE: [GENERAL] Several PostGreSQL questions.
Date: 2000-11-17 20:33:08
Message-ID: 183FA749499ED311B6550000F87E206C0C9465@srv.ctlno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

If you do a:

/usr/sbin/lsof |wc

What is the output? First number from wc is the number of lines, which in
this case translates to the number of open file descriptors. If this is
close to your limit, then bump your limit.

> -----Original Message-----
> From: Warren Vanichuk [SMTP:pyber(at)street-light(dot)com]
> Sent: Friday, November 17, 2000 12:41 PM
> To: pgsql-general(at)postgresql(dot)org
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: [GENERAL] Several PostGreSQL questions.
>
>
> Greetings.
>
> We've recently been seeing several database crashes. The last things seen
> in the logs are :
>
> postmaster: StreamConnection: accept: Too many open files in system
> postmaster: StreamConnection: accept: Too many open files in system
> FATAL 1: ReleaseLruFile: No open files available to be closed
> IpcSemaphoreLock: semop failed (Identifier removed) id=512
> IpcSemaphoreLock: semop failed (Identifier removed) id=513
> (repeated about 20-30 times)
> IpcSemaphoreUnlock: semop failed (Invalid argument) id=515
>
> FATAL: s_lock(40014065) at spin.c:127, stuck spinlock. Aborting.
>
> FATAL: s_lock(40014065) at spin.c:127, stuck spinlock. Aborting.
>
> FATAL: s_lock(40014065) at spin.c:127, stuck spinlock. Aborting.
> (repeated about 100 times)
>
> This is PostgreSQL v7.0.2 under a Debian 2.2 system with a custom 2.2.17
> kernel installed. I have the maximum per-process file descriptor limit
> set
> to 1024, and the maximum system file descriptor limit set to 8192, so I'm
> confused about the first messages.
>
> I'm also seeing :
>
> Sorry, too many clients already
> Sorry, too many clients already
> Sorry, too many clients already
>
> notices, but I thought I increased the number of allowed conncetions.
> What's the correct way to go about doing this? :)

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan (Mailing Lists) 2000-11-17 22:33:46 Date arithmatic question
Previous Message Warren Vanichuk 2000-11-17 18:41:04 Several PostGreSQL questions.

Browse pgsql-general by date

  From Date Subject
Next Message Reverend Trance Overlord 2000-11-17 21:14:39 "COPY table FROM file" status
Previous Message Alexander Jerusalem 2000-11-17 19:53:03 Re: I know installation questions are boring ...