Обсуждение: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
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
От
Bruce Momjian
Дата:
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
От
Magnus Hagander
Дата:
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