Re: server resetting - Mailing list pgsql-general

From Tom Lane
Subject Re: server resetting
Date
Msg-id 28287.1158594141@sss.pgh.pa.us
Whole thread Raw
In response to server resetting  (Geoffrey <esoteric@3times25.net>)
Responses Re: server resetting  (Geoffrey <esoteric@3times25.net>)
List pgsql-general
Geoffrey <esoteric@3times25.net> writes:
> Program terminated with signal 11, Segmentation fault.
> #0  exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
>          in pl_exec.c
> #0  exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> #1  0x0083f005 in exec_stmts (estate=0xfeff8a90, stmts=0x90fa9e0)
>      at pl_exec.c:903
> #2  0x0083f4f2 in exec_stmt_if (estate=0xfeff8a90, stmt=0x90fab78)
>      at pl_exec.c:1139

It seems you've got a corrupt "compiled statements" data structure for
a plpgsql trigger function.  Offhand this does not look like any of the
known post-7.4.7 bug fixes.  Can you show us the source code for that
trigger?

            regards, tom lane

pgsql-general by date:

Previous
From: "Brandon Aiken"
Date:
Subject: Re: server resetting
Next
From: "Alberto Molteni"
Date:
Subject: Restore data from old installation