Re: "snapshot too large" error when initializing logical replication (9.4)

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Steve Singer <steve(at)ssinger(dot)info>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "snapshot too large" error when initializing logical replication (9.4)
Date: 2014-11-17 14:51:54
Message-ID: 20141117145154.GZ1791@alvin.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund wrote:
> Hi,
>
> On 2014-10-25 18:09:36 -0400, Steve Singer wrote:
> > I sometimes get the error "snapshot too large" from my logical replication
> > walsender process when in response to a CREATE_REPLICATION_SLOT.
>
> Yes. That's possible if 'too much' was going on until a consistent point
> was reached. I think we can just use a much larger size for the array
> if necessary.
>
> I've attached patch for this. Could you try whether that helps? I don't
> have a testcase handy that reproduces the problem.

You haven't pushed this, have you?

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-11-17 14:52:38 Re: "snapshot too large" error when initializing logical replication (9.4)
Previous Message Sawada Masahiko 2014-11-17 14:07:46 Re: Proposal : REINDEX SCHEMA