[Pgpool-general] pgpool-II child process is segfaulting

[Lazaro Rubén García Martinez]

Hello Tatsuo, How I can download the latest stable release of pgpool-II 3.1, with the latest modifications developed?

Regards.

-----Mensaje original-----
De: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-bounces at pgfoundry.org] En nombre de Tatsuo Ishii
Enviado el: jueves, 27 de octubre de 2011 07:56
Para: Ronny.Winkler at communardo.de
CC: pgpool-general at pgfoundry.org
Asunto: Re: [Pgpool-general] pgpool-II child process is segfaulting

Can you try CVS HEAD?

After 3.1 released, I have committed some fixes regarding memory handling.
For your convenience I have attached patches.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hallo,
> 
> we have a Java application that is executing a larger sequence of SQL operations including table manipulations and content modifications within one connection. When we are running these operations through pgpool-II, the pgpool child process handling it always dies with a segmentation fault. But it's not always the same SQL Statement that is causing the segfault.
> 
> Our setup is as follows:
> - pgpool-II-3.1 on a Linux-x86_64 server. We also encountered the segmentation fault with pgpool-II-3.0.4 before trying out version 3.1.
> - the pgpool configuration is reduced to a minimum, that is the connection cache, the master slave and the load balance mode are off. The replication mode is enabled but only one backend is defined.
> - PostgreSQL server version is 9.0.4
> - the Java application uses the postgreSQL JDBC driver in version 9.0.801
> 
> Do you have an idea what might be causing this behavior?
> 
> For some additional details I attached a backtrace. I can also provide the debug messages of the child process, if you want to have look at them.
> 
> Thanks in advance.
> 
> Ronny