From: | Bert <biertie(at)gmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | slave restarts with kill -9 coming from somewhere, or nowhere |
Date: | 2013-04-02 17:34:02 |
Message-ID: | CAFCtE1nbVozMok5uLoKaPxkexWCkHJFtohN6MW8UwYqSX0UMvg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I'm running the latest postgres version (9.2.3), and today for the first
time I encountered this:
12774 2013-04-02 18:13:10 CEST LOG: server process (PID 28463) was
terminated by signal 9: Killed
12774 2013-04-02 18:13:10 CEST DETAIL: Failed process was running:
BEGIN;declare "SQL_CUR0xff25e80" cursor for select distinct .... as
"Reservation_date___time" , "C_4F_TRANSACTION"."FTRA_PRICE_VAL
12774 2013-04-02 18:13:10 CEST LOG: terminating any other active server
processes
12774 2013-04-02 18:13:12 CEST LOG: all server processes terminated;
reinitializing
29113 2013-04-02 18:13:15 CEST LOG: database system was interrupted while
in recovery at log time 2013-04-02 18:02:21 CEST
29113 2013-04-02 18:13:15 CEST HINT: If this has occurred more than once
some data might be corrupted and you might need to choose an earlier
recovery target.
29113 2013-04-02 18:13:15 CEST LOG: entering standby mode
29113 2013-04-02 18:13:15 CEST LOG: redo starts at 6B0/DD0928A0
29113 2013-04-02 18:13:22 CEST LOG: consistent recovery state reached at
6B0/DE3831E8
12774 2013-04-02 18:13:22 CEST LOG: database system is ready to accept
read only connections
29113 2013-04-02 18:13:22 CEST LOG: invalid record length at 6B0/DE3859B8
29117 2013-04-02 18:13:22 CEST LOG: streaming replication successfully
connected to primary
for as far as I know it happened twice today. I have no idea where these
kills are coming from. I only know thse are not nice :)
Does anyone has an idea what happened exactly?
wkr,
Bert
--
Bert Desmet
0477/305361
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-04-02 18:06:08 | Re: slave restarts with kill -9 coming from somewhere, or nowhere |
Previous Message | Douglas J Hunley | 2013-04-02 16:54:02 | Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? |