pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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