Re: Postgres Crashes on Win2K - Mailing list pgsql-hackers

Hi

 

The O/S is Win 2K Server SP4 and PG version is 8.0.  Here's the log file from the latest incident:

 

2006-06-16 09:40:01 LOG:  00000: server process (PID 4744) was terminated by signal 125

2006-06-16 09:40:01 LOCATION:  LogChildExit, postmaster.c:2335

2006-06-16 09:40:01 LOG:  00000: terminating any other active server processes

2006-06-16 09:40:01 LOCATION:  HandleChildCrash, postmaster.c:2228

2006-06-16 09:40:02 WARNING:  57P02: terminating connection because of crash of another server process

2006-06-16 09:40:02 DETAIL:  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.

2006-06-16 09:40:02 HINT:  In a moment you should be able to reconnect to the database and repeat your command.

2006-06-16 09:40:02 LOCATION:  quickdie, postgres.c:1890

2006-06-16 09:40:03 LOG:  00000: all server processes terminated; reinitializing

2006-06-16 09:40:03 LOCATION:  reaper, postmaster.c:2127

2006-06-16 09:40:04 LOG:  00000: database system was interrupted at 2006-06-15 20:03:42 GMT Daylight Time

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4054

2006-06-16 09:40:04 LOG:  00000: checkpoint record is at 0/3C5B5350

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4123

2006-06-16 09:40:04 LOG:  00000: redo record is at 0/3C5B5350; undo record is at 0/0; shutdown FALSE

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4151

2006-06-16 09:40:04 LOG:  00000: next transaction ID: 2991949; next OID: 182344

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4154

2006-06-16 09:40:04 LOG:  00000: database system was not properly shut down; automatic recovery in progress

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4210

2006-06-16 09:40:04 LOG:  00000: record with zero length at 0/3C5B5390

2006-06-16 09:40:04 LOCATION:  ReadRecord, xlog.c:2487

2006-06-16 09:40:04 LOG:  00000: redo is not required

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4312

2006-06-16 09:40:04 LOG:  00000: database system is ready

2006-06-16 09:40:04 LOCATION:  StartupXLOG, xlog.c:4517

 

Thanks

Ch.