Postgresql 9.0.13 core dump - Mailing list pgsql-general

From Laurentius Purba
Subject Postgresql 9.0.13 core dump
Date
Msg-id CAMfLBnhQ6641yMbij2-7oZKSGMgfnE5V3GGfkvYXOJy8uMRctg@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql 9.0.13 core dump
Re: Postgresql 9.0.13 core dump
Re: Postgresql 9.0.13 core dump
List pgsql-general
Hello all,

I am having core dump on Postgres 9.0.13 with the message "...was terminated by signal 10: Bus error...".

So, I set a PID on the log file to capture specific PID that causing this crash. After, several crashes, I finally got the PID that causing this crash. But I am still not convinced that this process that causing this crash. That is the reason why I sent out this email, hoping anybody can help me or have had this experience before.

Based on the PID on the log file, the crash happened while the application was trying to update a table's field with binary (PDF) content. The datatype of this field is TEXT.

I am using FreeBSD 9.1 host that has 3 database jails. One of them is this database that causing core dump. Other databases are working fine.

Below is the information about the core dump.

Any help is appreciated.

Thanks!
-Laurent


[pgsql@MY-BOX ~]$ gdb postgres data/postgres.core                                                                                                                                                                         
GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "amd64-marcel-freebsd"...(no debugging symbols found)...
Core was generated by `postgres'.
Program terminated with signal 10, Bus error.
Reading symbols from /usr/local/lib/libintl.so.9...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/libintl.so.9
Reading symbols from /usr/local/lib/libxml2.so.5...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/libxml2.so.5
Reading symbols from /usr/lib/libssl.so.6...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libssl.so.6
Reading symbols from /lib/libcrypto.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib/libcrypto.so.6
Reading symbols from /lib/libm.so.5...(no debugging symbols found)...done.
Loaded symbols for /lib/libm.so.5
Reading symbols from /lib/libc.so.7...(no debugging symbols found)...done.
Loaded symbols for /lib/libc.so.7
Reading symbols from /usr/local/lib/libiconv.so.3...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/libiconv.so.3
Reading symbols from /lib/libz.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib/libz.so.6
Reading symbols from /usr/lib/liblzma.so.5...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/liblzma.so.5
Reading symbols from /usr/local/lib/nss_ldap.so.1...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/nss_ldap.so.1
Reading symbols from /usr/local/lib/libldap-2.4.so.8...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/libldap-2.4.so.8
Reading symbols from /usr/local/lib/liblber-2.4.so.8...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/liblber-2.4.so.8
Reading symbols from /usr/lib/libkrb5.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libkrb5.so.10
Reading symbols from /usr/lib/libcom_err.so.5...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libcom_err.so.5
Reading symbols from /usr/lib/libgssapi_krb5.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libgssapi_krb5.so.10
Reading symbols from /usr/lib/libasn1.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libasn1.so.10
Reading symbols from /lib/libcrypt.so.5...(no debugging symbols found)...done.
Loaded symbols for /lib/libcrypt.so.5
Reading symbols from /usr/lib/libhx509.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libhx509.so.10
Reading symbols from /usr/lib/libroken.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libroken.so.10
Reading symbols from /usr/lib/libgssapi.so.10...(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libgssapi.so.10
Reading symbols from /usr/local/lib/postgresql/plpgsql.so...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/postgresql/plpgsql.so
Reading symbols from /usr/local/lib/postgresql/dict_snowball.so...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/postgresql/dict_snowball.so
Reading symbols from /usr/local/lib/postgresql/plperl.so...(no debugging symbols found)...done.
Loaded symbols for /usr/local/lib/postgresql/plperl.so
Reading symbols from /usr/local/lib/perl5/5.14.2/mach/CORE/libperl.so...(no debugging symbols found)...done.                                                                                                             [29/1378]
Loaded symbols for /usr/local/lib/perl5/5.14.2/mach/CORE/libperl.so
Reading symbols from /lib/libthr.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib/libthr.so.3
Reading symbols from /lib/libutil.so.9...(no debugging symbols found)...done.
Loaded symbols for /lib/libutil.so.9
Reading symbols from /libexec/ld-elf.so.1...(no debugging symbols found)...done.
Loaded symbols for /libexec/ld-elf.so.1
#0  0x0000000910d8121b in pthread_mutex_lock () from /lib/libthr.so.3
[New Thread 90f129000 (LWP 119947/postgres)]
(gdb) bt
#0  0x0000000910d8121b in pthread_mutex_lock () from /lib/libthr.so.3
#1  0x0000000800f38635 in xmlRMutexLock () from /usr/local/lib/libxml2.so.5
#2  0x0000000800f877bc in __xmlRandom () from /usr/local/lib/libxml2.so.5
#3  0x0000000800f87859 in xmlDictCreate () from /usr/local/lib/libxml2.so.5
#4  0x0000000800ecb685 in xmlInitParserCtxt () from /usr/local/lib/libxml2.so.5
#5  0x0000000800ecb6fe in xmlNewParserCtxt () from /usr/local/lib/libxml2.so.5
#6  0x000000000068e8d5 in cursor_to_xml ()
#7  0x000000000068eacf in xmlparse ()
#8  0x0000000000544540 in GetAttributeByNum ()
#9  0x000000000054127a in ExecProject ()
#10 0x0000000000547bc4 in ExecScan ()
#11 0x0000000000540d6d in ExecProcNode ()
#12 0x0000000000553ec3 in ExecModifyTable ()
#13 0x0000000000540ddd in ExecProcNode ()
#14 0x000000000053f9cf in standard_ExecutorRun ()
#15 0x000000000055e36b in SPI_saveplan ()
#16 0x000000000055e7ad in SPI_execute_plan_with_paramlist ()
#17 0x000000090d1483ad in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#18 0x000000090d14a3e2 in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#19 0x000000090d14bcff in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#20 0x000000090d14a610 in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#21 0x000000090d149ddb in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#22 0x000000090d14c693 in plpgsql_exec_function () from /usr/local/lib/postgresql/plpgsql.so
#23 0x000000090d142243 in plpgsql_call_handler () from /usr/local/lib/postgresql/plpgsql.so
#24 0x00000000006a79c5 in OidFunctionCall1 ()
#25 0x0000000000544540 in GetAttributeByNum ()
#26 0x000000000054127a in ExecProject ()
#27 0x00000000005559f3 in ExecResult ()
#28 0x0000000000540ded in ExecProcNode ()
#29 0x000000000053f9cf in standard_ExecutorRun ()
#30 0x000000000055e36b in SPI_saveplan ()
#31 0x000000000055e7ad in SPI_execute_plan_with_paramlist ()
#32 0x000000090d146a53 in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#33 0x000000090d149fdd in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#34 0x000000090d149ddb in exec_get_datum_type () from /usr/local/lib/postgresql/plpgsql.so
#35 0x000000090d14c693 in plpgsql_exec_function () from /usr/local/lib/postgresql/plpgsql.so
#36 0x000000090d142243 in plpgsql_call_handler () from /usr/local/lib/postgresql/plpgsql.so
#37 0x00000000006a79c5 in OidFunctionCall1 ()
#38 0x0000000000544540 in GetAttributeByNum ()
#39 0x000000000054127a in ExecProject ()
#40 0x00000000005559f3 in ExecResult ()
#41 0x0000000000540ded in ExecProcNode ()
#42 0x000000000053f9cf in standard_ExecutorRun ()
#43 0x00000000005f3d88 in PostgresMain ()
#44 0x00000000005f5271 in PortalRun ()
#45 0x00000000005f2c60 in PostgresMain ()
#46 0x00000000005c174b in ClosePostmasterPorts ()
#47 0x00000000005c23c7 in PostmasterMain ()
#48 0x000000000056c0fe in main ()
(gdb) quit


pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly
Next
From: Kevin Grittner
Date:
Subject: Re: Postgresql 9.0.13 core dump