Re: PostgreSQL crash on Freebsd 7

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael <michael(at)gameservice(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL crash on Freebsd 7
Date: 2007-10-26 00:15:54
Message-ID: 29394.1193357754@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael <michael(at)gameservice(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael 2007-10-26 00:45:05 Re: PostgreSQL crash on Freebsd 7
Previous Message Alvaro Herrera 2007-10-25 23:40:34 Re: PostgreSQL crash on Freebsd 7