[Pgpool-general] Failover shuts down incoming connections
Daniel.Crespo at l-3com.com
Daniel.Crespo at l-3com.com
Thu Jan 15 18:30:02 UTC 2009
Hello,
I finally have a log for what I noticed in the CVS head that I
downloaded one week ago. (Right now I don't have permissions to do a new
download).
I started pgpool-II with -n and -d flags. In addition to this, I started
it with the primary backend stopped. So as soon as it starts, it detects
a failure in backend0, supposing to keep backend1 alive, but it's not
the case: I can connect to pgpool but can't do anything. It says that
the connection is closed, although I'm still in psql. Please, look at
the below log and comments between lines.
-bash-3.1$ pgpool -n -d
2009-01-15 12:56:38 DEBUG: pid 6616: key: listen_addresses
2009-01-15 12:56:38 DEBUG: pid 6616: value: '*' kind: 4
[... loading up pgpool.conf info ...]
2009-01-15 12:56:38 DEBUG: pid 6616: value: '/var/lib/pgsql/data' kind:
4
2009-01-15 12:56:38 DEBUG: pid 6616: num_backends: 2 num_backends: 2
total_weight: 2.000000
2009-01-15 12:56:38 DEBUG: pid 6616: backend 0 weight: 1073741823.500000
2009-01-15 12:56:38 DEBUG: pid 6616: backend 1 weight: 1073741823.500000
2009-01-15 12:56:38 DEBUG: pid 6617: I am 6617
2009-01-15 12:56:38 DEBUG: pid 6618: I am 6618
2009-01-15 12:56:38 DEBUG: pid 6619: I am 6619
2009-01-15 12:56:38 DEBUG: pid 6620: I am 6620
2009-01-15 12:56:38 DEBUG: pid 6621: I am 6621
2009-01-15 12:56:38 DEBUG: pid 6622: I am 6622
2009-01-15 12:56:38 DEBUG: pid 6623: I am 6623
2009-01-15 12:56:38 DEBUG: pid 6624: I am 6624
2009-01-15 12:56:38 DEBUG: pid 6625: I am 6625
2009-01-15 12:56:38 DEBUG: pid 6626: I am 6626
2009-01-15 12:56:38 DEBUG: pid 6627: I am 6627
2009-01-15 12:56:38 DEBUG: pid 6628: I am 6628
2009-01-15 12:56:38 DEBUG: pid 6629: I am 6629
2009-01-15 12:56:38 DEBUG: pid 6630: I am 6630
2009-01-15 12:56:38 DEBUG: pid 6631: I am 6631
2009-01-15 12:56:38 DEBUG: pid 6632: I am 6632
2009-01-15 12:56:38 DEBUG: pid 6633: I am 6633
2009-01-15 12:56:38 DEBUG: pid 6634: I am 6634
2009-01-15 12:56:38 DEBUG: pid 6635: I am 6635
2009-01-15 12:56:38 DEBUG: pid 6636: I am 6636
2009-01-15 12:56:38 DEBUG: pid 6637: I am 6637
2009-01-15 12:56:38 DEBUG: pid 6638: I am 6638
2009-01-15 12:56:38 DEBUG: pid 6639: I am 6639
2009-01-15 12:56:38 DEBUG: pid 6640: I am 6640
2009-01-15 12:56:38 DEBUG: pid 6641: I am 6641
2009-01-15 12:56:38 DEBUG: pid 6642: I am 6642
2009-01-15 12:56:38 DEBUG: pid 6643: I am 6643
2009-01-15 12:56:38 DEBUG: pid 6644: I am 6644
2009-01-15 12:56:38 DEBUG: pid 6645: I am 6645
2009-01-15 12:56:38 DEBUG: pid 6646: I am 6646
2009-01-15 12:56:38 DEBUG: pid 6647: I am 6647
2009-01-15 12:56:38 DEBUG: pid 6648: I am 6648
2009-01-15 12:56:38 DEBUG: pid 6649: I am 6649
2009-01-15 12:56:38 DEBUG: pid 6650: I am 6650
2009-01-15 12:56:38 DEBUG: pid 6651: I am 6651
2009-01-15 12:56:38 DEBUG: pid 6652: I am 6652
2009-01-15 12:56:38 DEBUG: pid 6653: I am 6653
2009-01-15 12:56:38 DEBUG: pid 6654: I am 6654
2009-01-15 12:56:38 DEBUG: pid 6655: I am 6655
2009-01-15 12:56:38 DEBUG: pid 6656: I am 6656
2009-01-15 12:56:38 DEBUG: pid 6657: I am 6657
2009-01-15 12:56:38 DEBUG: pid 6658: I am 6658
2009-01-15 12:56:38 DEBUG: pid 6659: I am 6659
2009-01-15 12:56:38 DEBUG: pid 6660: I am 6660
2009-01-15 12:56:38 DEBUG: pid 6661: I am 6661
2009-01-15 12:56:38 DEBUG: pid 6662: I am 6662
2009-01-15 12:56:38 DEBUG: pid 6663: I am 6663
2009-01-15 12:56:38 DEBUG: pid 6664: I am 6664
2009-01-15 12:56:38 DEBUG: pid 6665: I am 6665
2009-01-15 12:56:38 DEBUG: pid 6666: I am 6666
2009-01-15 12:56:38 DEBUG: pid 6667: I am 6667
2009-01-15 12:56:38 DEBUG: pid 6668: I am 6668
2009-01-15 12:56:38 DEBUG: pid 6669: I am 6669
2009-01-15 12:56:38 DEBUG: pid 6670: I am 6670
2009-01-15 12:56:38 DEBUG: pid 6671: I am 6671
2009-01-15 12:56:38 DEBUG: pid 6672: I am 6672
2009-01-15 12:56:38 DEBUG: pid 6673: I am 6673
2009-01-15 12:56:38 DEBUG: pid 6674: I am 6674
2009-01-15 12:56:38 DEBUG: pid 6675: I am 6675
2009-01-15 12:56:38 DEBUG: pid 6676: I am 6676
2009-01-15 12:56:38 DEBUG: pid 6677: I am 6677
2009-01-15 12:56:38 DEBUG: pid 6678: I am 6678
2009-01-15 12:56:38 DEBUG: pid 6679: I am 6679
2009-01-15 12:56:38 DEBUG: pid 6680: I am 6680
2009-01-15 12:56:38 DEBUG: pid 6681: I am 6681
2009-01-15 12:56:38 DEBUG: pid 6682: I am 6682
2009-01-15 12:56:38 DEBUG: pid 6683: I am 6683
2009-01-15 12:56:38 DEBUG: pid 6684: I am 6684
2009-01-15 12:56:38 DEBUG: pid 6685: I am 6685
2009-01-15 12:56:38 DEBUG: pid 6686: I am 6686
2009-01-15 12:56:38 DEBUG: pid 6687: I am 6687
2009-01-15 12:56:38 DEBUG: pid 6688: I am 6688
2009-01-15 12:56:38 DEBUG: pid 6689: I am 6689
2009-01-15 12:56:38 DEBUG: pid 6690: I am 6690
2009-01-15 12:56:38 DEBUG: pid 6691: I am 6691
2009-01-15 12:56:38 DEBUG: pid 6692: I am 6692
2009-01-15 12:56:38 DEBUG: pid 6693: I am 6693
2009-01-15 12:56:38 DEBUG: pid 6694: I am 6694
2009-01-15 12:56:38 DEBUG: pid 6695: I am 6695
2009-01-15 12:56:38 DEBUG: pid 6696: I am 6696
2009-01-15 12:56:38 DEBUG: pid 6697: I am 6697
2009-01-15 12:56:38 DEBUG: pid 6698: I am 6698
2009-01-15 12:56:38 DEBUG: pid 6699: I am 6699
2009-01-15 12:56:38 DEBUG: pid 6700: I am 6700
2009-01-15 12:56:38 DEBUG: pid 6701: I am 6701
2009-01-15 12:56:38 DEBUG: pid 6702: I am 6702
2009-01-15 12:56:38 DEBUG: pid 6703: I am 6703
2009-01-15 12:56:38 DEBUG: pid 6704: I am 6704
2009-01-15 12:56:38 DEBUG: pid 6705: I am 6705
2009-01-15 12:56:38 DEBUG: pid 6706: I am 6706
2009-01-15 12:56:38 DEBUG: pid 6707: I am 6707
2009-01-15 12:56:38 DEBUG: pid 6708: I am 6708
2009-01-15 12:56:38 DEBUG: pid 6709: I am 6709
2009-01-15 12:56:38 DEBUG: pid 6710: I am 6710
2009-01-15 12:56:38 DEBUG: pid 6711: I am 6711
2009-01-15 12:56:38 DEBUG: pid 6712: I am 6712
2009-01-15 12:56:38 DEBUG: pid 6713: I am 6713
2009-01-15 12:56:38 DEBUG: pid 6714: I am 6714
2009-01-15 12:56:38 DEBUG: pid 6715: I am 6715
2009-01-15 12:56:38 DEBUG: pid 6716: I am 6716
2009-01-15 12:56:38 LOG: pid 6616: pgpool successfully started
2009-01-15 12:56:38 DEBUG: pid 6616: starting health checking
2009-01-15 12:56:38 DEBUG: pid 6616: health_check: 0 the DB node status:
1
2009-01-15 12:56:38 DEBUG: pid 6717: I am PCP 6717
2009-01-15 12:56:38 ERROR: pid 6616: connect_inet_domain_socket:
connect() failed: Connection refused
2009-01-15 12:56:38 ERROR: pid 6616: health check failed. 0 th host
172.20.79.163 at port 5432 is down
2009-01-15 12:56:38 LOG: pid 6616: set 0 th backend down status
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler called
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: starting to
select new master node
2009-01-15 12:56:38 LOG: pid 6616: starting degeneration. shutdown
host 172.20.79.163(5432)
2009-01-15 12:56:38 DEBUG: pid 6617: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6617
2009-01-15 12:56:38 DEBUG: pid 6618: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6618
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6619
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6620
2009-01-15 12:56:38 DEBUG: pid 6619: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6621
2009-01-15 12:56:38 DEBUG: pid 6622: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6620: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6621: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6622
2009-01-15 12:56:38 DEBUG: pid 6623: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6623
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6624
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6625
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6626
2009-01-15 12:56:38 DEBUG: pid 6625: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6624: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6627: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6627
2009-01-15 12:56:38 DEBUG: pid 6626: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6628
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6629
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6630
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6631
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6632
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6633
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6634
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6635
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6636
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6637
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6638
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6639
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6640
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6641
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6642
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6643
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6644
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6645
2009-01-15 12:56:38 DEBUG: pid 6628: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6646: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6629: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6646
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6647
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6648
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6649
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6650
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6651
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6652
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6653
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6654
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6655
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6656
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6657
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6658
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6659
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6660
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6661
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6662
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6663
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6664
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6665
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6666
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6667
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6668
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6669
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6670
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6671
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6672
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6673
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6674
2009-01-15 12:56:38 DEBUG: pid 6631: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6675
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6676
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6677
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6678
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6679
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6680
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6681
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6682
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6683
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6684
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6685
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6686
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6687
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6688
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6689
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6690
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6691
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6692
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6693
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6694
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6695
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6696
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6697
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6698
2009-01-15 12:56:38 DEBUG: pid 6630: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6699
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6700
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6701
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6702
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6703
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6704
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6705
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6706
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6707
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6708
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6709
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6710
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6711
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6712
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6713
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6714
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6715
2009-01-15 12:56:38 DEBUG: pid 6616: failover_handler: kill 6716
2009-01-15 12:56:38 LOG: pid 6616: failover_handler: set new master
node: 1
2009-01-15 12:56:38 DEBUG: pid 6699: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6718: I am 6718
2009-01-15 12:56:38 DEBUG: pid 6714: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6703: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6719: I am 6719
2009-01-15 12:56:38 DEBUG: pid 6702: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6704: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6720: I am 6720
2009-01-15 12:56:38 DEBUG: pid 6707: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6713: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6705: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6721: I am 6721
2009-01-15 12:56:38 DEBUG: pid 6708: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6709: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6712: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6722: I am 6722
2009-01-15 12:56:38 DEBUG: pid 6710: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6701: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6723: I am 6723
2009-01-15 12:56:38 DEBUG: pid 6711: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6716: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6647: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6700: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6632: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6715: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6724: I am 6724
2009-01-15 12:56:38 DEBUG: pid 6648: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6633: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6725: I am 6725
2009-01-15 12:56:38 DEBUG: pid 6726: I am 6726
2009-01-15 12:56:38 DEBUG: pid 6727: I am 6727
2009-01-15 12:56:38 DEBUG: pid 6652: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6634: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6728: I am 6728
2009-01-15 12:56:38 DEBUG: pid 6653: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6635: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6729: I am 6729
2009-01-15 12:56:38 DEBUG: pid 6654: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6636: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6730: I am 6730
2009-01-15 12:56:38 DEBUG: pid 6655: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6637: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6731: I am 6731
2009-01-15 12:56:38 DEBUG: pid 6732: I am 6732
2009-01-15 12:56:38 DEBUG: pid 6656: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6638: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6657: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6733: I am 6733
2009-01-15 12:56:38 DEBUG: pid 6639: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6658: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6734: I am 6734
2009-01-15 12:56:38 DEBUG: pid 6640: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6735: I am 6735
2009-01-15 12:56:38 DEBUG: pid 6659: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6641: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6736: I am 6736
2009-01-15 12:56:38 DEBUG: pid 6660: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6642: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6737: I am 6737
2009-01-15 12:56:38 DEBUG: pid 6661: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6643: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6662: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6738: I am 6738
2009-01-15 12:56:38 DEBUG: pid 6644: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6739: I am 6739
2009-01-15 12:56:38 DEBUG: pid 6663: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6645: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6740: I am 6740
2009-01-15 12:56:38 DEBUG: pid 6664: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6741: I am 6741
2009-01-15 12:56:38 DEBUG: pid 6742: I am 6742
2009-01-15 12:56:38 DEBUG: pid 6649: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6743: I am 6743
2009-01-15 12:56:38 DEBUG: pid 6665: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6650: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6744: I am 6744
2009-01-15 12:56:38 DEBUG: pid 6666: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6651: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6667: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6673: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6745: I am 6745
2009-01-15 12:56:38 DEBUG: pid 6668: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6674: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6746: I am 6746
2009-01-15 12:56:38 DEBUG: pid 6669: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6675: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6670: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6747: I am 6747
2009-01-15 12:56:38 DEBUG: pid 6679: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6748: I am 6748
2009-01-15 12:56:38 DEBUG: pid 6671: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6749: I am 6749
2009-01-15 12:56:38 DEBUG: pid 6680: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6750: I am 6750
2009-01-15 12:56:38 DEBUG: pid 6672: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6681: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6751: I am 6751
2009-01-15 12:56:38 DEBUG: pid 6676: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6685: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6677: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6686: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6752: I am 6752
2009-01-15 12:56:38 DEBUG: pid 6678: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6687: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6753: I am 6753
2009-01-15 12:56:38 DEBUG: pid 6682: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6691: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6754: I am 6754
2009-01-15 12:56:38 DEBUG: pid 6683: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6755: I am 6755
2009-01-15 12:56:38 DEBUG: pid 6692: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6684: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6756: I am 6756
2009-01-15 12:56:38 DEBUG: pid 6693: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6757: I am 6757
2009-01-15 12:56:38 DEBUG: pid 6688: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6758: I am 6758
2009-01-15 12:56:38 DEBUG: pid 6697: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6689: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6698: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6760: I am 6760
2009-01-15 12:56:38 DEBUG: pid 6761: I am 6761
2009-01-15 12:56:38 DEBUG: pid 6762: I am 6762
2009-01-15 12:56:38 DEBUG: pid 6690: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6694: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6763: I am 6763
2009-01-15 12:56:38 DEBUG: pid 6695: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6764: I am 6764
2009-01-15 12:56:38 DEBUG: pid 6696: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6706: child receives shutdown request
signal 3
2009-01-15 12:56:38 DEBUG: pid 6765: I am 6765
2009-01-15 12:56:38 DEBUG: pid 6759: I am 6759
2009-01-15 12:56:38 DEBUG: pid 6766: I am 6766
2009-01-15 12:56:38 DEBUG: pid 6767: I am 6767
2009-01-15 12:56:38 DEBUG: pid 6768: I am 6768
2009-01-15 12:56:38 DEBUG: pid 6769: I am 6769
2009-01-15 12:56:38 DEBUG: pid 6770: I am 6770
2009-01-15 12:56:38 DEBUG: pid 6771: I am 6771
2009-01-15 12:56:38 DEBUG: pid 6772: I am 6772
2009-01-15 12:56:38 DEBUG: pid 6773: I am 6773
2009-01-15 12:56:38 DEBUG: pid 6774: I am 6774
2009-01-15 12:56:38 DEBUG: pid 6775: I am 6775
2009-01-15 12:56:38 DEBUG: pid 6776: I am 6776
2009-01-15 12:56:38 DEBUG: pid 6777: I am 6777
2009-01-15 12:56:38 DEBUG: pid 6778: I am 6778
2009-01-15 12:56:38 DEBUG: pid 6779: I am 6779
2009-01-15 12:56:38 DEBUG: pid 6781: I am 6781
2009-01-15 12:56:38 DEBUG: pid 6782: I am 6782
2009-01-15 12:56:38 DEBUG: pid 6783: I am 6783
2009-01-15 12:56:38 DEBUG: pid 6780: I am 6780
2009-01-15 12:56:38 DEBUG: pid 6784: I am 6784
2009-01-15 12:56:38 DEBUG: pid 6785: I am 6785
2009-01-15 12:56:38 DEBUG: pid 6786: I am 6786
2009-01-15 12:56:38 DEBUG: pid 6787: I am 6787
2009-01-15 12:56:38 DEBUG: pid 6788: I am 6788
2009-01-15 12:56:38 DEBUG: pid 6789: I am 6789
2009-01-15 12:56:38 DEBUG: pid 6790: I am 6790
2009-01-15 12:56:38 DEBUG: pid 6791: I am 6791
2009-01-15 12:56:38 DEBUG: pid 6792: I am 6792
2009-01-15 12:56:38 DEBUG: pid 6793: I am 6793
2009-01-15 12:56:38 DEBUG: pid 6794: I am 6794
2009-01-15 12:56:38 DEBUG: pid 6795: I am 6795
2009-01-15 12:56:38 DEBUG: pid 6796: I am 6796
2009-01-15 12:56:38 DEBUG: pid 6797: I am 6797
2009-01-15 12:56:38 DEBUG: pid 6798: I am 6798
2009-01-15 12:56:38 DEBUG: pid 6799: I am 6799
2009-01-15 12:56:38 DEBUG: pid 6800: I am 6800
2009-01-15 12:56:38 DEBUG: pid 6801: I am 6801
2009-01-15 12:56:38 DEBUG: pid 6802: I am 6802
2009-01-15 12:56:38 DEBUG: pid 6803: I am 6803
2009-01-15 12:56:38 DEBUG: pid 6804: I am 6804
2009-01-15 12:56:38 DEBUG: pid 6805: I am 6805
2009-01-15 12:56:38 DEBUG: pid 6806: I am 6806
2009-01-15 12:56:38 DEBUG: pid 6807: I am 6807
2009-01-15 12:56:38 DEBUG: pid 6808: I am 6808
2009-01-15 12:56:38 DEBUG: pid 6809: I am 6809
2009-01-15 12:56:38 DEBUG: pid 6810: I am 6810
2009-01-15 12:56:38 DEBUG: pid 6811: I am 6811
2009-01-15 12:56:38 DEBUG: pid 6812: I am 6812
2009-01-15 12:56:38 DEBUG: pid 6813: I am 6813
2009-01-15 12:56:38 DEBUG: pid 6814: I am 6814
2009-01-15 12:56:38 DEBUG: pid 6815: I am 6815
2009-01-15 12:56:38 DEBUG: pid 6816: I am 6816
2009-01-15 12:56:38 DEBUG: pid 6817: I am 6817
2009-01-15 12:56:38 LOG: pid 6616: failover done. shutdown host
172.20.79.163(5432)
2009-01-15 12:56:38 DEBUG: pid 6616: reap_handler called
2009-01-15 12:56:38 DEBUG: pid 6616: reap_handler: call wait3
2009-01-15 12:56:38 DEBUG: pid 6616: child 6617 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6618 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6619 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6620 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6621 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6622 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6623 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6624 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6625 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6626 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6627 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6628 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6629 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6630 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6631 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6632 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6633 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6634 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6635 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6636 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6637 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6638 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6639 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6640 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6641 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6642 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6643 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6644 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6645 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6646 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6647 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6648 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6649 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6650 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6651 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6652 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6653 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6654 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6655 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6656 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6657 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6658 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6659 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6660 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6661 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6662 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6663 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6664 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6665 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6666 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6667 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6668 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6669 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6670 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6671 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6672 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6673 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6674 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6675 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6676 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6677 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6678 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6679 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6680 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6681 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6682 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6683 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6684 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6685 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6686 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6687 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6688 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6689 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6690 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6691 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6692 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6693 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6694 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6695 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6696 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6697 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6698 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6699 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6700 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6701 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6702 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6703 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6704 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6705 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6706 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6707 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6708 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6709 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6710 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6711 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6712 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6713 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6714 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6715 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: child 6716 exits with status 0 by
signal 0
2009-01-15 12:56:38 DEBUG: pid 6616: reap_handler: normally exited
[this stops here until I do something with my already opened connection:
I had an open database connection, in which I did:
eds_db=# select 1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
The log continued below]
2009-01-15 12:56:42 DEBUG: pid 6816: I am 6816 accept fd 5
2009-01-15 12:56:42 LOG: pid 6816: connection received: host=[local]
2009-01-15 12:56:42 DEBUG: pid 6816: Protocol Major: 3 Minor: 0
database: eds_db user: eds_db
2009-01-15 12:56:42 DEBUG: pid 6816: new_connection: connecting 0
backend
2009-01-15 12:56:42 DEBUG: pid 6816: new_connection: skipping slot 0
because backend_status = 3
2009-01-15 12:56:42 DEBUG: pid 6816: new_connection: connecting 1
backend
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length: slot: 1
length: 8
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 25
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: client_encoding
value: UTF8
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 23
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: DateStyle
value: ISO, MDY
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 26
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name:
integer_datetimes value: off
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 20
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: is_superuser
value: on
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 25
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: server_encoding
value: UTF8
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 25
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: server_version
value: 8.2.1
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 33
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name:
session_authorization value: eds_db
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 36
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name:
standard_conforming_strings value: off
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length2: master
slot: 1 length: 24
2009-01-15 12:56:42 DEBUG: pid 6816: 1 th backend: name: TimeZone value:
US/Eastern
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length: slot: 1
length: 12
2009-01-15 12:56:42 DEBUG: pid 6816: pool_send_auth_ok: send pid 14410
to frontend
2009-01-15 12:56:42 DEBUG: pid 6816: read_kind_from_backend: read kind
from 1 th backend Z NUM_BACKENDS: 2
2009-01-15 12:56:42 DEBUG: pid 6816: pool_process_query: kind from
backend: Z
2009-01-15 12:56:42 DEBUG: pid 6816: pool_read_message_length: slot: 1
length: 5
2009-01-15 12:56:42 DEBUG: pid 6816: ReadyForQuery: message length: 5
2009-01-15 12:56:42 DEBUG: pid 6816: ReadyForQuery: transaction state: I
2009-01-15 12:56:43 DEBUG: pid 6616: starting health checking
2009-01-15 12:56:43 DEBUG: pid 6616: health_check: 0 the DB node status:
3
2009-01-15 12:56:43 DEBUG: pid 6616: health_check: 1 the DB node status:
2
[...]
Before this CVS downloaded version, I had pgpool-II-2.1. This was not
happening. Instead of keep connections closed, it was blocking existent
connections, which could be solved by disconnecting and connecting
again.
I'm using FC6 and PostgreSQL 8.2.1.
Thanks,
Daniel
More information about the Pgpool-general
mailing list