NetBSD Problem Report #43628

From www@NetBSD.org  Sat Jul 17 05:28:41 2010
Return-Path: <www@NetBSD.org>
Received: from mail.netbsd.org (mail.netbsd.org [204.152.190.11])
	by www.NetBSD.org (Postfix) with ESMTP id F1DBD63BAE8
	for <gnats-bugs@gnats.NetBSD.org>; Sat, 17 Jul 2010 05:28:40 +0000 (UTC)
Message-Id: <20100717052840.64C5063BAE7@www.NetBSD.org>
Date: Sat, 17 Jul 2010 05:28:40 +0000 (UTC)
From: wenheping@gmail.com
Reply-To: wenheping@gmail.com
To: gnats-bugs@NetBSD.org
Subject: [databases/pgpool] Update to 3.4.1
X-Send-Pr-Version: www-1.0

>Number:         43628
>Category:       pkg
>Synopsis:       [databases/pgpool] Update to 3.4.1
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    minskim
>State:          closed
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Sat Jul 17 05:30:01 +0000 2010
>Closed-Date:    Tue Apr 05 17:48:39 +0000 2011
>Last-Modified:  Tue Apr 05 17:50:03 +0000 2011
>Originator:     Wen Heping
>Release:        NetBSD-5.0.2
>Organization:
Private
>Environment:
NetBSD nb502.wenjing.com 5.0.2 NetBSD 5.0.2 (GENERIC) #0: Sat Feb  6 17:53:27 UTC 2010  builds@b7.netbsd.org:/home/builds/ab/netbsd-5-0-2-RELEASE/i386/201002061851Z-obj/home/builds/ab/netbsd-5-0-2-RELEASE/src/sys/arch/i386/compile/GENERIC i386
>Description:
2007-09-14    <y-asaba@sraoss.co.jp>
        * Version 3.4.1
        * Fix handling failover when health_check was disabled. (Yoshiyuki)
          - The bug was introduced in 3.4.
        * Fix deadlock while processing Parse message. (Yoshiyuki)

2007-08-01    <y-asaba@sraoss.co.jp>
        * Version 3.4
        * Add new "replicate_select" directive, being the default value to
          be false. (Yoshiyuki)
          - If it is true, SELECT query is replicated. This behavior is
            same as V3.2 or earlier.
        * Improve signal handling. (Yoshiyuki)
          - Occasionaly, zombie processes were remained. Or processes were
            unstable.
        * Fix hang up when SELECT was error inside a transaction
          block. The bug was introduced in V3.3. (Yoshiyuki)
        * Fix PREPARE/EXECUTE handling in master slave mode. (Yoshiyuki)
        * Fix "kind mismatch error" when deadlock error
        * Fix hang up and SEGV in extended query protocol when a warning
          SQL like "SELECT '\'';" executed. (Yoshiyuki)
        * Fix memory leak when connection cache was full. (Yoshiyuki)

2007-05-18    <yamaguchi@sraoss.co.jp>
        * Version 3.3
        * Improve replication. SELECT nextval() and SELECT setval() are
          now replicated. (Yoshiyuki)
        * Change SELECT query is only sent to the master node. (Yoshiyuki)
          - Use /*REPLICATION*/ comment to repliate a SELECT query.
        * Fix unexpected failover error due to receiving an interrupt
          signal while connecting to the backend. (Yoshiyuki)
        * Fix "ps" output to follow PostgreSQL's output. (Taiki)
        * Change the default value for enable_pool_hba to true. (Taiki)
        * Add "pgpool.pam" file, for PAM configuration file, to be
          installed under "$PREFIX/share/". (Taiki)

2007-02-10    <ishii@sraoss.co.jp>
        * Version 3.2
        * Support HBA authentication(Taiki)
        * Support log_connections(Taiki)
        * Support log_hostname(Tatsuo)
        * Show pgpool status in ps command(Tatsuo)
        * Fix bug with prepared query(Yoshiyuki)
        * Detach secondary server when "kind mismatch error" is detected(Tatsuo)
        * Re-open socket if it was closed by backend while reusing
          connection(Yoshiyuki)
2006-12-12    <y-asaba@sraoss.co.jp>
        * Version 3.1.2
        * Allow 0 weight(Tatsuo)
        * Return correct error messaes when pg_hba.conf auth fails. Patch
          contributed by Kenji Kikuchi
        * Fix kind mismatch errors with COPY FROM STDIN(Yoshiyuki)
        * Allow load balancing with extended protocol(Yoshiyuki)

2006-07-23    <ishii@sraoss.co.jp>
        * Version 3.1.1
        * Fix LISTEN/NOTIFY bug in master/slave mode reported by Michael
          Ulitskiy (Tatsuo)

2006-07-01    <ishii@sraoss.co.jp>
        * Version 3.1
        * Improve documentation. patches contributed by Mark Stosberg
        * Fix "kind is 0!" error in Execute(). Reads messages until
          receiving CommandComplete, EmptyQuery, ErrorResponse or
          PortalSuspend in Execute() (Yoshiyuki)
        * Add log_statement option. patches contributed by Thomas E
          Lackey, modifications and documents by Tatsuo
        * In SimpleForwardToFrontend() do not send SYNC and wait for ready for
          query when PANIC or FATAL error occurs. In this case the backend
          closes the communication channel immediately which will cause unwanted
          failover/degeneration by, for example, trying to connect to
          invalid database (Tatsuo)
        * Fix dealock problem in extended modd by calling synchronize() in
          Execute if replication_strict is enabled (Yoshiyuki)
        * Fix segfault problem in race conditions among
          connection_life_time, child_life_time and child_max_connections (Tatsuo)

2006-05-17    <ishii@sraoss.co.jp>
        * Version 3.0.2
        * pgpool does not exit even if pgpool.conf contents is wrong(Tatsuo)
        * Fix buffer overrun bug with long health_check_user name(Taiki)
        * Fix occasional segfault with replication and load balance
          enabled(bug id #1000548)(Tatsuo)
        * Fix pool_send_error_message to send properly NULL terminated
          string(Yoshiyuki)
        * Fix kind mismatch error in SimpleFowardFrontend(Yoshiyuki)
        * Enable to build with BSD make(Yoshiyuki)
        * Fix pool_debug and friends to block signals while
          executing(Tatsuo)
        * Fix numerous bugs with extended query(Yoshiyuki)
        * Fix INSERT LOCK(Yoshiyuki)
        * Do not reuse startup packet(Tatsuo)
        * Automatically DEALLOCTE prepared queries when client
          disconnects(Yoshiyuki)
        * Do not forward packets when length = 0 in
          SimpleForwardToFrontend/SimpleForwardToBackend(Tatsuo)
        * Fix lost of kind info(Tatsuo)

2006-02-14    <ishii@sraoss.co.jp>
        * Version 3.0.1
        * Fix bugs with master/slave mode introduced in 2.7.2. per report
          from David Boreham (Tatsuo)
        * Fix bugs with master/slave and prepared quries. per report
          from David Boreham (Tatsuo)
2006-02-03    <devrim@commandprompt.com>
        * Version 3.0.0
        * Changed Copyright to PgPool Global Development Group
        * Fix a typo in man page

2006-02-02    <ishii@sraoss.co.jp>
        * version 2.7.2
        * PQnotifes() does not receive immediate responses from LISTEN
        * NOTIFY emits packet kind does not agree errors in master/slave
          mode
        * add pgpool man pages(Peter Eisentra)

2006-01-16    <ishii@sraoss.co.jp>
        * version 2.7.1
        * Fix bug in show pool_status for ignore_leading_white_space

>How-To-Repeat:

>Fix:
diff -urN pgpool/Makefile pgpool.new/Makefile
--- pgpool/Makefile     2008-06-12 10:14:18.000000000 +0800
+++ pgpool.new/Makefile 2010-07-17 21:18:04.000000000 +0800
@@ -1,8 +1,8 @@
 # $NetBSD: Makefile,v 1.9 2008/06/12 02:14:18 joerg Exp $

-DISTNAME=      pgpool-2.7
+DISTNAME=      pgpool-3.4.1
 CATEGORIES=    databases
-MASTER_SITES=  http://pgfoundry.org/frs/download.php/572/
+MASTER_SITES=  http://pgfoundry.org/frs/download.php/1446/

 MAINTAINER=    minskim@NetBSD.org
 HOMEPAGE=      http://pgpool.projects.postgresql.org/
@@ -16,10 +16,13 @@

 INSTALLATION_DIRS=     share/examples

-CONF_FILES=    ${PREFIX}/share/examples/pgpool.conf.sample             \
+CONF_FILES+=   ${PREFIX}/share/examples/pgpool.conf.sample \
                ${PKG_SYSCONFDIR}/pgpool.conf
+CONF_FILES+=   ${PREFIX}/share/examples/pool_hba.conf.sample \
+               ${PKG_SYSCONFDIR}/pool_hba.conf

 post-install:
        ${INSTALL_DATA} ${WRKSRC}/pgpool.conf.sample ${DESTDIR}${PREFIX}/share/examples
+       ${INSTALL_DATA} ${WRKSRC}/pool_hba.conf.sample ${DESTDIR}${PREFIX}/share/examples

 .include "../../mk/bsd.pkg.mk"
diff -urN pgpool/PLIST pgpool.new/PLIST
--- pgpool/PLIST        2005-02-12 00:40:43.000000000 +0800
+++ pgpool.new/PLIST    2010-07-17 21:20:09.000000000 +0800
@@ -1,3 +1,5 @@
 @comment $NetBSD: PLIST,v 1.1.1.1 2005/02/11 16:40:43 minskim Exp $
 bin/pgpool
 share/examples/pgpool.conf.sample
+share/examples/pool_hba.conf.sample
+share/pgpool/pgpool.pam
diff -urN pgpool/distinfo pgpool.new/distinfo
--- pgpool/distinfo     2006-01-16 01:09:50.000000000 +0800
+++ pgpool.new/distinfo 2010-07-17 21:02:41.000000000 +0800
@@ -1,6 +1,6 @@
 $NetBSD: distinfo,v 1.4 2006/01/15 17:09:50 minskim Exp $

-SHA1 (pgpool-2.7.tar.gz) = 25963c9956c5cb00019a38b2f89c0e8b4830b153
-RMD160 (pgpool-2.7.tar.gz) = c143f763f978b93faa23d5b5b0b87ff34975bb4a
-Size (pgpool-2.7.tar.gz) = 153554 bytes
-SHA1 (patch-aa) = 868af0f14b2f03921e2ad2301658a4d3466586ae
+SHA1 (pgpool-3.4.1.tar.gz) = 55027bfb0437b4edea38a480163e32762698c48a
+RMD160 (pgpool-3.4.1.tar.gz) = ba409a8b2b424272cd458e689ea94234f9bc3f42
+Size (pgpool-3.4.1.tar.gz) = 201509 bytes
+SHA1 (patch-aa) = 9ebe234913cae93610ec80b17e8a6593c991512c
diff -urN pgpool/patches/patch-aa pgpool.new/patches/patch-aa
--- pgpool/patches/patch-aa     2006-01-16 01:09:51.000000000 +0800
+++ pgpool.new/patches/patch-aa 2010-07-17 20:57:42.000000000 +0800
@@ -1,13 +1,13 @@
-$NetBSD: patch-aa,v 1.2 2006/01/15 17:09:51 minskim Exp $
+$NetBSD$

---- Makefile.in.orig   2006-01-02 16:33:53.000000000 -0800
+--- Makefile.in.orig   2010-07-17 12:56:43.000000000 +0000
 +++ Makefile.in
-@@ -177,7 +177,7 @@ pgpool_SOURCES = pool.h version.h pgpool
-       pool_process_query.c pool_stream.c pool_connection_pool.c pool_params.c \
-       pool_signal.h pool_signal.c
+@@ -184,7 +184,7 @@ pgpool_SOURCES = pool.h version.h pgpool
+       pool_hba.c pool_list.h pool_list.c pool_path.h pool_path.c \
+       pool_type.h pool_ip.h pool_ip.c pool_hba.conf.sample pgpool.pam

--sysconf_DATA = pgpool.conf.sample
+-sysconf_DATA = pgpool.conf.sample pool_hba.conf.sample
 +sysconf_DATA =
+ pkgdata_DATA = pgpool.pam
  AM_CPPFLAGS = -Wall -Wmissing-prototypes -Wmissing-declarations -D_GNU_SOURCE
- all: config.h
-       $(MAKE) $(AM_MAKEFLAGS) all-am
+ man_MANS = pgpool.8

>Release-Note:

>Audit-Trail:

Responsible-Changed-From-To: pkg-manager->minskim
Responsible-Changed-By: gls@NetBSD.org
Responsible-Changed-When: Sat, 17 Jul 2010 05:44:55 +0000
Responsible-Changed-Why:
Over to maintainer.


State-Changed-From-To: open->closed
State-Changed-By: minskim@NetBSD.org
State-Changed-When: Tue, 05 Apr 2011 17:48:39 +0000
State-Changed-Why:
Updated.  Thank you for the PR!


From: "Min Sik Kim" <minskim@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc: 
Subject: PR/43628 CVS commit: pkgsrc/databases/pgpool
Date: Tue, 5 Apr 2011 17:47:17 +0000

 Module Name:	pkgsrc
 Committed By:	minskim
 Date:		Tue Apr  5 17:47:17 UTC 2011

 Modified Files:
 	pkgsrc/databases/pgpool: Makefile PLIST distinfo
 	pkgsrc/databases/pgpool/patches: patch-aa

 Log Message:
 Update pgpool to 3.4.1.

 Patch provided by Wen Heping in PR 43628.

 Changes:
         * Fix handling failover when health_check was disabled. (Yoshiyuki)
           - The bug was introduced in 3.4.
         * Fix deadlock while processing Parse message. (Yoshiyuki)
         * Add new "replicate_select" directive, being the default value to
           be false. (Yoshiyuki)
           - If it is true, SELECT query is replicated. This behavior is
             same as V3.2 or earlier.
         * Improve signal handling. (Yoshiyuki)
           - Occasionaly, zombie processes were remained. Or processes were
             unstable.
         * Fix hang up when SELECT was error inside a transaction
           block. The bug was introduced in V3.3. (Yoshiyuki)
         * Fix PREPARE/EXECUTE handling in master slave mode. (Yoshiyuki)
         * Fix "kind mismatch error" when deadlock error
         * Fix hang up and SEGV in extended query protocol when a warning
           SQL like "SELECT '\'';" executed. (Yoshiyuki)
         * Fix memory leak when connection cache was full. (Yoshiyuki)
         * Improve replication. SELECT nextval() and SELECT setval() are
           now replicated. (Yoshiyuki)
         * Change SELECT query is only sent to the master node. (Yoshiyuki)
           - Use /*REPLICATION*/ comment to repliate a SELECT query.
         * Fix unexpected failover error due to receiving an interrupt
           signal while connecting to the backend. (Yoshiyuki)
         * Fix "ps" output to follow PostgreSQL's output. (Taiki)
         * Change the default value for enable_pool_hba to true. (Taiki)
         * Add "pgpool.pam" file, for PAM configuration file, to be
           installed under "$PREFIX/share/". (Taiki)
         * Support HBA authentication(Taiki)
         * Support log_connections(Taiki)
         * Support log_hostname(Tatsuo)
         * Show pgpool status in ps command(Tatsuo)
         * Fix bug with prepared query(Yoshiyuki)
         * Detach secondary server when "kind mismatch error" is detected(Tatsuo)
         * Re-open socket if it was closed by backend while reusing
           connection(Yoshiyuki)
         * Allow 0 weight(Tatsuo)
         * Return correct error messaes when pg_hba.conf auth fails. Patch
           contributed by Kenji Kikuchi
         * Fix kind mismatch errors with COPY FROM STDIN(Yoshiyuki)
         * Allow load balancing with extended protocol(Yoshiyuki)
         * Fix LISTEN/NOTIFY bug in master/slave mode reported by Michael
           Ulitskiy (Tatsuo)
         * Improve documentation. patches contributed by Mark Stosberg
         * Fix "kind is 0!" error in Execute(). Reads messages until
           receiving CommandComplete, EmptyQuery, ErrorResponse or
           PortalSuspend in Execute() (Yoshiyuki)
         * Add log_statement option. patches contributed by Thomas E
           Lackey, modifications and documents by Tatsuo
         * In SimpleForwardToFrontend() do not send SYNC and wait for ready for
           query when PANIC or FATAL error occurs. In this case the backend
           closes the communication channel immediately which will cause unwanted
           failover/degeneration by, for example, trying to connect to
           invalid database (Tatsuo)
         * Fix dealock problem in extended modd by calling synchronize() in
           Execute if replication_strict is enabled (Yoshiyuki)
         * Fix segfault problem in race conditions among
           connection_life_time, child_life_time and child_max_connections
         * pgpool does not exit even if pgpool.conf contents is wrong(Tatsuo)
         * Fix buffer overrun bug with long health_check_user name(Taiki)
         * Fix occasional segfault with replication and load balance
           enabled(bug id #1000548)(Tatsuo)
         * Fix pool_send_error_message to send properly NULL terminated
           string(Yoshiyuki)
         * Fix kind mismatch error in SimpleFowardFrontend(Yoshiyuki)
         * Enable to build with BSD make(Yoshiyuki)
         * Fix pool_debug and friends to block signals while
           executing(Tatsuo)
         * Fix numerous bugs with extended query(Yoshiyuki)
         * Fix INSERT LOCK(Yoshiyuki)
         * Do not reuse startup packet(Tatsuo)
         * Automatically DEALLOCTE prepared queries when client
           disconnects(Yoshiyuki)
         * Do not forward packets when length = 0 in
           SimpleForwardToFrontend/SimpleForwardToBackend(Tatsuo)
         * Fix lost of kind info(Tatsuo)
         * Fix bugs with master/slave mode introduced in 2.7.2. per report
           from David Boreham (Tatsuo)
         * Fix bugs with master/slave and prepared quries. per report
           from David Boreham (Tatsuo)
         * Changed Copyright to PgPool Global Development Group
         * Fix a typo in man page
         * PQnotifes() does not receive immediate responses from LISTEN
         * NOTIFY emits packet kind does not agree errors in master/slave
           mode
         * add pgpool man pages(Peter Eisentra)
         * Fix bug in show pool_status for ignore_leading_white_space


 To generate a diff of this commit:
 cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/pgpool/Makefile
 cvs rdiff -u -r1.1.1.1 -r1.2 pkgsrc/databases/pgpool/PLIST
 cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/pgpool/distinfo
 cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/pgpool/patches/patch-aa

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.

>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.51 2026/08/10 02:28:17 riastradh Exp $
$NetBSD: gnats_config.sh,v 1.10 2026/05/13 22:00:09 riastradh Exp $
Copyright © 1994-2026 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.