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

Reviving this thread

2021-08-10 19:05:09.096 UTC [3738] LOG: logical replication apply
worker for subscription "sub_mycluster_alltables" has started
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 code 1

select * from pg_publication;
-[ RECORD 1 ]+------------------------
oid | 16415
pubname | sub_mycluster_alltables
pubowner | 10
puballtables | t
pubinsert | t
pubupdate | t
pubdelete | t
pubtruncate | t

select * from pg_replication_slots;
-[ RECORD 1 ]-------+--------------------------------
slot_name | mycluster_cjvq_68cf55677c_6vgcf
plugin |
slot_type | physical
datoid |
database |
temporary | f
active | t
active_pid | 433
xmin |
catalog_xmin |
restart_lsn | 0/D000000
confirmed_flush_lsn |
-[ RECORD 2 ]-------+--------------------------------
slot_name | sub_mycluster_alltables
plugin | pgoutput
slot_type | logical
datoid | 16395
database | mycluster
temporary | f
active | t
active_pid | 8799
xmin |
catalog_xmin | 500
restart_lsn | 0/40011C0

confirmed_flush_lsn | 0/40011C0

I'm at a loss as to where to even look at this point.

Dave