publication not found, yet it is there.??

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: publication not found, yet it is there.??
Date: 2020-01-08 13:35:28
Message-ID: CADK3HHJfAGs3LQdx-h=iHe70e9a0YKXYh4T7HCORSybKjfG4sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2020-01-08 14:02:02 Re: publication not found, yet it is there.??
Previous Message Tomas Vondra 2020-01-08 13:27:41 Re: BUG #16197: pg_advisory_xact_lock error