Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock

chenhj <chjischj@163.com>

View thread View on postgr.es

From: chenhj <chjischj@163.com>

To: "Peter Geoghegan" <pg@bowt.ie>

Cc: "PostgreSQL Hackers" <pgsql-hackers@lists.postgresql.org>

Date: 2018-11-11T17:10:32Z

Lists: pgsql-hackers

Attachments

primary_hang_20181026_52.tar.gz (application/x-gzip)


>
>BTW, I strongly doubt that disabling hugepages has fixed anything,
>though it may have accidentally masked the problem. This is an issue
>around the basic correctness of the locking protocols used by GIN.
>

We had disable hugepages for some days, but the bug still occurs.


The attachment is the gcore files that was collected when the issue occurred on the primary, and I hope to help analyze the problem.






Regard,
Chen Huajun

Commits

Fix WAL format incompatibility introduced by backpatching of 52ac6cd2d0
- d1166af192ed 9.4.22 landed
- cda5f6575306 9.5.17 landed
- f8a69a68a087 9.6.13 landed
- e23d44016d51 10.8 landed
- 89f39736f484 11.3 landed
Fix wrong backpatching of ginRedoDeletePage() deadlock fix
- bf0e5a73be20 9.4.21 landed
Fix deadlock in GIN vacuum introduced by 218f51584d5
- fd83c83d0943 12.0 landed
- 2e3bd064e530 10.7 landed
- 9aa94d8536f8 11.2 landed
Prevent GIN deleted pages from being reclaimed too early
- 52ac6cd2d0cd 12.0 landed
- ad6ebcfcbb88 9.5.16 landed
- 1cf175c74f10 9.4.21 landed
- cd24b4eaece3 9.6.12 landed
- a0696d29551b 10.7 landed
- dd951dc34a2e 11.2 landed
Prevent deadlock in ginRedoDeletePage()
- c6ade7a8cd31 12.0 landed
- 19cf52e6cc33 9.4.21 landed
- f6c44e1b55c1 9.5.16 landed
- 865870374aff 10.7 landed
- 80d4d8d71d57 9.6.12 landed
- 225b5c9c480f 11.2 landed
Reduce page locking in GIN vacuum
- 218f51584d5a 10.0 cited
Fix race condition in GIN posting tree page deletion.
- ac4ab97ec05e 9.4.0 cited