Postgresql segmentation fault at slot_deform_tuple

Поиск
Список
Период
Сортировка
От Pham Ngoc Hai
Тема Postgresql segmentation fault at slot_deform_tuple
Дата
Msg-id 1336968768.34492.YahooMailNeo@web164501.mail.gq1.yahoo.com
обсуждение исходный текст
Ответы Re: Postgresql segmentation fault at slot_deform_tuple  (Pham Ngoc Hai <pngochai@yahoo.com>)
Re: Postgresql segmentation fault at slot_deform_tuple  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
I'm running PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 64-bit
on CentOS release 6.2 (Final)
Recently we encountered postmaster segfault, what the core dump gives me is:
===================================================
gdb /usr/pgsql-9.1/bin/postmaster core.27986
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-50.el6)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/pgsql-9.1/bin/postmaster...Reading symbols from /usr/lib/debug/usr/pgsql-9.1/bin/postgres.debug...done.
done.
[New Thread 27986]
Missing separate debuginfo for
Try: yum --disablerepo='*' --enablerepo='*-debuginfo' install /usr/lib/debug/.build-id/b4/1d7cd75a11fc1c03b68d7f9a3ef1ea1edbf200
Reading symbols from /usr/lib64/libxml2.so.2...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libxml2.so.2
Reading symbols from /lib64/libpam.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib64/libpam.so.0
Reading symbols from /usr/lib64/libssl.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libssl.so.10
Reading symbols from /usr/lib64/libcrypto.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libcrypto.so.10
Reading symbols from /lib64/libgssapi_krb5.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libgssapi_krb5.so.2
Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libldap-2.4.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libldap-2.4.so.2
Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/libkrb5.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib64/libkrb5.so.3
Reading symbols from /lib64/libcom_err.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcom_err.so.2
Reading symbols from /lib64/libz.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libz.so.1
Reading symbols from /lib64/libaudit.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libaudit.so.1
Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcrypt.so.1
Reading symbols from /lib64/libk5crypto.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib64/libk5crypto.so.3
Reading symbols from /lib64/libkrb5support.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib64/libkrb5support.so.0
Reading symbols from /lib64/libkeyutils.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libkeyutils.so.1
Reading symbols from /lib64/libresolv.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libresolv.so.2
Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib64/liblber-2.4.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/liblber-2.4.so.2
Reading symbols from /usr/lib64/libssl3.so...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libssl3.so
Reading symbols from /usr/lib64/libsmime3.so...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libsmime3.so
Reading symbols from /usr/lib64/libnss3.so...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libnss3.so
Reading symbols from /usr/lib64/libnssutil3.so...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libnssutil3.so
Reading symbols from /lib64/libplds4.so...(no debugging symbols found)...done.
Loaded symbols for /lib64/libplds4.so
Reading symbols from /lib64/libplc4.so...(no debugging symbols found)...done.
Loaded symbols for /lib64/libplc4.so
Reading symbols from /lib64/libnspr4.so...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnspr4.so
Reading symbols from /usr/lib64/libsasl2.so.2...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libsasl2.so.2
Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done.
[Thread debugging using libthread_db enabled]
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done.
Loaded symbols for /lib64/libfreebl3.so
Reading symbols from /lib64/libselinux.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libselinux.so.1
Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libnss_files.so.2
Core was generated by `postgres: postgres pminterfaces 10.0.8.14(55824) SELECT               '.
Program terminated with signal 11, Segmentation fault.
#0  slot_deform_tuple (slot=0x228aa30, natts=41) at heaptuple.c:1090
1090                                    off = att_align_pointer(off, thisatt->attalign, -1,
Missing separate debuginfos, use: debuginfo-install audit-libs-2.1.3-3.el6.x86_64 cyrus-sasl-lib-2.1.23-13.el6.x86_64 glibc-2.12-1.47.el6_2.9.x86_64 keyutils-libs-1.4-3.el6.x86_64 krb5-libs-1.9-22.el6_2.1.x86_64 libcom_err-1.41.12-11.el6.x86_64 libselinux-2.0.94-5.2.el6.x86_64 libxml2-2.7.6-4.el6_2.4.x86_64 nspr-4.8.9-3.el6_2.x86_64 nss-3.13.1-7.el6_2.x86_64 nss-softokn-freebl-3.12.9-11.el6.x86_64 nss-util-3.13.1-3.el6_2.x86_64 openldap-2.4.23-20.el6.x86_64 openssl-1.0.0-20.el6_2.3.x86_64 pam-1.1.1-10.el6.x86_64 zlib-1.2.3-27.el6.x86_64
(gdb) bt
#0  slot_deform_tuple (slot=0x228aa30, natts=41) at heaptuple.c:1090
#1  0x000000000045634e in slot_getallattrs (slot=0x228aa30) at heaptuple.c:1253
#2  0x0000000000459021 in printtup (slot=0x228aa30, self=0x22759b0) at printtup.c:300
#3  0x0000000000566a3e in ExecutePlan (queryDesc=0x2229670, direction=<value optimized out>, count=0) at execMain.c:1464
#4  standard_ExecutorRun (queryDesc=0x2229670, direction=<value optimized out>, count=0) at execMain.c:313
#5  0x0000000000634577 in PortalRunSelect (portal=0x2225e30, forward=<value optimized out>, count=0, dest=0x22759b0) at pquery.c:943
#6  0x0000000000635848 in PortalRun (portal=0x2225e30, count=9223372036854775807, isTopLevel=1 '\001', dest=0x22759b0, altdest=0x22759b0, completionTag=0x7fffbcb1a6c0 "") at pquery.c:787
#7  0x0000000000631f0b in exec_simple_query (query_string=0x2217330 "select * from opr_track_and_trace limit 100") at postgres.c:1018
#8  0x0000000000632e93 in PostgresMain (argc=<value optimized out>, argv=<value optimized out>, username=<value optimized out>) at postgres.c:3926
#9  0x00000000005f46c9 in BackendRun () at postmaster.c:3606
#10 BackendStartup () at postmaster.c:3291
#11 ServerLoop () at postmaster.c:1455
#12 0x00000000005f6e5c in PostmasterMain (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1116
#13 0x0000000000598a40 in main (argc=5, argv=0x216d400) at main.c:199
===================================================

I've been searching around but the closest I've got to is #6200 and #6425 but it looks different in my case.
Any help would be really appreciated.


В списке pgsql-general по дате отправления:

Предыдущее
От: Evan Martin
Дата:
Сообщение: Re: Why is RELEASE SAVEPOINT sometimes slow?
Следующее
От: Pham Ngoc Hai
Дата:
Сообщение: Re: Postgresql segmentation fault at slot_deform_tuple