Re: Dangling Client Backend Process - Mailing list pgsql-hackers

From Rajeev rastogi
Subject Re: Dangling Client Backend Process
Date
Msg-id BF2827DCCE55594C8D7A8F7FFD3AB77159965D4C@szxeml521-mbs.china.huawei.com
Whole thread
In response to Dangling Client Backend Process  (Rajeev rastogi <rajeev.rastogi@huawei.com>)
Responses Re: Dangling Client Backend Process
List pgsql-hackers

On 12th October 2015 20:45, Rajeev Rastogi Wrote:

 

>>> I observed one strange behavior today that if postmaster process gets crashed/killed, then it kill all background processes but not the client backend process.

 

>> This is a known behaviour and there was some discussion on this

>> topic [1] previously as well.

 

> Now as it is confirmed to be valid issue, I will spend some time on this to find if there is something more appropriate solution.

 

I checked the latest code and found Heikki has already added code for secure_read using the latch mechanism (using WaitLatchOrSocket). It currently waits for two events i.e. WL_LATCH_SET and WL_SOCKET_READABLE.

            Commit id: 80788a431e9bff06314a054109fdea66ac538199

 

If we add the event WL_POSTMASTER_DEATH also, client backend process handling will become same as other backend process. So postmaster death can be detected in the same way.

 

But I am not sure if WL_POSTMASTER_DEATH event was not added intentionally for some reason. Please confirm.

Also is it OK to add this even handling in generic path of Libpq?

 

Please let me know if I am missing something?

 

Thanks and Regards,

Kumar Rajeev Rastogi

pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: Getting sorted data from foreign server
Next
From: Praveen M
Date:
Subject: Eclipse Help