On Thursday, June 21, 2018, Jorge Daniel <
elgaita@hotmail.com> wrote:
Hi guys, we're receiving this kind of Abnormal terminations :
2018-06-19 14:11:02.394 PDT rhost= app=:user=:db=:LOG: server process (PID 235545) was terminated by signal 9: Killed
2018-06-19 14:11:02.394 PDT rhost= app=:user=:db=:DETAIL: Failed process was running: LISTEN dirty
2018-06-19 14:11:02.394 PDT rhost= app=:user=:db=:LOG: terminating any other active server processes
Does someone has information about "LISTEN DIRTY" as failed process, I've google it but no mention of this anywhere.
Kill 9 isn't abnormal, it's user initiated (usually anyway). Someone killed an open client session that had issued the LISTEN SQL command with a user-specific channel name of "dirty".
I'm unsure under what circumstances a session would be running a listen command long enough to be killed in this manner - but it might be normal as I have little experience with listen mechanics.
David J.