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). >
Thanks. 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
test_hash.sql
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers