BUG #13143: Cannot stop and restart a streaming server with a replication slot

Поиск
Список
Период
Сортировка
От pdrolet@infodata.ca
Тема BUG #13143: Cannot stop and restart a streaming server with a replication slot
Дата
Msg-id 20150424101006.2556.60897@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Следующее
От: postgresql2@realityexists.net
Дата:
Сообщение: BUG #13148: Unexpected deferred EXCLUDE constraint violation on derived table