pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
Date: Wed, 27 Jun 2018 11:34:14 -0400
Message-ID: <2E8EE382-0E75-4919-87CF-5EABCD26D3F3@crazybean.net> (raw)
In-Reply-To: <CA+t6e1mwWg0SCR0d=0fH-+YxnLwjB-_UKkhvGEvsGM9MS8jFkw@mail.gmail.com>
References: <CA+t6e1kS=B5G4KiRXDnZMexrMd9uH4iC6gd++82Qj6r0cE7f9g@mail.gmail.com>
	<A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net>
	<CAGHTAeOzne+6nXhOTpBRs_ggeZBc1yBhqv9_j1kdQQk=L=MGyw@mail.gmail.com>
	<e333fa64-3722-c947-ca26-762a10a481f6@gmail.com>
	<CA+t6e1n0moY-sVxgKn+giq=q-zV89nVVxdyyp5_W1QrwbXAN8Q@mail.gmail.com>
	<70C74E85-F24B-4930-8942-5662540E0B74@crazybean.net>
	<CA+t6e1mwWg0SCR0d=0fH-+YxnLwjB-_UKkhvGEvsGM9MS8jFkw@mail.gmail.com>



> On Jun 27, 2018, at 6:02 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
> 
> Hi all,
> it happened again. The weird thing is that when I query pg_stat_replication I see only one slave(the one that is still synced) and I dont see the second one. Moreover,  I dont see anything in the repmgr log of the primary and in the slave regarding the disconnection...
> 

Right, once it drops out of replication it no longer shows up in pg_stat_replication — it is a live view of current active connections.

Does the replica report that the WAL has already been removed from primary?  If so most likely due to a spike in WAL file generation where the setting wal_keep_segment is too low; However, I’m still confused about your setup.  Is the replica on the same subnet and what is the network usages? Any large activity happening on the system, i.e. index rebuilds?  How many WALs where generated when the replica dropped out?








view thread (10+ messages)  latest in thread

Message-ID: <2E8EE382-0E75-4919-87CF-5EABCD26D3F3@crazybean.net>
Permalink:  ../2E8EE382-0E75-4919-87CF-5EABCD26D3F3@crazybean.net/
Also on:    postgresql.org/message-id/2E8EE382-0E75-4919-87CF-5EABCD26D3F3@crazybean.net

 · 

reply
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-admin@postgresql.org
  Cc: rui@crazybean.net, mariel.cherkassky@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
  In-Reply-To: <2E8EE382-0E75-4919-87CF-5EABCD26D3F3@crazybean.net>

* 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