Re: Segmentation Fault PG 14 - Mailing list pgsql-general

On 11/7/22 12:15, Willian Colognesi wrote:
> All the extensions installed in this database are these:
> ```
>                                       List of installed extensions
>          Name        | Version |   Schema   |                       
>   Description
> --------------------+---------+------------+-----------------------------------------------------------
>   amcheck            | 1.3     | public     | functions for verifying
> relation integrity
>   btree_gist         | 1.6     | public     | support for indexing
> common datatypes in GiST
>   pg_stat_statements | 1.9     | public     | track execution statistics
> of all SQL statements executed
>   pgcrypto           | 1.3     | public     | cryptographic functions
>   plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
> (5 rows)
> ```
>
> I tried to execute a query with parameters the query was supposed to be
> run (because I'm not sure exactly the values in the where clause that
> made the segmentation fault).
>
> here is the explain: https://explain.depesz.com/s/Tql3
> <https://explain.depesz.com/s/Tql3> (Ps: I just had to suppress the real
> table/index names)
>
> Looks like since I've disable *jit* as Boris told, until now the
> database did not restarted again... (not sure if it's coincidence)
>

I did not see that post or suggestion.

What was the suggestion?

Are you saying the database does not start up now?

--
Adrian Klaver
adrian.klaver@aklaver.com