From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | LWLockAcquire |
Date: | 2002-09-25 09:01:33 |
Message-ID: | amrugl$3db$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
this morning I seen on my test linux box ( Postgres 7.2.2) the followin
lines in the logs:
Sep 24 13:49:59 pserver postgres[24943]: [1214174] DEBUG: BackendStartup:
forked pid=11625 socket=9
Sep 24 13:49:59 pserver postgres[11625]: [1214174] DEBUG: InitPostgres
Sep 24 13:49:59 pserver postgres[11625]: [1214175] FATAL 1: Database
"template0" is not currently accepting connections
Sep 24 13:49:59 pserver postgres[11625]: [1214176] DEBUG: proc_exit(0)
Sep 24 13:49:59 pserver postgres[11625]: [1214177] DEBUG: shmem_exit(0)
Sep 24 13:49:59 pserver postgres[11625]: [1214178] FATAL 1: LWLockAcquire:
can't wait without a PROC structure
Sep 24 13:49:59 pserver postgres[11625]: [1214179] DEBUG: proc_exit(1)
Sep 24 13:49:59 pserver postgres[11625]: [1214180] DEBUG: shmem_exit(1)
Sep 24 13:49:59 pserver postgres[11625]: [1214181] DEBUG: exit(1)
Sep 24 13:49:59 pserver postgres[24943]: [1214175] DEBUG: reaping dead
processes
Sep 24 13:49:59 pserver postgres[24943]: [1214176] DEBUG: child process
(pid 11625) exited with exit code 1
Sep 24 13:49:59 pserver postgres[24943]: [1214177] DEBUG: server process
(pid 11625) exited with exit code 1
Sep 24 13:49:59 pserver postgres[24943]: [1214178] DEBUG: terminating any
other active server processes
Sep 24 13:49:59 pserver postgres[24943]: [1214179] DEBUG: CleanupProc:
sending SIGQUIT to process 11623
Sep 24 13:49:59 pserver postgres[24943]: [1214180] DEBUG: CleanupProc:
sending SIGQUIT to process 11609
Sep 24 13:49:59 pserver postgres[11623]: [1214193-1] NOTICE: Message from
PostgreSQL backend:
Sep 24 13:49:59 pserver postgres[24943]: [1214181] DEBUG: CleanupProc:
sending SIGQUIT to process 11595
Sep 24 13:49:59 pserver postgres[11609]: [1214157-1] NOTICE: Message from
PostgreSQL backend:
Sep 24 13:49:59 pserver postgres[11623]: [1214193-2] ^IThe Postmaster has
informed me that some other backend
Sep 24 13:49:59 pserver postgres[24943]: [1214182] DEBUG: CleanupProc:
sending SIGQUIT to process 11589
Sep 24 13:49:59 pserver postgres[11595]: [1214226-1] NOTICE: Message from
PostgreSQL backend:
Sep 24 13:49:59 pserver postgres[11609]: [1214157-2] ^IThe Postmaster has
informed me that some other backend
Sep 24 13:49:59 pserver postgres[11623]: [1214193-3] ^Idied abnormally and
possibly corrupted shared memory.
Sep 24 13:49:59 pserver postgres[24943]: [1214183] DEBUG: CleanupProc:
sending SIGQUIT to process 11584
The machine have 512MB of RAM and
I used for Postgres 128MB of shared memory
shared_buffers=15200
and
max_connections=64
anyone have any idea ?
Ciao
Gaetano
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2002-09-25 12:52:05 | Re: logging queries |
Previous Message | Laurette Cisneros | 2002-09-25 00:33:17 | dump a table in windows |