Re: [HACKERS] SIGSEGV on CREATE FUNCTION with plpgsql - Mailing list pgsql-hackers

From Wayne Piekarski
Subject Re: [HACKERS] SIGSEGV on CREATE FUNCTION with plpgsql
Date
Msg-id 199908070816.RAA26052@helpdesk.senet.com.au
Whole thread Raw
In response to Re: [HACKERS] SIGSEGV on CREATE FUNCTION with plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Wayne Piekarski <wayne@senet.com.au> writes:
> > So can someone give me some advice? Do you want me to provide a stack dump
> > or something? 
> 
> A stack trace might help --- I'm not sure why you are seeing this
> problem if there are no functions approaching 4k of text.

Ok, I've got a test postgres set up which I used for my profiling so I'll
have a play and get a stack dump and see if I can work out whats causing
this. Been busy lately so haven't had a chance ... more later on this. 

> > Right now I'm reluctant to play with my plpgsql functions because I'm
> > scared its going to die and I wont be able to reload them back in.
> 
> You can play with them in a playpen installation... I wouldn't do that
> sort of testing on a production installation either.  A playpen is
> always a good thing to have.  Note you can put multiple playpens on
> one machine --- all you need is a separate data directory and socket
> number for each one.

I've got multiple testing databases, but due to the random nature of the
problem, the functions will reload normally, but when the pg_dump output
reloads them, it does it in a different order and dies. So it is dependent
on order and a bunch of other things, and so even with testing, I still
can't be sure it won't break the real production database.

I'll have a look through the code and see if I can spot something obvious.
My functions are all <= 1k and so I'm miles away from 2k or 4k problems
with btree indices.

thanks,
Wayne

------------------------------------------------------------------------------
Wayne Piekarski                               Tel:     (08) 8221 5221
Research & Development Manager                Fax:     (08) 8221 5220
SE Network Access Pty Ltd                     Mob:     0407 395 889
222 Grote Street                              Email:   wayne@senet.com.au
Adelaide SA 5000                              WWW:     http://www.senet.com.au



pgsql-hackers by date:

Previous
From: Wayne Piekarski
Date:
Subject: Inefficiencies in COPY command
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Inefficiencies in COPY command