Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Cc: Dilip Kumar <dilipbalaut@gmail.com>,
Alvaro Herrera <alvherre@alvh.no-ip.org>, Petr Jelinek <petr@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, Henry Hinze <henry.hinze@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Date: 2020-11-27T02:21:24Z
Lists: pgsql-bugs
On Fri, Nov 27, 2020 at 7:29 AM Peter Smith <smithpb2250@gmail.com> wrote: > > On Thu, Nov 26, 2020 at 11:35 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > Okay, I see your point, so changed it accordingly and fixed the code > > comments as suggested by you. Does this address all your > > concerns/suggestions? > > Yes. Now the v4 patch addresses everything I previously mentioned. > > However, today I did notice one more small thing you may want to change. > > === > > REVIEW COMMENT: > > (1) missing comment? > > @@ -928,7 +917,9 @@ apply_handle_stream_abort(StringInfo s) > > /* write the updated subxact list */ > subxact_info_write(MyLogicalRepWorker->subid, xid); > - CommitTransactionCommand(); > + > + if (!am_tablesync_worker()) > + CommitTransactionCommand(); > } > } > > That new condition seems to be missing a comment saying "/* The > synchronization worker runs in a single transaction */". Such a > comment accompanies all other am_tablesync_worker() conditions that > look like this one. > Yeah, I had intentionally left it because, in the same function, few lines before we have that condition and comment, so adding it again didn't appear to be a good idea to me. > === > > I also re-ran the tablesync test using the v4 patch, and have stepped > to see the normal stream file normal cleanup being executed by the > tablesync worker. > > So apart from that trivial missing comment, I think now it is all good. > Cool, I'm planning to push this in a few minutes time. -- With Regards, Amit Kapila.
Commits
-
Fix replication of in-progress transactions in tablesync worker.
- 0926e96c4934 14.0 landed
-
Review logical replication tablesync code
- b05fe7b442fd 14.0 landed
-
Restore replication protocol's duplicate command tags
- 72e43fc313e9 13.1 landed
- 4e9821b6fac5 14.0 landed