Segmentation fault postgres 9.6

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Segmentation fault postgres 9.6
Date: 2018-09-17 12:15:44
Message-ID: CA+t6e1kumaZXmkd-TzR=7sgGjFSG616p+zyOSQ1i9=0EV5OgZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I'm trying to insert a few values into a foreign table via sqllite_fdw and
my postgresql database crushes :
2018-09-17 12:09:54 UTC 43444 LOG: server process (PID 43831) was
terminated by signal 11: Segmentation fault
2018-09-17 12:09:54 UTC 43444 DETAIL: Failed process was running: insert
into vip_foreign values (2,2,2);
2018-09-17 12:09:54 UTC 43444 LOG: terminating any other active server
processes
2018-09-17 12:09:54 UTC 43451 WARNING: terminating connection because of
crash of another server process
2018-09-17 12:09:54 UTC 43451 DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2018-09-17 12:09:54 UTC 43451 HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2018-09-17 12:09:54 UTC 43444 LOG: archiver process (PID 43452) exited
with exit code 1
2018-09-17 12:09:54 UTC 43444 LOG: all server processes terminated;
reinitializing
2018-09-17 12:09:54 UTC 43840 LOG: database system was interrupted; last
known up at 2018-09-17 12:08:35 UTC
2018-09-17 12:09:56 UTC 43840 LOG: database system was not properly shut
down; automatic recovery in progress
2018-09-17 12:09:56 UTC 43840 LOG: redo starts at 0/6000098
2018-09-17 12:09:56 UTC 43840 LOG: invalid record length at 0/60000D0:
wanted 24, got 0
2018-09-17 12:09:56 UTC 43840 LOG: redo done at 0/6000098
2018-09-17 12:09:56 UTC 43840 LOG: checkpoint starting: end-of-recovery
immediate
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=0.006
s, sync=0.000 s, total=0.030 s; sync files=0, longest=0.000 s,
average=0.000 s; distance=0 kB, estimate=0 kB
2018-09-17 12:09:56 UTC 43840 LOG: MultiXact member wraparound
protections are now enabled
2018-09-17 12:09:56 UTC 43444 LOG: database system is ready to accept
connections
2018-09-17 12:09:56 UTC 43844 LOG: autovacuum launcher started

any idea how can I investigate if the problem in the wrapper or in the
database ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message still Learner 2018-09-17 12:38:33 Big image tables maintenance
Previous Message Nicolas Karolak 2018-09-17 07:44:58 Re: postgresql HA solution for different network domain