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

Herouth Maoz herouth at unicell.co.il
Mon Apr 29 21:20:17 JST 2013


Can anybody offer me any advice on this?

Herouth

On 23/04/2013, at 17:48, Herouth Maoz wrote:

> 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
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


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


More information about the pgpool-general mailing list