Re: BUG #19108: Stack overflow duting query parse - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19108: Stack overflow duting query parse
Date
Msg-id 1879801.1762790568@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #19108: Stack overflow duting query parse  (Andrey Zhidenkov <pensnarik@gmail.com>)
Responses Re: BUG #19108: Stack overflow duting query parse
List pgsql-bugs
Andrey Zhidenkov <pensnarik@gmail.com> writes:
>> Can you create a self-contained SQL script to reproduce this, and post it
>> on this thread with reply-all, please?

> Unfortunately, I cannot reproduce the issue even on an existing 15.7
> node (one that hasn't upgraded) (don't know if it matters, but now it's a
> hot standby node) but there are core dumps and debug info packages
> installed so I can provide more data from core dump.

Could you at least provide a not-mangled-to-the-point-of-incorrectness
version of the query?  The posted one fails with

ERROR:  table name "tablename_v2" specified more than once

and there are other visible bugs in it.  Some clarity about the column
data types would be helpful as well.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump
Next
From: Tom Lane
Date:
Subject: Re: BUG #19107: The hold cursor is unexpectedly released during rollback