DB terminating - Mailing list 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.