On Tue, Jul 16, 2019 at 8:22 PM Tomas Vondra <tomas.von...@2ndquadrant.com> wrote: > On Mon, Jul 15, 2019 at 08:20:00PM -0500, Jerry Sievers wrote: > >>>>>We have a reproduceable case of $subject that issues a backtrace such as > >>>>>seen below.
> >>>>>#0 initscan (scan=scan@entry=0x55d7a7daa0b0, key=0x0, > >>>>>keep_startblock=keep_startblock@entry=1 '\001') > >>>>> at > >>>>> /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/access/heap/heapam.c:233 > >>>>>#1 0x000055d7a72fa8d0 in heap_rescan (scan=0x55d7a7daa0b0, > >>>>>key=key@entry=0x0) at > >>>>>/build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/access/heap/heapam.c:1529 > >>>>>#2 0x000055d7a7451fef in ExecReScanSeqScan > >>>>>(node=node@entry=0x55d7a7d85100) at > >>>>>/build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/nodeSeqscan.c:280 > >>>>>#3 0x000055d7a742d36e in ExecReScan (node=0x55d7a7d85100) at > >>>>>/build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/execAmi.c:158 > >>>>>#4 0x000055d7a7445d38 in ExecReScanGather > >>>>>(node=node@entry=0x55d7a7d84d30) at > >>>>>/build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/nodeGather.c:475 > >>>>>#5 0x000055d7a742d255 in ExecReScan (node=0x55d7a7d84d30) at > >>>>>/build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/execAmi.c:166 Here's a query that rescans a gather node repeatedly on 9.6 in case it helps someone build a repro, but it works fine here. -- Thomas Munro https://enterprisedb.com
test.sql
Description: application/sql
