Re: BUG #8410: out of binary heap slots

On 2013-08-30 23:00:15 +0200, Andres Freund wrote:
> Hi,
>
>
> On 2013-08-30 20:46:27 +0000, terje(at)elde(dot)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