Skip site navigation (1) Skip section navigation (2)

Strange pgsql crash on MacOSX

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Strange pgsql crash on MacOSX
Date: 2006-12-23 02:47:27
Message-ID: 458C98BF.8080101@007Marketing.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I have a dual G4 1.25Ghz with 2GB RAM running Mac OSX 10.4.8 and
PostgreSQL 8.2.0

This only happened to me today and with everything I have tried it 
always happens now - had been running fine before.

The only thing I can think of that has changed in the last few days is I
have installed the last 2 security updates from Apple and the X11 update 
(X11 1.1.3) that Apple released a while ago -

http://www.apple.com/support/downloads/securityupdate2006008ppc.html
http://www.apple.com/support/downloads/securityupdate20060071048clientppc.html

the first one I can't see having anything to do with postgres as it is I
believe only updating Java. The other one updates a few different areas
and may be the culprit.

I can't think of anything else I have changed just recently - certainly 
not in the last couple of days.

To test and try and track down the cause I have restarted my machine 
then started by unzipping the 8.2.0 released source and done the 
following steps (this example is with clean data files and everything 
default - the startup script has been there a while and using pg_ctl 
instead makes no difference) make check passes all test -

./configure --prefix=/usr/local/pgsql
make check
sudo make install
cd /usr/local/pgsql
sudo mkdir data
sudo chown pgsql:pgsql data
sudo chmod 700 data
sudo -u pgsql /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
sudo /Library/StartupItems/PostgreSQL/PostgreSQL start

Then I get the following -
[devbox:~] shane% psql
Welcome to psql 8.2.0, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help with psql commands
        \g or terminate with semicolon to execute query
        \q to quit

postgres=# \q
psql(24931) malloc: *** error for object 0x180a800: incorrect checksum
for freed object - object was probably modified after being freed, break
at szone_error to debug
psql(24931) malloc: *** set a breakpoint in szone_error to debug
Segmentation fault
[devbox:~] shane%

The serverlog gives me -
[devbox:local/pgsql/data] root# cat serverlog
LOG:  database system was shut down at 2006-12-23 12:27:44 CST
LOG:  checkpoint record is at 0/42BEB8
LOG:  redo record is at 0/42BEB8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/593; next OID: 10820
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready


Apple's crashreporter gives me -

Date/Time:      2006-12-23 12:28:21.499 +1030
OS Version:     10.4.8 (Build 8L127)
Report Version: 4

Command: psql
Path:    /usr/local/pgsql/bin/psql
Parent:  tcsh [294]

Version: ??? (???)

PID:    24931
Thread: 0

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

Thread 0 Crashed:
0   libSystem.B.dylib 	0x90006cd8 szone_free + 3148
1   libSystem.B.dylib 	0x900152d0 fclose + 176
2   libedit.2.dylib   	0x96b5c334 history_end + 1632
3   libedit.2.dylib   	0x96b5c7bc history + 468
4   libedit.2.dylib   	0x96b5ec58 write_history + 84
5   psql              	0x00008350 saveHistory + 208
6   psql              	0x00008428 finishInput + 120
7   libSystem.B.dylib 	0x90014578 __cxa_finalize + 260
8   libSystem.B.dylib 	0x90014444 exit + 36
9   psql              	0x00001d00 _start + 764
10  psql              	0x00001a00 start + 48

Thread 0 crashed with PPC Thread State 64:
   srr0: 0x0000000090006cd8 srr1: 0x000000000000d030
    vrsave: 0x0000000000000000
     cr: 0x42002444          xer: 0x0000000020000001   lr:
0x0000000090006ca4  ctr: 0x00000000900143a0
     r0: 0x0000000090006ca4   r1: 0x00000000bffff610   r2:
0x0000000042002442   r3: 0x000000000000000d
     r4: 0x0000000000000000   r5: 0x000000000000000d   r6:
0x0000000080808080   r7: 0x0000000000000003
     r8: 0x0000000039333100   r9: 0x00000000bffff545  r10:
0x0000000000000000  r11: 0x0000000042002442
    r12: 0x00000000900143a0  r13: 0x0000000000000000  r14:
0x0000000000000000  r15: 0x0000000000000000
    r16: 0x0000000000000000  r17: 0x0000000000000052  r18:
0x0000000000000400  r19: 0x0000000000000054
    r20: 0x00000000020000a4  r21: 0x000000000180a800  r22:
0x00000000a0001fac  r23: 0x00000000020000a8
    r24: 0x0000000000000002  r25: 0x0000000000000002  r26:
0x0000000000000001  r27: 0x0000000034306167
    r28: 0x0000000001800000  r29: 0x000000000180a400  r30:
0x000000002e616767  r31: 0x00000000900060a0

Binary Images Description:
     0x1000 -    0x36fff psql 	/usr/local/pgsql/bin/psql
    0x3f000 -    0x54fff libpq.5.dylib 	/usr/local/pgsql/lib/libpq.5.dylib
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
0x9110f000 - 0x9111dfff libz.1.dylib 	/usr/lib/libz.1.dylib
0x969c3000 - 0x969f1fff libncurses.5.4.dylib 	/usr/lib/libncurses.5.4.dylib
0x96b4d000 - 0x96b63fff libedit.2.dylib 	/usr/lib/libedit.2.dylib

Model: PowerMac3,6, BootROM 4.4.8f2, 2 processors, PowerPC G4  (3.2),
1.25 GHz, 2 GB
Graphics: NVIDIA GeForce4 MX, GeForce4 MX, AGP, 32 MB
Memory Module: DIMM0/J21, 512 MB, DDR SDRAM, PC2600U-25330
Memory Module: DIMM1/J22, 512 MB, DDR SDRAM, PC2600U-25330
Memory Module: DIMM2/J23, 512 MB, DDR SDRAM, PC2600U-25330
Memory Module: DIMM3/J20, 512 MB, DDR SDRAM, PC2600U-25330
AirPort: AirPort, 9.52
Network Service: Built-in Ethernet, Ethernet, en0
PCI Card: pci-bridge, pci, SLOT-3
PCI Card: firewire, ieee1394, 1x0
PCI Card: usb, usb, 1x1
PCI Card: usb, usb, 1x1
PCI Card: pci167e,225a, , 1x1
Parallel ATA Device: LITE-ON DVD SOHD-167T,
Parallel ATA Device: WDC WD1200JB-00FUA0, 111.79 GB
Parallel ATA Device: IBM-IC35L120AVVA07-0, 115.04 GB
USB Device: Apple Pro Keyboard, Mitsumi Electric, Up to 1.5 Mb/sec, 500 mA
USB Device: i350, Canon, Up to 12 Mb/sec, 500 mA
FireWire Device: unknown_device, unknown_value, Up to 400 Mb/sec



-- 

Shane Ambler
pgSQL(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-12-23 03:42:23
Subject: Re: Operator class group proposal
Previous:From: Bruce MomjianDate: 2006-12-23 01:59:22
Subject: Re: Patch(es) to expose n_live_tuples and

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group