Re: PostgreSQL crash on Freebsd 7

From: Michael <michael(at)gameservice(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL crash on Freebsd 7
Date: 2007-11-01 18:50:01
Message-ID: 43877923.20071101205001@gameservice.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-01 21:08:30 Re: PostgreSQL crash on Freebsd 7
Previous Message Tiago Daniel Jacobs 2007-11-01 15:17:44 Re: BUG #3479: contraint exclusion and locks