pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Remove the streaming files for incomplete xacts after restart. 3+ messages / 1 participants [nested] [flat]
* pgsql: Remove the streaming files for incomplete xacts after restart. @ 2023-01-07 06:59 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2023-01-07 06:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Remove the streaming files for incomplete xacts after restart. After restart, we try to stream the changes for large transactions that were not sent before server crash and restart. However, we forget to send the abort message for such transactions. This leads to spurious streaming files on the subscriber which won't be cleaned till the apply worker or the subscriber server restarts. Reported-by: Dilip Kumar Author: Hou Zhijie Reviewed-by: Dilip Kumar and Amit Kapila Backpatch-through: 14 Discussion: https://postgr.es/m/OS0PR01MB5716A773F46768A1B75BE24394FB9@OS0PR01MB5716.jpnprd01.prod.outlook.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/2b6df05461cb540d8f103dfe55f38efc09b4189b Modified Files -------------- src/backend/replication/logical/reorderbuffer.c | 4 ++++ 1 file changed, 4 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Remove the streaming files for incomplete xacts after restart. @ 2023-01-07 06:59 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2023-01-07 06:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Remove the streaming files for incomplete xacts after restart. After restart, we try to stream the changes for large transactions that were not sent before server crash and restart. However, we forget to send the abort message for such transactions. This leads to spurious streaming files on the subscriber which won't be cleaned till the apply worker or the subscriber server restarts. Reported-by: Dilip Kumar Author: Hou Zhijie Reviewed-by: Dilip Kumar and Amit Kapila Backpatch-through: 14 Discussion: https://postgr.es/m/OS0PR01MB5716A773F46768A1B75BE24394FB9@OS0PR01MB5716.jpnprd01.prod.outlook.com Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/18b81258ab60cdd172329fe80dd2314d587bd551 Modified Files -------------- src/backend/replication/logical/reorderbuffer.c | 4 ++++ 1 file changed, 4 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Remove the streaming files for incomplete xacts after restart. @ 2023-01-07 06:59 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2023-01-07 06:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Remove the streaming files for incomplete xacts after restart. After restart, we try to stream the changes for large transactions that were not sent before server crash and restart. However, we forget to send the abort message for such transactions. This leads to spurious streaming files on the subscriber which won't be cleaned till the apply worker or the subscriber server restarts. Reported-by: Dilip Kumar Author: Hou Zhijie Reviewed-by: Dilip Kumar and Amit Kapila Backpatch-through: 14 Discussion: https://postgr.es/m/OS0PR01MB5716A773F46768A1B75BE24394FB9@OS0PR01MB5716.jpnprd01.prod.outlook.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b2cc5b81001ad5e856d7316bab11f08ce1386d4b Modified Files -------------- src/backend/replication/logical/reorderbuffer.c | 4 ++++ 1 file changed, 4 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-01-07 06:59 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-01-07 06:59 pgsql: Remove the streaming files for incomplete xacts after restart. Amit Kapila <akapila@postgresql.org> 2023-01-07 06:59 pgsql: Remove the streaming files for incomplete xacts after restart. Amit Kapila <akapila@postgresql.org> 2023-01-07 06:59 pgsql: Remove the streaming files for incomplete xacts after restart. Amit Kapila <akapila@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox