From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Sergey Shchukin <shchukin.s.a@gmail.com>
To: Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
To: pgsql-general@postgresql.org
Subject: Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
Date: Thu, 5 Mar 2015 02:25:42 -0600
Message-ID: <54F81306.9060404@BlueTreble.com> (raw)
In-Reply-To: <54F050D2.7030406@gmail.com>
References: <54EC7FAE.8050003@gmail.com>
<CAJYcdTtmk4bB9eXfEK_YSrqmXMmssJ3NVwTPXNw2UVrtCScoew@mail.gmail.com>
<54EEBC5B.5000402@gmail.com>
<54F03052.6050900@BlueTreble.com>
<54F050D2.7030406@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 2/27/15 5:11 AM, Sergey Shchukin wrote:
>
> show max_standby_streaming_delay;
> max_standby_streaming_delay
> -----------------------------
> 30s
We both need to be more clear about which server we're talking about
(master or replica).
What are max_standby_streaming_delay and max_standby_archive_delay set
to *on the replica*?
My hope is that one or both of those is set to somewhere around 8
minutes on the replica. That would explain everything.
If that's not the case then I suspect what's happening is there's
something running on the replica that isn't checking for interrupts
frequently enough. That would also explain it.
When replication hangs, is the replication process using a lot of CPU?
Or is it just sitting there? What's the process status for the replay
process show?
Can you get a trace of the replay process on the replica when this is
happening to see where it's spending all it's time?
How are you generating these log lines?
Tue Feb 24 15:05:07 MSK 2015 Stream: MASTER-masterdb:79607161592048
SLAVE:79607161550576 Replay:79607160986064 :: REPLAY 592 KBytes
(00:00:00.398376 seconds)
Do you see the confl_* fields in pg_stat_database_conflicts on the
*replica* increasing?
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jim.Nasby@BlueTreble.com, shchukin.s.a@gmail.com, radovan.jablonovsky@replicon.com, pgsql-general@postgresql.org
Subject: Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary
In-Reply-To: <54F81306.9060404@BlueTreble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox