From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= <zeleny.ales@gmail.com>
cc: David Rowley <dgrowleyml@gmail.com>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17512: Process running query fails with SIGSEV -
 nodeMemoize.c:349
In-reply-to: 
 <CAODqTUY5DqbnSMxmTB2xWKuOd4Ykg8GEJMPA16jUkPsmx75TrQ@mail.gmail.com>
References: <17512-36fa5fab90f48af9@postgresql.org>
 <CAApHDvqohSVm-QgGyJhq6TB1GSN-UeuWdOaQwHTkL6UVQ3xpsg@mail.gmail.com>
 <CAODqTUatpvf7D0e5cykrqEih6j8cGw7NTRLpZhPAZX6+-Ec94Q@mail.gmail.com>
 <CAODqTUY5DqbnSMxmTB2xWKuOd4Ykg8GEJMPA16jUkPsmx75TrQ@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= <zeleny.ales@gmail.com>
	message dated "Tue, 07 Jun 2022 19:04:38 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1264307.1654628854.1@sss.pgh.pa.us>
Date: Tue, 07 Jun 2022 15:07:34 -0400
Message-ID: <1264308.1654628854@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1264308.1654628854%40sss.pgh.pa.us>
Precedence: bulk

> So far, it looks that the query I've been using to prove the SIGSEV works
> fine when I disabled jit by setting
> jit=off

Oh!  So it's (probably) not a Memoize problem, it's an LLVM problem.

> The jit package is postgresql14-llvmjit-14.2-1PGDG.rhel7.x86_64

Hm.  What LLVM version have you got on that machine?  (And I wonder
whether it's the same as what Devrim built this PGDG package against.)

			regards, tom lane