pgsql: Don't use _mdfd_getseg() in mdsyncfiletag().

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема pgsql: Don't use _mdfd_getseg() in mdsyncfiletag().
Дата
Msg-id E1ifyPp-0007d7-68@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Don't use _mdfd_getseg() in mdsyncfiletag().

_mdfd_getseg() opens all segments up to the requested one.  That
causes problems for mdsyncfiletag(), if mdunlinkfork() has
already unlinked other segment files.  Open the file we want
directly by name instead, if it's not already open.

The consequence of this bug was a rare panic in the checkpointer,
made more likely if you saturated the sync request queue so that
the SYNC_FORGET_REQUEST messages for a given relation were more
likely to be absorbed in separate cycles by the checkpointer.

Back-patch to 12.  Defect in commit 3eb77eba.

Author: Thomas Munro
Reported-by: Justin Pryzby
Discussion: https://postgr.es/m/20191119115759.GI30362%40telsasoft.com

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/c3dc0cdd6b58f6d4a632364554c9aec5b4f83f69

Modified Files
--------------
src/backend/storage/smgr/md.c | 57 ++++++++++++++++++++++++++++++-------------
1 file changed, 40 insertions(+), 17 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Don't use _mdfd_getseg() in mdsyncfiletag().
Следующее
От: Thomas Munro
Дата:
Сообщение: pgsql: Fix mdsyncfiletag(), take II.