Re: BUG #8410: out of binary heap slots

From: Terje Elde <terje(at)elde(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8410: out of binary heap slots
Date: 2013-08-30 21:31:36
Message-ID: 24B0C54D-10A1-4B75-B4E9-1F2B0B4DC60C@elde.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Aug 30, 2013, at 11:23 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Sounds like a bug all right, but I'm not convinced it explains Terje's
> report. The thing this theory doesn't explain is why would Terje be
> having trouble reproducing the failure? Seems like re-running the same
> query ought to produce the same failure.

Same query, but possibly different context.

The query originally runs as part of a larger stored procedure.

(mailing the thing out in a separate mail, omitting the list for that part)

Other than the context, the explain analyze was run with the same parameters as the failed query (copypasted from the logged failure). It's possibly that execution might be different as I ran it perhaps half an hour later. Possible, but not likely.

Terje

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2013-08-30 21:44:29 Re: BUG #8410: out of binary heap slots
Previous Message Andres Freund 2013-08-30 21:30:12 Re: BUG #8410: out of binary heap slots