Unable to restart barman backup

[P1E33E]

Hello,

My pg_wal was full and my db is ko .

i clean the FS (rm wal file). and i make a pg_receival --reset and i can restart my DB and  all is ok .

But i cant restart barman

 barman receive-wal postgres_12

Starting receive-wal for server postgres_12

postgres_12: pg_receivewal: starting log streaming at 4/55000000 (timeline 1)

postgres_12: pg_receivewal: error: unexpected termination of replication stream: ERROR:  requested WAL segment 000000010000000400000055 has already been removed

postgres_12: pg_receivewal: error: disconnected

ERROR: ArchiverFailure:pg_receivexlog terminated with error code: 1

-bash-4.2$ barman switch-wal --force postgres_12

do you have any idea ?

thanks 

[P1E33E]

Hello i have found the solution

i have drop the slot and reset again

-bash-4.2$ barman receive-wal --reset postgres_12

Resetting receive-wal directory status

Removing status file /backup/barman//postgres_12/streaming/000000010000000400000055.partial

Creating status file /backup/barman//postgres_12/streaming/00000001000000090000006A.partial

and now its OK

[Luca Ferrari]

On Wed, May 19, 2021 at 2:53 PM P1E33E <pdar...@gmail.com> wrote:
> i clean the FS (rm wal file). and i make a pg_receival --reset and i can restart my DB and all is ok .

A very bad idea, because it probably was due to barman not archiving the wals.
Removing the wals should be always the last resort when you have no
other option, and besides, pg_controldata could help finding out the
situation.

> barman receive-wal postgres_12
> Starting receive-wal for server postgres_12
> postgres_12: pg_receivewal: starting log streaming at 4/55000000 (timeline 1)
> postgres_12: pg_receivewal: error: unexpected termination of replication stream: ERROR: requested WAL segment 000000010000000400000055 has already been removed
> postgres_12: pg_receivewal: error: disconnected

The system has noticed the wals break and is unable to process a
stream of wals with a hole within. You have already discovered you
have to start over the backup, and this means your previous backup are
no more valid as continuos ones.

Luca