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 по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: Re: Readd use of TAP subtests
От: Michael Paquier
Дата:
FAQ