Re: PostgreSQL crash on Freebsd 7

do you have a repeatable test case?

I have a FreeBSD 7/amd64 box that I can do the following:

1) make test runs
2) make available to a developer.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

-----Original Message-----
From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Michael
Sent: Thursday, November 01, 2007 4:24 PM
To: Tom Lane
Subject: Re: [BUGS] PostgreSQL crash on Freebsd 7

TL> How repeatable is this --- does it happen on every connection attempt,
TL> or only sometimes? Can you start and stop the postmaster without
TL> any problems being logged?
Only sometimes, 1-4 times per day under high load. Postmaster starts
and stops without problems.

Backtraces are a bit different from time to time, here is last:

(gdb) bt
#0 0x485d8277 in kill () from /lib/libc.so.7
#1 0x485d81d6 in raise () from /lib/libc.so.7
#2 0x485d6dda in abort () from /lib/libc.so.7
#3 0x0824694e in errfinish ()
#4 0x08247a43 in elog_finish ()
#5 0x081c565e in s_lock ()
#6 0x081c522e in LWLockAcquire ()
#7 0x081c15ff in LockRelease ()
#8 0x081c03d3 in UnlockRelationId ()
#9 0x08096824 in index_close ()
#10 0x08095afe in systable_endscan ()
#11 0x08131a88 in RelationBuildTriggers ()
#12 0x08241bc8 in RelationCacheInitializePhase2 ()
#13 0x08251afd in InitPostgres ()
#14 0x081cc789 in PostgresMain ()
#15 0x081a5270 in ClosePostmasterPorts ()
#16 0x081a6741 in PostmasterMain ()
#17 0x081650f2 in main ()

Michael

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend