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@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893


-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.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