pgpool2.git / summary / log / commit / refs
commit f7d79192c6cb129fd89a3c5c74e72b06c4bf8493
Author: Yugo Nagata <nagata@sraoss.co.jp>
Date: Mon Dec 14 10:34:49 2015 +0000
Prepare 3.5 beta1
NEWS | 24 +++++++++++++++++++++++-
configure | 20 ++++++++++----------
configure.ac | 2 +-
doc/pgpool-ja.html | 22 +++++++++++++++++++++-
4 files changed, 55 insertions(+), 13 deletions(-)
diff --git a/NEWS b/NEWS
index 7d43acdbb..8644b8b44 100644
--- a/NEWS
+++ b/NEWS
@@ -4,7 +4,7 @@
3.5 Series (2014/12/15 - )
===============================================================================
- 3.5.0 (ekieboshi) 2015/12/15
+ 3.5.0 (ekieboshi) 201x/xx/xx
* Version 3.5.0
@@ -251,6 +251,28 @@
- test: Fix regression test 055 for rhel7 rpm (Yugo Nagata)
+ - Fix reset query stuck problem (Muhammad Usama)
+
+ The issue is already fixed in older branches and this fix adopts the
+ same solution used by 3.3 series, i.e. closing the backend connection
+ when client idle limit is reached.
+
+ - Fix bug with "SET TRANSACTION READ ONLY" (Tatsuo Ishii)
+
+ Pgpool-II remembers that non read only queries (including SET) were
+ executed in an explicit transaction and adds a "writing transaction"
+ mark to the transaction. The mark affects the query routing behavior
+ of pgpool-II while running in streaming replication mode. Pgpool-II
+ starts sending queries to the primary after the mark is set. Because
+ the effect of writing queries may appear on standbys after some delay
+ in streaming replication mode, it is safer to route read queries to
+ the primary after the mark is set.
+
+ However there's oversight here. "SET TRANSACTION READ ONLY" does no
+ data modification and should be treated as an exception.
+
+ Per bug #157.
+
===============================================================================
3.4 Series (2014/11/07 - )
===============================================================================
diff --git a/configure b/configure
index 5e432823a..f761995e7 100755
--- a/configure
+++ b/configure
@@ -1,6 +1,6 @@
#! /bin/sh
# Guess values for system-dependent variables and create Makefiles.
-# Generated by GNU Autoconf 2.69 for pgpool-II 3.5alpha1.
+# Generated by GNU Autoconf 2.69 for pgpool-II 3.5beta1.
#
# Report bugs to <pgpool-hackers@pgpoo.net>.
#
@@ -590,8 +590,8 @@ MAKEFLAGS=
# Identity of this package.
PACKAGE_NAME='pgpool-II'
PACKAGE_TARNAME='pgpool-II'
-PACKAGE_VERSION='3.5alpha1'
-PACKAGE_STRING='pgpool-II 3.5alpha1'
+PACKAGE_VERSION='3.5beta1'
+PACKAGE_STRING='pgpool-II 3.5beta1'
PACKAGE_BUGREPORT='pgpool-hackers@pgpoo.net'
PACKAGE_URL=''
@@ -1343,7 +1343,7 @@ if test "$ac_init_help" = "long"; then
# Omit some internal or obsolete options to make the list less imposing.
# This message is too long to be a string in the A/UX 3.1 sh.
cat <<_ACEOF
-\`configure' configures pgpool-II 3.5alpha1 to adapt to many kinds of systems.
+\`configure' configures pgpool-II 3.5beta1 to adapt to many kinds of systems.
Usage: $0 [OPTION]... [VAR=VALUE]...
@@ -1413,7 +1413,7 @@ fi
if test -n "$ac_init_help"; then
case $ac_init_help in
- short | recursive ) echo "Configuration of pgpool-II 3.5alpha1:";;
+ short | recursive ) echo "Configuration of pgpool-II 3.5beta1:";;
esac
cat <<\_ACEOF
@@ -1541,7 +1541,7 @@ fi
test -n "$ac_init_help" && exit $ac_status
if $ac_init_version; then
cat <<\_ACEOF
-pgpool-II configure 3.5alpha1
+pgpool-II configure 3.5beta1
generated by GNU Autoconf 2.69
Copyright (C) 2012 Free Software Foundation, Inc.
@@ -2204,7 +2204,7 @@ cat >config.log <<_ACEOF
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
-It was created by pgpool-II $as_me 3.5alpha1, which was
+It was created by pgpool-II $as_me 3.5beta1, which was
generated by GNU Autoconf 2.69. Invocation command line was
$ $0 $@
@@ -3980,7 +3980,7 @@ fi
# Define the identity of the package.
PACKAGE='pgpool-II'
- VERSION='3.5alpha1'
+ VERSION='3.5beta1'
cat >>confdefs.h <<_ACEOF
@@ -15168,7 +15168,7 @@ cat >>$CONFIG_STATUS <<\_ACEOF || ac_write_fail=1
# report actual input values of CONFIG_FILES etc. instead of their
# values after options handling.
ac_log="
-This file was extended by pgpool-II $as_me 3.5alpha1, which was
+This file was extended by pgpool-II $as_me 3.5beta1, which was
generated by GNU Autoconf 2.69. Invocation command line was
CONFIG_FILES = $CONFIG_FILES
@@ -15234,7 +15234,7 @@ _ACEOF
cat >>$CONFIG_STATUS <<_ACEOF || ac_write_fail=1
ac_cs_config="`$as_echo "$ac_configure_args" | sed 's/^ //; s/[\\""\`\$]/\\\\&/g'`"
ac_cs_version="\\
-pgpool-II config.status 3.5alpha1
+pgpool-II config.status 3.5beta1
configured by $0, generated by GNU Autoconf 2.69,
with options \\"\$ac_cs_config\\"
diff --git a/configure.ac b/configure.ac
index 0c4fd1d91..7a2a084b7 100644
--- a/configure.ac
+++ b/configure.ac
@@ -1,5 +1,5 @@
dnl Process this file with autoconf to produce a configure script.
-AC_INIT([pgpool-II], [3.5alpha1], [pgpool-hackers@pgpoo.net], [pgpool-II])
+AC_INIT([pgpool-II], [3.5beta1], [pgpool-hackers@pgpoo.net], [pgpool-II])
dnl Checks for programs.
AC_PROG_CC
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index cdbd84efc..ac3712f81 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -6005,7 +6005,7 @@ configure に失敗します。必ず libpq 3.0 以降(PostgreSQL 7.4以降) を
<hr><a name="release3.5.x"></a>
<!-- -------------------------------------------------------------------------------- -->
-<h2><a name="release3.5.0"></a>3.5.0 (ekieboshi) 2015/12/15</h2>
+<h2><a name="release3.5.0"></a>3.5.0 (ekieboshi) 201x/xx/xx</h2>
<!-- -------------------------------------------------------------------------------- -->
<h3>概要</h3>
<p>
@@ -6291,6 +6291,26 @@ JDBC_DRIVER 環境変数の値を用いるように変更されました。
<li>doc: ドキュメントに欠けていたデフォルト値の記述を追加しました。(Yugo Nagata)</li>
+<li>リセットクエリがスタックする問題を修正しました。(Muhammad Usama)
+<p>
+この問題は他のブランチでは既に修正済みであり、今回も 3.3 シリーズと同じ方法で解決されました。
+すなわち、client idle limit に達した際に、バックエンドの接続を閉じるようにしました。
+</p>
+</li>
+
+<li>"SET TRANSACTION READ ONLY" のバグを修正しました。(Tatsuo Ishii)
+<p>
+pgpool-II は読み込み以外を行うクエリ（SET を含む）が明示的なトランザクションの中で実行されたことを記憶し、
+それが「書き込みトランザクション」であることをマークします。
+これはストリーミングレプリケーション時のクエリの振り分け処理に影響します。
+pgpool-II はそのマークの後、クエリをプライマリに送信するようになります。
+これは、ストリーミングレプリケーションで書き込みクエリの結果がスタンバイで遅れて現れるために、
+クエリはプライマリに送られが方がより安全だからです。
+
+ただし、見過ごされていましたが "SET TRANSACTION READ ONLY" はデータを変更しないので、例外として扱われるべきでした。
+
+バグ報告 #157 によります。
+</p></li>
</ul>
<!-- ================================================================================ -->
[parent: adde99925136]