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)
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 |