]> granicus.if.org Git - postgresql/commit
Avoid possible deadlock while locking multiple heap pages.
authorAmit Kapila <akapila@postgresql.org>
Sat, 2 Feb 2019 03:16:32 +0000 (08:46 +0530)
committerAmit Kapila <akapila@postgresql.org>
Sat, 2 Feb 2019 03:16:32 +0000 (08:46 +0530)
commit1ca33fc7b5111748222d1ac20b8b8ebb49bb75e6
tree00994835e5175210143218b8b4cf4e7bce5ea3fe
parent478e0069fb8bc30d7e0c1a8fc390ed041e1b67c9
Avoid possible deadlock while locking multiple heap pages.

To avoid deadlock, backend acquires a lock on heap pages in block
number order.  In certain cases, lock on heap pages is dropped and
reacquired.  In this case, the locks are dropped for reading in
corresponding VM page/s. The issue is we re-acquire locks in bufferId
order whereas the intention was to acquire in blockid order.

This commit ensures that we will always acquire locks on heap pages in
blockid order.

Reported-by: Nishant Fnu
Author: Nishant Fnu
Reviewed-by: Amit Kapila and Robert Haas
Backpatch-through: 9.4
Discussion: https://postgr.es/m/5883C831-2ED1-47C8-BFAC-2D5BAE5A8CAE@amazon.com
src/backend/access/heap/hio.c