Re: BUG #8410: out of binary heap slots - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #8410: out of binary heap slots
Date
Msg-id 20130830210525.GB8932@awork2.anarazel.de
Whole thread Raw
In response to Re: BUG #8410: out of binary heap slots  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: BUG #8410: out of binary heap slots
Re: BUG #8410: out of binary heap slots
Re: BUG #8410: out of binary heap slots
Re: BUG #8410: out of binary heap slots
List pgsql-bugs
On 2013-08-30 23:00:15 +0200, Andres Freund wrote:
> Hi,
>
>
> On 2013-08-30 20:46:27 +0000, terje@elde.net wrote:
> > I'm getting "out of binary heap slots", which offcourse spoils the fun of
> > the query.
>
> > Explain analyze gives this plan (again anonymized a bit, but can send proper
> > off-list):
>
> Since I reviewed the patch that introduced that message, I'd be
> interested in getting that. Ideally in a state where I can reproduce the
> issue in a new cluster.

No need, found the bug. And I think can build a testcase myself.

ExecReScanMergeAppend resets ms_initialized, but doesn't clear the
binaryheap. Thus no new elements fit.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #8410: out of binary heap slots
Next
From: Terje Elde
Date:
Subject: Re: BUG #8410: out of binary heap slots