Hello!

 

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,

 

silvio 
  
Silvio Svečnjak 
Bull, Architect of an Open world (TM) 
Koturaška 69 
10000 Zagreb 
Croatia 
tel. 385.1.631.12.63 
mob. 385.992.187.703 
fax. 385.1.617.08.13 
[email protected] <mailto:[email protected]>  

 

Attachment: pgpool.conf
Description: pgpool.conf

Attachment: pgpool_14_11.log
Description: pgpool_14_11.log

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to