| From: | Warren Vanichuk <pyber(at)street-light(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Several PostGreSQL questions. |
| Date: | 2000-11-17 18:41:04 |
| Message-ID: | Pine.LNX.4.21.0011171028060.20568-100000@urd.street-light.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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? :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew | 2000-11-17 20:33:08 | RE: [GENERAL] Several PostGreSQL questions. |
| Previous Message | Timothy J Hitchens | 2000-11-17 18:14:13 | What security on database files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2000-11-17 19:07:52 | Re: Requests for Development |
| Previous Message | Schmidt, Peter | 2000-11-17 18:38:37 | Hung backends |