Postgres Pro
Downloads
Home   >   mailing lists

BUG #13143: Cannot stop and restart a streaming server with a replication slot - Mailing list pgsql-bugs

From pdrolet@infodata.ca
Subject BUG #13143: Cannot stop and restart a streaming server with a replication slot
Date
Msg-id 20150424101006.2556.60897@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13143
Logged by:          Patrice Drolet
Email address:      pdrolet@infodata.ca
PostgreSQL version: 9.4.1
Operating system:   Windows 2008r2
Description:

I have experienced it many times. The master streams to the slave for days
and no problem (using a replication slot). If I stop the master, it does not
want to restart and I have this error in the log:

2015-04-24 04:47:12 EDT LOG:  le système de bases de données a été arrêté à
2015-04-24 04:44:37 EDT
2015-04-24 04:47:12 EDT PANIC:  n'a pas pu synchroniser sur disque (fsync)
le fichier « pg_replslot/node_win2012sec/state » : Bad file descriptor
2015-04-24 04:47:12 EDT LOG:  processus de lancement (PID 23180) quitte avec
le code de sortie 3
2015-04-24 04:47:12 EDT LOG:  annulation du démarrage à cause d'un échec
dans le processus de lancement

To restart the server, I have to manually delete the folder in pg_replslot.
But then I need to re build the slave. Not very practical for a multi
gigabyte database.

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Next
From: postgresql2@realityexists.net
Date:
Subject: BUG #13148: Unexpected deferred EXCLUDE constraint violation on derived table