Re: Why is my Postgre server went in recovery mode all in sudden

On 05/11/2018 03:30 AM, nikhil raj wrote:
> Hi Adrian Klaver,
> 
> No its like it opens  connection and once the query gets execute it goes 
> to idle connection and again idle connection time out i kept it for 2 mins .
> 
> It never happen again.
> 
> need few answers
> why will share buffer crashes ?

 From the error message it was maybe shared memory:

"The postmaster has commanded this server process to roll back the 
current transaction and exit, because another server process exited 
abnormally and possibly corrupted shared memory."

I don't have an answer as it is not clear to me what process triggered 
the exit. My suspicion is it was this:

"timestamp=2018-05-07 00:34:11.209 
EDT,user=,db=,app=,client=,transaction-ID=0,session_start_timestamp=2018-04-26 
10:08:19 EDT,SQL_state=00000LOG:  worker process: parallel worker for 
PID 2864 (PID 4476) exited with exit code 0"

To me it looks like a parallel query process that ran for 11 days.
Is that possible and do you know what the query was doing?

> 
> Thanks,
> 
> 
> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com