Michael <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to