Обсуждение: PG v12.2 - Setting jit_above_cost is causing the server to crash
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.
!>
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 ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
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 ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
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
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
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
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
>compiled by Apple LLVM version 6.0(clang-600.0.54) (based on LLVM 3.5svn)
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 ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"