Re: Segmentation fault postgres 9.6

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Segmentation fault postgres 9.6
Date: 2018-09-17 14:04:05
Message-ID: 18073.1537193045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-09-17 14:04:44 Re: Segmentation fault postgres 9.6
Previous Message Stephen Frost 2018-09-17 14:03:29 Re: Big image tables maintenance