Skip site navigation (1) Skip section navigation (2)

Re: Postgres crashes

From: <operationsengineer1(at)yahoo(dot)com>
To: chelsea boot <scx6148(at)yahoo(dot)co(dot)uk>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgres crashes
Date: 2006-03-17 20:49:29
Message-ID: 20060317204929.49196.qmail@web33301.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- chelsea boot <scx6148(at)yahoo(dot)co(dot)uk> wrote:

> Can anyone help please.  Intermittently a
> postgres/postmaster process appears to crash on our
> server 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
>    
>   Alternatively I get the same messages as above but
> an additional WARNING regarding the crash of another
> server process has caused a rollback but it does not
> identify which process crashed.
>    
>   When either occurs it is also 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 exception unknown software exception
> (0xc00000fd) occurred in the application at
> 0x7c59bd01. Click on OK to terminate the
> application".
>    
>   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.
>    
>   Thanks

the first step i would take is upgrade pgsql to its
latest production revision.  this may well resolve th
eissues.

what version are you running?

this probably isn't relevant, but did you alter a
column type prior to this problem occurring?

http://groups.google.com/group/mailing.database.pgsql-admin/browse_frm/thread/927ec9c91ca2a411/c963f442809858b4?lnk=st&q=server+process+PID++was+terminated+by+signal++win2k&rnum=1&hl=en#c963f442809858b4

did you recall doing anything unusual just prior to
this crash problem?  did you add any stored
procedures?

if you upgrading doesn't work, try detailing your
issue here first...

http://archives.postgresql.org/pgsql-ports/

if you don't get an answer...

http://archives.postgresql.org/pgsql-hackers/

be sure to let pgsql hackers know you tried novice and
ports before asking them the question.

best of luck - and i hope an upgrade resolves your issue.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-18 15:26:15
Subject: Re: log rotation
Previous:From: Sean DavisDate: 2006-03-17 13:31:36
Subject: Re: Find and Replace All

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group