[Pgpool-general] FW: Child process was terminated by segmentation fault

[Tatsuo Ishii]

> We're using pgpool 3.1 with PostgreSQL 8.4.7 on RHEL 5.3 x64 where pgpool is configured for replication only on 2 backends. Pgpool is used by a real time java application which occasionally (without any visible pattern) catches an exception (org.postgresql.util.PSQLException: An I/O error occured while sending to the backend). 
> 
>  
> 
> We've determined that the exception is caused by pgpool as at the same time pgpool records the following error: 
> 
>  
> 
> 2011-11-14 14:14:45 ERROR: pid 10783: Child process 10812 was terminated by segmentation fault
> 
> 2011-11-14 14:14:45 DEBUG: pid 10783: child 10812 exits with status 11 by signal 11
> 
>  
> 
> Bigger chunk of  log file is enclosed as well as the pgpool configuration file.
> 
>  
> 
> After some research on the mailing lists, I found that some patches have been released for version 3.1 which may resolve the issue. So I downloaded and deployed the latest stable release pgpool2-V3_1_STABLE-8b47d55, but it didn't solve the problem. 
> 
>  
> 
> I would appreciate very much if someone could provide any help with this? Thank you in advance,

Can you take a core and show us the backtrace? It will be very helpfull.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp