Thread: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
From
"chee leong"
Date:
The following bug has been logged online:
Bug reference: 3318
Logged by: chee leong
Email address: cheeleong.chong@incenplus.com.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
Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
From
Bruce Momjian
Date:
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.chong@incenplus.com.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@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
From
Magnus Hagander
Date:
Bruce Momjian wrote: > 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: Access denied. Most often showed for accessing memory outside the mapped space, so this similar to SIGSEGV. //Magnus