Re: segmentation fault postgres 9.3.5 core dump perlu related ?

On Thu, Jan 29, 2015 at 8:40 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Day, David" <dday(at)redcom(dot)com> writes:
> > I am amending the info threads info there are two threads.
>
> Well, that's your problem right there. There should never, ever be more
> than one thread in a Postgres backend process: none of the code in the
> backend is meant for a multithreaded situation, and so there are no
> interlocks on global variable access etc.
>

One thing you might try is setting a breakpoint on pthread_create (or
perhaps clone?) and see if that gives any clues as to what is spawning the
thread. If that doesn't help, I would try commenting out large chunks of
the plperlu function until the break point is not tripped, trying to find
what line causes it. It might also be interesting to see what happens if
you try with a non thread enabled perl-- but AFAICT nothing in
cc.get_sip_id() should cause threads to be used. A very quick grep of the
perl source seems to confirm this. Maybe something in the URI module?