agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedpgsql: Fix checkpointer restartpoint assertion failure
7+ messages / 1 participants
[nested] [flat]
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:36 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/c2c696c1a4827cde5fdaf8c8f03f9991d43ebfad
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 26 ++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 8 ++++++++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:36 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/7b4c2c1bcd366d4324fdee4f99c15e0b391d5f43
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 26 ++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 8 ++++++++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:36 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_18_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/da7e446abbd5607e8a1cb6fa82f7b04097e1d12b
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 32 +++++++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 2 ++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:36 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/5d13f7530545ecd3ac011b9ed1b4aac669e37b19
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 32 +++++++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 2 ++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:37 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:37 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_16_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/f0089b766261470a7b8c095bb414b053ef9bab10
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 32 +++++++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 2 ++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:37 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:37 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/bdaa5a0e4a7e8d0769c7a88c93eb9188cf8cccac
Modified Files
--------------
src/backend/access/transam/xlog.c | 7 ++++---
src/backend/access/transam/xlogrecovery.c | 32 +++++++++++++++++++++++++++++++
src/include/access/xlogrecovery.h | 2 ++
3 files changed, 38 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Fix checkpointer restartpoint assertion failure
@ 2026-09-02 05:37 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2026-09-02 05:37 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix checkpointer restartpoint assertion failure
When recovery starts from a backup without a signal file, pg_subtrans
is not started at the beginning of recovery and remains unstarted
throughout recovery. However, previously, a restartpoint run by
the checkpointer during recovery nevertheless tried to truncate
pg_subtrans, triggering the assertion failure:
TRAP: failed Assert("TransactionIdIsValid(initial)")
This commit fixes this by tracking whether pg_subtrans has been
started during recovery, and have the checkpointer check this flag
before truncating pg_subtrans at restartpoints.
Backpatch to all supported versions.
Reported-by: Imran Zaheer <imran.zhir@gmail.com>
Author: Imran Zaheer <imran.zhir@gmail.com>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA+UBfamzfEReT0VOGRUW_=_AecCYQ-CNKLR_T4Q+YEmJAH3fdg@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/d3c9ccdf1edec4f486a860e279d2ef2e22f5e4f1
Modified Files
--------------
src/backend/access/transam/xlog.c | 42 ++++++++++++++++++++++++++++++++++++---
1 file changed, 39 insertions(+), 3 deletions(-)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2026-09-02 05:37 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-09-02 05:36 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:36 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:36 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:36 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:37 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:37 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
2026-09-02 05:37 pgsql: Fix checkpointer restartpoint assertion failure Fujii Masao <fujii@postgresql.org>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox