From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Background writer process terminating |
Date: | 2005-03-29 01:08:17 |
Message-ID: | 20050328170441.R18713@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, 29 Mar 2005, Greg Sabino Mullane wrote:
> Not many data points yet, but here's all the occurances:
>
> $ grep "signal 9" 5810.log
> <2005-03-28 03:38:14 EST >LOG: server process (PID 29216) was terminated by signal 9
> <2005-03-28 10:15:45 EST >LOG: background writer process (PID 29271) was terminated by signal 9
> <2005-03-28 11:05:00 EST >LOG: background writer process (PID 2202) was terminated by signal 9
> <2005-03-28 12:22:26 EST >LOG: background writer process (PID 7748) was terminated by signal 9
> <2005-03-28 12:27:37 EST >LOG: background writer process (PID 17119) was terminated by signal 9
> <2005-03-28 12:27:48 EST >LOG: background writer process (PID 17404) was terminated by signal 9
> <2005-03-28 12:28:27 EST >LOG: background writer process (PID 17409) was terminated by signal 9
> <2005-03-28 12:28:41 EST >LOG: startup process (PID 17452) was terminated by signal 9
> <2005-03-28 13:52:00 EST >LOG: 00000: background writer process (PID 21456) was terminated by signal 9
> <2005-03-28 15:26:25 EST 21453>LOG: 00000: background writer process (PID 24526) was terminated by signal 9
> <2005-03-28 15:39:16 EST 21453>LOG: 00000: background writer process (PID 655) was terminated by signal 9
> <2005-03-28 16:05:02 EST 21453>LOG: 00000: background writer process (PID 1579) was terminated by signal 9
> <2005-03-28 16:05:09 EST 21453>LOG: 00000: background writer process (PID 4141) was terminated by signal 9
> <2005-03-28 16:15:06 EST 21453>LOG: 00000: background writer process (PID 4159) was terminated by signal 9
> <2005-03-28 16:15:20 EST 21453>LOG: 00000: background writer process (PID 5822) was terminated by signal 9
>
> > Any chance you have a "terminate with extreme prejudice" daemon or
> > cron job that kills processes meeting certain conditions?
>
> Nope. I've been happily running pg on this server for many years. I'd frankly suspect
> the computer before Postgres, however, but a better error message (e.g. pointing
> to a corrupt disk or something) would be helpful. The first one was a server process
> and not a background writer process, FWIW.
Well, it seems to be saying that it was terminated by SIGKILL which I
can't see a reason to be internally generated. Is there anything else
running on the system that might (for example) be taxing memory to cause
an OOM killing spree or some such?
From | Date | Subject | |
---|---|---|---|
Next Message | helman | 2005-03-29 01:18:44 | BUG #1568: concat |
Previous Message | Greg Sabino Mullane | 2005-03-29 00:42:49 | Re: Background writer process terminating |