standby database crash

From: "Seong Son (US)" <Seong(dot)Son(at)datapath(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: standby database crash
Date: 2017-07-31 21:15:18
Message-ID: BY2PR17MB032844BB5004388A0D6632E784B20@BY2PR17MB0328.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a client who has streaming replication setup with the primary in one city and standby in another city both identical servers with Postgresql 9.6 on Windows Server 2012.

They have some network issues, which is causing the connection from the primary to standby to drop sometimes. And recently standby crashed with the following log. And it could not be restarted.

2017-07-18 09:21:13 UTC FATAL: invalid memory alloc request size 4148830208
2017-07-18 09:21:14 UTC LOG: startup process (PID 5608) exited with exit code 1
2017-07-18 09:21:14 UTC LOG: terminating any other active server processes
2017-07-18 09:21:14 UTC LOG: database system is shut down

Last entry from the pg_xlogdump shows the following

pg_xlogdump: FATAL: error in WAL record at D5/D1BD5FD0: unexpected pageaddr D1/E7BD6000 in log segment 00000000000000D5000000D1, offset 12410880

So my questions are, could an old WAL segment being resent through the network cause crash like this? Shouldn't Postgresql be able to handle out of order WAL segments instead of just crashing?

And what would be the best way to recover the standby server? Resynching the entire database seems to be too time consuming.

Thanks in advance for any info.

-Seong

Responses

Browse pgsql-general by date

  From Date Subject
Next Message armand pirvu 2017-07-31 21:26:34 upsert and update filtering
Previous Message Scott Marlowe 2017-07-31 21:06:57 Re: Schemas and serials