postmaster core ( finally I have it ) - Mailing list pgsql-hackers

Hi all,
since long time ( in the mean time I did Postgres upgrade four time and
now I'm using 7.3.3 ) I'm having, at least once in a week, a signal 11 on
a backend, and how you can immagine with the subseguent drop of all
connections, finally now I have the core.

The process killed made always the same select ( with different
id_package ):

SELECT id_publisher, publisher_name, id_package, package_name
FROM v_psl_package_info
WHERE id_package = 177;

Here it is:

bash-2.05$ file core
core: ELF 32-bit LSB core file of 'postmaster' (signal 11), Intel 80386,
version 1, from 'postmaster'

bash-2.05$ gdb /usr/bin/postmaster core
GNU gdb Red Hat Linux (5.2-2)
Copyright 2002 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 "i386-redhat-linux"...(no debugging symbols
found)...

warning: core file may not match specified executable file.
Core was generated by `postgres: push empdb 192.168'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libpam.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib/libpam.so.0
Reading symbols from /lib/libssl.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib/libssl.so.2
Reading symbols from /lib/libcrypto.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib/libcrypto.so.2
Reading symbols from /usr/kerberos/lib/libkrb5.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr/kerberos/lib/libkrb5.so.3
Reading symbols from /usr/lib/libz.so.1...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libreadline.so.4
Reading symbols from /lib/libtermcap.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/libm.so.6...done.
Loaded symbols for /lib/libm.so.6
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /usr/kerberos/lib/libcom_err.so.3...done.
Loaded symbols for /usr/kerberos/lib/libcom_err.so.3
Reading symbols from /usr/kerberos/lib/libk5crypto.so.3...done.
Loaded symbols for /usr/kerberos/lib/libk5crypto.so.3
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
#0  0x08171fdd in RelationBuildRuleLock ()
(gdb) where
#0  0x08171fdd in RelationBuildRuleLock ()
#1  0x081722ab in RelationBuildDesc ()
#2  0x0817311c in RelationIdGetRelation ()
#3  0x08077b95 in relation_open ()
#4  0x08077d24 in heap_openrv ()
#5  0x080b1015 in addRangeTableEntry ()
#6  0x080ab6de in transformTableEntry ()
#7  0x080ab942 in transformFromClauseItem ()
#8  0x080ab321 in transformFromClause ()
#9  0x0809f639 in transformSelectStmt ()
#10 0x0809dcc4 in transformStmt ()
#11 0x0809da06 in parse_analyze ()
#12 0x08128a35 in pg_analyze_and_rewrite ()
#13 0x08128ce2 in pg_exec_query_string ()
#14 0x08129fc3 in PostgresMain ()
#15 0x08110344 in DoBackend ()
#16 0x0810fc2d in BackendStartup ()
#17 0x0810ed21 in ServerLoop ()
#18 0x0810e6f9 in PostmasterMain ()
#19 0x080e9cdd in main ()
#20 0x40249336 in __libc_start_main (main=0x80e9ab0 <main>, argc=3,
ubp_av=0xbffffb04, init=0x806b2ec <_init>,   fini=0x8188830 <_fini>, rtld_fini=0x4000d2fc <_dl_fini>,
stack_end=0xbffffafc) at ../sysdeps/generic/libc-start.c:129
(gdb) quit


and here all the activity performed by the process:


Jul 22 20:00:02 sdr2 postgres[25079]: [2896523] LOG:  connection received:
host= xxx.xxx.xxx.xxx port=53809
Jul 22 20:00:02 sdr2 postgres[25079]: [2896524] LOG:  connection authorized:
user=push database=empdb
Jul 22 20:00:02 sdr2 postgres[25079]: [2896525] DEBUG:  /usr/bin/postmaster
child[25079]: starting with (
Jul 22 20:00:02 sdr2 postgres[25079]: [2896526] DEBUG:  ^Ipostgres
Jul 22 20:00:02 sdr2 postgres[25079]: [2896527] DEBUG:  ^I-v131072
Jul 22 20:00:02 sdr2 postgres[25079]: [2896528] DEBUG:  ^I-p
Jul 22 20:00:02 sdr2 postgres[25079]: [2896529] DEBUG:  ^Iempdb
Jul 22 20:00:02 sdr2 postgres[25079]: [2896530] DEBUG:  )
Jul 22 20:00:02 sdr2 postgres[25079]: [2896531] DEBUG:  InitPostgres
Jul 22 20:00:02 sdr2 postgres[25079]: [2896532] DEBUG:
StartTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896533-1] LOG:  query: set datestyle
to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII'
then 'UNKNOWN' else
Jul 22 20:00:02 sdr2 postgres[25079]: [2896533-2]  getdatabaseencoding()
end;
Jul 22 20:00:02 sdr2 postgres[25079]: [2896534] DEBUG:  ProcessUtility
Jul 22 20:00:02 sdr2 postgres[25079]: [2896535] DEBUG:
CommitTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896536] DEBUG:
StartTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896537] DEBUG:  ProcessQuery
Jul 22 20:00:02 sdr2 postgres[25079]: [2896538] DEBUG:
CommitTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896539] LOG:  duration: 0.035168 sec
Jul 22 20:00:02 sdr2 postgres[25079]: [2896540] DEBUG:
StartTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896541] LOG:  query: set
client_encoding = 'UNICODE'; show autocommit
Jul 22 20:00:02 sdr2 postgres[25079]: [2896542] DEBUG:  ProcessUtility
Jul 22 20:00:02 sdr2 postgres[25079]: [2896543] DEBUG:
CommitTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896544] DEBUG:
StartTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896545] DEBUG:  ProcessUtility
Jul 22 20:00:02 sdr2 postgres[25079]: [2896546] DEBUG:
CommitTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896547] LOG:  duration: 0.003609 sec
Jul 22 20:00:02 sdr2 postgres[25079]: [2896548] DEBUG:
StartTransactionCommand
Jul 22 20:00:02 sdr2 postgres[25079]: [2896549] LOG:  query:  SELECT
id_publisher, publisher_name, id_package, package_name  FROM
v_psl_package_info  WHERE id_package = 177


Do you need others informations or may I do something in order
to permit you to isolate the problem ?



Regards
Gaetano