Re: Optionally automatically disable logical replication subscriptions on error
От
Amit Kapila
Тема
Re: Optionally automatically disable logical replication subscriptions on error
Дата
Msg-id
CAA4eK1L4QVNrqVACUADbP0bUyPbW509fceDc8VA9254S7DReHA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "wangw.fnst@fujitsu.com" <wangw.fnst@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Nathan Bossart <nathandbossart@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Masahiko Sawada <sawada.mshk@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila <amit.kapila16@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Greg Nancarrow <gregn4422@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error vignesh C <vignesh21@gmail.com>
RE: Optionally automatically disable logical replication subscriptions on error "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Optionally automatically disable logical replication subscriptions on error Peter Smith <smithpb2250@gmail.com>
Re: Optionally automatically disable logical replication subscriptions on error Mark Dilger <mark.dilger@enterprisedb.com>
On Thu, Feb 24, 2022 at 1:20 PM Masahiko Sawada wrote: > > Here are some comments: > > Why do we need SyncTableStartWrapper() and ApplyLoopWrapper()? > I have given this comment to move the related code to separate functions to slightly simplify ApplyWorkerMain() code but if you don't like we can move it back. I am not sure I like the new function names in the patch though. > --- > + /* > + * Log the error that caused DisableSubscriptionOnError to be called. We > + * do this immediately so that it won't be lost if some other internal > + * error occurs in the following code. > + */ > + EmitErrorReport(); > + AbortOutOfAnyTransaction(); > + FlushErrorState(); > > Do we need to hold interrupts during cleanup here? > I think so. We do prevent interrupts via HOLD_INTERRUPTS/RESUME_INTERRUPTS during cleanup. -- With Regards, Amit Kapila.
В списке pgsql-hackers по дате отправления