On Wed, Aug 24, 2016 at 11:44 AM, Mark Kirkwood
<mark.kirkw...@catalyst.net.nz> wrote:
> On 24/08/16 17:01, Mark Kirkwood wrote:
>> ...actually I was wrong there, only 2 of them were the same. So I've
>> attached a new log of bt's of them all.
> And I can reproduce with only 1 session, figured that might be a helpful
> piece of the puzzle (trace attached).


I think I know the problem here.  Basically _hash_freeovflpage() is
trying to take a lock on a buffer previous to overflow page to update
the links and it is quite possible that the same buffer is already
locked for moving the tuples while squeezing the bucket.  I am working
on a fix for the same.

Coincidently, Ashutosh Sharma a colleague of mine who was also testing
this patch found the same issue by an attached sql script.  So we
might be able to inculcate a test case  in the regression suite as
well after fix.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Attachment: test_hash.sql
Description: Binary data

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to