[Pgpool-general] Failover shuts down incoming connections
Daniel.Crespo at l-3com.com
Daniel.Crespo at l-3com.com
Mon Jan 19 21:35:46 UTC 2009
[~]$ patch < pgpool.patch
(Stripping trailing CRs from patch.)
patching file pool_process_query.c
Hunk #1 FAILED at 251.
1 out of 1 hunk FAILED -- saving rejects to file
pool_process_query.c.rej
Do I have the correct version of pool_process_query.c? Unfortunately, I
don't have access to the CVS head right now for downloading it.
Here is the first 6 lines of pool_process_query.c file that I have:
1 /* -*-pgsql-c-*- */
2 /*
3 * $Header: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v 1.131
2009/01/07 13:33:31 t-ishii Exp $
4 *
5 * pgpool: a language independent connection pool server for
PostgreSQL
6 * written by Tatsuo Ishii
...
Thanks,
Daniel
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Sunday, January 18, 2009 8:01 AM
> To: Crespo, Daniel @ SDS
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] Failover shuts down incoming connections
>
> Thanks for testing. This error is very strange. It seems only
> *once* I was able to reproduce the error. But since that was
> not reproducable, it is very hard to track the case of the problem.
>
> If you easily reproduce the error, could you apply included
> patches and show me the log? I have just added a debug log.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
> > 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
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
>
More information about the Pgpool-general
mailing list