| From: | pdrolet(at)infodata(dot)ca |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #13143: Cannot stop and restart a streaming server with a replication slot |
| Date: | 2015-04-24 10:10:06 |
| Message-ID: | 20150424101006.2556.60897@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13143
Logged by: Patrice Drolet
Email address: pdrolet(at)infodata(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-04-24 13:18:26 | Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated) |
| Previous Message | Kyotaro HORIGUCHI | 2015-04-24 03:54:48 | Re: [BUGS] Failure to coerce unknown type to specific type |