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

  1. Close the file descriptor in ApplyLogicalMappingFile