Re: Bus error in libxml2 in postgresql 9.2.x on FreeBSD

Hello Steve,
this reminds me the problems i had when trying to install pl/java in postgresql 9.2 FreeBSD :
http://lists.freebsd.org/pipermail/freebsd-java/2013-February/010019.html
http://lists.freebsd.org/pipermail/freebsd-java/2013-February/010021.html
http://lists.freebsd.org/pipermail/freebsd-java/2013-February/010022.html

The solution was to explicit link postgresql with /usr/lib/libpthread.so in src/backend/Makefile

postgres: $(OBJS)
$(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX) $(export_dynamic) $(call expand_subsys,$^) $(LIBS) -lpthread -o $@

Just an advice, you are also likely to find answers for similar problems in FreeBSD lists.

On 16/12/2013 16:41, Steve McCoy wrote:
> Hello,
>
> I found some semi-recent messages related to this in 9.0.x, but wanted to confirm for anybody searching that the same issue exists in 9.2.x. It crashes for me with a similar backtrace as [Laurentius
> Purba’s][1]. The same fix/workaround applies as well: Compile libxml2 without the “threads” option.
>
> If I’m understanding the explanations correctly, the issue is that libxml2+threads expects something to be initialized by the calling program (postgres), but since the program isn’t multithreaded,
> this doesn’t happen. It sounds like something that neither side can really fix, but if I’m wrong and any devs would like a core file, I can provide one.
>
>
> [1] http://www.postgresql.org/message-id/CAMfLBnhQ6641yMbij2-7oZKSGMgfnE5V3GGfkvYXOJy8uMRctg@mail.gmail.com

--
Achilleas Mantzios