Re: How is this possible "publication does not exist"

On Wed, Aug 11, 2021 at 1:18 AM Dave Cramer <davecramer@gmail.com> wrote:
>
> Reviving this thread
>
> 2021-08-10 19:05:09.096 UTC [3738] LOG:  logical replication apply worker for subscription "sub_mycluster_alltables"
hasstarted
 
> 2021-08-10 19:05:09.107 UTC [3739] LOG:  logical replication table synchronization worker for subscription
"sub_mycluster_alltables",table "t_random" has started
 
> 2021-08-10 19:05:12.222 UTC [3739] LOG:  logical replication table synchronization worker for subscription
"sub_mycluster_alltables",table "t_random" has finished
 
> 2021-08-10 19:05:14.806 UTC [3738] ERROR:  could not receive data from WAL stream: ERROR:  publication
"sub_mycluster_alltables"does not exist
 
>         CONTEXT:  slot "sub_mycluster_alltables", output plugin "pgoutput", in the change callback, associated LSN
0/4015DF0
> 2021-08-10 19:05:14.811 UTC [175] LOG:  background worker "logical replication worker" (PID 3738) exited with exit
code1
 
>
>
> select * from pg_publication;
> -[ RECORD 1 ]+------------------------
> oid          | 16415
> pubname      | sub_mycluster_alltables
> pubowner     | 10
> puballtables | t
> pubinsert    | t
> pubupdate    | t
> pubdelete    | t
> pubtruncate  | t
>

By any chance, did you dropped and recreated this publication as
mentioned in your first email? If so, I think this can happen because
of our use of historical snapshots to consult system catalogs.

-- 
With Regards,
Amit Kapila.