<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Can anybody offer me any advice on this?<div><br></div><div>Herouth</div><div><br><div><div>On 23/04/2013, at 17:48, Herouth Maoz wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hello again.<div><br></div><div>Now that I have upgraded to pgpool 3.2.3 I decided to run a set of tests that show that my single pgpool works well with replication before I attempt to set up two pgpools.</div><div><br></div><div>Replication and failover work OK. However, when I try to promote a new master, it fails.</div><div><br></div><div>Initial state (in psql):</div><div><br></div><div><div><font class="Apple-style-span" color="#2c7b2a">postgres=#</font><font class="Apple-style-span" color="#602185"> show pool_nodes;</font></div><div><font class="Apple-style-span" face="'Courier New'"> node_id | hostname | port | status | lb_weight | role </font></div><div><font class="Apple-style-span" face="'Courier New'">---------+----------+------+--------+-----------+---------</font></div><div><font class="Apple-style-span" face="'Courier New'"> 0 | pstgr01 | 5432 | 2 | 0.500000 | primary</font></div><div><font class="Apple-style-span" face="'Courier New'"> 1 | pstgr02 | 5432 | 2 | 0.500000 | standby</font></div><div><font class="Apple-style-span" face="'Courier New'">(2 rows)</font></div><div><br></div><div>I then run:</div><div><br></div><div><font class="Apple-style-span" color="#2c7b2a">postgres@pool01:~$</font> <font class="Apple-style-span" color="#602185">/usr/sbin/pcp_promote_node 10 localhost 9898 postgres [password] 1</font></div>
<br></div><div>Checking the nodes now gives me:</div><div><br></div><div><font class="Apple-style-span" color="#2c7b2a">postgres@pool01:~$</font> <font class="Apple-style-span" color="#602185">/usr/sbin/pcp_node_info 10 localhost 9898 postgres [password] 0</font></div><div><div>pstgr01 5432 3 0.500000</div><div><font class="Apple-style-span" color="#2c7b2a">postgres@pool01:~$</font> <font class="Apple-style-span" color="#602185">/usr/sbin/pcp_node_info 10 localhost 9898 postgres [password] 1</font></div><div>pstgr02 5432 2 0.500000</div></div><div><br></div><div>Checking the postgresql servers on pstgr01 and pstgr02, I find that they continue to work as before - pstgr01 is still primary and pstgr02 is still standby. Attempting to psql through pgpool and insert into a table gives me "ERROR: cannot execute INSERT in a read-only transaction".</div><div><br></div><div>I suspect that it is not succeeding in shutting down the host at pstgr01, but I haven't found where I can set up the command for shutting down. And I'm not sure why it thinks that server 1 is in status 2, when it is clearly not allowing inserts.</div><div><br></div><div>Can anybody explain how this should work and what I should look for?</div><div><br></div><div><br></div><div>Thank you,</div><div>Herouth</div><div><br></div><div>(Here is the log after sending the promote command, until it changes the status on node 0 to 3)</div><div><br></div><div><div>Apr 23 16:56:37 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17618: promote_backend: 1 promote node request from pid 17618</div><div>Apr 23 16:56:37 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler called</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: starting to select new master node</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: starting promotion. promote host pstgr02(5432)</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: Restart all children</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17620</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17619</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17621</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17622</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17623</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17624</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17625</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17626</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17627</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17628</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17629</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17630</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17631</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17632</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17633</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17634</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17635</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17636</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17637</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17638</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17639</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17640</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17641</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17642</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17643</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17644</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17645</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17646</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17647</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17648</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17649</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17651</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: starting follow degeneration. shutdown host pstgr01(5432)</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: failover: 1 follow backends have been degenerated</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: failover: set new primary node: 1</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG: pid 17217: failover: set new master node: 1</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17620: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17619: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17621: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17622: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17623: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17624: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17625: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17626: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17627: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17628: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17629: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17630: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17631: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17632: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17633: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17634: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17635: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17636: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17637: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17638: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17639: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17640: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17641: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17642: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17643: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17644: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17645: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17646: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17647: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17648: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17649: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17651: child received shutdown request signal 3</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17681: I am 17681</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17682: I am 17682</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17683: I am 17683</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17684: I am 17684</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17678: I am 17678</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17679: I am 17679</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17680: I am 17680</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17680: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17685: I am 17685</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17686: I am 17686</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17686: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17687: I am 17687</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17684: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17678: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17682: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17683: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17688: I am 17688</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17681: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17685: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17689: I am 17689</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17679: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17687: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17688: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17689: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17691: I am 17691</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17692: I am 17692</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17692: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17694: I am 17694</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17695: I am 17695</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17693: I am 17693</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17693: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17691: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17694: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17690: I am 17690</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17695: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17697: I am 17697</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17698: I am 17698</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17699: I am 17699</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17699: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17700: I am 17700</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17700: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17701: I am 17701</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17690: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17696: I am 17696</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17697: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17698: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17701: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17702: I am 17702</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17704: I am 17704</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17705: I am 17705</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17696: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17706: I am 17706</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17707: I am 17707</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17707: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17703: I am 17703</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17703: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17702: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 LOG: pid 17650: worker process received restart request</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 LOG: pid 17217: promotion done. promoted host pstgr02(5432)</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17704: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17705: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17706: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17709: I am 17709</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17709: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17708: I am 17708</div><div>Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17708: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG: pid 17618: pcp child process received restart request</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG: pid 17217: PCP child 17618 exits with status 256 in failover()</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG: pid 17217: fork a new PCP child pid 17710 in failover()</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler called</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler: call wait3</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17619 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17620 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17621 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17622 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17623 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17624 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17625 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17626 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17627 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17628 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17629 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17630 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17631 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17632 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17633 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17634 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17635 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17636 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17637 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17638 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17639 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17640 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17641 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17642 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17643 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17644 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17645 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17646 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17647 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17648 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17649 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG: pid 17217: worker child 17650 exits with status 256</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG: pid 17217: fork a new worker child pid 17711</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17651 exits with status 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler: normally exited</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: I am 17711</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: pool_initialize_private_backend_status: initialize backend status</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: pool_ssl: SSL requested but SSL support is not available</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: auth kind: 0</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: backend key data received</div><div>Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: transaction state: I</div><div>Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: starting health checking</div><div>Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: health_check: 0 th DB node status: 3</div><div>Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: health_check: 1 th DB node status: 2</div><div><br></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></blockquote></div><br>
<br></div></body></html>