Re: logical decoding / rewrite map vs. maxAllocatedDescs
Tomas Vondra <tomas.vondra@2ndquadrant.com>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>,
Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-08-14T21:26:30Z
Lists: pgsql-hackers
On 8/14/18 10:05 AM, Tomas Vondra wrote: > ... > > I take that back - I can reproduce the crashes, both with and without > the patch, all the way back to 9.6. Attached is a bunch of backtraces > from various versions. There's a bit of variability depending on which > pgbench script gets started first (insert.sql or vacuum.sql) - in one > case (when vacuum is started before insert) the crash happens in > InitPostgres/RelationCacheInitializePhase3, otherwise it happens in > exec_simple_query. > > Another observation is that the failing COPY is not necessary, I can > reproduce the crashes without this (so even with wal_level=replica). > BTW I have managed to reproduce this on an old test server. If anyone wants to take a look, I can arrange ssh access to that machine (for trustworthy developers). Let me know. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Close the file descriptor in ApplyLogicalMappingFile
- 43ba5ac6aa48 11.0 landed
- e00f4b68dc87 10.6 landed
- 5257b9bfbafd 9.6.11 landed
- 864ecd716a0d 9.5.15 landed
- ef1ac5b2ad08 9.4.20 landed
- fa73b377ee11 12.0 landed