Re: "snapshot too large" error when initializing logical replication (9.4) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: "snapshot too large" error when initializing logical replication (9.4)
Date
Msg-id 20141117145238.GD27042@awork2.anarazel.de
Whole thread Raw
In response to Re: "snapshot too large" error when initializing logical replication (9.4)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: "snapshot too large" error when initializing logical replication (9.4)  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 2014-11-17 11:51:54 -0300, Alvaro Herrera wrote:
> 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?

No, but it's on my todo list.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: "snapshot too large" error when initializing logical replication (9.4)
Next
From: Robert Haas
Date:
Subject: Re: Wait free LW_SHARED acquisition - v0.2