Multiple Crashs on OSX Intel

From: Marc Simonin <m(dot)simonin(at)allibert-trekking(dot)com>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: Multiple Crashs on OSX Intel
Date: 2007-01-31 13:19:12
Message-ID: C1E655E0.9549%m.simonin@allibert-trekking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Hello !

Here is the problem :

We have a database that works perfectly on a Xserv G5, 10.4.8. (PPC) , but
encounter multiple postmaster and postgres crashes when we try it on an
intel mac.

We tried on a 10.4.8 intel xserv xeon, and on a 10.4.8 intel macbook pro,
with postgres8.1.5 and 8.2.1 ... with the same issues.

The postmaster is well launched, and no problem is logged.
But after a few times, when the machine begin to have many requests, i can
see almost regular crashes from some postgres or postmaster launched
process.

Postgres log is a bit helpless cause crashes seems to occure "randomly" with
every requests, even with the autovacuum.

The CrashLog log for every crashes one of this two codes

Exception: EXC_BAD_ACCESS (0x0001)
Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x9003b7e0

Exception: EXC_BAD_ACCESS (0x0001)
Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x00000000

I was thinking of some memory problem, so I tried to run the server without
any special configuration in postgresql.conf like shared_buffer (exept
allowing external connections) but, the problem still remains.

I don't know why it works on ppc and not on intel. Must I try to recompile
postgres from the sources with specials options ?

Does anyone have an idea or a hint ?
Thank you in advance !

Marc

PS : This actually occured on these platforms :

CPU : MacbookPro Core2duo & Xserve Xeon (both Intel cpus)
OS Version: 10.4.8 (Build 8N1051) & (Build 8N1215)
Postgres Version : 8.1.5 (Macport & Entropy ports) , 8.2.1 (Entropy port)

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2007-01-31 15:33:49 Re: Multiple Crashs on OSX Intel
Previous Message Tom Lane 2007-01-31 00:16:35 Re: Daylight Saving Time