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

[Silvio Svečnjak]

Thanks for your quick response. Dump/trace files are enclosed - I hope they contain the information you need - if not please let me know what else could help you.
Regards,

silvio




-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
Sent: 14. studeni 2011 16:05
To: Silvio Svečnjak
Cc: pgpool-general at pgfoundry.org
Subject: Re: [Pgpool-general] FW: Child process was terminated by segmentation fault

> 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
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dump_backtrace_20294.txt
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111115/ad85580e/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dump_backtrace_20473.txt
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111115/ad85580e/attachment-0001.txt>