From: | Scott Felt <scott(dot)felt(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | DB terminating |
Date: | 2009-11-18 17:23:43 |
Message-ID: | 26411033.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello. I have been having an issue with a database. The logs consistently
show this:
2009-11-17 16:03:55 ESTLOG: 00000: server process (PID 9644) exited with
exit code 128
2009-11-17 16:03:55 ESTLOCATION: LogChildExit,
.\src\backend\postmaster\postmaster.c:2705
2009-11-17 16:03:55 ESTLOG: 00000: terminating any other active server
processes
2009-11-17 16:03:55 ESTLOCATION: HandleChildCrash,
.\src\backend\postmaster\postmaster.c:2552
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of
crash of another server process
2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2009-11-17 16:03:55 ESTLOCATION: quickdie,
.\src\backend\tcop\postgres.c:2495
2009-11-17 16:03:57 ESTLOG: 00000: all server processes terminated;
reinitializing
2009-11-17 16:03:57 ESTLOCATION: PostmasterStateMachine,
.\src\backend\postmaster\postmaster.c:2910
2009-11-17 16:04:07 ESTFATAL: XX000: pre-existing shared memory block is
still in use
2009-11-17 16:04:07 ESTHINT: Check if there are any old server processes
still running, and terminate them.
2009-11-17 16:04:07 ESTLOCATION: PGSharedMemoryCreate,
.\src\backend\port\win32_shmem.c:185
2009-11-17 16:04:08 ESTDEBUG: 00000: logger shutting down
2009-11-17 16:04:08 ESTLOCATION: SysLoggerMain,
.\src\backend\postmaster\syslogger.c:434
Prior to this, the logs show nothing other than AutoVacWorkerMain
activities. This database is installed on a Windows OS. The version of
PostgreSQL is 8.4.1 (which I was hoping had a fix since I saw references to
a bug fix for a shared memory problem). Does anybody have any suggestions
on how to determine what causes these shutdowns? Should I be considering
dialing up the shared_buffers size in the config file? Currently it is set
at 32mb.
Thanks for any help.
--
View this message in context: http://old.nabble.com/DB-terminating-tp26411033p26411033.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | doug livesey | 2009-11-18 17:36:55 | Re: Totally fresh uninstall/reinstall of Postgres on MacBook Pro running Snow Leopard? |
Previous Message | Pavel Stehule | 2009-11-18 17:13:38 | Re: passing parameters to multiple statements |