Date: Mon, 17 Sep 2018 23:28:12 +0200 (CEST)
From: 066ce286@free.fr
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Message-ID: 
 <267397260.583976168.1537219692795.JavaMail.root@zimbra82-e14.priv.proxad.net>
In-Reply-To: 
 <CA+t6e1kumaZXmkd-TzR=7sgGjFSG616p+zyOSQ1i9=0EV5OgZQ@mail.gmail.com>
Subject: Re: Segmentation fault postgres 9.6
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

I do have the same problem with a simple select max() from foreign_table wh=
ere...

Syslog said the the mysql fdw lib segfaulted.

I've tried to compile the mysql_fdw sources ; but still same problem.


----- Mail original -----
De: "Mariel Cherkassky" <mariel.cherkassky@gmail.com>
=C3=80: pgsql-admin@lists.postgresql.org
Envoy=C3=A9: Lundi 17 Septembre 2018 14:15:44
Objet: Segmentation fault postgres 9.6


Hi,=20
I'm trying to insert a few values into a foreign table via sqllite_fdw and =
my postgresql database crushes :=20

2018-09-17 12:09:54 UTC 43444 LOG: server process (PID 43831) was terminate=
d by signal 11: Segmentation fault=20
2018-09-17 12:09:54 UTC 43444 DETAIL: Failed process was running: insert in=
to vip_foreign values (2,2,2);=20
2018-09-17 12:09:54 UTC 43444 LOG: terminating any other active server proc=
esses=20
2018-09-17 12:09:54 UTC 43451 WARNING: terminating connection because of cr=
ash of another server process=20
2018-09-17 12:09:54 UTC 43451 DETAIL: The postmaster has commanded this ser=
ver process to roll back the current transaction and exit, because another =
server process exited abnormally and possibly corrupted shared memory.=20
2018-09-17 12:09:54 UTC 43451 HINT: In a moment you should be able to recon=
nect to the database and repeat your command.=20
2018-09-17 12:09:54 UTC 43444 LOG: archiver process (PID 43452) exited with=
 exit code 1=20
2018-09-17 12:09:54 UTC 43444 LOG: all server processes terminated; reiniti=
alizing=20
2018-09-17 12:09:54 UTC 43840 LOG: database system was interrupted; last kn=
own up at 2018-09-17 12:08:35 UTC=20
2018-09-17 12:09:56 UTC 43840 LOG: database system was not properly shut do=
wn; automatic recovery in progress=20
2018-09-17 12:09:56 UTC 43840 LOG: redo starts at 0/6000098=20
2018-09-17 12:09:56 UTC 43840 LOG: invalid record length at 0/60000D0: want=
ed 24, got 0=20
2018-09-17 12:09:56 UTC 43840 LOG: redo done at 0/6000098=20
2018-09-17 12:09:56 UTC 43840 LOG: checkpoint starting: end-of-recovery imm=
ediate=20
2018-09-17 12:09:56 UTC 43840 LOG: checkpoint complete: wrote 0 buffers (0.=
0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=3D0.006 =
s, sync=3D0.000 s, total=3D0.030 s; sync files=3D0, longest=3D0.000 s, aver=
age=3D0.000 s; distance=3D0 kB, estimate=3D0 kB=20
2018-09-17 12:09:56 UTC 43840 LOG: MultiXact member wraparound protections =
are now enabled=20
2018-09-17 12:09:56 UTC 43444 LOG: database system is ready to accept conne=
ctions=20
2018-09-17 12:09:56 UTC 43844 LOG: autovacuum launcher started=20


any idea how can I investigate if the problem in the wrapper or in the data=
base ?