[pgpool-general: 1659] Can't promote to another master.

Tue Apr 23 23:48:35 JST 2013

Hello again.

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.

Replication and failover work OK. However, when I try to promote a new master, it fails.

Initial state (in psql):

postgres=# show pool_nodes;
 node_id | hostname | port | status | lb_weight |  role   
---------+----------+------+--------+-----------+---------
 0       | pstgr01  | 5432 | 2      | 0.500000  | primary
 1       | pstgr02  | 5432 | 2      | 0.500000  | standby
(2 rows)

I then run:

postgres at pool01:~$ /usr/sbin/pcp_promote_node 10 localhost 9898 postgres [password] 1

Checking the nodes now gives me:

postgres at pool01:~$ /usr/sbin/pcp_node_info 10 localhost 9898 postgres [password] 0
pstgr01 5432 3 0.500000
postgres at pool01:~$ /usr/sbin/pcp_node_info 10 localhost 9898 postgres [password] 1
pstgr02 5432 2 0.500000

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".

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.

Can anybody explain how this should work and what I should look for?

Thank you,
Herouth

(Here is the log after sending the promote command, until it changes the status on node 0 to 3)

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
Apr 23 16:56:37 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler called
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: starting to select new master node
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: starting promotion. promote host pstgr02(5432)
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: Restart all children
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17620
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17619
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17621
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17622
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17623
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17624
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17625
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17626
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17627
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17628
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17629
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17630
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17631
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17632
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17633
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17634
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17635
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17636
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17637
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17638
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17639
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17640
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17641
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17642
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17643
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17644
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17645
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17646
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17647
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17648
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17649
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17217: failover_handler: kill 17651
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: starting follow degeneration. shutdown host pstgr01(5432)
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: failover: 1 follow backends have been degenerated
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: failover: set new primary node: 1
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 LOG:   pid 17217: failover: set new master node: 1
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17620: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17619: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17621: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17622: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17623: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17624: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17625: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17626: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17627: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17628: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17629: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17630: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17631: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17632: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17633: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17634: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17635: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17636: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17637: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17638: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17639: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17640: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17641: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17642: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17643: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17644: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17645: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17646: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17647: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17648: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:37 DEBUG: pid 17649: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17651: child received shutdown request signal 3
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17681: I am 17681
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17682: I am 17682
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17683: I am 17683
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17684: I am 17684
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17678: I am 17678
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17679: I am 17679
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17680: I am 17680
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17680: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17685: I am 17685
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17686: I am 17686
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17686: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17687: I am 17687
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17684: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17678: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17682: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17683: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17688: I am 17688
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17681: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17685: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17689: I am 17689
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17679: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17687: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17688: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17689: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17691: I am 17691
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17692: I am 17692
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17692: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17694: I am 17694
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17695: I am 17695
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17693: I am 17693
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17693: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17691: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17694: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17690: I am 17690
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17695: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17697: I am 17697
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17698: I am 17698
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17699: I am 17699
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17699: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17700: I am 17700
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17700: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17701: I am 17701
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17690: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17696: I am 17696
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17697: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17698: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17701: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17702: I am 17702
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17704: I am 17704
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17705: I am 17705
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17696: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17706: I am 17706
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17707: I am 17707
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17707: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17703: I am 17703
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17703: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17702: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 LOG:   pid 17650: worker process received restart request
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 LOG:   pid 17217: promotion done. promoted host pstgr02(5432)
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17704: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17705: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17706: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17709: I am 17709
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17709: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17708: I am 17708
Apr 23 16:56:38 pool01 pgpool: 2013-04-23 16:56:38 DEBUG: pid 17708: pool_initialize_private_backend_status: initialize backend status
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG:   pid 17618: pcp child process received restart request
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()
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()
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler called
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler: call wait3
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17619 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17620 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17621 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17622 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17623 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17624 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17625 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17626 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17627 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17628 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17629 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17630 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17631 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17632 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17633 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17634 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17635 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17636 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17637 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17638 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17639 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17640 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17641 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17642 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17643 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17644 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17645 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17646 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17647 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17648 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17649 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG:   pid 17217: worker child 17650 exits with status 256
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 LOG:   pid 17217: fork a new worker child pid 17711
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: child 17651 exits with status 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17217: reap_handler: normally exited
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: I am 17711
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: pool_initialize_private_backend_status: initialize backend status
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
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: auth kind: 0
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: backend key data received
Apr 23 16:56:39 pool01 pgpool: 2013-04-23 16:56:39 DEBUG: pid 17711: s_do_auth: transaction state: I
Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: starting health checking
Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: health_check: 0 th DB node status: 3
Apr 23 16:56:40 pool01 pgpool: 2013-04-23 16:56:40 DEBUG: pid 17217: health_check: 1 th DB node status: 2

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130423/4617b7ae/attachment-0001.html>