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

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

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