LWLockAcquire
От | Gaetano Mendola |
---|---|
Тема | LWLockAcquire |
Дата | |
Msg-id | amrugl$3db$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: LWLockAcquire
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | 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
В списке pgsql-admin по дате отправления: