Re: PG v12.2 - Setting jit_above_cost is causing the server to crash

From: Imre Samu <pella(dot)samu(at)gmail(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PG v12.2 - Setting jit_above_cost is causing the server to crash
Date: 2020-02-24 07:44:33
Message-ID: CAJnEWwngkTqHC0C2BMxvJ2R5Pu4EReZ4CS5XexkbOsG=QEpNpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

>PostgreSQL 12.2 ...
>compiled by Apple LLVM version 6.0(clang-600.0.54)* (based on LLVM 3.5svn)*

this LLVM is >= 3.9 ?

according to the docs : "Build with support for LLVM based JIT compilation
.... *The minimum required version of LLVM is currently 3.9.*"
https://www.postgresql.org/docs/12/install-procedure.html
Regards,
Imre

Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> ezt írta (időpont:
2020. febr. 24., H, 7:46):

> Hi Team,
>
> The PG 12.2 server is crashing on setting the jit_above_cost param. Below
> is the output.
>
> postgres=# select version();
>
> version
>
>
>
> ----------------------------------------------------------------------------------------------------------------------------
>
> PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM version
> 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit
>
> (1 row)
>
>
> postgres=# SET jit_above_cost=10;
>
> SET
>
> postgres=# SELECT count(*) FROM pg_class;
>
> server closed the connection unexpectedly
>
> This probably means the server terminated abnormally
>
> before or while processing the request.
>
> The connection to the server was lost. Attempting reset: Failed.
>
> !>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message dbatoCloud Solution 2020-02-24 10:12:26 test
Previous Message Aditya Toshniwal 2020-02-24 07:35:19 Re: PG v12.2 - Setting jit_above_cost is causing the server to crash

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2020-02-24 08:01:26 Re: Error on failed COMMIT
Previous Message Aditya Toshniwal 2020-02-24 07:35:19 Re: PG v12.2 - Setting jit_above_cost is causing the server to crash