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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Aditya Toshniwal
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"
Reply | Threaded
Open this post in threaded view
|

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

Aditya Toshniwal
++hackers.

On Mon, Feb 24, 2020 at 12:16 PM Aditya Toshniwal <[hidden email]> wrote:
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"


--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
Reply | Threaded
Open this post in threaded view
|

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

Andres Freund

Hi,

On 2020-02-24 12:16:08 +0530, Aditya Toshniwal wrote:
> The PG 12.2 server is crashing on setting the jit_above_cost param. Below
> is the output.

> 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.

This isn't reproducible here. Are you sure that you're running on a
clean installation?

If not, we'd at least need a backtrace to figure out what's going on.

Greetings,

Andres Freund


Reply | Threaded
Open this post in threaded view
|

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

Imre Samu
In reply to this post by Aditya Toshniwal
>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."
Regards,
Imre


Aditya Toshniwal <[hidden email]> 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"