Re: sqlite_fdw crashes & errors

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: sqlite_fdw crashes & errors
Date: 2018-09-18 08:59:37
Message-ID: 170c1a6b-651a-4ae8-6ea3-4ce1ab54275f@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On 18/09/18 20:36, Mariel Cherkassky wrote:
> I used version 3.6.24 maybe this is the reason ?
> Moreover, I got a core dump and the output is :
> root(at)node1_priviledged data]# gdb -q -c core
> [New Thread 15599]
>
> warning: no loadable sections found in added symbol-file
> system-supplied DSO at 0x7ffec2934000
> Core was generated by `postgres: postgres afa [local] INSERT            '.
> Program terminated with signal 11, Segmentation fault.
> #0  0x00007f128d3269df in ?? ()
>
>

You might need the debug symbols packages installed for Sqlite and
Postgres (how to do this depends on your OS).

The version difference is worth eliminating as a factor - maybe spin up
a VM of Ubuntu 18.04 and test (or build Sqlite 3.22 on your OS with dev
headers and libs etc). BTW , what is your OS and HW? (could be a factor)!

regards
Mark

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Francesco Vecchio 2018-09-18 11:08:12 Problems when initdb on AIX 5.3
Previous Message Mariel Cherkassky 2018-09-18 08:36:45 Re: sqlite_fdw crashes & errors