Search Postgresql Archives

Re: segmentation fault postgres 9.3.5 core dump perlu related ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for the inputs,  I’ll attempt to apply it and will update when I have some new information. 

 

Thanks

 

 

Dave

 

From: Alex Hunsaker [mailto:badalex@xxxxxxxxx]
Sent: Thursday, January 29, 2015 3:30 PM
To: Day, David
Cc: pgsql-general@xxxxxxxxxxxxxx; Tom Lane
Subject: Re: [GENERAL] segmentation fault postgres 9.3.5 core dump perlu related ?

 

 

 

On Thu, Jan 29, 2015 at 8:40 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

"Day, David" <dday@xxxxxxxxxx> 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?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux