Re: Segmentation fault postgres 9.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The output of the core : 
[root@node1_priviledged data]# gdb -q -c core
BFD: Warning: /data/pgsql/data/core is truncated: expected core file size >= 3268321280, found: 100470784.
[New Thread 861]
Failed to read a valid object file image from memory.
Core was generated by `postgres: postgres db1 [local] INSERT            '.
Program terminated with signal 11, Segmentation fault.
#0  0x00007fda258499df in ?? ()

Doesnt give me any details that can help me investigate further.  What else can I check ?

‫בתאריך יום ב׳, 17 בספט׳ 2018 ב-17:04 מאת ‪Tom Lane‬‏ <‪tgl@xxxxxxxxxxxxx‬‏>:‬
Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> writes:
> I'm trying to insert a few values into a foreign table via sqllite_fdw and
> my postgresql database crushes :
> ...
> any idea how can I investigate if the problem in the wrapper or in the
> database ?

Get a stack trace:

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

If the trace shows that the failure occurred in code of the wrapper,
I'd definitely blame the wrapper.  If sqllite_fdw is nowhere to be seen
anywhere in the trace, then it's more debatable.

                        regards, tom lane

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux