From: | Sameer Thakur-2 <Sameer(dot)Thakur(at)nttdata(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Support for N synchronous standby servers - take 2 |
Date: | 2015-09-12 08:32:37 |
Message-ID: | 1442046757497-5865685.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
I did apply the patch to HEAD and tried to setup basic async replication.But
i got an error. Turned on logging for details below.
Unpatched Primary Log
LOG: database system was shut down at 2015-09-12 13:41:40 IST
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
Unpatched Standby log
LOG: entering standby mode
LOG: redo starts at 0/2000028
LOG: invalid record length at 0/20000D0
LOG: started streaming WAL from primary at 0/2000000 on timeline 1
LOG: consistent recovery state reached at 0/20000F8
LOG: database system is ready to accept read only connections
Patched Primary log
LOG: database system was shut down at 2015-09-12 13:50:17 IST
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: server process (PID 17317) was terminated by signal 11: Segmentation
fault
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2015-09-12 13:50:18
IST
FATAL: the database system is in recovery mode
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: invalid record length at 0/3000098
LOG: redo is not required
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: server process (PID 17343) was terminated by signal 11: Segmentation
fault
LOG: terminating any other active server processes
Patched Standby log
LOG: database system was interrupted; last known up at 2015-09-12 13:50:16
IST
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
LOG: entering standby mode
LOG: redo starts at 0/2000028
LOG: invalid record length at 0/20000D0
LOG: started streaming WAL from primary at 0/2000000 on timeline 1
FATAL: could not receive data from WAL stream: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
FATAL: could not connect to the primary server: FATAL: the database system
is in recovery mode
Not sure if there is something i am missing which causes this.
regards
Sameer
--
View this message in context: http://postgresql.nabble.com/Support-for-N-synchronous-standby-servers-take-2-tp5849384p5865685.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Olshevskiy | 2015-09-12 09:25:30 | typo in create policy doc |
Previous Message | Pavel Stehule | 2015-09-12 06:52:13 | Re: Review: check existency of table for -t option (pg_dump) when pattern... |