bottledwater-pg icon indicating copy to clipboard operation
bottledwater-pg copied to clipboard

[FATAL] no known snapshots

Open wendaoshuangyue opened this issue 7 years ago • 1 comments

My bottledwater suddenly crashed with following error message and no longer able to restart. Can anyone help me? Thanks a lot. Error message: [FATAL] Replication stream was unexpectedly terminated: Error: no known snapshots CONTEXT: slot "bottledwater_hpg_000000", output plugin "bottledwater", callback in change, related LSN address is 0/2C833598

wendaoshuangyue avatar Nov 23 '17 08:11 wendaoshuangyue

I see same error in "wal2json"

org.postgresql.util.PSQLException: ERROR: no known snapshots Where: slot "cdc", output plugin "wal2json", in the change callback, associated LSN CC/88421640 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477) at org.postgresql.core.v3.QueryExecutorImpl.processCopyResults(QueryExecutorImpl.java:1107) at org.postgresql.core.v3.QueryExecutorImpl.endCopy(QueryExecutorImpl.java:956) at org.postgresql.core.v3.CopyDualImpl.endCopy(CopyDualImpl.java:27) at org.postgresql.core.v3.replication.V3PGReplicationStream.close(V3PGReplicationStream.java:278)

igouss avatar Jun 28 '18 20:06 igouss