Re: segmentation fault postgres 9.3.5 core dump perlu related ?

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: segmentation fault postgres 9.3.5 core dump perlu related ?
Дата
Msg-id CAFaPBrQBCTsKeq9N7Z4gEYnXcnOgVng0Cy=Uty-V867H+jM04Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: segmentation fault postgres 9.3.5 core dump perlu related ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: segmentation fault postgres 9.3.5 core dump perlu related ?  ("Day, David" <dday@redcom.com>)
Список pgsql-general


On Thu, Jan 29, 2015 at 8:40 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Day, David" <dday@redcom.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?

В списке pgsql-general по дате отправления:

Предыдущее
От: "Sterpu Victor"
Дата:
Сообщение: Re: Subselect with no records results in final empty set
Следующее
От: "Sterpu Victor"
Дата:
Сообщение: Re: Subselect with no records results in final empty set