Re: sqlite_fdw crashes & errors

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: sqlite_fdw crashes & errors
Дата
Msg-id CA+t6e1=PHY0S9h6mvPn6A6EFn7trUsq3+uvcx9=JfqzkthesZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sqlite_fdw crashes & errors  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: sqlite_fdw crashes & errors  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-admin
I installed the 3.22 version but got the same crash on the postgresql side. I'm using CentOS release 6.10.
What is HW ?  can you guide me regarding the debug symbols ?

‫בתאריך יום ג׳, 18 בספט׳ 2018 ב-11:59 מאת ‪Mark Kirkwood‬‏ <‪mark.kirkwood@catalyst.net.nz‬‏>:‬
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@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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Francesco Vecchio
Дата:
Сообщение: Problems when initdb on AIX 5.3
Следующее
От:
Дата:
Сообщение: PG Install Best Practices