Thread: Postgres Crashes on Win2K

Postgres Crashes on Win2K

From
chelsea boot
Date:
Hi
 
Can anyone offer advice on this please: Intermittently a postgres process appears to crash and the postmaster service needs restarting.  The following is entered in the log:
 
2006-03-15 09:50:03 LOG:  server process (PID 348) was terminated by signal 125
2006-03-15 09:50:03 LOG:  terminating any other active server processes
2006-03-15 09:50:06 FATAL:  the database system is in recovery mode
2006-03-15 09:50:06 LOG:  all server processes terminated; reinitializing
2006-03-15 09:50:06 FATAL:  the database system is starting up
2006-03-15 09:50:06 LOG:  database system was interrupted at 2006-03-15 00:16:39 GMT Standard Time
2006-03-15 09:50:06 LOG:  checkpoint record is at 0/C1F3E48
2006-03-15 09:50:06 LOG:  redo record is at 0/C1F3E48; undo record is at 0/0; shutdown FALSE
2006-03-15 09:50:06 LOG:  next transaction ID: 651022; next OID: 113846
2006-03-15 09:50:06 LOG:  database system was not properly shut down; automatic recovery in progress
2006-03-15 09:50:06 FATAL:  the database system is starting up
2006-03-15 09:50:06 LOG:  record with zero length at 0/C1F3E88
2006-03-15 09:50:06 LOG:  redo is not required
2006-03-15 09:50:06 FATAL:  the database system is starting up
2006-03-15 09:50:06 LOG:  database system is ready
 
This is accompanied by 2 postgres errors in the Application Log of the Win2K server:
(1) "the application failed to initialize properly (0xc0000142). Click on OK to terminate the application"
(2) "the execption unknown software exception (0xc00000fd) occurred in the application at 0x7c59bd01. Click on OK to terminate the application".
 
Alternatively I get the same messages as above but with an additional WARNING:
 
WARNING: terminating connection because of a crash of another server process
DEATIL: The postmaster has commaned this server process to roll back the current transaction and exit, possibly because another server process exited abnormally and possibly corrupted shared memory.
 
What is the signal 125 and how can I troubleshoot what is causing the process to crash as the error occurs at random times eg. 8pm when no-one is using the network and no utility is running such as AV or backup or during the day?
 
I've posted to novice and ports but have been unable to find a solution.
 
Many Thanks
Ch.

Send instant messages to your online friends http://uk.messenger.yahoo.com

Re: Postgres Crashes on Win2K

From
Robert Treat
Date:
On Thursday 25 May 2006 10:47, chelsea boot wrote:
> Hi
>
>   Can anyone offer advice on this please: Intermittently a postgres process
> appears to crash and the postmaster service needs restarting.  The
> following is entered in the log:
>
>   2006-03-15 09:50:03 LOG:  server process (PID 348) was terminated by
> signal 125 2006-03-15 09:50:03 LOG:  terminating any other active server
> processes 2006-03-15 09:50:06 FATAL:  the database system is in recovery
> mode 2006-03-15 09:50:06 LOG:  all server processes terminated;
> reinitializing 2006-03-15 09:50:06 FATAL:  the database system is starting
> up
>   2006-03-15 09:50:06 LOG:  database system was interrupted at 2006-03-15
> 00:16:39 GMT Standard Time 2006-03-15 09:50:06 LOG:  checkpoint record is
> at 0/C1F3E48
>   2006-03-15 09:50:06 LOG:  redo record is at 0/C1F3E48; undo record is at
> 0/0; shutdown FALSE 2006-03-15 09:50:06 LOG:  next transaction ID: 651022;
> next OID: 113846 2006-03-15 09:50:06 LOG:  database system was not properly
> shut down; automatic recovery in progress 2006-03-15 09:50:06 FATAL:  the
> database system is starting up
>   2006-03-15 09:50:06 LOG:  record with zero length at 0/C1F3E88
>   2006-03-15 09:50:06 LOG:  redo is not required
>   2006-03-15 09:50:06 FATAL:  the database system is starting up
>   2006-03-15 09:50:06 LOG:  database system is ready
>
>   This is accompanied by 2 postgres errors in the Application Log of the
> Win2K server: (1) "the application failed to initialize properly
> (0xc0000142). Click on OK to terminate the application" (2) "the execption
> unknown software exception (0xc00000fd) occurred in the application at
> 0x7c59bd01. Click on OK to terminate the application".
>
>   Alternatively I get the same messages as above but with an additional
> WARNING:
>
>   WARNING: terminating connection because of a crash of another server
> process DEATIL: The postmaster has commaned this server process to roll
> back the current transaction and exit, possibly because another server
> process exited abnormally and possibly corrupted shared memory.
>
>   What is the signal 125 and how can I troubleshoot what is causing the
> process to crash as the error occurs at random times eg. 8pm when no-one is
> using the network and no utility is running such as AV or backup or during
> the day?
>
>   I've posted to novice and ports but have been unable to find a solution.
>

Try setting log_error_verbosity to verbose and sending that info in along with 
OS and PG Versions.

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


Re: Postgres Crashes on Win2K

From
chelsea boot
Date:
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.


Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. Do it now...