<div>Pgpool: 3.2.1</div><div>Postgresql: 9.1.6</div><div>mode: statement replication</div><div><br></div><div>We are seeing some segfault from pgpool child process.</div><div><br></div><div>pgpool.log :</div><div>2013-02-15 00:29:29 ERROR: pid 4478: Child process 4972 was terminated by segmentation fault</div>
<div><br></div><div>postgresql log :</div><div>[2013-02-15 00:29:29.482 KST][10.10.10.31(59440)][smailrealdb][smail_dml][[unknown]][5712][08P01]LOG: unexpected EOF on client connection</div><div><br></div><div>jboss log :</div>
<div>00:29:29,491 INFO [STDOUT] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.</div><div><br></div><div>Through these logs, I just guess that...</div><div>1. Receiving a request from jboss, pgpool terminates the child process and throws segfaults exception.</div>
<div>2. The postgresql complains about Unexpected EOF on the client.</div><div>3. Jboss prints out the error "An I/O error occured while sending to the backend."</div><div><br></div><div>I have got some research on my own and found some possibilities...</div>
<div>1. pgpool goes down with jboss running?</div><div>- No.</div><div><br></div><div>2. Have you killed child process or done pg_terminate_backend?</div><div>- Yes, might be though, the segfaults occurs periodically.</div>
<div><br></div><div>Is there another possibilities? If so, how can I fix it?</div><div><br></div><div>Any adivce would be very appreciated..</div><div><br></div><div>The logs and configures are attached.</div>