Re: segfaults / backend crashing - Mailing list pgsql-general

I'm having a problem with the backend occasionally crashing.

I have interfaces with the database in two different applications -- a web viewer using JDBC and an insertion routine written using the c libraries.  It makes fairly heavy use of the tsearch protocol.  (I haven't been able to figure out anything repetitious, it happens at different times, and after I get a new connection the exact search query or insertion string works fine).

All that's printed to the postgres log is this:
2003-09-02 10:41:18 [428]    LOG:  server process (pid 479) was terminated by signal 11
2003-09-02 10:41:18 [428]    LOG:  terminating any other active server processes
2003-09-02 10:41:18 [428]    LOG:  all server processes terminated; reinitializing shared memory and semaphores
2003-09-02 10:41:18 [510]    LOG:  database system was interrupted at 2003-09-02 10:17:38 CDT
2003-09-02 10:41:18 [428]    LOG:  all server processes terminated; reinitializing shared memory and semaphores
2003-09-02 10:41:18 [510]    LOG:  database system was interrupted at 2003-09-02 10:17:38 CDT
2003-09-02 10:41:18 [510]    LOG:  checkpoint record is at 0/53E94490
2003-09-02 10:41:18 [510]    LOG:  redo record is at 0/53E94490; undo record is at 0/0; shutdown TRUE
2003-09-02 10:41:18 [510]    LOG:  next transaction id: 127192; next oid: 1562034
2003-09-02 10:41:18 [510]    LOG:  database system was not properly shut down; automatic recovery in progress
2003-09-02 10:41:18 [510]    LOG:  redo starts at 0/53E944D0
2003-09-02 10:41:18 [510]    LOG:  ReadRecord: record with zero length at 0/53EA28E0
2003-09-02 10:41:18 [510]    LOG:  redo done at 0/53EA282C
2003-09-02 10:41:20 [510]    LOG:  database system is ready

The crash log associated with that crash isn't particularly useful, at least to me:
Date/Time:  2003-09-02 10:41:17 -0500
OS Version: 10.2.6 (Build 6L60)
Host:       dahak.local.

Command:    postmaster
PID:        479

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

Thread 0 Crashed:

PPC Thread State:
  srr0: 0xbfffe5e0 srr1: 0x0200f930                vrsave: 0x00000000
   xer: 0x00000000   lr: 0xbfffe5e0  ctr: 0x90010000   mq: 0x00000000
    r0: 0xbfffe5e0   r1: 0xbfffe5d0   r2: 0x8fe4e3e0   r3: 0x00000000
    r4: 0x0088ec1c   r5: 0x00000007   r6: 0x00000006   r7: 0x0088eba4
    r8: 0x0000000c   r9: 0x00000000  r10: 0x004594d4  r11: 0x008a0150
   r12: 0x90010000  r13: 0x00000000  r14: 0x00000000  r15: 0x00000000
   r16: 0x00000000  r17: 0x00000000  r18: 0x00000000  r19: 0x00000000
   r20: 0x00000000  r21: 0x00000000  r22: 0x00000000  r23: 0x00000000
   r24: 0x00000000  r25: 0x00000000  r26: 0xbffffbd4  r27: 0x0000000c
   r28: 0x00000002  r29: 0x00459534  r30: 0x00000000  r31: 0x00000000

One of the crashlogs for the JDBC connection looks like this:
Date/Time:  2003-08-13 01:10:21 -0500
OS Version: 10.2.6 (Build 6L60)
Host:       dahak.local.

Command:    postmaster
PID:        460

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

Thread 0 Crashed:
 #0   0x90010070 in __swsetup
 #1   0x00d9f8d8 in compare
 #2   0x00d9f5a0 in merge
 #3   0x00d9f788 in sort
 #4   0x00d9fbc0 in create_pool
 #5   0x00da1b40 in setup_english_stemmer
 #6   0x00da23f4 in initmorph
 #7   0x00da43c4 in tsearch
 #8   0x00064904 in ExecCallTriggerFunc (trigger.c:1120)
 #9   0x00064a7c in ExecBRInsertTriggers (trigger.c:1171)
 #10  0x00071018 in ExecInsert (execMain.c:1216)
 #11  0x00070ee4 in ExecutePlan (execMain.c:1102)
 #12  0x000701fc in ExecutorRun (execMain.c:195)
 #13  0x000d31dc in ProcessQuery (pquery.c:247)
 #14  0x000d0f8c in pg_exec_query_string (postgres.c:839)
 #15  0x000d24d4 in PostgresMain (postgres.c:2020)
 #16  0x000b379c in DoBackend (postmaster.c:2293)
 #17  0x000b2ff4 in BackendStartup (postmaster.c:1916)
 #18  0x000b1ec0 in ServerLoop (postmaster.c:1006)
 #19  0x000b19f8 in PostmasterMain (postmaster.c:785)
 #20  0x00086670 in main (main.c:210)
 #21  0x00001b58 in _start (crt.c:267)
 #22  0x000019d8 in start

PPC Thread State:
  srr0: 0x90010070 srr1: 0x0200f930                vrsave: 0x00000000
   xer: 0x00000000   lr: 0x90010070  ctr: 0x90003900   mq: 0x00000000
    r0: 0x90010070   r1: 0xbfffe5f0   r2: 0x00000000   r3: 0x000000e3
    r4: 0x00000000   r5: 0x000000e3   r6: 0x0000000a   r7: 0x00000020
    r8: 0x00000030   r9: 0x000000e3  r10: 0x00000060  r11: 0xa00043ac
   r12: 0x90003900  r13: 0x001a0c10  r14: 0x009b4f58  r15: 0xbfffed60
   r16: 0x00d37e00  r17: 0x00000000  r18: 0x00000000  r19: 0x00000000
   r20: 0x00d367e8  r21: 0x00d385f0  r22: 0x00d36958  r23: 0x00d36af8
   r24: 0x00000001  r25: 0x00d36f28  r26: 0x00d36a48  r27: 0x00d385f0
   r28: 0xbfffeaa0  r29: 0x00000000  r30: 0x00daebd5  r31: 0x9001000c

Any help would be appreciated.
Jeffrey Melloy
jmelloy@visualdistortion.org


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
The most reliable support for the most reliable Open Source database.