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.cherkassky@xxxxxxxxx>:
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@xxxxxxxxxxxxxxx>: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
