[pgpool-general: 3299] Re: pgpool-II 3.3.4, 3.2.9, 3.1.12, and 3.0, 16 released
Tatsuo Ishii
ishii at postgresql.org
Mon Nov 24 12:07:55 JST 2014
> Oh OK. So, to clarify. Before that change in 3.3.4 what was the value? 1
> sec or 0 sec?
1 sec.
> And now in 3.3.4 it's hardcoded internally to 10 seconds?
Yes, correct. Do you have any problem with this?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Tatsuo Ishii <ishii at postgresql.org> writes:
>
>> This is an internal constant and there's no doc or knob for this in
>> 3.3. However in 3.4 there is a new knob called "connect_timeout" which
>> allows to change the value.
>
>
>
>>> Hi Yugo,
>>>
>>> In regards to the following:
>>>
>>> - Change connect() timeout longer (10 seconds) for flaky network
>>> (Tatsuo Ishii)
>>>
>>>
>>> I don't see any mention of it in the official documentation here:
>>> http://www.pgpool.net/docs/latest/pgpool-en.html
>>>
>>> How is this timeout set?
>>>
>>> Yugo Nagata <nagata at sraoss.co.jp> writes:
>>>
>>>> Pgpool Global Development Group is pleased to announce the
>>>> availability of pgpool-II 3.3.4, 3.2.9, 3.1.12, and 3.0,16. These are
>>>> the latest stable minor versions of each major versions of pgpool-II.
>>>>
>>>> You can download the source code, installer, RPMs from:
>>>> http://pgpool.net/mediawiki/index.php/Downloads
>>>>
>>>> ===============================================================================
>>>>
>>>> 3.3.4 (tokakiboshi) 2014/09/05
>>>>
>>>> * Version 3.3.4
>>>>
>>>> This is a bugfix release against pgpool-II 3.3.3.
>>>>
>>>> __________________________________________________________________
>>>>
>>>> * Bug fixes
>>>>
>>>> - Fix a typo of pgpool.spec (Yugo Nagata)
>>>>
>>>> - Fix bug that worker child process keeps failing when there's no
>>>> primary backend (Tatsuo Ishii)
>>>>
>>>> Problem identified and fix contributed by Junegunn Choi.
>>>>
>>>> See [pgpool-hackers: 471] for more details.
>>>>
>>>> - Close listen socket when smart shutdown request is made (Tatsuo
>>>> Ishii)
>>>>
>>>> When smart shutdown process starts, pgpool children still listen
>>>> on the port and clients can send further connection requests which
>>>> fail in the end. Which is not only waste of time, but also prevents a
>>>> load balancer which sits in front of pgpool from realizing the pgpool
>>>> is going down.
>>>>
>>>> Problem analyzed and patch provided by Junegunn Choi in
>>>> [pgpool-hackers 474], and enhanced to take care not only inet domain
>>>> socket but UNIX domain socket by Tatsuo Ishii.
>>>>
>>>> - doc: Add cautions that recovery commands are killed by
>>>> statement_timeout of PostgreSQL. (Tatsuo Ishii)
>>>>
>>>> - test: Fix bug that wait_for_pgpool_startup does not work.
>>>> (Tatsuo Ishii)
>>>>
>>>> - test: Fix test driver for watchdog to use
>>>> wait_for_pgpool_startup correctly (Tatsuo Ishii)
>>>>
>>>> - Fix to ignore a harmless error code when executing ifconfig
>>>> command (Yugo Nagata)
>>>>
>>>> When executing command such as ifconfig or ping by execv() in a
>>>> forked child proess, wait() can fails with an error code ECHILD,
>>>> although the process exists exactly, if SIGCHLD is set to SIG_IGN in
>>>> Linux. We should ignore this and not treat as failure of the command.
>>>>
>>>> - test: Add undocumented "-j" option to the script comment.
>>>> (Tatsuo Ishii)
>>>>
>>>> - test: Fix unwanted JDBC regression test failure (Tatsuo Ishii)
>>>>
>>>> - test: Fix to prevent regression test failures on slow machines
>>>> (Tatsuo Ishii)
>>>>
>>>> - test: Allow to specify PostgreSQL library directory by
>>>> environment variable (Tatsuo Ishii)
>>>>
>>>> - Adopt PostgreSQL 9.4 having to_regclass (Tatsuo Ishii)
>>>>
>>>> PostgreSQL 9.4 has built-in function "to_regclass", which has
>>>> equivalent functionality of pgpool_regclass. Now pgpool searches
>>>> to_regclass first then try pgpool_regclass.
>>>>
>>>> - Fix unportable code related to SO_REUSEPORT (Tatsuo Ishii)
>>>>
>>>> There are several places using setsockopt(sock, SOL_SOCKET,
>>>> SO_REUSEPORT...). SO_REUSEPORT is not available on all Linux kernels
>>>> and the source code uses ifdef to detect the feature in the compile
>>>> time. Problem is, the binary created with kernel which provides the
>>>> feature cannot run on a kernel which does not provide the feature. Fix
>>>> is, detecting the feature in the run time by checking error code
>>>> returned by setsockopt() and ignore it if the cause of the error is
>>>> lacking the feature.
>>>>
>>>> - doc: Remove old restriction description which is no longer true
>>>> (Tatsuo Ishii)
>>>>
>>>> - Fix return type of text_to_lsn() function (Yugo Nagata)
>>>>
>>>> This caused compile warning.
>>>>
>>>> - Fix file descriptor leak when daemonize. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111471.
>>>>
>>>> - Fix memory leak. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111442.
>>>>
>>>> - Fix pgpool.init's long-standing bug of stop/restart failure
>>>> (Yugo Nagata)
>>>>
>>>> In previous, pgpool.init uses killproc for stopping pgpool, but
>>>> there are several problems. In the new version, "pgpool -m fast stop"
>>>> is used in stop command.
>>>>
>>>> Original patch contributed by Ryan DeShone and modified by Yugo
>>>> Nagata.
>>>>
>>>> See [pgpool-hackers: 239][pgpool-hackers: 512].
>>>>
>>>> - Allow to run pgpool_setup and regression test on Ubuntu box
>>>> (Tatsuo Ishii)
>>>>
>>>> - test: Fix -i option (install directory of pgpool) not working
>>>> (Tatsuo Ishii)
>>>>
>>>> - Add missing include file sys/wait.h. (Tatsuo Ishii)
>>>>
>>>> Per bug #104. http://www.pgpool.net/mantisbt/view.php?id=104
>>>>
>>>> - Fix an infinite loop of ping error at new active pgpool when
>>>> virtual IP switching (Yugo Nagata)
>>>>
>>>> This bug also caused hangs of the old active pgpool, since this
>>>> waits response from the new active pgpool, which is in the infinite
>>>> loop and not able to respond.
>>>>
>>>> This problem is reported by Qian Peng in [pgpool-hackers: 520].
>>>>
>>>> - Disbale statement_timeout of PostgreSQL while executing online
>>>> recovery (Tatsuo Ishii)
>>>>
>>>> Online recovery may take very long time and user may enable
>>>> statement timeout. To prevent online recovery canceled by statement
>>>> timeout, disable statement timeout in the connection used by online
>>>> recovery.
>>>>
>>>> See [pgpool-general: 2919] for more details.
>>>>
>>>> - Fix pool_table_name_to_oid in case new to_regclass used which is
>>>> introduced in PostgreSQL 9.4 (Tatsuo Ishii)
>>>>
>>>> The relcache func used here should return 0 if target table is
>>>> not found. However to_regclass returns NULL in this case. To fix the
>>>> problem now COALESCE is used.
>>>>
>>>> - test: Fix regression test 057 hung if run against PostgreSQL 9.4
>>>> or later (Tatsuo Ishii)
>>>>
>>>> PostgreSQL 9.4 or later changed libpq behavior: NULL username
>>>> for connection string does not cause an error, which was expected in
>>>> the test.
>>>>
>>>> - Fix to close pipe when ping command exits with failure (Yugo
>>>> Nagata)
>>>>
>>>> This bug causes pipe open error: Too many open files, which
>>>> leads to failure of connecting to trusted servers, and then pgpool
>>>> goes to down status.
>>>>
>>>> - Fix Resource leaks (Muhammad Usama)
>>>>
>>>> Coverity issue #1222998 and #1222999.
>>>>
>>>> - Add a description that pcp_detach_node command disconnects
>>>> existing sessions (Tatsuo Ishii)
>>>>
>>>> - Fix failover.sh produced by pgpool_setup (Tatsuo Ishii)
>>>>
>>>> It did not support there's more than 3 nodes case. It always
>>>> tries to promoto node0 or node1.
>>>>
>>>> - Remove meaningless minus check because of unsigned int variable
>>>> (Tatsuo Ishii)
>>>>
>>>> Coverity issue #1111419, #1111420, #1111422.
>>>>
>>>> - replacing strcpy() with much safer and recomended call strlcpy()
>>>> (Muhammad Usama)
>>>>
>>>> Coverity issue #1111480.
>>>>
>>>> - Fix pgpool.spec to support openssl (Tatsuo Ishii)
>>>>
>>>> - Fix pgpool.spec to use 3.3-stable tree head (Tatsuo Ishii)
>>>>
>>>> - Remove unnecessary call to pool_shmem_exit() which removes
>>>> semaphore when it shouldn't (Tatsuo Ishii)
>>>>
>>>> exit_handler checks if the process is parent or not. This is
>>>> good. However, even if it is a child process, it calls
>>>> pool_shmem_exit() which removes semaphore and shmem when it should
>>>> not. It should be called only from parent process.
>>>>
>>>> Per bug #102. http://www.pgpool.net/mantisbt/view.php?id=102
>>>>
>>>> - Fix get_insert_command_table_name() function not to use freed
>>>> pointer (Muhammad Usama)
>>>>
>>>> Coverity issue #1223007.
>>>>
>>>> - Fix pool_handle_query_cache() to not free NULL pointer (Tatsuo
>>>> Ishii)
>>>>
>>>> - Change connect() timeout longer (10 seconds) for flaky network
>>>> (Tatsuo Ishii)
>>>>
>>>> Change connect() timeout in connect_inet_domain_socket_by_port()
>>>> from 1 second to 10 seconds for flaky network such as AWS. This should
>>>> help reducing frequent failover.
>>>>
>>>> - Fix reset query stuck problem. (Tatsuo Ishii)
>>>>
>>>> It is reported that reset query (DISCARD ALL etc.) occasionally
>>>> does not finish and pgpool child remain waiting for reply from backend
>>>> thus client cannot connect to pgpool.
>>>>
>>>> The cause of problem is not identified yet but if client
>>>> suddenly closes connection to pgpool in the middle of query
>>>> processing, backend may not accept the reset queries because they are
>>>> not ready for query.
>>>>
>>>> The fix is, if frontend closes connection in unexpected way,
>>>> query process loop immediately returns with new state:
>>>> POOL_END_WITH_FRONTEND_ERROR and pgpool closes connection to
>>>> PostgreSQL then goes back to new connection request waiting loop.
>>>>
>>>> Also, pgpool closes connections to backend when
>>>> client_idle_limit is set and the idle limit.
>>>>
>>>> Per bug #107. http://www.pgpool.net/mantisbt/view.php?id=107
>>>>
>>>> - Fix other dozens of coverity issues (Muhammad Usama)
>>>>
>>>> ===============================================================================
>>>>
>>>> 3.2.9 (namameboshi) 2014/09/05
>>>>
>>>> * Version 3.2.9
>>>>
>>>> This is a bugfix release against pgpool-II 3.2.8.
>>>>
>>>> __________________________________________________________________
>>>>
>>>> * Bug fixes
>>>>
>>>> - Fix a typo of pgpool.spec (Yugo Nagata)
>>>>
>>>> - Fix bug that worker child process keeps failing when there's no
>>>> primary backend (Tatsuo Ishii)
>>>>
>>>> Problem identified and fix contributed by Junegunn Choi.
>>>>
>>>> See [pgpool-hackers: 471] for more details.
>>>>
>>>> - Close listen socket when smart shutdown request is made (Tatsuo
>>>> Ishii)
>>>>
>>>> When smart shutdown process starts, pgpool children still listen
>>>> on the port and clients can send further connection requests which
>>>> fail in the end. Which is not only waste of time, but also prevents a
>>>> load balancer which sits in front of pgpool from realizing the pgpool
>>>> is going down.
>>>>
>>>> Problem analyzed and patch provided by Junegunn Choi in
>>>> [pgpool-hackers 474], and enhanced to take care not only inet domain
>>>> socket but UNIX domain socket by Tatsuo Ishii.
>>>>
>>>> - doc: Add cautions that recovery commands are killed by
>>>> statement_timeout of PostgreSQL. (Tatsuo Ishii)
>>>>
>>>> - doc: Remove old restriction description which is no longer true
>>>> (Tatsuo Ishii)
>>>>
>>>> - Fix return type of text_to_lsn() function (Yugo Nagata)
>>>>
>>>> This caused compile warning.
>>>>
>>>> - Fix file descriptor leak when daemonize. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111471.
>>>>
>>>> - Fix memory leak. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111442.
>>>>
>>>> - Fix pgpool.init's long-standing bug of stop/restart failure
>>>> (Yugo Nagata)
>>>>
>>>> In previous, pgpool.init uses killproc for stopping pgpool, but
>>>> there are several problems. In the new version, "pgpool -m fast stop"
>>>> is used in stop command.
>>>>
>>>> Original patch contributed by Ryan DeShone and modified by Yugo
>>>> Nagata.
>>>>
>>>> See [pgpool-hackers: 239][pgpool-hackers: 512].
>>>>
>>>> - Add missing include file sys/wait.h. (Tatsuo Ishii)
>>>>
>>>> Per bug #104. http://www.pgpool.net/mantisbt/view.php?id=104
>>>>
>>>> - Disbale statement_timeout of PostgreSQL while executing online
>>>> recovery (Tatsuo Ishii)
>>>>
>>>> Online recovery may take very long time and user may enable
>>>> statement timeout. To prevent online recovery canceled by statement
>>>> timeout, disable statement timeout in the connection used by online
>>>> recovery.
>>>>
>>>> See [pgpool-general: 2919] for more details.
>>>>
>>>> - Remove unnecessary call to pool_shmem_exit() which removes
>>>> semaphore when it shouldn't (Tatsuo Ishii)
>>>>
>>>> exit_handler checks if the process is parent or not. This is
>>>> good. However, even if it is a child process, it calls
>>>> pool_shmem_exit() which removes semaphore and shmem when it should
>>>> not. It should be called only from parent process.
>>>>
>>>> Per bug #102. http://www.pgpool.net/mantisbt/view.php?id=102
>>>>
>>>> ===============================================================================
>>>>
>>>> 3.1.12 (hatsuiboshi) 2014/09/05
>>>>
>>>> * Version 3.1.12
>>>>
>>>> This is a bugfix release against pgpool-II 3.1.11.
>>>>
>>>> __________________________________________________________________
>>>>
>>>> * Bug fixes
>>>>
>>>> - Fix a typo of pgpool.spec (Yugo Nagata)
>>>>
>>>> - Fix bug that worker child process keeps failing when there's no
>>>> primary backend (Tatsuo Ishii)
>>>>
>>>> Problem identified and fix contributed by Junegunn Choi.
>>>>
>>>> See [pgpool-hackers: 471] for more details.
>>>>
>>>> - Close listen socket when smart shutdown request is made (Tatsuo
>>>> Ishii)
>>>>
>>>> When smart shutdown process starts, pgpool children still listen
>>>> on the port and clients can send further connection requests which
>>>> fail in the end. Which is not only waste of time, but also prevents a
>>>> load balancer which sits in front of pgpool from realizing the pgpool
>>>> is going down.
>>>>
>>>> Problem analyzed and patch provided by Junegunn Choi in
>>>> [pgpool-hackers 474], and enhanced to take care not only inet domain
>>>> socket but UNIX domain socket by Tatsuo Ishii.
>>>>
>>>> - doc: Add cautions that recovery commands are killed by
>>>> statement_timeout of PostgreSQL. (Tatsuo Ishii)
>>>>
>>>> - doc: Remove old restriction description which is no longer true
>>>> (Tatsuo Ishii)
>>>>
>>>> - Fix return type of text_to_lsn() function (Yugo Nagata)
>>>>
>>>> This caused compile warning.
>>>>
>>>> - Fix file descriptor leak when daemonize. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111471.
>>>>
>>>> - Fix memory leak. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111442.
>>>>
>>>> - Fix pgpool.init's long-standing bug of stop/restart failure
>>>> (Yugo Nagata)
>>>>
>>>> In previous, pgpool.init uses killproc for stopping pgpool, but
>>>> there are several problems. In the new version, "pgpool -m fast stop"
>>>> is used in stop command.
>>>>
>>>> Original patch contributed by Ryan DeShone and modified by Yugo
>>>> Nagata.
>>>>
>>>> See [pgpool-hackers: 239][pgpool-hackers: 512].
>>>>
>>>> - Disbale statement_timeout of PostgreSQL while executing online
>>>> recovery (Tatsuo Ishii)
>>>>
>>>> Online recovery may take very long time and user may enable
>>>> statement timeout. To prevent online recovery canceled by statement
>>>> timeout, disable statement timeout in the connection used by online
>>>> recovery.
>>>>
>>>> See [pgpool-general: 2919] for more details.
>>>>
>>>> - Remove unnecessary call to pool_shmem_exit() which removes
>>>> semaphore when it shouldn't (Tatsuo Ishii)
>>>>
>>>> exit_handler checks if the process is parent or not. This is
>>>> good. However, even if it is a child process, it calls
>>>> pool_shmem_exit() which removes semaphore and shmem when it should
>>>> not. It should be called only from parent process.
>>>>
>>>> Per bug #102. http://www.pgpool.net/mantisbt/view.php?id=102
>>>>
>>>> ===============================================================================
>>>>
>>>> 3.0.16 (umiyameboshi) 2014/09/05
>>>>
>>>> * Version 3.0.16
>>>>
>>>> This is a bugfix release against pgpool-II 3.0.15.
>>>>
>>>> __________________________________________________________________
>>>>
>>>> * Bug fixes
>>>>
>>>> - Fix a typo of pgpool.spec (Yugo Nagata)
>>>>
>>>> - Fix bug that worker child process keeps failing when there's no
>>>> primary backend (Tatsuo Ishii)
>>>>
>>>> Problem identified and fix contributed by Junegunn Choi.
>>>>
>>>> See [pgpool-hackers: 471] for more details.
>>>>
>>>> - Close listen socket when smart shutdown request is made (Tatsuo
>>>> Ishii)
>>>>
>>>> When smart shutdown process starts, pgpool children still listen
>>>> on the port and clients can send further connection requests which
>>>> fail in the end. Which is not only waste of time, but also prevents a
>>>> load balancer which sits in front of pgpool from realizing the pgpool
>>>> is going down.
>>>>
>>>> Problem analyzed and patch provided by Junegunn Choi in
>>>> [pgpool-hackers 474], and enhanced to take care not only inet domain
>>>> socket but UNIX domain socket by Tatsuo Ishii.
>>>>
>>>> - doc: Add cautions that recovery commands are killed by
>>>> statement_timeout of PostgreSQL. (Tatsuo Ishii)
>>>>
>>>> - doc: Remove old restriction description which is no longer true
>>>> (Tatsuo Ishii)
>>>>
>>>> - Fix return type of text_to_lsn() function (Yugo Nagata)
>>>>
>>>> This caused compile warning.
>>>>
>>>> - Fix file descriptor leak when daemonize. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111471.
>>>>
>>>> - Fix memory leak. (Tatsuo Ishii)
>>>>
>>>> Per Coverity 1111442.
>>>>
>>>> - Fix pgpool.init's long-standing bug of stop/restart failure
>>>> (Yugo Nagata)
>>>>
>>>> In previous, pgpool.init uses killproc for stopping pgpool, but
>>>> there are several problems. In the new version, "pgpool -m fast stop"
>>>> is used in stop command.
>>>>
>>>> Original patch contributed by Ryan DeShone and modified by Yugo
>>>> Nagata.
>>>>
>>>> See [pgpool-hackers: 239][pgpool-hackers: 512].
>>>>
>>>> - Disbale statement_timeout of PostgreSQL while executing online
>>>> recovery (Tatsuo Ishii)
>>>>
>>>> Online recovery may take very long time and user may enable
>>>> statement timeout. To prevent online recovery canceled by statement
>>>> timeout, disable statement timeout in the connection used by online
>>>> recovery.
>>>>
>>>> See [pgpool-general: 2919] for more details.
>>>>
>>>> - Remove unnecessary call to pool_shmem_exit() which removes
>>>> semaphore when it shouldn't (Tatsuo Ishii)
>>>>
>>>> exit_handler checks if the process is parent or not. This is
>>>> good. However, even if it is a child process, it calls
>>>> pool_shmem_exit() which removes semaphore and shmem when it should
>>>> not. It should be called only from parent process.
>>>>
>>>> Per bug #102. http://www.pgpool.net/mantisbt/view.php?id=102
>>>>
>>>> ===============================================================================
>>>
>>> --
>>> "I am not young enough to know everything."
>>> - Oscar Wilde
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>
> --
> "For, contrary to the unreasoned opinion of the ignorant, the choice of
> a system of numeration is mere matter of convention."
> - Blaise Pascal (1623-1662)
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list