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

Postgres Crashes on Win2K

From: chelsea boot <scx6148(at)yahoo(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres Crashes on Win2K
Date: 2006-05-25 14:47:49
Message-ID: 20060525144749.61830.qmail@web86805.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 

Responses

pgsql-hackers by date

Next:From: Andreas PflugDate: 2006-05-25 15:25:30
Subject: Re: XLogArchivingActive
Previous:From: David FetterDate: 2006-05-25 14:36:31
Subject: Re: Gborg and pgfoundry

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