From: | Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | How to continue streaming replication after this error? |
Date: | 2014-02-21 08:17:47 |
Message-ID: | 53070BAB.30102@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
one of our streaming replicas died with
2014-02-21 05:17:10 UTC PANIC: heap2_redo: unknown op code 32
2014-02-21 05:17:10 UTC CONTEXT: xlog redo UNKNOWN
2014-02-21 05:17:11 UTC LOG: startup process (PID 1060) was terminated
by signal 6: Aborted
2014-02-21 05:17:11 UTC LOG: terminating any other active server processes
2014-02-21 05:17:11 UTC WARNING: terminating connection because of
crash of another server process
2014-02-21 05:17:11 UTC DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2014-02-21 05:17:11 UTC HINT: In a moment you should be able to
reconnect to the database and repeat your command.
Now, if I try to restart it, I get this:
The PostgreSQL server failed to start. Please check the log output:
2014-02-21 07:42:53 UTC LOG: database system was interrupted while in
recovery at log time 2014-02-21 05:02:45 UTC
2014-02-21 07:42:53 UTC HINT: If this has occurred more than once some
data might be corrupted and you might need to choose an earlier recovery
target.
2014-02-21 07:42:53 UTC LOG: incomplete startup packet
2014-02-21 07:42:53 UTC LOG: entering standby mode
2014-02-21 07:42:53 UTC LOG: redo starts at 11C/B2211778
2014-02-21 07:42:53 UTC FATAL: the database system is starting up
2014-02-21 07:42:54 UTC LOG: consistent recovery state reached at
11C/B4234108
2014-02-21 07:42:54 UTC LOG: database system is ready to accept read
only connections
2014-02-21 07:42:54 UTC PANIC: heap2_redo: unknown op code 32
2014-02-21 07:42:54 UTC CONTEXT: xlog redo UNKNOWN
2014-02-21 07:42:54 UTC LOG: startup process (PID 38187) was terminated
by signal 6: Aborted
2014-02-21 07:42:54 UTC LOG: terminating any other active server processes
This is 9.3.2. What is the supposed way to continue replication? Or do I
need to start from a fresh base backup?
Thanks,
Torsten
From | Date | Subject | |
---|---|---|---|
Next Message | loref85 | 2014-02-21 13:50:43 | Read tables of sql server with postgres |
Previous Message | James Harper | 2014-02-21 06:26:27 | Re: semi-variable length type |