<div class="gmail_quote">Hi all,<div><br></div><div>I am using pgpool-II for my project. Everything is working fine i.e. automatic failover and online recovery. </div><div><br></div><div>I have two servers, one is master and other is standby. I am directly communicating with pgpool-II which connects with master and standby servers.</div>
<div><br></div><div>Now I am inserting records in database using java on the same port where pgpool-II is running.</div><div><br></div><div>When I killed my master node then my java client also killed before automatic failover. </div>
<div><br></div><div>Logs at pgpool-II</div><div><br></div><div><div>2012-02-06 12:20:00 DEBUG: pid 30348: pool_unset_command_success: done</div><div>2012-02-06 12:20:00 DEBUG: pid 30348: pool_set_failed_transaction: done</div>
<div>2012-02-06 12:20:00 DEBUG: pid 30348: pool_set_ignore_till_sync: done</div><div>2012-02-06 12:20:00 DEBUG: pid 30348: pool_unset_query_in_progress: done</div><div>2012-02-06 12:20:00 LOG: pid 30348: do_child: exits with status 1 due to error</div>
<div>2012-02-06 12:20:00 ERROR: pid 30348: pool_flush_it: write failed to backend (0) . reason: Broken pipe offset: 0 wlen: 5</div>
<div>2012-02-06 12:20:00 DEBUG: pid 30318: reap_handler called</div><div>2012-02-06 12:20:00 DEBUG: pid 30318: reap_handler: call wait3</div><div>2012-02-06 12:20:00 DEBUG: pid 30318: child 30348 exits with status 256</div>
<div>2012-02-06 12:20:00 DEBUG: pid 30318: fork a new child pid 30433</div><div>2012-02-06 12:20:00 DEBUG: pid 30318: reap_handler: normally exited</div><div>2012-02-06 12:20:00 DEBUG: pid 30433: I am 30433</div><div>2012-02-06 12:20:00 DEBUG: pid 30433: pool_initialize_private_backend_status: in itialize backend status</div>
<div>2012-02-06 12:20:06 DEBUG: pid 30318: starting health checking</div><div>2012-02-06 12:20:06 DEBUG: pid 30318: health_check: 0 th DB node status: 2</div><div>2012-02-06 12:20:06 ERROR: pid 30318: connect_inet_domain_socket: connect() fail ed: Connection refused</div>
<div>2012-02-06 12:20:06 ERROR: pid 30318: health check failed. 0 th host localhost a t port 5434 is down</div><div>2012-02-06 12:20:06 LOG: pid 30318: set 0 th backend down status</div>
<div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler called</div><div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: starting to select new m aster node</div>
<div>2012-02-06 12:20:06 LOG: pid 30318: starting degeneration. shutdown host local host(5434)</div><div>2012-02-06 12:20:06 LOG: pid 30318: Restart all children</div>
<div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: kill 30319</div><div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: kill 30320</div><div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: kill 30321</div>
<div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: kill 30322</div><div>2012-02-06 12:20:06 DEBUG: pid 30318: failover_handler: kill 30323</div><div>2012-02-06 12:20:06 DEBUG: pid 30320: child received shutdown request signal 3</div>
<div>2012-02-06 12:20:06 DEBUG: pid 30321: child received shutdown request signal 3</div></div><div><br></div><div>pgpool.conf:</div><div><br></div><div><div>listen_addresses = '*'</div><div>port = 5432</div><div>
pcp_port = 5433</div></div><div><div>num_init_children = 32</div></div><div><div>max_pool = 4</div></div><div><div>child_life_time = 300</div></div><div><div>health_check_timeout = 30</div><div>health_check_period = 10</div>
<div>health_check_user = 'health'</div><div>health_check_password = 'health'</div><div><br></div></div><div>Please tell me am I doing anything wrong?</div><div><br></div><div>Thanks,</div><div>Saurabh</div>
<div><br></div><div><br></div>
</div><br>