Re: sqlite_fdw crashes & errors

the core content :

Core was generated by `postgres: postgres afa [local] INSERT '.
Program terminated with signal 11, Segmentation fault.
#0 0x00007f128d3269df in __strlen_sse42 () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install
audit-libs-2.4.5-6.el6.x86_64 cyrus-sasl-lib-2.1.23-15.el6_6.2.x86_64
glibc-2.12-1.212.el6.x86_64 keyutils-libs-1.4-5.el6.x86_64
krb5-libs-1.10.3-65.el6.x86_64 libcom_err-1.41.12-24.el6.x86_64
libselinux-2.0.94-7.el6.x86_64 libxml2-2.7.6-21.el6_8.1.x86_64
nspr-4.19.0-1.el6.x86_64 nss-3.36.0-8.el6.x86_64
nss-softokn-freebl-3.14.3-23.3.el6_8.x86_64 nss-util-3.36.0-1.el6.x86_64
openldap-2.4.40-16.el6.x86_64 openssl-1.0.1e-57.el6.x86_64
pam-1.1.1-24.el6.x86_64 sqlite-3.6.20-1.el6_7.2.x86_64
zlib-1.2.3-29.el6.x86_64

(gdb) bt
#0 0x00007f128d3269df in __strlen_sse42 () from /lib64/libc.so.6
#1 0x00000000007fdac1 in MemoryContextStrdup (context=0x1fd61d0,
string=0x0) at mcxt.c:1155
#2 0x00007f11c1800e24 in sqlitefdw_report_error (elevel=<value optimized
out>, stmt=0x20013f8, conn=<value optimized out>, sql=0x0, rc=1) at
connection.c:288
#3 0x00007f11c1804efe in sqliteExecForeignInsert (estate=<value optimized
out>, resultRelInfo=<value optimized out>, slot=0x200a338, planSlot=<value
optimized out>) at sqlite_fdw.c:1167
#4 0x00000000005e8e89 in ExecInsert (node=0x200a008) at
nodeModifyTable.c:332
#5 ExecModifyTable (node=0x200a008) at nodeModifyTable.c:1512
#6 0x00000000005ceb28 in ExecProcNode (node=0x200a008) at
execProcnode.c:396
#7 0x00000000005cc62a in ExecutePlan (queryDesc=0x2001018,
direction=<value optimized out>, count=0) at execMain.c:1566
#8 standard_ExecutorRun (queryDesc=0x2001018, direction=<value optimized
out>, count=0) at execMain.c:338
#9 0x00000000006e491f in ProcessQuery (plan=0x1fec8f8,
sourceText=0x1fbbf18 "insert into vip_foreign_3_22 values (2,2,2);",
params=0x0, dest=<value optimized out>, completionTag=0x7ffec280b960 "")
at pquery.c:187
#10 0x00000000006e4b6a in PortalRunMulti (portal=0x2004a78, isTopLevel=1
'\001', setHoldSnapshot=0 '\000', dest=0x1fec9d8, altdest=0x1fec9d8,
completionTag=0x7ffec280b960 "") at pquery.c:1303
#11 0x00000000006e5234 in PortalRun (portal=0x2004a78,
count=9223372036854775807, isTopLevel=1 '\001', dest=0x1fec9d8,
altdest=0x1fec9d8, completionTag=0x7ffec280b960 "") at pquery.c:815
#12 0x00000000006e1ed1 in exec_simple_query (query_string=0x1fbbf18 "insert
into vip_foreign_3_22 values (2,2,2);") at postgres.c:1086
#13 0x00000000006e359c in PostgresMain (argc=<value optimized out>,
argv=<value optimized out>, dbname=0x1f0eb78 "afa", username=<value
optimized out>) at postgres.c:4072
#14 0x0000000000682ed5 in BackendRun (argc=<value optimized out>,
argv=<value optimized out>) at postmaster.c:4342
#15 BackendStartup (argc=<value optimized out>, argv=<value optimized out>)
at postmaster.c:4016
#16 ServerLoop (argc=<value optimized out>, argv=<value optimized out>) at
postmaster.c:1721
#17 PostmasterMain (argc=<value optimized out>, argv=<value optimized ou

‫בתאריך יום ג׳, 18 בספט׳ 2018 ב-14:37 מאת ‪Mariel Cherkassky‬‏ <‪
mariel(dot)cherkassky(at)gmail(dot)com‬‏>:‬

> 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(dot)kirkwood(at)catalyst(dot)net(dot)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(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
>>
>