Re: [HACKERS] dropping a partition may cause deadlock

2017-04-11 Thread Amit Langote
On 2017/04/11 22:18, Robert Haas wrote: > On Sun, Apr 9, 2017 at 7:57 PM, Noah Misch wrote: >> The above-described topic is currently a PostgreSQL 10 open item. Robert, >> since you committed the patch believed to have created it, you own this open >> item. If some other commit is more relevant

Re: [HACKERS] dropping a partition may cause deadlock

2017-04-11 Thread Robert Haas
On Sun, Apr 9, 2017 at 7:57 PM, Noah Misch wrote: > The above-described topic is currently a PostgreSQL 10 open item. Robert, > since you committed the patch believed to have created it, you own this open > item. If some other commit is more relevant or if this does not belong as a > v10 open it

Re: [HACKERS] dropping a partition may cause deadlock

2017-04-09 Thread Noah Misch
On Mon, Apr 03, 2017 at 03:48:05PM +0900, Amit Langote wrote: > I noticed that a deadlock can occur due to the way locking when dropping a > partition proceeds. Steps to reproduce: > > 1. Attach debugger to two sessions, one of which will do a select on the > partitioned parent and the other will

[HACKERS] dropping a partition may cause deadlock

2017-04-02 Thread Amit Langote
Hi, I noticed that a deadlock can occur due to the way locking when dropping a partition proceeds. Steps to reproduce: 1. Attach debugger to two sessions, one of which will do a select on the partitioned parent and the other will drop one of its partitions. 2. In the first debugging session, se