Re: shared_buffers > 284263 on OS X

On 5-Dec-06, at 4:10 PM, Tom Lane wrote:
> Brian Wipf <brian@clickspace.com> writes:
>> shared_buffers can now be set as high as shmmax without getting the
>> error message "could not create shared memory segment...". Now,
>> however, when shared_buffers are set greater than 279212 a
>> segmentation fault occurs on startup of PostgreSQL.
>
> Stack trace please?

Normally, when something crashes in OS X, I get a stack trace in the /
Library/Logs/CrashReporter/crashdump.crash.log. Unfortunately, the
only stack trace in crashdump.crash.log appears to be for
CrashReporter itself crashing. A guess is that crashreporterd is only
32-bit and can't handle generating a report for the crash of a 64-bit
program.

# file /usr/libexec/crashreporterd
/usr/libexec/crashreporterd: Mach-O executable ppc

Running gdb on the only generated core file shows:

/cores root# gdb /usr/local/pgsql/bin/postgres core.708
GNU gdb 6.3.50-20050815 (Apple version gdb-573) (Fri Oct 20 15:54:33
GMT 2006)
Core was generated by `/usr/libexec/crashdump'.
#0  0x00000000fffeff20 in ?? ()
(gdb) bt
#0  0x00000000fffeff20 in ?? ()
Cannot access memory at address 0xbffffa8000000000
#1  0x000000009293d968 in ?? ()
Cannot access memory at address 0xbffffa8000000000
Cannot access memory at address 0xbffffa8000000010

which appears to be for Crash Reporter crashing. Any idea how I might
be able to get a useful stack trace?

All crashdump.crash.log shows is:

Host Name:      Hulk1
Date/Time:      2006-12-05 23:36:51.928 +0000
OS Version:     10.4.8 (Build 8L127)
Report Version: 4

Command: crashdump
Path:    /usr/libexec/crashdump
Parent:  crashreporterd [112]

Version: ??? (???)

PID:    708
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_INVALID_ADDRESS (0x0001) at 0x789421ff

Thread 0 Crashed:
0   <<00000000>>        0xfffeff20 objc_msgSend_rtp + 32
1   com.apple.Foundation        0x9293d968 NSPopAutoreleasePool + 536
2   crashdump                   0x00005c58 0x1000 + 19544
3   crashdump                   0x00005cec 0x1000 + 19692
4   crashdump                   0x00002954 0x1000 + 6484
5   crashdump                   0x000027f8 0x1000 + 6136

Thread 0 crashed with PPC Thread State 64:
   srr0: 0x00000000fffeff20 srr1:
0x100000000000f030                        vrsave: 0x0000000000000000
     cr: 0x44000234          xer: 0x0000000000000000   lr:
0x000000009293d968  ctr: 0x0000000000000001
     r0: 0x0000000000000001   r1: 0x00000000bffff620   r2:
0x00000000789421ff   r3: 0x0000000000308bc0
     r4: 0x0000000090aa8904   r5: 0x0000000001800000   r6:
0xffffffffffffffff   r7: 0x0000000001807400
     r8: 0x0000000000000001   r9: 0x0000000000030000  r10:
0x0000000000000005  r11: 0x000000006f548904
    r12: 0x000000000000357b  r13: 0x0000000000000000  r14:
0x0000000000000000  r15: 0x0000000000000000
    r16: 0x0000000000000000  r17: 0x0000000000000000  r18:
0x0000000000000000  r19: 0x0000000000000000
    r20: 0x0000000000000000  r21: 0x0000000000000000  r22:
0x0000000000000000  r23: 0x0000000000000000
    r24: 0x0000000000000000  r25: 0x0000000000306990  r26:
0x0000000000010000  r27: 0x0000000000000001
    r28: 0x0000000000010000  r29: 0x0000000000308bc0  r30:
0x000000000000d02c  r31: 0x000000009293d764

Binary Images Description:
     0x1000 -     0xbfff crashdump       /usr/libexec/crashdump
0x8fe00000 - 0x8fe51fff dyld 45.3       /usr/lib/dyld
0x90000000 - 0x901bcfff libSystem.B.dylib       /usr/lib/
libSystem.B.dylib
0x90214000 - 0x90219fff libmathCommon.A.dylib   /usr/lib/system/
libmathCommon.A.dylib
0x9021b000 - 0x90268fff com.apple.CoreText 1.0.2 (???)  /System/
Library/Frameworks/ApplicationServices.framework/Versions/A/
Frameworks/CoreText.framework/Versions/A/CoreText
...
...
0x94281000 - 0x94281fff com.apple.audio.units.AudioUnit 1.4     /
System/Library/Frameworks/AudioUnit.framework/Versions/A/AudioUnit
0x94283000 - 0x94456fff com.apple.QuartzCore 1.4.9      /System/
Library/Frameworks/QuartzCore.framework/Versions/A/QuartzCore
0x944ac000 - 0x944e9fff libsqlite3.0.dylib      /usr/lib/
libsqlite3.0.dylib
0x944f1000 - 0x94541fff libGLImage.dylib        /System/Library/
Frameworks/OpenGL.framework/Versions/A/Libraries/libGLImage.dylib
0x945d2000 - 0x94614fff com.apple.vmutils 4.0.2 (93.1)  /System/
Library/PrivateFrameworks/vmutils.framework/Versions/A/vmutils