The table definition is:
CREATE TABLE opr_track_and_trace
(
id serial NOT NULL,
item_no character varying(100) NOT NULL,
carrier_account_code character varying(50) NOT NULL,
source_id bigint,
source_desc character varying(50),
carrier_id character varying(20),
carrier_desc character varying(50),
reference_code character varying(50),
date_processed character varying(50),
track_and_trace_id bigint,
consignment_no character varying(100),
date_assigned timestamp without time zone NOT NULL,
track_and_trace_type_id bigint,
track_and_trace_desc character varying(100),
event_code character varying(100),
event_description character varying(100),
work_type character varying(50),
source_name character varying(50),
login_name character varying(25),
user_name character varying(50),
site_code character varying(50),
site_id character varying(50),
site_name character varying(50),
details character varying(255),
note character varying(255),
signatory character varying(100),
signatory_date character varying(100),
associated_xml character varying(1000),
associated_data_id character varying(255),
associated_data_name character varying(255),
associated_data_barcode character varying(255),
associated_data_text character varying(255),
product_type_name character varying(255),
event_transaction_id character varying(100),
created_datetime timestamp without time zone DEFAULT now(),
modified_datetime timestamp without time zone,
modified_by character varying(30),
external_group_id character varying(30),
consignment_reference character varying(255),
customer_account_number character varying(255),
success_failure character varying(20),
CONSTRAINT opr_track_and_trace_pkey PRIMARY KEY (id )
)
WITH (
OIDS=FALSE
);
(
id serial NOT NULL,
item_no character varying(100) NOT NULL,
carrier_account_code character varying(50) NOT NULL,
source_id bigint,
source_desc character varying(50),
carrier_id character varying(20),
carrier_desc character varying(50),
reference_code character varying(50),
date_processed character varying(50),
track_and_trace_id bigint,
consignment_no character varying(100),
date_assigned timestamp without time zone NOT NULL,
track_and_trace_type_id bigint,
track_and_trace_desc character varying(100),
event_code character varying(100),
event_description character varying(100),
work_type character varying(50),
source_name character varying(50),
login_name character varying(25),
user_name character varying(50),
site_code character varying(50),
site_id character varying(50),
site_name character varying(50),
details character varying(255),
note character varying(255),
signatory character varying(100),
signatory_date character varying(100),
associated_xml character varying(1000),
associated_data_id character varying(255),
associated_data_name character varying(255),
associated_data_barcode character varying(255),
associated_data_text character varying(255),
product_type_name character varying(255),
event_transaction_id character varying(100),
created_datetime timestamp without time zone DEFAULT now(),
modified_datetime timestamp without time zone,
modified_by character varying(30),
external_group_id character varying(30),
consignment_reference character varying(255),
customer_account_number character varying(255),
success_failure character varying(20),
CONSTRAINT opr_track_and_trace_pkey PRIMARY KEY (id )
)
WITH (
OIDS=FALSE
);
From: Pham Ngoc Hai <pngochai@xxxxxxxxx>
To: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, May 14, 2012 12:12 PM
Subject: Postgresql segmentation fault at slot_deform_tuple
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:
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
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.
