Re: PostgreSQL crash on Freebsd 7

I tried a clean rebuild as Tom Lane suggested, but this didn't help.
Anyone offers commercial support for solving this problem?

M> Hello.
M> I have problems with Postgres core dumping on FreeBSD7 (RELENG_7)

M> Here is backtrace from gdb postgres postgres.core:

M> (gdb) bt
M> #0  0x485dc277 in kill () from /lib/libc.so.7
M> #1  0x485dc1d6 in raise () from /lib/libc.so.7
M> #2  0x485dadda in abort () from /lib/libc.so.7
M> #3  0x0824c075 in errfinish ()
M> #4  0x0824c8b1 in elog_finish ()
M> #5  0x081c9184 in s_lock ()
M> #6  0x081c8d48 in LWLockAcquire ()
M> #7  0x081c61ec in LockAcquire ()
M> #8  0x081c4289 in LockRelationOid ()
M> #9  0x080938fc in relation_open ()
M> #10 0x08096d5a in index_open ()
M> #11 0x08096139 in systable_beginscan ()
M> #12 0x08134f10 in RelationBuildTriggers ()
M> #13 0x08245d4d in RelationCacheInitializePhase2 ()
M> #14 0x08256af0 in InitPostgres ()
M> #15 0x081cfd13 in PostgresMain ()
M> #16 0x081a90ec in ClosePostmasterPorts ()
M> #17 0x081a9ea7 in PostmasterMain ()
M> #18 0x0816912f in main ()

M> Extract from dmesg:
M> pid 30622 (postgres), uid 70: exited on signal 6 (core dumped)

M> Nothing interesting in other logs.

M> I run FreeBSD 7.0-BETA1 on Dual-Core AMD Opteron(tm) Processor 2216
M> (2394.01-MHz 686-class CPU) with ULE scheduler
M> PostgreSQL 8.2.5

M> I can't find what triggers this behavior (it started core dumping
M> after upgrading from FreeBSD 6.2)

M> Anyone have solution for this problem?



M> Michael


M> ---------------------------(end of
M> broadcast)---------------------------
M> TIP 7: You can help support the PostgreSQL project by donating at

M>                 http://www.postgresql.org/about/donate



Michael