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