Hi everyone,
Have you seen PostgreSQL terminated abnormally with "signal 66" ?
I'm using PostgreSQL 8.1.4 on Windows XP SP2.
autovacuum process aborted with "signal 66", and "startup process"
aborted also.
-----
2008-01-18 10:04:56 892 LOCATION: AutoVacMain, autovacuum.c:412
2008-01-18 10:05:56 3808 LOG: 00000: autovacuum process (PID 1160) was terminated by signal 66
2008-01-18 10:05:56 3808 LOCATION: LogChildExit, postmaster.c:2436
2008-01-18 10:05:56 3808 LOG: 00000: terminating any other active server processes
2008-01-18 10:05:56 3808 LOCATION: HandleChildCrash, postmaster.c:2317
2008-01-18 10:05:56 2152 WARNING: 57P02: terminating connection because of crash of another server process
2008-01-18 10:05:56 2152 DETAIL: The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory.
2008-01-18 10:05:56 2152 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-01-18 10:05:56 2152 LOCATION: quickdie, postgres.c:2105
2008-01-18 10:05:56 2436 WARNING: 57P02: terminating connection because of crash of another server process
2008-01-18 10:05:56 2436 DETAIL: The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory.
2008-01-18 10:05:56 2436 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-01-18 10:05:56 2436 LOCATION: quickdie, postgres.c:2105
2008-01-18 10:05:56 2536 WARNING: 57P02: terminating connection because of crash of another server process
2008-01-18 10:05:56 2536 DETAIL: The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory.
2008-01-18 10:05:56 2536 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-01-18 10:05:56 2536 LOCATION: quickdie, postgres.c:2105
2008-01-18 10:05:57 3808 LOG: 00000: all server processes terminated; reinitializing
2008-01-18 10:05:57 3808 LOCATION: reaper, postmaster.c:2217
2008-01-18 10:05:57 3808 LOG: 00000: startup process (PID 3668) was terminated by signal 66
2008-01-18 10:05:57 3808 LOCATION: LogChildExit, postmaster.c:2436
2008-01-18 10:05:57 3808 LOG: 00000: aborting startup due to startup process failure
2008-01-18 10:05:57 3808 LOCATION: reaper, postmaster.c:2062
2008-01-18 10:05:57 1336 LOG: 00000: logger shutting down
2008-01-18 10:05:57 1336 LOCATION: SysLoggerMain, syslogger.c:361
-----
This trouble does not occur after this.
Do you know meaning of "signal 66" ?
Thanks
-----
Akio Iwaasa (NEC Soft, Ltd.)
mail : iwaasa@mxs.nes.nec.co.jp
URL : http://www.necsoft.com/eng/index.html