Michael <michael@gameservice.ru> writes:
> Here is backtrace from gdb postgres postgres.core:
> (gdb) bt
> #0 0x485dc277 in kill () from /lib/libc.so.7
> #1 0x485dc1d6 in raise () from /lib/libc.so.7
> #2 0x485dadda in abort () from /lib/libc.so.7
> #3 0x0824c075 in errfinish ()
> #4 0x0824c8b1 in elog_finish ()
> #5 0x081c9184 in s_lock ()
> #6 0x081c8d48 in LWLockAcquire ()
> #7 0x081c61ec in LockAcquire ()
Apparently s_lock_stuck ... though you might want to look at
postmaster's stderr output to confirm that.
> I run FreeBSD 7.0-BETA1 on Dual-Core AMD Opteron(tm) Processor 2216
> (2394.01-MHz 686-class CPU) with ULE scheduler
> PostgreSQL 8.2.5
> I can't find what triggers this behavior (it started core dumping
> after upgrading from FreeBSD 6.2)
Did you recompile Postgres? Maybe you need to. I dunno what the
differences are between 6.2 and 7 ...
regards, tom lane