Re: Segmentation fault postgres 9.6 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Segmentation fault postgres 9.6
Date
Msg-id 18073.1537193045@sss.pgh.pa.us
Whole thread Raw
In response to Segmentation fault postgres 9.6  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: Segmentation fault postgres 9.6  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:
> I'm trying to insert a few values into a foreign table via sqllite_fdw and
> my postgresql database crushes :
> ...
> any idea how can I investigate if the problem in the wrapper or in the
> database ?

Get a stack trace:

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

If the trace shows that the failure occurred in code of the wrapper,
I'd definitely blame the wrapper.  If sqllite_fdw is nowhere to be seen
anywhere in the trace, then it's more debatable.

            regards, tom lane


pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Big image tables maintenance
Next
From: Shreeyansh Dba
Date:
Subject: Re: Segmentation fault postgres 9.6