publication not found, yet it is there.??

--000000000000e46401059ba0f72d
Content-Type: text/plain; charset="UTF-8"

How is this possible?

I have checked pg_replication_slots and the slot exists. I have checked
pg_publications and the publication exists.



2020-01-07 20:45:44.111 GMT [3768] DEBUG:  received replication command:
CREATE_REPLICATION_SLOT debezium  LOGICAL pgoutput
2020-01-07 20:45:44.133 GMT [3768] DEBUG:  searching for logical decoding
starting point, starting at 0/20B9640
2020-01-07 20:45:44.133 GMT [3768] LOG:  logical decoding found initial
starting point at 0/20B9640
2020-01-07 20:45:44.133 GMT [3768] DETAIL:  Waiting for transactions
(approximately 1) older than 629 to end.
2020-01-07 20:45:46.439 GMT [3768] LOG:  logical decoding found consistent
point at 0/20BB328
2020-01-07 20:45:46.439 GMT [3768] DETAIL:  There are no running
transactions.
2020-01-07 20:45:46.440 GMT [3768] LOG:  exported logical decoding
snapshot: "00000005-00000009-1" with 0 transaction IDs
2020-01-07 20:45:46.798 GMT [3768] DEBUG:  received replication command:
IDENTIFY_SYSTEM
2020-01-07 20:45:46.800 GMT [3768] LOG:  duration: 0.751 ms  statement:
SELECT COUNT(1) FROM pg_publication WHERE pubname = 'dbz_publication'
2020-01-07 20:45:46.802 GMT [3768] LOG:  duration: 0.642 ms  statement:
CREATE PUBLICATION dbz_publication FOR ALL TABLES;
2020-01-07 20:45:46.805 GMT [3768] DEBUG:  received replication command:
START_REPLICATION SLOT debezium LOGICAL 0/20BB360 ("publication_names"
'dbz_publication', "proto_version" '1')
2020-01-07 20:45:46.805 GMT [3768] LOG:  starting logical decoding for slot
"debezium"
2020-01-07 20:45:46.805 GMT [3768] DETAIL:  Streaming transactions
committing after 0/20BB360, reading WAL from 0/20B9640.
2020-01-07 20:45:46.806 GMT [3768] LOG:  logical decoding found initial
starting point at 0/20B9640
2020-01-07 20:45:46.806 GMT [3768] DETAIL:  Waiting for transactions
(approximately 1) older than 629 to end.
2020-01-07 20:45:46.806 GMT [3768] LOG:  logical decoding found consistent
point at 0/20BB328
2020-01-07 20:45:46.806 GMT [3768] DETAIL:  There are no running
transactions.
2020-01-07 20:45:46.807 GMT [3768] DEBUG:  "PostgreSQL JDBC Driver" has now
caught up with upstream server
2020-01-07 20:45:46.988 GMT [3768] DEBUG:  serializing snapshot to
pg_logical/snapshots/0-20C2590.snap
2020-01-07 20:45:48.970 GMT [3768] ERROR:  publication "dbz_publication"
does not exist
2020-01-07 20:45:48.970 GMT [3768] CONTEXT:  slot "debezium", output plugin
"pgoutput", in the change callback, associated LSN 0/20BB360
Dave Cramer

--000000000000e46401059ba0f72d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">How is this possible?<div><br></div><div>I have checked pg=
_replication_slots and the slot exists. I have checked pg_publications and =
the publication exists.</div><div><br></div><div><br><div><br></div><div>20=
20-01-07 20:45:44.111 GMT [3768] DEBUG: =C2=A0received replication command:=
 CREATE_REPLICATION_SLOT debezium =C2=A0LOGICAL pgoutput<br>2020-01-07 20:4=
5:44.133 GMT [3768] DEBUG: =C2=A0searching for logical decoding starting po=
int, starting at 0/20B9640<br>2020-01-07 20:45:44.133 GMT [3768] LOG: =C2=
=A0logical decoding found initial starting point at 0/20B9640<br>2020-01-07=
 20:45:44.133 GMT [3768] DETAIL: =C2=A0Waiting for transactions (approximat=
ely 1) older than 629 to end.<br>2020-01-07 20:45:46.439 GMT [3768] LOG: =
=C2=A0logical decoding found consistent point at 0/20BB328<br>2020-01-07 20=
:45:46.439 GMT [3768] DETAIL: =C2=A0There are no running transactions.<br>2=
020-01-07 20:45:46.440 GMT [3768] LOG: =C2=A0exported logical decoding snap=
shot: &quot;00000005-00000009-1&quot; with 0 transaction IDs<br>2020-01-07 =
20:45:46.798 GMT [3768] DEBUG: =C2=A0received replication command: IDENTIFY=
_SYSTEM<br>2020-01-07 20:45:46.800 GMT [3768] LOG: =C2=A0duration: 0.751 ms=
 =C2=A0statement: SELECT COUNT(1) FROM pg_publication WHERE pubname =3D &#3=
9;dbz_publication&#39;<br>2020-01-07 20:45:46.802 GMT [3768] LOG: =C2=A0dur=
ation: 0.642 ms =C2=A0statement: CREATE PUBLICATION dbz_publication FOR ALL=
 TABLES;<br>2020-01-07 20:45:46.805 GMT [3768] DEBUG: =C2=A0received replic=
ation command: START_REPLICATION SLOT debezium LOGICAL 0/20BB360 (&quot;pub=
lication_names&quot; &#39;dbz_publication&#39;, &quot;proto_version&quot; &=
#39;1&#39;)<br>2020-01-07 20:45:46.805 GMT [3768] LOG: =C2=A0starting logic=
al decoding for slot &quot;debezium&quot;<br>2020-01-07 20:45:46.805 GMT [3=
768] DETAIL: =C2=A0Streaming transactions committing after 0/20BB360, readi=
ng WAL from 0/20B9640.<br>2020-01-07 20:45:46.806 GMT [3768] LOG: =C2=A0log=
ical decoding found initial starting point at 0/20B9640<br>2020-01-07 20:45=
:46.806 GMT [3768] DETAIL: =C2=A0Waiting for transactions (approximately 1)=
 older than 629 to end.<br>2020-01-07 20:45:46.806 GMT [3768] LOG: =C2=A0lo=
gical decoding found consistent point at 0/20BB328<br>2020-01-07 20:45:46.8=
06 GMT [3768] DETAIL: =C2=A0There are no running transactions.<br>2020-01-0=
7 20:45:46.807 GMT [3768] DEBUG: =C2=A0&quot;PostgreSQL JDBC Driver&quot; h=
as now caught up with upstream server<br>2020-01-07 20:45:46.988 GMT [3768]=
 DEBUG: =C2=A0serializing snapshot to pg_logical/snapshots/0-20C2590.snap<b=
r>2020-01-07 20:45:48.970 GMT [3768] ERROR: =C2=A0publication &quot;dbz_pub=
lication&quot; does not exist<br>2020-01-07 20:45:48.970 GMT [3768] CONTEXT=
: =C2=A0slot &quot;debezium&quot;, output plugin &quot;pgoutput&quot;, in t=
he change callback, associated LSN 0/20BB360<br><div><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature">Dave Cramer</div></=
div></div></div></div>

--000000000000e46401059ba0f72d--