slave restarts with kill -9 coming from somewhere, or nowhere

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux