[~]$ 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:[email protected]] > Sent: Sunday, January 18, 2009 8:01 AM > To: Crespo, Daniel @ SDS > Cc: [email protected] > 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 > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
