Re: Unknown Process DETAIL: Failed process was running: LISTEN dirty

On Thursday, June 21, 2018, Jorge Daniel <elgaita(at)hotmail(dot)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.