Core dump

Sparc solaris 2.7 with postgres 7.0.2

It seems to be reproducable, the server crashes on us at a rate of about
every few hours.

Any ideas?

GNU gdb 4.17
Copyright 1998 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 "sparc-sun-solaris2.7"...

warning: core file may not match specified executable file.
Core was generated by `postmaster -i -N 128 -B 512'.
Program terminated with signal 10, Bus Error.
Reading symbols from /usr/lib/libgen.so.1...done.
Reading symbols from /usr/lib/libcrypt_i.so.1...done.
Reading symbols from /usr/lib/libnsl.so.1...done.
Reading symbols from /usr/lib/libsocket.so.1...done.
Reading symbols from /usr/lib/libdl.so.1...done.
Reading symbols from /usr/lib/libm.so.1...done.
Reading symbols from /usr/lib/libcurses.so.1...done.
Reading symbols from /usr/lib/libc.so.1...done.
Reading symbols from /usr/lib/libmp.so.2...done.
Reading symbols from /usr/platform/SUNW,Ultra-2/lib/libc_psr.so.1...done.
Reading symbols from /usr/lib/nss_files.so.1...done.
#0 0xff145fa0 in _morecore ()
(gdb) bt
#0 0xff145fa0 in _morecore ()
#1 0xff1457c8 in _malloc_unlocked ()
#2 0xff1455bc in malloc ()
#3 0x1dd170 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:263
#4 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#5 <signal handler called>
#6 0xff145c04 in realfree ()
#7 0xff14581c in _malloc_unlocked ()
#8 0xff1455bc in malloc ()
#9 0x1dce4c in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:176
#10 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#11 <signal handler called>
#12 0xff19814c in _libc_write ()
#13 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has
d me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#14 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#15 <signal handler called>
#16 0xff19814c in _libc_write ()
#17 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#18 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#19 <signal handler called>
#20 0x1dcf7c in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:205
#21 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#22 <signal handler called>
#23 0xff19814c in _libc_write ()
#24 0x1dd210 in elog (lev=0,
d me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#25 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#26 <signal handler called>
#27 0xff19814c in _libc_write ()
#28 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#29 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#30 <signal handler called>
#31 0xff17e1c0 in _doprnt ()
#32 0xff181d0c in vsnprintf ()
#33 0x1dd100 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:249
#34 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#35 <signal handler called>
#36 0xff19814c in _libc_write ()
#37 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#38 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#39 <signal handler called>
#40 0xff19814c in _libc_write ()
#41 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#42 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#43 <signal handler called>
#44 0xff177d34 in dcgettext_u ()
#45 0xff177cc4 in dgettext ()
#46 0x1dcd84 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:159
#47 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#48 <signal handler called>
#49 0xff19814c in _libc_write ()
#50 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#51 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#52 <signal handler called>
#53 0xff136df0 in strlen ()
#54 0x1dcddc in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:172
#55 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#56 <signal handler called>
#57 0xff19814c in _libc_write ()
#58 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#59 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#60 <signal handler called>
#61 0xff19814c in _libc_write ()
#62 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#63 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#64 <signal handler called>
#65 0xff19814c in _libc_write ()
#66 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#67 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#68 <signal handler called>
#69 0xff19814c in _libc_write ()
#70 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
#71 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#72 <signal handler called>
#73 0xff19814c in _libc_write ()
#74 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#75 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#76 <signal handler called>
#77 0xff19814c in _libc_write ()
#78 0x1dd210 in elog (lev=0,
fmt=0x21a9b0 "Message from PostgreSQL backend:\n\tThe Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.\n\tI have rolled back the current transaction and am going "...)
at elog.c:312
#79 0x1636f8 in quickdie (postgres_signal_arg=16) at postgres.c:713
#80 <signal handler called>
#81 0xff195dd4 in _poll ()
#82 0xff14e79c in select ()
#83 0x14df58 in s_lock_sleep (spin=18) at s_lock.c:62
#84 0x14dfa0 in s_lock (lock=0xff270011 "ÿ", file=0x2197c8 "spin.c", line=127)
at s_lock.c:76
#85 0x154620 in SpinAcquire (lockid=0) at spin.c:127
#86 0x149100 in ReadBufferWithBufferLock (reln=0x2ce4e8, blockNum=4323,
bufferLockHeld=1 '\001') at bufmgr.c:297
#87 0x14a130 in ReleaseAndReadBuffer (buffer=360, relation=0x2ce4e8,
blockNum=4323) at bufmgr.c:900
#88 0x4d5c4 in heapgettup (relation=0x2ce4e8, tuple=0x2d7a60, dir=1,
buffer=0x2d7a8c, snapshot=0x2d7648, nkeys=0, key=0x0) at heapam.c:488
#89 0x4ee00 in heap_getnext (scandesc=0x2d7a48, backw=0) at heapam.c:973
#90 0xc5c40 in SeqNext (node=0x2d6120) at nodeSeqscan.c:101
#91 0xbb674 in ExecScan (node=0x2d6120, accessMtd=0xc5afc <SeqNext>)
at execScan.c:103
#92 0xc5ccc in ExecSeqScan (node=0x2d6120) at nodeSeqscan.c:150
#93 0xb7a3c in ExecProcNode (node=0x2d6120, parent=0x2d6120)
at execProcnode.c:268
#94 0xb589c in ExecutePlan (estate=0x2d7858, plan=0x2d6120,
operation=CMD_SELECT, offsetTuples=0, numberTuples=0,
direction=ForwardScanDirection, destfunc=0x2d7698) at execMain.c:1052
#95 0xb47bc in ExecutorRun (queryDesc=0x2d7a30, estate=0x2d7858, feature=3,
limoffset=0x0, limcount=0x0) at execMain.c:291
#96 0x165bd8 in ProcessQueryDesc (queryDesc=0x2d7a30, limoffset=0x0,
limcount=0x0) at pquery.c:310
#97 0x165c90 in ProcessQuery (parsetree=0x2d5470, plan=0x2d6120, dest=Remote)
at pquery.c:353
#98 0x163650 in pg_exec_query_dest (
query_string=0x26b3d8 "SELECT campid, login, pass FROM ppc_campaigns WHERE login = 'xxx' AND pass = 'xxx'", dest=Remote, aclOverride=0 '\000')
at postgres.c:663
#99 0x163404 in pg_exec_query (
query_string=0x26b3d8 "SELECT campid, login, pass FROM ppc_campaigns WHERE login = 'xxx' AND pass = 'xxx'") at postgres.c:562
#100 0x1650ac in PostgresMain (argc=6, argv=0xffbef198, real_argc=6,
real_argv=0xffbefd9c) at postgres.c:1590
#101 0x1319cc in DoBackend (port=0x279360) at postmaster.c:2009
#102 0x13117c in BackendStartup (port=0x279360) at postmaster.c:1776
#103 0x12f6c4 in ServerLoop () at postmaster.c:1037
#104 0x12ec34 in PostmasterMain (argc=6, argv=0xffbefd9c) at postmaster.c:725
#105 0xd8abc in main (argc=6, argv=0xffbefd9c) at main.c:93

--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde