Re: Segmentation Fault PG 14

From: Willian Colognesi <willian_colognesi(at)trimble(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Segmentation Fault PG 14
Date: 2022-11-07 20:29:07
Message-ID: CADAf1kbivJTf0ebP9KzWTRwA--tMk71Ac5MQn-=i7Dg-K54Vzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No, the database is running well, no problem until now after disabled *jit.*

I just realized that he send an email direct to me, the message was:
```
I had similar problems with and the cure was to turn off jit in
Postgres.conf

jit = off
--
Boris
```

On Mon, Nov 7, 2022 at 5:25 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(dot)klaver(at)aklaver(dot)com
>
>

--
<http://www.trimble.com/>

*Willian Cezar de O. Colognesi*
Systems Analysis Specialist, Trimble Transportation Brazil
Avenida Santos Dumont, 271 | Londrina, PR | 86039-090

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-11-07 20:40:40 Re: copy file from a client app to remote postgres isntance
Previous Message Adrian Klaver 2022-11-07 20:25:02 Re: Segmentation Fault PG 14