Thread: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

From
FOUTE K. Jaurès
Date:
Hello EveryOne,

How can I solve Issue. ???

ERROR:  could not start WAL streaming: ERROR:  replication slot "XXX" does not exist
2021-03-27 11:48:33.012 WAT [1090] LOG:  background worker "logical replication worker" (PID 8458) exited with exit code 1
2021-03-27 11:48:38.019 WAT [8461] LOG:  logical replication apply worker for subscription "XXX has started

All working fine a few days ago but this morning I have this issue.

--
Jaurès FOUTE
As per your error, it seems replication slot has been dropped.

On Saturday, March 27, 2021, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:
Hello EveryOne,

How can I solve Issue. ???

ERROR:  could not start WAL streaming: ERROR:  replication slot "XXX" does not exist
2021-03-27 11:48:33.012 WAT [1090] LOG:  background worker "logical replication worker" (PID 8458) exited with exit code 1
2021-03-27 11:48:38.019 WAT [8461] LOG:  logical replication apply worker for subscription "XXX has started

All working fine a few days ago but this morning I have this issue.

--
Jaurès FOUTE
Curiously the slot is not dropped.

Le sam. 27 mars 2021 à 20:31, Atul Kumar <akumar14871@gmail.com> a écrit :
As per your error, it seems replication slot has been dropped.

On Saturday, March 27, 2021, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:
Hello EveryOne,

How can I solve Issue. ???

ERROR:  could not start WAL streaming: ERROR:  replication slot "XXX" does not exist
2021-03-27 11:48:33.012 WAT [1090] LOG:  background worker "logical replication worker" (PID 8458) exited with exit code 1
2021-03-27 11:48:38.019 WAT [8461] LOG:  logical replication apply worker for subscription "XXX has started

All working fine a few days ago but this morning I have this issue.

--
Jaurès FOUTE


--
Jaurès FOUTE
Le dim. 28 mars 2021 à 11:53, FOUTE K. Jaurès <jauresfoute@gmail.com> a écrit :
Curiously the slot is not dropped.


You didn't say the name of the replication slot. Does it have upper case? That's probably the biggest issue with naming objects with PostgreSQL.

Le sam. 27 mars 2021 à 20:31, Atul Kumar <akumar14871@gmail.com> a écrit :
As per your error, it seems replication slot has been dropped.

On Saturday, March 27, 2021, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:
Hello EveryOne,

How can I solve Issue. ???

ERROR:  could not start WAL streaming: ERROR:  replication slot "XXX" does not exist
2021-03-27 11:48:33.012 WAT [1090] LOG:  background worker "logical replication worker" (PID 8458) exited with exit code 1
2021-03-27 11:48:38.019 WAT [8461] LOG:  logical replication apply worker for subscription "XXX has started

All working fine a few days ago but this morning I have this issue.

--
Jaurès FOUTE


--
Jaurès FOUTE


--
Guillaume.