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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, 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: 2015-03-20 12:41:38
Message-ID: 20150320124137.GJ6317@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 17, 2014 at 03:52:38PM +0100, Andres Freund wrote:
> 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.

Uh, where are we on this?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2015-03-20 12:43:14 Re: PATCH: pgbench - merging transaction logs
Previous Message Bruce Momjian 2015-03-20 12:31:24 Re: Incorrect comment in tablecmds.c