search

confluentinc / bottledwater-pg

Change data capture from PostgreSQL into Kafka
http://blog.confluent.io/2015/04/23/bottled-water-real-time-integration-of-postgresql-and-kafka/
Apache License 2.0
3 stars 149 forks source link

[FATAL] no known snapshots #149

Open wendaoshuangyue opened 6 years ago

wendaoshuangyue commented 6 years ago

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

igouss commented 6 years ago

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)