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

From: Steve Singer <steve(at)ssinger(dot)info>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: "snapshot too large" error when initializing logical replication (9.4)
Date: 2014-10-25 22:09:36
Message-ID: BLU437-SMTP100EC1797A336DB6763B10ADC900@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I sometimes get the error "snapshot too large" from my logical
replication walsender process when in response to a CREATE_REPLICATION_SLOT.

This is in SnapBuildExportSnapshot in snapbuild.c

newxcnt is 212 at that point

I have max_connections = 200

procArray->maxProcs=212

Should we be testing
newxcnt > GetMaxSnapshotXidCount()

instead of
newxcnt >= GetMaxSnapshotXidCount()

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Singer 2014-10-25 22:18:07 logical decoding - reading a user catalog table
Previous Message Haribabu Kommi 2014-10-25 21:52:42 Possible problem with shm_mq spin lock