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

Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: chee leong <cheeleong(dot)chong(at)incenplus(dot)com(dot)my>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
Date: 2007-05-29 14:27:24
Message-ID: 200705291427.l4TEROx12040@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
What is signal 5 in XP?  I looked in the MinGW source used to build
PostgreSQL 8.1.4 and there is no mention of a signal 5 there.  I see
signal 5 mentioned here:

	http://archives.postgresql.org/pgsql-bugs/2004-11/msg00175.php

and it was diagnosed as an invalid memory access.

I suggest you upgrade to the newest release of 8.1.X, 8.1.9.  It does
not require you to dump your database.  This might fix it:

	ftp://ftp5.ca.postgresql.org/mirrors/postgresql/binary/v8.1.9/win32

---------------------------------------------------------------------------

chee leong wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      3318
> Logged by:          chee leong
> Email address:      cheeleong(dot)chong(at)incenplus(dot)com(dot)my
> PostgreSQL version: 8.1.4
> Operating system:   Windows XP
> Description:        PostgreSQL : server process (PID 3480) was terminated by
> signal 5
> Details: 
> 
> Dear Sir/Madam,
>      
>          We have 2 pc, both also install postgreSQL, but one of the pc
> having problem in the middle of running program call to postgreSQL, but
> another one no problem at all.
>  
>          the problem as follow :
>    
>          2007-05-14 09:55:36 LOG:  server process (PID 3480) was terminated
> by signal 5
>          2007-05-14 09:55:36 LOG:  terminating any other active server
> processes
>          2007-05-14 09:55:36 LOG:  all server processes terminated;
> reinitializing
>          2007-05-14 09:55:36 LOG:  database system was interrupted at
> 2007-05-14 09:53:42 Malay Peninsula Standard Time
>          2007-05-14 09:55:36 LOG:  checkpoint record is at 1/D50D3610
>          
>          Many thanks and hope you can give some info/suggestion for solving
> this problem.
>  
> Thanks and regards,
> Chee Leong
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2007-05-29 16:53:09
Subject: Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
Previous:From: Tom LaneDate: 2007-05-29 13:41:38
Subject: Re: BUG #3320: Error when using INSERT...RETURNING as a subquery

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