2010-04-23 15:53 t-ishii
* test/parser/expected/: v84.out (V2_3_STABLE.2), v84.out (1.1):
Add missing file
2010-04-23 15:53 t-ishii
* test/parser/expected/v84.out (V2_3_STABLE.1): file v84.out was
added on branch V2_3_STABLE on 2010-04-23 06:54:38 +0000
2010-04-23 13:50 anzai
* ChangeLog (tags: V2_3_3) (V2_3_STABLE.1):
Prepare 2.3.3
2010-04-23 13:47 anzai
* COPYING, NEWS, configure, configure.in, doc/pgpool-ja.html
(V2_3_STABLE.[1,1,1,1,1]) (utags: V2_3_3):
Prepare 2.3.3
2010-04-16 13:16 kitagawa
* pool_config.c (1.36, V2_3_3): parallel_mode requires
replication_mode or load_balance_mode turned on. This fix is
consistent with the description of manual.
2010-04-13 13:14 t-ishii
* child.c (1.45), main.c (1.64), pool_connection_pool.c (1.22)
(utags: V2_3_3): Fix long standing bug which causes segfault of
pgpool child process. This was caused buy miscalculation of shmem
size in pgpool parent. The bug appears in at least following
sequence in 64bit linux platform:
1) set max_pool = 1 and num_init_children = 30
2) connect to the pgpool child which was forked lastly
3) let pgpool child die by SIGQUIT and fork (i.e. failover,
child_life_time timeout etc.)
4) if tries to connect to #3 child, it segfaults
This bug has been there since pgpool-II 1.0 was born.
Bug analysis by Toshihiro Kitagawa.
2010-04-05 16:34 kitagawa
* doc/: pgpool-en.html (1.42, V2_3_3), pgpool-ja.html (1.71): Add
restriction for parallel mode. This is the same description as the
manual of V2_2_STABLE.
- The Natural Join is not supported.
- The USING CLAUSE is converted to ON CLAUSE by query rewrite
process.
2010-03-25 13:24 kitagawa
* pool_config.l (1.33, V2_3_3): parallel_mode requires
replication_mode or load_balance_mode turned on. This fix is
consistent with the description of manual.
2010-03-19 21:55 kitagawa
* pool_rewrite_outfuncs.c (1.23, V2_3_3): Fix possible crash during
rewriting JOIN syntax that have USING in parallel query mode.
This fix is supporting such as following JOIN syntax.
example:
- SELECT * FROM a JOIN b USING (aid) JOIN c USING (cid);
- SELECT * FROM a JOIN b USING (aid) JOIN c USING (cid) JOIN d USING
(did); etc.
2010-03-19 21:24 kitagawa
* pool_rewrite_query.c (1.15, V2_3_3): Fix getInsertRule() so that
it can parse INSERT statements that have current_time before a
partitioning key column.
See [pgpool-general-jp: 712] for more details.
2010-03-19 20:53 kitagawa
* pool_config.l (1.32): parallel_mode requires replication_mode
turned on. See [pgpool-general-jp: 719] for more details.
2010-03-19 20:39 kitagawa
* pool_process_query.c (1.199, V2_3_3): Fix
SimpleForwardToBackend() so that pgpool doesn't keep waiting for
reply from a backend, when clients using the extended query protocol
cause a command error such as bind error.
This bug occur in raw mode or connection pool mode. This fix is,
sending SYNC message to recover error after command error.
2010-03-19 16:31 t-ishii
* child.c (1.44): Fix SIGINT/SIGQUIT is ignored if pgpool child is
in select(). In this case pgpool retries select() thus the signal is
ignored. See following thread for more details.
Subject: [Pgpool-general] The Unplugged wire From: Daniel Codina To:
pgpool-general@pgfoundry.org Date: Mon, 1 Mar 2010 15:19:00 +0100
2010-03-19 16:23 t-ishii
* pool_proto_modules.c (1.37, V2_3_3): Fix typo in comment.
2010-03-09 15:18 t-ishii
* pgpool.conf.sample-master-slave (1.4, V2_3_3): Change default
value for insert_lock to false since there's no point in turning
this on in master/slave mode. Fix suggested by Fujii Masao.
2010-03-06 21:54 t-ishii
* pcp_child.c (1.13, V2_3_3), pool.h (1.58, V2_3_3),
pool_connection_pool.c (1.21): Fix
connect_inet_domain_socket_by_port/
connect_unix_domain_socket_by_port so that they check if
SIGTERM/SIGINT/SIGQUIT signal has been delivered. Per bug report
from Daniel Codina. See: Subject: Re: [Pgpool-general] The Unplugged
wire Date: Thu, 4 Mar 2010 15:20:37 +0100
2010-03-05 15:49 kitagawa
* pool_process_query.c (1.198): Fix possible crash during creating
"kind mismatch" error message. This used to work but was broken in
2.3.2.
2010-03-03 09:31 t-ishii
* child.c (1.43), main.c (1.63), pool.h (1.57),
pool_connection_pool.c (1.20): Fix bug with healh checking. If a
network problem such as unplugged wire happens while calling
connect(), health checking does not work since
connect_unix_domain_socket()/connect_inet_domain_socket() do retry
if connect() is interrupted by ALARM signal. Added new retry
argument which controls the retrying behavior to those functions.
Per bug report and problem analysis by Daniel Codina. See following
message for more details. Subject: [Pgpool-general] The Unplugged
wire Date: Mon, 1 Mar 2010 15:19:00 +0100
2010-03-03 00:31 t-ishii
* pool_process_query.c (1.197): Fix enbug in 2.3.2.2 with time
stamp rewriting in SimpleForwardToBackend. Per bug report from
Bugtrack #1010771. Report from Peter Pramberge.
2010-03-03 00:25 t-ishii
* main.c (1.62): Fix comment.
2010-03-02 18:55 kitagawa
* pool_rewrite_outfuncs.c (1.22): Import patch at revision
1.15.2.4.
Fix rewriting "*" in paralell query. Patch conributed by sho-san.
2010-02-28 21:39 t-ishii
* README.online-recovery (1.1, V2_3_3): Internal document for
online recovery
2010-02-28 18:22 t-ishii
* pool_connection_pool.c (1.19): Fix typo.
2010-02-27 13:21 t-ishii
* pool_connection_pool.c (1.18): Fix
connect_inet_domain_socket_by_port() so that it print out error
message by using hstrerror(), rather than strerror().
2010-02-22 14:20 t-ishii
* ChangeLog (1.48, V2_3_2_2): Prepare for 2.3.2.2.
2010-02-22 14:18 t-ishii
* doc/pgpool-ja.html (1.70, V2_3_2_2): prepare for 2.3.2.2.
2010-02-22 13:49 t-ishii
* NEWS (1.34), configure (1.37), configure.in (1.34) (utags:
V2_3_2_2): Prepare 2.3.2.2
2010-02-22 12:53 t-ishii
* pool_proto_modules.c (1.36, V2_3_2_2): Fix parse(). When
rewriting timestamp query, it allocated less than what it actually
needed.
2010-02-17 23:00 t-ishii
* pool_timestamp.c (1.7, V2_3_3, V2_3_2_2): Fix
bind_rewrite_timestamp. It crashes if param length is -1, that
indicates NULL.
2010-02-13 20:23 t-ishii
* main.c (1.61, V2_3_2_2): Fix read_status_file so that if all
nodes were marked down status, it is regarded that this file is
bogus. This will prevent "all node down" syndrome.
2010-02-11 18:40 t-ishii
* ChangeLog (1.47), doc/pgpool-ja.html (1.69) (utags: V2_3_2_1):
Prepare 2.3.2.1
2010-02-11 18:35 t-ishii
* doc/pgpool-ja.html (1.68), NEWS (1.33, V2_3_2_1): Prepare 2.3.2.1
2010-02-11 18:29 t-ishii
* configure (1.36), configure.in (1.33) (utags: V2_3_2_1): Prepare
2.3.2.1
2010-02-10 18:41 t-ishii
* pool_process_query.c (1.196, V2_3_2_2, V2_3_2_1): Fix
pool_extract_error_message not to write past end of message_buf.
This causes kind = 0 error on some platforms/gcc combo. Patch
contributed by Akio Ishida. Minor tweak by Tatsuo.
2010-02-07 16:20 t-ishii
* ChangeLog (1.46), NEWS (1.32), doc/pgpool-ja.html (1.67) (utags:
V2_3_2): Prepare 2.3.2
2010-02-07 16:04 t-ishii
* pool_process_query.c (1.195, V2_3_2): Fix read_kind_from_backend
so that it properly checks the return value from
pool_extract_error_message.
2010-02-07 12:08 t-ishii
* pool_process_query.c (1.194): Enhance read_kind_from_backend. If
kind mismatch error occurs and command is DEALLOCATE, print original
prepared query which DEALLOCATE tries to delete.
2010-02-07 12:05 t-ishii
* pool_proto_modules.c (1.35, V2_3_2_1, V2_3_2): Fix SimpleQuery if
DEALLOCATE received, register pending function.
2010-02-07 12:04 t-ishii
* main.c (1.60, V2_3_2_1, V2_3_2): Fix I/O check in reading/writing
status file.
2010-02-04 09:31 t-ishii
* pool_ssl.c (1.5, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2): Change
pool_error to pool_log when backend does not support SSL but pgpool
does.
2010-02-03 19:31 t-ishii
* pool_ssl.c (1.4): All previously handled errors related to the
OpenSSL engine are now handled with a macro and a small static
function in order to both produce more informative errors as well as
commonize some duplicate code in pool_ssl.c
Patch contributed by Sean Finney
2010-02-03 17:11 t-ishii
* pool.h (1.56, V2_3_2_2, V2_3_2_1, V2_3_2), pool_process_query.c
(1.193), pool_proto_modules.c (1.34): Emit statement log when
error or notice message comes from backend when SimpleQuery or Parse
executed. This is usefull because PostgreSQL does not log
particular statement if the error was detected *before* raw parser
get executed. This typlically happens when encoding error was
found.
2010-02-02 14:45 t-ishii
* TODO (1.20, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2): Sync TODO with
2.3.2
2010-02-02 14:44 t-ishii
* doc/: pgpool-en.html (1.41, V2_3_2_2, V2_3_2_1, V2_3_2),
pgpool-ja.html (1.66): Add description about how to sync
sequences in online recovery
2010-02-02 14:43 t-ishii
* pool_process_query.c (1.192): Fix typo in comment
2010-02-01 18:05 t-ishii
* child.c (1.42, V2_3_2_2, V2_3_2_1, V2_3_2), pool.h (1.55),
pool_process_query.c (1.191), pool_timestamp.c (1.6, V2_3_2_1,
V2_3_2), test/timestamp/expected/insert.out (1.3, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2), test/timestamp/input/insert.sql
(1.2, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2): Fix timestamp
rewritting. Fix number of parameters of Prepare. Fix prepared
statement list to be reset when connection_cache = false. Patch
contributed by Akio Ishida.
2010-01-31 22:28 t-ishii
* pool_ssl.c (1.3): Include string.h for strlen
2010-01-31 12:15 t-ishii
* ChangeLog (1.45): Update ChangeLog
2010-01-31 11:55 t-ishii
* pool_process_reporting.c (1.4, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2): Add lobj_lock_table, ssl, ssl_key and ssl_cert.
2010-01-31 11:54 t-ishii
* pool_lobj.c (1.3, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2): Fix error
message
2010-01-31 11:22 t-ishii
* NEWS (1.31), configure (1.35, V2_3_2), configure.in (1.32,
V2_3_2), pgpool.conf.sample (1.32, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2), pgpool.conf.sample-master-slave (1.3, V2_3_2_2,
V2_3_2_1, V2_3_2), pgpool.conf.sample-replication (1.3, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2), pool.h (1.54), pool_config.c (1.35,
V2_3_2_2, V2_3_2_1, V2_3_2), pool_config.l (1.31, V2_3_2_2,
V2_3_2_1, V2_3_2), pool_ssl.c (1.2), doc/pgpool-en.html (1.40),
doc/pgpool-ja.html (1.65): Prepare 2.3.2.
2010-01-30 10:57 t-ishii
* pool_process_query.c (1.190), pool_proto_modules.c (1.33): Fix
parse() so that it does not use already-freeed memory when sending
rewritten packet for timestamp support. Also fix
SimpleForwardToBackend() to free rewritten packet in proper timing.
2010-01-26 23:49 t-ishii
* Makefile.am (1.30, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2),
Makefile.in (1.34, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2), child.c
(1.41), config.h.in (1.10, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2),
configure (1.34), configure.in (1.31), main.c (1.59),
pgpool.conf.sample (1.31), pgpool.conf.sample-master-slave (1.2),
pgpool.conf.sample-replication (1.2), pool.h (1.53),
pool_config.c (1.34), pool_config.l (1.30), pool_ssl.c (1.1),
pool_stream.c (1.19, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2): Add SSL
support. Patch contributed by Sean Finney.
-------------------------------------------------------------------
The new pool_ssl.c provides the necessary functions for negotiating
SSL based connections for both frontend and backend connections.
child.c has been updated to request the negotiation in both cases,
and pool_stream.c has been modified to use SSL based i/o functions
if a connection has successfully negotiated a connection.
SSL related failures should be handled as gracefully as possible.
For frontend connections, the client is allowed to continue in
cleartext in the case that SSL negotiation was not successful. For
backend connections, plaintext connections should continue as well,
modulo any pg_hba restrictions on the remote server. It is also
possible to have connections where only one of the frontend/backend
uses SSL.
By default this functionality is off (further testing should be done
and perhaps better controls on certificate verification, etc).
New fields are added to the global pool configuration to allow
specifying SSL related settings:
* "ssl", global on/off switch (default: off)
* "ssl_cert", path to SSL public certificate (default: "")
* "ssl_key", path to SSL private key (default: "")
The sample pgpool.conf files have been updated with comments and
sample values for these new settings.
The autoconf build system has been updated with a new
"--with-openssl" option to allow enabling/disabling SSL support at
build time. For simplicity and clarity no effort is made to provide
extra flexibility similar to the existing
--with-pgsql{,-include-dir,lib-dir} ./configure flags. In the
meantime it's expected that the necessary flags are provided via
CFLAGS/LDFLAGS etc when calling ./configure.
2010-01-26 18:53 t-ishii
* pool.h (1.52), pool_lobj.c (1.2), pool_process_query.c (1.189),
pool_relcache.c (1.6, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2),
pool_timestamp.c (1.5), test/timestamp/main.c (1.2, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2): Teach do_query to support V2
protocol. This will solve the problem with pgpool-II 2.3 user who
are experiencing error while using V2 dirvers (for example
unixODBC). See [Pgpool-general] Bug report pgpool-II-2.3.1 plus ODBC
submitted on Tue, 12 Jan 2010 12:46:35 -0500 for this kind of use
case. Patch contributed by Toshihiro Kitagawa.
2010-01-24 00:21 t-ishii
* Makefile.am (1.29), Makefile.in (1.33), pgpool.conf.sample
(1.30), pool.h (1.51), pool_config.c (1.33), pool_config.l
(1.29), pool_lobj.c (1.1), pool_process_query.c (1.188): Add
support for large object creation in replication mode. We rewrite
lo_creat function call to lo_create which allow us to specifiy large
object id. The missing argument for lo_create is taken by: SELECT
coalesce(max(loid)::INTEGER, 0)+1 FROM pg_catalog.pg_largeobject; To
avoid race condion, we add new directive called lobj_lock_table
which is used to aquire lock while grabing above value. New source
file pool_lobj.c added.
2010-01-21 16:41 t-ishii
* pool_process_query.c (1.187), pool_proto_modules.c (1.32): Fix
SimpleForwardtoBackend so that it sends Bind, Describe and Close
message to only master node if running in master/slave and in
transaction.
2010-01-19 16:23 kitagawa
* child.c (1.40): Fix do_child() so that check_stop_request() exits
immediately when smart shutdown signal has been sent. This has been
used to work in 2.2.
2010-01-17 17:42 t-ishii
* pool_rewrite_outfuncs.c (1.21, V2_3_2_2, V2_3_2_1, V2_3_2): Add
standard pgpool Global Development Group header comments. This was
missing from the day one of the file.
Fix _rewriteGrantStmt to suppress compiler warnings. (This is not
an actual fix, just make it cleaner that we are missing some
implementations).
2010-01-17 17:19 t-ishii
* pool_timestamp.c (1.4): Fix bind_rewrite_timestamp when used with
paramFormats being specified and more than two parameters exist.
Patch contributed by Akio Ishida. See [pgpool-general-jp: 670] for
more details.
2010-01-09 18:15 t-ishii
* pool_proto_modules.c (1.31): Fix ProcessFrontendResponse not to
accept invalid frotend packet. Patch contributed by Xavier Noguer.
2010-01-09 18:10 t-ishii
* child.c (1.39), pool.h (1.50), pool_process_query.c (1.186):
Remove unused argument first_ready_for_query_received from
pool_process_query. Also change argument "connection_reuse" to
reset_request which is more appropreate one. While processing
reset_request is true, we don't read from frontend any data because
after received terminate request, anything from from frontend must
be bogus and should be ignored. Remove unsed variable
first_ready_for_query_received from do_child.
2010-01-02 18:32 t-ishii
* child.c (1.38):
I found what I think is a small error allocating memory in the
make_persistent_db_connection() function in child.c. The amount of
memory allocated is more than it should be, so it's actually
harmless.
Patch contributed by Xavier Noguer.
2010-01-02 18:17 t-ishii
* pool_connection_pool.c (1.17, V2_3_2_2, V2_3_2_1, V2_3_2),
pool_process_query.c (1.185), pool_proto_modules.c (1.30),
pool_relcache.c (1.5): Fix warnings when compiling on 64bit
platforms.
2009-12-25 10:59 t-ishii
* pool_proto_modules.c (1.29): Do not force replication of
DEALLOCATE if operated in master/slave mode. Now that pgpool do not
execute PARSE in all nodes, this was pointless and caused problem
(kind mismatch when executing DEALLOCATE).
2009-12-25 10:58 t-ishii
* pool_process_query.c (1.184): Fix sloppy coding in
parse_copy_data. Add error checking for malloc. Remove meaningless
strerror.
Fix sloppy coding in send_dealllocate. If failed to malloc, return
-1, rather than horrible exit(1).
2009-12-23 18:30 t-ishii
* main.c (1.58), recovery.c (1.14, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2): While health checking and recovery use postgres database
if possible. If postgres database does not exist, use template1 as
it stands now. While connecting template1, certain commands, for
example DROP DATABSE cannot used. Using postgres database allows to
use these commands while recovery.
2009-12-18 17:18 t-ishii
* doc/pgpool-ja.css (1.1, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1): Add css file for Japanese.
2009-12-18 17:16 t-ishii
* NEWS (1.30), doc/pgpool-ja.html (1.64), ChangeLog (1.44) (utags:
V2_3_1): Prepare for 2.3.
2009-12-18 16:09 t-ishii
* Makefile.am (1.28), Makefile.in (1.32), c-compiler.m4 (1.1,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2), c-library.m4 (1.1, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2), config.h.in (1.9), configure (1.33),
configure.in (1.30), general.m4 (1.1, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2), parser/Makefile.in (1.18, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2), pcp/Makefile.in (1.16, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2) (utags: V2_3_1): Fix bugtrack [#1010740] BigInt
distortion in pgpool-II 2.3 version, when NOW() use. This bug only
exists on 64bit platforms.
This was caused by that following code in parser/scan.l does not
work properly on 64bit platforms because HAVE_LONG_INT_64 is not
defined. To fix this we steal part of PostgreSQL's configure and
some m4 macros.
long val;
char* endptr;
SET_YYLLOC();
errno = 0;
val = strtol(yytext, &endptr, 10);
if (*endptr != '\0' || errno == ERANGE #ifdef HAVE_LONG_INT_64
/* if long > 32 bits, check for overflow of int4 */
|| val != (long) ((int32) val) #endif
)
{
/* integer too large, treat it as a float */
yylval.str = pstrdup(yytext);
return FCONST;
}
yylval.ival = val;
return ICONST;
2009-12-18 09:30 t-ishii
* pool_process_reporting.c (1.3, V2_3_1): Fix crush with show
pool_status when there many (more than 18) DB nodes.
2009-12-16 18:35 t-ishii
* main.c (1.57, V2_3_1): Enhance pgpool start up log.
2009-12-16 16:27 t-ishii
* pool_process_query.c (1.183, V2_3_1): Fix sloppy coding of
detect_erorr(). Check memory allocation error, check buffer overrun
error.
2009-12-16 16:19 t-ishii
* pool.h (1.49, V2_3_1), pool_process_query.c (1.182): Enhance
"kind mismatch" message. If kind is ERROR or NOTICE, print the
ERROR/NOTICE message to help users to find what's going on. For
this pupose, add new function pool_extract_error_message() into
pool_process_query.c.
2009-12-07 20:47 t-ishii
* Makefile.am (1.27), Makefile.in (1.31): Forgot to add sample
pgpool.conf files.
2009-12-07 18:41 t-ishii
* doc/pgpool-ja.html (1.63, V2_3): Change release date
2009-12-07 18:38 t-ishii
* NEWS (1.29, V2_3), doc/pgpool-en.html (1.39, V2_3_1, V2_3),
doc/pgpool-ja.html (1.62), ChangeLog (1.43, V2_3): Prepare 2.3
2009-12-07 17:11 t-ishii
* pool_process_query.c (1.181, V2_3): Allow to load balance EXPLAIN
and EXPLAIN ANALYZE (only if query is SELECT). This will prevent
kind mismatch errors when query plan are different among servers.
2009-12-06 21:55 t-ishii
* main.c (1.56), pool.h (1.48), pool_type.h (1.11, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1) (utags: V2_3): Restore
backend status by using pgpool_status file.
2009-12-06 20:53 t-ishii
* version.h (1.6, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_3): Change code name for pgpool-II 2.3
2009-12-06 18:57 t-ishii
* pgpool.conf.sample-master-slave (1.1),
pgpool.conf.sample-replication (1.1) (utags: V2_3, V2_3_1): Add
pgpool.conf sample for replication mode and master/slave mode
2009-12-06 17:46 t-ishii
* pgpool.conf.sample (1.29, V2_3_1, V2_3), pool.h (1.47),
pool_config.c (1.32, V2_3_1, V2_3), pool_config.l (1.28, V2_3_1,
V2_3), pool_process_query.c (1.180), pool_process_reporting.c
(1.2, V2_3), pool_stream.c (1.18, V2_3_1, V2_3): Add new
configuration parameter fail_over_on_backend_error which controls
the behavior when write to backend socket fails.
Also add pool_log when postmaster administrative shutdown detected.
2009-12-06 16:52 t-ishii
* pool_process_query.c (1.179), pool_proto_modules.c (1.28, V2_3_1,
V2_3): Ignore error of pool_flush(frontend).
2009-12-06 16:46 t-ishii
* pool_proto_modules.c (1.27): Optimization when num_init_children
== 1. In this case we don't need to wait for master returning a
response before sending a query to the other nodes.
2009-12-06 16:43 t-ishii
* Makefile.am (1.26, V2_3), Makefile.in (1.30, V2_3),
pool_process_query.c (1.178), pool_process_reporting.c (1.1):
Teach process_reporting() about log_per_node_statement. Also
refactor pool_process_query.c to remove process_reporting() and make
a new source file "pool_process_reporting.c" to hold the funtcion.
Main reason for this is, process_reporting() is now big enough to
have a separate C source file.
2009-12-02 23:19 t-ishii
* child.c (1.37, V2_3_1, V2_3), pool.h (1.46), pool_process_query.c
(1.177): Enhance SIGINT handler.
2009-12-02 23:11 t-ishii
* pool_proto_modules.c (1.26): Fix ProcessFrontendResponse()
handling of Parse message in master/slave mode. If it's inside
transaction, enable master_slave_dml, which means execute parse on
master only. This will prevent unwanted parase executed on slave,
which holds at least AccessShareLock on tables until transaction
commits. It seems unamed statement does not release the lock until
execute.
Please note that, even with this fix, bind state will remain on
slave if JDBC issues parse with autocommit off. This is because
BEGIN parsed, bind on both master and slave but execute only on
master. However, this is not harmfull since parse/bind does not hold
any locks on tables.
Also add some logging statemets.
2009-11-29 20:56 t-ishii
* pool_process_query.c (1.176): Fix is_select_query() not to allow
cursor statements. Close() should not allowed since hold cursor +
update may cause data inconsistency.
2009-11-29 17:42 t-ishii
* pool_process_query.c (1.175): Add logging by
per_node_statement().
2009-11-18 15:45 t-ishii
* config.h.in (1.8), configure (1.32), configure.in (1.29) (utags:
V2_3): Add -lcrypt for linking commnad. Certain distribution
ships libpq without linking to libcrypt by some reasons which I
don't know.
2009-11-15 20:16 t-ishii
* ChangeLog (1.42): Run cvs2cl.pl -t --fsf -b -F trunk
2009-11-15 17:27 t-ishii
* pgpool.conf.sample (1.28), pool.h (1.45), pool_config.c (1.31),
pool_config.l (1.27), pool_process_query.c (1.174),
pool_proto_modules.c (1.25), pool_relcache.c (1.4, V2_3_1, V2_3):
Add new directive log_per_node_statement. If true, print all
statements to the log. Similar to log_statement except that prints
DB node id and backend process id info.
2009-11-15 17:05 t-ishii
* pool_config.c (1.30), pool_config.l (1.26): Set change default
value of reset_query_list to "ABORT, DISCARD ALL"
2009-11-14 22:22 t-ishii
* child.c (1.36), pool.h (1.44), pool_process_query.c (1.173),
pool_proto_modules.c (1.24), pool_proto_modules.h (1.8, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3): Fix connection_cache =
false case. In this mode, if frontend exits abnormaly, some global
state variables are not reset. For this purpose, new function
reset_variables() added.
Remove unnecessary argument of end_load_balance().
2009-11-14 20:41 t-ishii
* pool_config.c (1.29): Update pool_config.l
2009-11-14 20:40 t-ishii
* pool_config.l (1.25): Allow to change weight with reloading
pgpool.conf
2009-11-14 20:35 t-ishii
* main.c (1.55): Limit listen(2)'s backlog parameter to
num_init_children*2 at largest. This is almost same algorithm as
PostgreSQL. I hope pgpool-II does not consume so much system
resource any more...
2009-11-14 08:35 t-ishii
* pool_timestamp.c (1.3), test/timestamp/expected/insert.out (1.2),
test/timestamp/expected/misc.out (1.2, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2), test/timestamp/expected/update.out (1.2,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2) (utags: V2_3, V2_3_1): Fix
some query rewriting cases.
2009-11-12 16:37 t-ishii
* pgpool.conf.sample (1.27): Change reset_query_list default to
PostgreSQL 8.3.
2009-11-12 16:04 t-ishii
* pool_process_query.c (1.172): Prepare for
bind_rewrite_timestamp() returns NULL case. This could happen if
SELECT now() is called inside an aborted transaction.
Fix SimpleForwardToBackend free rewrite_msg too early.
2009-11-11 10:53 t-ishii
* pool_timestamp.c (1.2): Fix comment.
2009-11-10 19:03 t-ishii
* Makefile.am (1.25), Makefile.in (1.29), pool_process_query.c
(1.171), pool_proto_modules.c (1.23), pool_proto_modules.h (1.7),
pool_timestamp.c (1.1), pool_timestamp.h (1.1, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), test/timestamp/Makefile (1.1,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/timestamp/main.c (1.1, V2_3_1, V2_3),
test/timestamp/parse_schedule (1.1, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/timestamp/run-test (1.1, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/timestamp/expected/insert.out (1.1),
test/timestamp/expected/misc.out (1.1),
test/timestamp/expected/update.out (1.1),
test/timestamp/input/insert.sql (1.1, V2_3_1, V2_3),
test/timestamp/input/misc.sql (1.1, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/timestamp/input/update.sql (1.1,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3): Add support
for CURRENT_TIMESTAMP and friends. Patch provided by Akio Ishida.
2009-11-10 11:24 t-ishii
* main.c (1.54): Fix comment.
2009-11-05 15:26 t-ishii
* pool_relcache.c (1.3): Fix relcache replacement logic bug.
Patches provided by Akio Ishida.
2009-11-05 12:43 t-ishii
* ChangeLog (1.41), TODO (1.19, V2_3_1, V2_3), parser/outfuncs.c
(1.8, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/expected/insert.out (1.3, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/parser/expected/select.out (1.4,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/input/insert.sql (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/parser/input/select.sql (1.4, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3): Fix nodeToString()
bug. example test case: If nodeToString() is given the parse tree of
"insert into r1 values(1,2), (3,4)", it returns "insert into r1
values(1,2), values(3,4)", which is apparently wrong. Patch
provided by Akio Ishida.
2009-11-04 22:59 t-ishii
* pool_process_query.c (1.170): Fix do_query() to return more than
1 characters. Patch provided by Akio Ishida.
2009-11-03 20:14 devrim
* pgpool.spec (1.18, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_3):
- Remove init script from all runlevels before uninstall. Per #RH
Bugzilla 532177
2009-11-03 11:00 t-ishii
* pool.h (1.43), pool_auth.c (1.18, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), pool_process_query.c (1.169): When
authentication fails, report to frontend proper error messages,
rather than unhelpfull "server closed the connection unexpectedly"
message. Patch provided by Glyn Astill with minor tweak by Tatsuo
Ishii.
2009-11-03 10:50 t-ishii
* pool_stream.c (1.17): Fix pool_flush_it() so that it does not
complain when failed to flush to frontend. Also add info to the
message if it was backend or frontend to avoid confusion.
2009-10-30 14:11 t-ishii
* pool_proto_modules.c (1.22): Allow is_temp_table to work with pre
8.4 PostgreSQL.
2009-10-29 22:44 t-ishii
* Makefile.am (1.24), Makefile.in (1.28), child.c (1.35), configure
(1.31), configure.in (1.28), pool.h (1.42), pool_process_query.c
(1.168), pool_proto_modules.c (1.21): Add pool_relcache.c to
Makefile.am. Refactor need_insert_lock to use pool_search_relcache
and friends. Add LocalSessionId to child.c which manage per session
counter of relcache. Allow to use temp tables with master/slave
mode. Parse() failed. since Parse() was always sent to master and
slave and slave does not have the temp table. To fix this,
is_temp_table() added to pool_proto_modules.c which inquire
particular table is a temporary one or not when
INSERT/UPDATE/DELETE. If it's a temporary table, parse message is
sent to only master. Note that /*NO LOAD BALANCE*/ directive can be
used to control this. SELECT still needs /*NO LOAD BALANCE*/. It's
hard to find all tables in a SELECT statement.
2009-10-29 21:46 t-ishii
* pool_relcache.c (1.2): Per process relation cache module
2009-10-25 16:19 t-ishii
* test/jdbc/: CreateTempTableTest.java (1.2),
expected/CreateTempTable (1.2), RunTest.java (1.3) (utags: V2_3,
V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): Add temp table test
2009-10-22 20:52 devrim
* redhat/: pgpool.init (1.6), pgpool.sysconfig (1.3) (utags: V2_3,
V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): Fix logging, per
report from Toshihiro Kitagawa.
2009-10-21 23:39 t-ishii
* pool_process_query.c (1.167): Do not execute CREATE/DROP TABLE
SPACE inside a transaction block.
Teach do_command() that S (parameter status) should be ignored until
receiving command complete.
2009-10-21 23:05 t-ishii
* main.c (1.53): Let reaper() report the case when child died by
segfault.
2009-10-12 11:21 t-ishii
* pgpool.8.in (1.6, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_3): Fix typo in man page. Patch provided by Rodolphe.
2009-10-12 10:54 t-ishii
* pool_process_query.c (1.166): REINDEX DATABASE or SYSTEM should
not be executed in a transaction block. See [pgpool-general-jp: 623]
for more details.
2009-10-06 00:12 devrim
* pgpool.spec (1.17):
Add 2 new docs, per Tatsuo.
2009-10-05 19:38 devrim
* pgpool.spec (1.16):
- Update to 2.2.5, for various fixes described at
http://lists.pgfoundry.org/pipermail/pgpool-general/2009-October/002188.html
- Re-apply a fix for Red Hat Bugzilla #442372
- Sync with Fedora spec.
2009-10-04 08:52 t-ishii
* doc/: tutorial-en.html (1.7), tutorial-ja.html (1.6) (utags:
V2_3, V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): Add sample to
use rotatelogs
2009-10-03 21:39 t-ishii
* sample/pgpool_recovery_pitr (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3): Enhance online recovery 2nd stage script
to sync sequence value
2009-10-03 20:55 t-ishii
* pool_proto_modules.h (1.6): Remove unnecessary declaration
"allow_close_transaction"
2009-10-02 17:00 t-ishii
* pool_proto_modules.c (1.20): Prevoius commit was incomplete
2009-10-02 16:56 t-ishii
* pool_proto_modules.c (1.19): Fix Parse() to use
wait_for_query_response() instead of synchronize().
2009-10-02 16:53 t-ishii
* pool_process_query.c (1.165): Fix comment
2009-09-26 18:14 t-ishii
* pool_proto_modules.c (1.18): Allow to print more accurate query
when Parse() detects kind mismatch errors.
2009-09-26 16:51 t-ishii
* pool_process_query.c (1.164): Fix reset_backend to deal with
DEALLOCATE error. In this case prepared objects are not removed and
reset_backend is infinitely called.
Fix do_command to guard against the case that after execution of an
SQL command, the backend does not return either N, E or C. This
should not happen but there was a report that it actually happend in
certain cases(maybe caused by asynchronized backend data?)
See:
Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children
From: Xavier Noguer Date: Fri, 25 Sep 2009 03:35:57 -0400
For more details.
Patches by Xavier Noguer with minor tweak by Tatsuo Ishii.
2009-09-26 09:27 t-ishii
* pool_process_query.c (1.163): Remove error checks for
pool_write(frontend), pool_flush(frontend) in
SimpleForwardToFrontend.
Check error for send_deallocate() in reset_backend. Otherwise
send_deallocate will be called infinitely. Per bug report from
Agustin Almonte Ferrada. See:
Subject: Re: [Pgpool-general] pgpool 2.2.4: DEALLOCATED children
From: Agustin Almonte Ferrada <aalmonte@antica.cl> To: Tatsuo Ishii
<ishii@sraoss.co.jp> Cc: pgpool-general@pgfoundry.org Date: Wed, 23
Sep 2009 01:55:54 -0400
2009-09-26 09:05 t-ishii
* pool_process_query.c (1.162): FIX parallel query
1. Fix JOIN Expr
Subquery was used on larg or rarg.
Subquery was used on ON-Cluase.
Full OUTER JOIN was not optimized.ãã
2. Fail_on_error=false was passed to the 3rd arguments of
dblink.
This patch was applied to only 2.2-STABLE tree by y-mori on
2009/09/08.
2009-09-25 16:35 t-ishii
* main.c (1.52): Fix write_pid_file. It forgot to write out NULL
termination of pid. Pgpool occasionally won't stop because of this
bug.
2009-09-23 11:03 t-ishii
* pool_auth.c (1.17): Fix pool_read_kind and pool_read_int so that
the error message for kind is shown in hexadecimal. Other part of
pgpool-II already does this.
2009-09-17 20:32 t-ishii
* pool_process_query.c (1.161), pool_proto_modules.c (1.17),
pool_proto_modules.h (1.5): Teach do_command() to use
wait_for_query_response(). insert_lock() calls do_command() to
issue LOCK TABLE to lock tables having SERIAL column when
insert_lock is true. Problem is, insert_lock() waits forever in
do_command() if the target table is locked by someone else. This
patch should give a way insert_lock() to espcape from the situation.
2009-09-06 12:56 t-ishii
* child.c (1.34), pool.h (1.41): Fix connection_count_down() so
that it does decrement too much in some corner cases. If failed to
read a start up packet, or receive cancel request etc.,
connection_count_down() is called and goes back to the onnection
accept loop. Problem is, at the very beginning of the connection
accept loop, if we have received a signal, we call child_exit()
which calls connection_count_down() again. Problem report by
Ryoichi TANABE. See [pgpool-general-jp: 616] for more details.
Also unneccesary public declarations for connection_count_up() and
connection_count_down() are removed.
2009-09-06 12:54 t-ishii
* pool_process_query.c (1.160): Undef #define
SEND_NOTICE_ON_PROTO2, which was defined by mistake.
2009-08-22 13:04 t-ishii
* child.c (1.33), main.c (1.51), md5.c (1.2, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), pcp_child.c (1.12, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), pg_md5.c (1.4, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), pool_auth.c (1.16),
pool_config.c (1.28), pool_connection_pool.c (1.16, V2_3_1,
V2_3), pool_error.c (1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), pool_hba.c (1.6, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), pool_ip.c (1.3, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), pool_params.c (1.4, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), pool_path.c (1.3,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
pool_process_query.c (1.159), pool_proto_modules.c (1.16),
pool_query_cache.c (1.10, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), pool_rewrite_outfuncs.c (1.20, V2_3_1, V2_3),
pool_rewrite_query.c (1.14, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_3), pool_sema.c (1.7, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), pool_shmem.c (1.5, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), pool_signal.c (1.4, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), pool_stream.c (1.16),
pool_system.c (1.6, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_3), ps_status.c (1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), recovery.c (1.13, V2_3_1, V2_3), strlcpy.c (1.3,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), pcp/md5.c
(1.2, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3): Remove
unnecessary spaces and tabs at end of line. Patch conributed by Jun
Kuriyama.
2009-08-20 15:26 t-ishii
* pool_process_query.c (1.158): Fix possible bug introduced in
pgpool-II 2.2.2. Load balance control variables may remain not be
restored and subsequent DML/DDL call might sent to only master node.
2009-08-18 17:41 t-ishii
* pool_process_query.c (1.157), pool_proto_modules.c (1.15),
pool_proto_modules.h (1.4): Change wait_for_query_response() so
that it sends NOTICE message to frontend periodically. It appears
that pgpool-II 2.2.3 unconditionaly sends param packet to client
even it uses version 2 protocol, which is apparentlt wrong. Also
tweak checking period from 1 second to 30 seconds since 1 second
seems too aggressive. Note that you need to edit
pool_process_query.c to define SEND_NOTICE_ON_PROTO2 around line 879
to enable this feature in version 2 protocol.
2009-08-18 17:30 t-ishii
* child.c (1.32): Remove unneccessary call to send_frontend_exit()
in do_child().
2009-08-13 22:40 t-ishii
* child.c (1.31): Remove unnessary call of send_frontend_exits() in
die().
2009-08-13 22:39 t-ishii
* main.c (1.50): Block signals before forking children rather
after. Otherwise parent will be killed by failover signal if it
receives before establish signal handler. See [pgpool-general-jp:
586] for more details.
2009-08-11 22:23 t-ishii
* pool_connection_pool.c (1.15): Fix new_connection() so that it
does leave garbage in POOL_CONNECTION_POOL->slot[i]. This caused
segfault in child_exit(). Bug report at [pgpool-general-jp: 586].
2009-08-06 20:38 t-ishii
* Makefile.in (1.27): Update Makefile.am
2009-08-06 18:11 t-ishii
* Makefile.am (1.23): Add parser/test files. Patch contributed by
Akio Ishida.
2009-08-06 16:55 t-ishii
* pool_proto_modules.c (1.14): Print last query for kind mismatch
error message even extended protocol is used. Patch contributed by
Akio Ishida.
2009-08-06 16:46 t-ishii
* pool_process_query.c (1.156): Fix buffer overrun error which
mangled kind mismatch error message in pool_send_error_message().
Bug rpeort by Takahiro Itagaki at [pgsql-jp: 39950]. Fix suggested
by Akio Ishida at [pgsql-jp: 39952].
2009-08-03 19:31 t-ishii
* parser/: kwlist.h (1.1), kwlookup.c (1.1) (utags: V2_3, V2_3_1,
V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): Missing files for PostgreSQL
8.4 paraser adaoptation. Patch contributed by Akio Ishida.
2009-08-01 20:41 t-ishii
* child.c (1.30): Check MASTER_CONNECTION(p)->sp) is non 0 before
further referring to sp. Current implementation may interrupt in the
window, after setting p and before setting sp.
2009-08-01 20:34 t-ishii
* pool_connection_pool.c (1.14): Fix pool_debug's mismatch between
data type and conversion specification for time_t. Check
MASTER_CONNECTION(p)->sp) is non 0 before further referring to sp.
Current implementation may interrupt in the window, after setting p
and before setting sp.
2009-08-01 12:20 t-ishii
* test/parser/: parse_schedule (1.2), input/v84.sql (1.1) (utags:
V2_3, V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): parser test
for PostgreSQL 8.4 or later. Patch contributed by Akio Ishida.
2009-07-30 23:44 t-ishii
* pool_process_query.c (1.155), pool_rewrite_outfuncs.c (1.19),
pool_type.h (1.10), parser/Makefile.am (1.5, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/Makefile.in (1.17, V2_3),
parser/copyfuncs.c (1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), parser/gram.c (1.11, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), parser/gram.h (1.10, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/gram.y (1.6, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/keywords.c
(1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
parser/keywords.h (1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), parser/makefuncs.c (1.4, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/makefuncs.h (1.4, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/nodes.c (1.3,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/nodes.h
(1.4, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
parser/outfuncs.c (1.7), parser/parsenodes.h (1.4, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/parser.c (1.6,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
parser/pool_memory.h (1.6, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_3), parser/pool_parser.h (1.6, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), parser/primnodes.h (1.4, V2_3_3,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3), test/parser/Makefile
(1.2, V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/expected/copy.out (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/parser/expected/create.out (1.3,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/expected/cursor.out (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/parser/expected/delete.out (1.2,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/expected/insert.out (1.2),
test/parser/expected/misc.out (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3), test/parser/expected/prepare.out (1.2,
V2_3_3, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_3),
test/parser/expected/privileges.out (1.2, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3), test/parser/expected/select.out
(1.3), test/parser/expected/update.out (1.2, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3): Adopt PostgreSQL 8.4 parser.
Patch contributed by Akio Ishida.
2009-07-28 09:34 t-ishii
* pool_process_query.c (1.154): Fix typo in comment
2009-07-26 18:14 t-ishii
* pool_rewrite_outfuncs.c (1.18): Fix breakage by previous commit.
Patch by Guillaume Lelarge.
2009-07-26 12:09 t-ishii
* pool_rewrite_outfuncs.c (1.17): fix: Join statment in parallel
query
sample)
Accouts table is defined by dist_def,
the below query is executed as loadbalance.
SELECT a.aid
FROM
accounts as a
JOIN
accounts as b
ON a.aid=b.aid
WHERE a.aid =1 or a.aid=2;
2009-07-26 12:01 t-ishii
* pool_process_query.c (1.153): Fix comment about load balancing.
2009-07-26 11:57 t-ishii
* pool_sema.c (1.6): Fix various pool_error/log format errors.
Patch provided by Akio Ishida.
2009-07-22 17:51 t-ishii
* child.c (1.29), main.c (1.49), pool.h (1.40),
pool_process_query.c (1.152), pool_proto_modules.c (1.13),
pool_rewrite_outfuncs.c (1.16), pool_shmem.c (1.4): Fix various
pool_error/log format errors. Patch provided by Akio Ishida.
2009-07-22 17:26 t-ishii
* pool_process_query.c (1.151), pool_proto_modules.c (1.12),
pool_proto_modules.h (1.3): Query cancel by statement timeout
does not generate "kind mismatch" error any more. How to reproduce
the test case:
Directory connect to PostgreSQL. T1: BEGIN; T1: LOCK TABLE t1;
T2: SET statement_timeout TO 5000; T2: UPDATE t1 SET ...
UPDATE query aborts and error message comes out on T2: ERROR:
canceling statement due to statement timeout
A side effect of this is, statement timeout works correctly (rather
than statement timeout value * # of node).
Note that to initiate T1 by directory connecting to slave node will
not work (still results in kind mismatch error). But I don't think
this could happend in the real world.
Also refactor error detecting modules (detect_deadlock_error and so
on).
2009-07-21 18:48 t-ishii
* main.c (1.48): Check read(2) error in health_check(). This should
detect case described in message below, i.e. postmaster is blocked
by SIGSTOP.
Subject: [Pgpool-general] Healt Check issues From: Vctrjsn@gmail.com
To: pgpool-general@pgfoundry.org Date: Sun, 05 Jul 2009 18:01:18
+0000
2009-07-21 10:43 t-ishii
* pool.h (1.39), pool_proto_modules.c (1.11): Check frontend
connection while waiting for response from backend for extended
protocol (Execute()). Replace synchronize() with
wait_for_query_response(). Also tweak pool.h so that it includes
cancel packet's mazic proto number.
2009-07-21 09:30 t-ishii
* pool_process_query.c (1.150): Do not start transaction if the
command is CLUSTER with no argument
2009-07-20 21:21 t-ishii
* child.c (1.28), pool.h (1.38), pool_process_query.c (1.149),
pool_proto_modules.c (1.10), pool_proto_modules.h (1.2): Check
frontend connection while waiting for response from backend. This
is done in wait_for_query_response() by writing a dummy parameter
status packet to pgpool client every 1 second. If the write fails, a
cancel packet is sent to backend to free backend. This is usefull
to prevent pgpool child from waiting forever for backend response.
Pgpool client will diconnect to pgpool if the query takes too long.
This is typical use case for Web applications.
2009-07-20 21:16 t-ishii
* pool_process_query.c (1.148): Fix bug with
SimpleForwardToFrontend(). Clients using the extend protocol send
'H'(Flush) after each command. Problem is, SimpleForwardToFrontend
does not immediately forward 'C'(Command Complete) packet to
frontend. So the client sends 'H' and wait for 'C'. On the other
hand backend receives 'H' but reply back nothing since Command
complete has nothing to be returned. Both side stuck.
The fix is, forwarding 'C' packet immediately after receiving it
from backend. To prevent similar bugs happen in the future, I put
pool_flush(frontend) after calling SimpleForwardToFrontend in
pool_process_query() (other places already do this).
The extra pool_flush() might harm performance. So I did some tests
using pgbench -S, and found nothing has been changed regarding
performance after patching.
Bug report from Gavin Sherry along with patches for
SimpleForwardToFrontend().
2009-07-20 21:06 t-ishii
* pool.h (1.37), pool_process_query.c (1.147): Add
pool_set_timeout() to control pool_check_fd()'s behavior. This can
be used for various places. The first user is reset_backend() to
fix following scenario: Do COPY_FROM(for example pgbench -i) Cancel
pgbench pgpool waits for response from backend while sending reset
queries and hang. Backend waits for data coming from pgpool
forever.
BTW, I don't think PostgreSQL's befaviro for COPY_FROM is quite
correct since the doc stats:"Receipt of any other non-copy message
type constitutes an error that will abort the copy-in state as
described above" If my understanding correct, COPY_FROM should abort
copy-in state if it receives ABORT (issued in reset_backend). It
seems PostgreSQL is not implemented as stated in the doc...
2009-07-15 15:09 t-ishii
* pool_process_query.c (1.146): Fix bug with prepared statement
deallocation:
Subject: [Pgpool-general] Pgpool probelms From: Nimesh Satam
<nimesh.satam@gmail.com> To: pgpool-general@pgfoundry.org Cc: Nimesh
Satam <nimesh.zedo@gmail.com> Date: Wed, 17 Jun 2009 11:31:37 +0530
This was caused a bug in reset_backend().
if (qcnt >= qn + prepared_list.cnt) {
reset_prepared_list(&prepared_list);
return 2; } send_deallocate(backend, &prepared_list, qcnt - qn);
return 1;
Problem is, send_deallocate -> SimpleQuery("DEALLOCATE") calls
del_prepared_list, which will decrement prepared_list.cnt. In short,
incrementing of qcnt *and* decrementing of prepared_list.cnt happen
at the same time. So deallocate is only called 1/2 times than it
should be.
Bug analysis and fix provided by Akio Ishida.
2009-07-14 17:39 t-ishii
* sql/pgpool-recovery/pgpool-recovery.c (1.7, V2_3_3, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_3): PostgreSQL 8.4 needs to include
utils/binutils.h
2009-05-24 17:43 t-ishii
* sql/pgpool-recovery/Makefile (1.2, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3): Support pre 8.0 PostgreSQL which does not
have pg_config --pgxs option. Patch provided by Enrico Pirozzi with
slight modification by Tatsuo Ishii
2009-05-12 10:01 t-ishii
* doc/pgpool-en.html (1.38): Fix description of client_idle_limit
2009-05-02 17:48 t-ishii
* pool_process_query.c (1.145): Fix is_select_query() to test "sql"
parameter is NULL. As of 2.2, pgpool sets Portal->sql_string to
NULL for SQL command PREPARE. Usually this is ok, since in most
cases SQL command EXECUTE follows anyway. Problem is, some
applications mix PREPARE with extended protocol command "EXECUTE"
and so on. Execute() seems to think this never happens but it is not
real. Someday we should extract actual query string from
PrepareStmt->query and set it to Portal->sql_string.
2009-05-02 17:45 t-ishii
* pool_stream.c (1.15): Fix pool_flush() so that it ignores error
on frontend connection. This is needed to continue processing with
backend, otherwise we risk data incositency.
2009-05-02 17:41 t-ishii
* child.c (1.27): Call pool_send_frontend_exits() before
pool_discard_cp() when resetting connection fails. This will avoid
"unexpected EOF on client connection" error on when pgpool client
exits abnormaly
2009-05-01 09:37 t-ishii
* pool_proto_modules.c (1.9): Add missing patches for this:
date: 2009/04/08 11:12:11; author: t-ishii; state: Exp; lines:
+15 -14 In master slave mode, sometimes DEALLOCATE fails. This is
caused by that the first PREPARE was not executed on the slave.
Patch contributed by Toshihiro Kitagawa.
2009-04-08 20:11 t-ishii
* pool_proto_modules.c (1.8): In master slave mode, sometimes
DEALLOCATE fails. This is caused by that the first PREPARE was not
executed on the slave. Patch contributed by Toshihiro Kitagawa.
2009-04-03 22:43 t-ishii
* doc/: pgpool-en.html (1.37), pgpool-ja.html (1.61): Add documents
about configuration reloading.
2009-04-03 22:30 t-ishii
* pool_proto_modules.c (1.7): Fix SimpleQuery() to properly check
extended query related commands. Before it ignores them if query is
not NULL. This is problematic if frontend == NULL, which could
happen with queries defined in reset_query_list. The bug had been
there since 2.1 BTW.
2009-03-23 10:14 devrim
* pgpool.spec (1.15), redhat/pgpool.init (1.5):
- Own /usr/share/pgpool-II directory.
- Fix pid file path in init script, per pgcore #81.
- Fix spec file -- we don't use short_name macro in pgcore spec
file.
- Create pgpool pid file directory, per pgcore #81.
- Fix stop/start routines, also improve init script a bit.
- Install conf files to a new directory (/etc/pgpool-II), and get
rid of sample conf files.
2009-03-23 10:13 devrim
* redhat/pgpool.conf.sample.patch (1.1, V2_3_3, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_3): Add a patch which configures sample conf
file to match RPM and Red Hat defaults.
2009-03-14 12:39 t-ishii
* pool_process_query.c (1.144): Fix need_insert_lock so that it
returns false if the protocol version is 2. insert_lock has not been
working for V2 protocol anyway, so this is ok.
2009-03-09 00:00 gleu
* main.c (1.47), pgpool.8.in (1.5), doc/pgpool-en.html (1.36):
Update usage function, doc and man page.
2009-03-07 18:19 t-ishii
* pool_process_query.c (1.143): Add a comment to need_insert_lock()
if the query being used to check if the table has SERIAL column is
valid for PostgreSQL 7.3 to 8.3.
2009-03-07 08:49 t-ishii
* pool_process_query.c (1.142): Make excessive message level in
read_kind_from_backend from LOG to DEBUG.
2009-03-06 18:35 gleu
* main.c (1.46): Add support for long options name in pgpool
command.
2009-03-01 22:22 t-ishii
* doc/pgpool-ja.html (1.60): Fix release note for 2.2
2009-02-28 15:29 t-ishii
* Makefile.in (1.26): Update Makefile.am
2009-02-28 15:25 t-ishii
* Makefile.am (1.22): Add doc/load_balance.png,
doc/load_balance.odp
2009-02-28 13:45 t-ishii
* ChangeLog (1.40), NEWS (1.28), TODO (1.18, V2_2_3, V2_2_2,
V2_2_1), configure (1.30) (utags: V2_2_0): Version 2.2
2009-02-28 13:40 t-ishii
* configure.in (1.27, V2_2_0): Version 2.2
2009-02-24 11:20 t-ishii
* pool_auth.c (1.15, V2_2_3, V2_2_2, V2_2_1), pool_process_query.c
(1.141) (utags: V2_2_0): Prpare for receiving parameter status
packets.
If postgresql.conf was changed and reloaded, PostgreSQL sends
parameter status packets asynchronously even those changed
parameters are not one of session_authorization etc., which is
marked as GUC_REPORT in guc.c(GUC_REPORT means parameter status
packet is sent if its value is changed).
After receiving those packets, they are discarded. I think this is
harmless since most of changes are not affected to the frontend
behavior.
2009-02-21 19:00 t-ishii
* TODO (1.17), configure (1.29), ChangeLog (1.39) (utags:
V2_2_0_RC2): pgpool-II 2.2 RC2
2009-02-21 18:56 t-ishii
* configure.in (1.26, V2_2_0_RC2): pgpool 2.2 RC2
2009-02-21 18:52 t-ishii
* doc/load_balance.png (1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2): A load balance logic explanation
figure
2009-02-21 18:47 t-ishii
* doc/: pgpool-en.html (1.35), pgpool-ja.html (1.59) (utags:
V2_2_0, V2_2_0_RC2): Add comment about rsync and autovacuum.
2009-02-20 10:34 t-ishii
* pool_process_query.c (1.140, V2_2_0_RC2): Fix
pool_send_frontend_exits() so that it checks the connection to
backend if it actually exists. This is needed, for example, in the
final stae of online recovery. pgpool child holds 1 connection to a
backend. After failback one more backend added but there's no
connection to the backend.
2009-02-17 18:50 t-ishii
* pool_process_query.c (1.139): Do not start internal transaction
if CREATE INDEX CONCURRENTLY
2009-02-17 15:16 devrim
* pgpool.spec (1.14, V2_2_0, V2_2_0_RC2): Update to 2.2 (Download
URL is broken, since we don't know yet the pgfoundry download URL
yet)
2009-02-15 14:35 t-ishii
* configure (1.28, V2_2_0_RC1): run autoconf
2009-02-15 14:32 t-ishii
* configure.in (1.25, V2_2_0_RC1): 2.2 RC1
2009-02-15 14:31 t-ishii
* ChangeLog (1.38, V2_2_0_RC1): Update Changelog
2009-02-15 14:29 t-ishii
* TODO (1.16, V2_2_0_RC1): Mention that two items were resolved
2009-02-15 14:26 t-ishii
* pgpool.conf.sample (1.26, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2), doc/pgpool-en.html (1.34),
doc/pgpool-ja.html (1.58) (utags: V2_2_0_RC1): Reflect the fact
that DISCARD ALL holds exclusive lock on pg_listener, thus will
degrade performance.
2009-02-10 10:11 t-ishii
* pool_process_query.c (1.138, V2_2_0_RC1): Fix
is_internal_transaction_needed() so that DROP DATABASE does not
start internal transaction
2009-02-07 21:57 t-ishii
* configure (1.27, V2_2_0_BETA2): Run autoconf
2009-02-07 21:57 t-ishii
* configure.in (1.24, V2_2_0_BETA2): Update version
2009-02-07 21:52 t-ishii
* NEWS (1.27, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Update NEWS
2009-02-07 00:30 t-ishii
* pool_process_query.c (1.137, V2_2_0_BETA2): Add pid_file_name to
show pool_status
2009-02-05 17:24 t-ishii
* doc/pgpool-ja.html (1.57, V2_2_0_BETA2): Fix typo
2009-02-05 09:33 t-ishii
* ChangeLog (1.37, V2_2_0_BETA2): Run cvs2cl.pl -t --fsf
2009-02-05 09:30 t-ishii
* doc/pgpool-ja.html (1.56): Add more fix to release info
2009-02-05 09:26 t-ishii
* recovery.c (1.12, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2): Fix online recovery to wait for
failback done before allowing to accept connections from clients. It
was supposed to work like this but actually was not since the day 0
when online recovery was born. Without the fix there could be
potential data inconsistency among DB nodes.
2009-02-05 09:24 t-ishii
* main.c (1.45, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2):
Fix/add comments
2009-02-01 19:13 t-ishii
* NEWS (1.26): Add new item
2009-02-01 19:11 t-ishii
* pool_process_query.c (1.136): Start internal transaction if
necessary. Before we only started transaction INSERT, UPDATE, DELETE
and SELECT. Obviously we need to start transaction other than these,
for example CREATE TABLE. To avoid an overhead to look up large
number of statements (currently 70), we use bsearch() now.
2009-01-31 22:17 t-ishii
* doc/pgpool-ja.html (1.55): Update release note
2009-01-30 17:15 t-ishii
* test/jdbc/README.euc_jp (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2): Add
comment how to add CLASSPATH
2009-01-30 09:06 y-mori
* pool_rewrite_query.c (1.13), pool_rewrite_query.h (1.8, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4) (utags: V2_2_0, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2,
V2_2_1, V2_2_2, V2_2_3): Add comment
2009-01-28 15:48 t-ishii
* NEWS (1.25): Add more items
2009-01-27 10:04 t-ishii
* COPYING (1.4, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2): Update copyright year
2009-01-25 20:13 t-ishii
* NEWS (1.24), TODO (1.15, V2_2_0_BETA2), configure (1.26),
configure.in (1.23), version.h (1.5, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2), doc/pgpool-en.html (1.33, V2_2_0_BETA2),
doc/pgpool-ja.html (1.54) (utags: V2_2_0_BETA1): Prepare 2.2
beta1
2009-01-25 19:13 t-ishii
* main.c (1.44), pool.h (1.36, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2), pool_config.l (1.24, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2), pgpool.conf.sample (1.25, V2_2_0_BETA2),
pool_config.c (1.27, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2) (utags: V2_2_0_BETA1): Add
pid_file_name directive
2009-01-25 13:32 t-ishii
* ChangeLog (1.36, V2_2_0_BETA1): ChangeLog is now generated by
using cvs2cl.pl -t --fsf
2009-01-25 09:09 t-ishii
* pool_rewrite_query.c (1.12, V2_2_0_BETA1): Remove unused static
function check_whereClause() Update Copyright year
2009-01-24 20:34 t-ishii
* pool.h (1.35): Include limit.h. This seems to be necessary Fedra
box. Update copyright year
2009-01-22 18:29 y-mori
* pool_stream.c (1.14, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1): Fix different function name was used
in the error message.
2009-01-22 18:16 y-mori
* pool_process_query.c (1.135, V2_2_0_BETA1), pool_proto_modules.c
(1.6, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1), pool_rewrite_query.c (1.11), pool_rewrite_query.h
(1.7, V2_2_0_BETA1): add the comment related to parallel query
2009-01-22 09:50 t-ishii
* child.c (1.26, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1): Remove unnecessary function
declaration for child_exit()
Add comments to child_exit() which had no comments at all
Modify child_exit() so that it sends terminate mesagges before
exiting. This will prevent backend process from being idle waiting
for TCP keepalive event occurs. This is not good since a backend
process may hold locking on certain tables.
2009-01-22 09:45 t-ishii
* pool_process_query.c (1.134): Modify pool_send_frontend_exits()
so that it change fd to non block while sending terminate message
(X) to backend. This should prevent pgpool from being blocked while
sending data to socket.
2009-01-21 10:43 t-ishii
* pool_process_query.c (1.133): Add debug code and message
2009-01-18 22:54 t-ishii
* ps_status.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix FreeBSD case. patch
provided by Jun Kuriyama.
2009-01-14 23:54 t-ishii
* pool_process_query.c (1.132): Fix excessive debug statement
2009-01-07 22:33 t-ishii
* pool_process_query.c (1.131): Add new argument to detect_error()
so that it can recognize the error class (E or N). per bug report
from Daniel: From: Daniel.Crespo@l-3com.com To:
<pgpool-general@pgfoundry.org> Date: Tue, 6 Jan 2009 12:50:08 -0500
The bug was caused by detect_postmaster_down_error() not detecting
receive crash shutdown error.
Enbug by: Subject: [Pgpool-committers] pgpool - pgpool-II: Fix
detect_error() so that it ignores NOTICE. From:
t-ishii@pgfoundry.org (User T-ishii) To:
pgpool-committers@pgfoundry.org Date: Tue, 30 Dec 2008 01:05:37
+0000 (UTC)
2009-01-07 22:27 t-ishii
* pool_connection_pool.c (1.13, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_proto_modules.c
(1.5): Update copyright year
2009-01-02 18:38 t-ishii
* pool_process_query.c (1.130): Emit pool_error when detects kind
mismatch error. Before we only sent error messages to client, but
this will leave only on client, which may or may not be kept.
Leaving it on pgpool log should leave on pgpool side at least.
2008-12-31 23:45 t-ishii
* child.c (1.25), main.c (1.43): Fix typos in comments. Patch
contributed by Jun Kuriyama.
2008-12-31 23:42 t-ishii
* pool_sema.c (1.5, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1): Enhance error message when failed to
create semaphores. Patch contributed by Jun Kuriyama.
2008-12-31 19:25 t-ishii
* pcp/: pcp.c (1.8), pcp.h (1.4, V2_2_7), pcp_attach_node.c (1.3,
V2_2_7), pcp_detach_node.c (1.3, V2_2_7), pcp_node_count.c (1.3,
V2_2_7), pcp_node_info.c (1.3, V2_2_7), pcp_proc_count.c (1.4,
V2_2_7), pcp_proc_info.c (1.3, V2_2_7), pcp_recovery_node.c (1.4,
V2_2_7), pcp_stop_pgpool.c (1.3, V2_2_7), pcp_systemdb_info.c
(1.3, V2_2_7) (utags: V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2,
V2_2_0_RC1, V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4, V2_2_5,
V2_2_6, V2_3, V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): Add -d
(debug)option to pcp commands. patch contributed by Jun Kuriyama
2008-12-30 21:16 t-ishii
* pool.h (1.34), pool_process_query.c (1.129), pool_proto_modules.c
(1.4): Enhance "kind mismatch" error message to include original
query. This would not work for extended query, though.
2008-12-30 10:05 t-ishii
* pool_process_query.c (1.128): Fix detect_error() so that it
ignores NOTICE. Without this following error occurs, for example:
BEGIN; BEGIN;
ERROR: kind mismatch among backends 0[N] 1[E]
2008-12-30 09:59 t-ishii
* child.c (1.24), main.c (1.42), pool.h (1.33), pool_auth.c (1.14,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1), pool_type.h
(1.9, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Fix
bug with query cancel. It seems this has not been working since
pgpool-II was born.
To fix this, now we have each connection's pid and cancel key in the
shared memory area. If a cancel packet is sent, the table is
searched by the pid and the cancel key. If found, the actual cancel
key is sent to each backend.
2008-12-27 16:26 t-ishii
* config.h.in (1.7, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Update
timestamp
2008-12-23 21:26 t-ishii
* pool_process_query.c (1.127): Fix unnessary code(maybe copy &
paste error?) Take out internal transction starting code from
insert_lock.
2008-12-23 21:24 t-ishii
* pool_proto_modules.c (1.3): Fix Query() so that it starts
transaction *before* checking insert lock is needed or not
2008-12-23 21:21 t-ishii
* child.c (1.23): Do not make a connection cache for postgres
database
2008-12-21 21:57 t-ishii
* pgpool.conf.sample (1.24): Change insert_lock's default value to
true. Since automatic SERIAL data type is implemented, always making
insert_lock to true is harmless.
2008-12-21 08:02 t-ishii
* pool.h (1.32), pool_config.c (1.26), pool_process_query.c
(1.126): If SERIAL data type is used(checked in system catalog)
and insert_lock is true(now default) then automatically lock the
table.
2008-12-21 07:59 t-ishii
* pool_config.l (1.23): Now insert_lock is defaulted to be true
2008-12-20 20:21 t-ishii
* pool_process_query.c (1.125): Fix need_insert_lock() so that it
runs a little bit faster with no INSERT case.
2008-12-20 20:12 t-ishii
* pool_proto_modules.c (1.2): Enhance and fix comments related to
Query()
2008-12-13 20:25 t-ishii
* parser/gram.c (1.10, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0), Makefile.am (1.21), Makefile.in (1.25),
parser/gram.h (1.9, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0) (utags: V2_2_0_BETA1, V2_2_0_BETA2,
V2_2_0_RC1, V2_2_0_RC2): Update generated files
2008-12-13 20:23 t-ishii
* pool_process_query.c (1.124), pool_proto_modules.c (1.1),
pool_proto_modules.h (1.1, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Refactor
pool_process_query.c. Now it is devided into pool_process_query.c
and pool_proto_modules.c. Also pool_proto_modules.h added which is
a companion header file.
2008-12-13 20:21 t-ishii
* main.c (1.41): Fix comment
2008-12-13 17:20 t-ishii
* pool_process_query.c (1.123): Fix Execute() to avoid kind
mismatch error caused by "SET TRANSACTION ISOLATION LEVEL must be
called before any query".
2008-12-13 17:13 t-ishii
* pool_process_query.c (1.122): Avoid kind mismatch error caused by
"SET TRANSACTION ISOLATION LEVEL must be called before any query".
This could happen in following scenario:
* M:S1:BEGIN;
* S:S1:BEGIN;
* M:S1:SELECT 1; <-- only sent to MASTER
* M:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
* S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
* M: <-- error
* S: <-- ok since no previous SELECT is sent. kind mismatch error
occurs!
Fix ReadyForQuery() by calling pool_unread if backend after
do_error_command executed not returns read for query packet.
Fix comments
2008-12-08 22:48 t-ishii
* pool_process_query.c (1.121): Check serialization failure error
and abort all nodes if so. Otherwise we allow data inconsistency
among DB nodes. See following scenario: (M:master, S:slave)
M:S1:BEGIN; M:S2:BEGIN; S:S1:BEGIN; S:S2:BEGIN; M:S1:SET TRANSACTION
ISOLATION LEVEL SERIALIZABLE; M:S2:SET TRANSACTION ISOLATION LEVEL
SERIALIZABLE; S:S1:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
S:S2:SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; M:S1:UPDATE t1
SET i = i + 1; S:S1:UPDATE t1 SET i = i + 1; M:S2:UPDATE t1 SET i =
i + 1; <-- blocked S:S1:COMMIT; M:S1:COMMIT; M:S2:ERROR: could not
serialize access due to concurrent update S:S2:UPDATE t1 SET i = i +
1; <-- success in UPDATE and data becomes inconsistent!
2008-12-08 21:38 t-ishii
* pool_process_query.c (1.120): Forget to add free_string()
2008-12-08 21:32 t-ishii
* pool_process_query.c (1.119): Fix uninitialized variable in
read_kind_from_backend. Also refactor to make it more effective and
readable. Add lots of comments and enhance error message to display
eacho kinds.
2008-12-05 23:38 t-ishii
* pool_process_query.c (1.118): Fix client_idle_limit_in_recovery
handling not to hang when goes into 2nd stage. Also fix grammatical
errors in comments.
2008-11-27 09:30 t-ishii
* pool_auth.c (1.13): Fix thoughtless coding in MD5 case checking.
We should have considered raw mode case. Bug pointed out by Duco
Fijma. See discussions below for more details. Subject:
[Pgpool-general] MD5 authentication in "raw mode" From: Duco Fijma
<duco@fijma.net> To: pgpool-general@pgfoundry.org Date: Tue, 25 Nov
2008 13:29:39 +0100
2008-11-15 16:10 t-ishii
* pool_process_query.c (1.117): Fix pool_discard_packet. Missing
statement in the last commit.
2008-11-15 15:15 t-ishii
* pool_process_query.c (1.116): Fix do_error_command. If mistakely
assumed that after sending an error query, always ReadyForQuery came
right after that. If some debugging or logging verboseness is set,
PostgreSQL might sends NOTICE before ReadyForQuery.
2008-11-12 22:42 t-ishii
* pool_process_query.c (1.115): Fix do_command in case of notice
message sent right after Complete command response. See threads in
pgpool-general:
Subject: Re: [Pgpool-general] Pgpool-II - replication problems From:
"nir osovsky" <nosovsky1@gmail.com>
for more details.
2008-11-10 09:58 t-ishii
* pool_process_query.c (1.114): Enhance error message in do_command
2008-11-07 18:20 t-ishii
* ChangeLog (1.35), Makefile.in (1.24), aclocal.m4 (1.16, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1), configure (1.25), pgpool.conf.sample
(1.23), pool.h (1.31), pool_config.c (1.25), pool_config.l
(1.22), pool_process_query.c (1.113), pool_stream.c (1.13),
doc/pgpool-en.html (1.32), doc/pgpool-ja.html (1.53),
parser/Makefile.in (1.16, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1), pcp/Makefile.in (1.15, V2_2_7, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1): Add
client_idle_limit_in_recovery
2008-10-31 14:21 t-ishii
* doc/load_balance.odp (1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1): Add a flow chart which explains load
balance/replication/send to master only is decided.
2008-10-31 10:31 t-ishii
* doc/: pgpool-en.html (1.31), pgpool-ja.html (1.52): Fix wording
Fix description for replicate_select and "condition for load
balance" section.
2008-10-31 10:28 t-ishii
* pgpool.conf.sample (1.22): Fix incorrect comment for
recovery_timeout
2008-09-05 13:25 t-ishii
* main.c (1.40): Fix and enhance comments
2008-08-29 14:17 t-ishii
* pool_process_query.c (1.112): Allow to load balance DECLARE,
FETCH and CLOSE. Also fix comments.
2008-08-29 11:54 t-ishii
* main.c (1.39): Fix bug in fork_a_child which mistakely closed
pipe fds which are not created yet at the startup time
2008-08-28 21:37 t-ishii
* pool_process_query.c (1.111): Fix/enhance log messages and
comments
2008-08-28 21:35 t-ishii
* main.c (1.38):
- Close all file descriptors when running in daemon mode. Otherwise
we inherit socket from apache when it's started by pgpoolAdmin.
This results in that port 80 is occupied for example. Pach
provided by Akio Ishida. Also add chdir("/"). This always good for
daemon programs.
- Always fail over and restart all children. Before we do not
restart if master has not been changed. This was wrong. If we have
trouble with network cable or something, TCP/IP stack keeps on
retrying for long time and the only way to prevent it is restarting
process.
2008-07-23 17:50 y-asaba
* NEWS (1.23), configure (1.24), configure.in (1.22),
doc/pgpool-ja.html (1.51) (utags: V2_1_0): Prepare for 2.1.
2008-07-08 16:53 y-mori
* ChangeLog (1.34, V2_1_0), NEWS (1.22) (utags: V2_1_0_RC1):
Prepare for pgpool-II 2.1 RC1.
-add comment to ChangeLog NEWS
2008-07-08 16:41 y-mori
* NEWS (1.21): FIX indent
2008-07-08 16:37 y-mori
* doc/pgpool-ja.html (1.50, V2_1_0_RC1): Update release note
parallel query bug fix comment
2008-07-08 16:21 y-asaba
* Makefile.in (1.23, V2_1_0), aclocal.m4 (1.15, V2_1_0), configure
(1.23), configure.in (1.21), parser/Makefile.in (1.15, V2_1_0),
pcp/Makefile.in (1.14, V2_1_0) (utags: V2_1_0_RC1): Prepare for
pgpool-II 2.1 RC1.
2008-07-04 22:00 y-mori
* pool_rewrite_outfuncs.c (1.15, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1): FIX: query rewrite of DISTINCT ON
2008-07-04 14:27 y-mori
* pool.h (1.30, V2_1_0, V2_1_0_RC1), pool_process_query.c (1.110,
V2_1_0, V2_1_0_RC1), pool_rewrite_outfuncs.c (1.14),
pool_rewrite_query.c (1.10, V2_1_0, V2_1_0_RC1), pool_stream.c
(1.12, V2_1_0, V2_1_0_RC1): FIX: join partitioned tables
Delete: pool_read_parallel
2008-07-01 21:26 y-mori
* pool_rewrite_outfuncs.c (1.13): fix: Converting JOIN expression
from USING to ON in query rewriting at parallel mode
2008-06-30 16:05 y-mori
* pool_process_query.c (1.109): Fix Hung up when two or more insert
statment was executed in parallel mode
2008-05-30 16:18 y-asaba
* pool_process_query.c (1.108): Fixed segfault if client protocol
was V2.
2008-05-22 23:36 y-asaba
* main.c (1.37, V2_1_0, V2_1_0_RC1): If a backend raised FATAL
error while health checking, do not send a Terminate message.
Because sending the message fails with EPIPE.
2008-05-08 12:02 y-asaba
* child.c (1.22, V2_1_0, V2_1_0_RC1): Fix segfault if all weight
values are zero and master node is down. Perf report by Michael
SALOMON.
2008-05-04 14:04 y-asaba
* sql/pgpool-recovery/pgpool-recovery.c (1.6, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1): Use snprintf().
2008-04-12 03:09 devrim
* pgpool.spec (1.13, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1): Sync with community spec file. Fix
Requires: problem.
2008-04-09 16:45 y-asaba
* redhat/pgpool.init (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1):
* Remove non-ascii character.
* Fix the daemon stdio redirection.
Per report by kabe-san.
2008-04-09 16:03 y-asaba
* sample/replicate_def_pgbench.sql (1.2, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Fix SQL error.
2008-04-09 16:01 y-asaba
* sql/system_db.sql (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1): Drop replicate_def table if
exists.
2008-04-09 15:26 devrim
* redhat/pgpool.init (1.3):
- Honor /etc/sysconfig/pgpool settings. Previously we could never
customize PGPOOLPID=/var/run/pgpool.pid et al.
- Remaining hardcoded paths replaced by customizable variables
such as $PGPOOLCONF .
2008-04-09 15:22 y-asaba
* Makefile.am (1.20, V2_1_0, V2_1_0_RC1), Makefile.in (1.22): Add
sample/replicate_def_pgbench.sql into a release tar ball.
2008-04-07 01:49 devrim
* pgpool.spec (1.12): Update to 2.1 beta2
2008-04-04 13:32 y-asaba
* NEWS (1.20), doc/pgpool-ja.html (1.49) (utags: V2_1_0_BETA2):
Update 2.1 release note.
2008-04-03 22:10 y-asaba
* pool_process_query.c (1.107, V2_1_0_BETA2): Fix hang up in
Execute.
We sended a syntax error query to abort a transaction if
replicate_select was true. However, the query was sended over Query
message. In extended query mode, we *must* send the query over
Execute message. Because postgres discards messages until a Sync is
reached when an error is detected.
2008-04-03 14:44 y-asaba
* ChangeLog (1.33, V2_1_0_BETA2): Add.
2008-04-03 14:30 y-asaba
* pool_process_query.c (1.106): Do not close a internal transaction
when Sync message is received after receiving Parse message. This
hack is for PHP-PDO.
2008-04-02 11:48 y-asaba
* NEWS (1.19), doc/pgpool-ja.html (1.48): Update release note.
2008-04-01 17:31 y-asaba
* configure (1.22), configure.in (1.20) (utags: V2_1_0_BETA2):
Prepare for 2.1 beta2.
2008-04-01 10:12 y-asaba
* pool_rewrite_outfuncs.c (1.12, V2_1_0_BETA2): Fix "AS" handling
in FROM clause. Patch contributed by sho-san.
2008-03-31 17:27 y-asaba
* pgpool.8.in (1.4, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Enhance manpage.
patch contributed by kabe-san.
- no hypenation, no justify for better greppability
- have explicit subsection for [noargs], stop, switch for
readability
- some phrases rewritten to suit manpages
- add "-v" option
2008-03-31 17:07 y-asaba
* ChangeLog (1.32): Add items.
2008-03-31 13:19 t-ishii
* TODO (1.14, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add Docs section
and add an item (writelibpcp docs)
2008-03-31 11:56 y-asaba
* NEWS (1.18), doc/pgpool-ja.html (1.47): Add a item into 2.1
release note.
2008-03-28 01:06 y-asaba
* child.c (1.21), pool_hba.c (1.5, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1) (utags: V2_1_0_BETA2): Use child_exit() instead of
exit().
2008-03-28 01:04 y-asaba
* pcp_child.c (1.11, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2), recovery.c (1.11) (utags: V2_1_0,
V2_1_0_BETA2, V2_1_0_RC1, V2_2_0_BETA1): Fix a race condition
between SIGUSR2 signal and pause().
2008-03-28 01:01 y-asaba
* pool_connection_pool.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2):
Fix core dump with the following scenario.
1. detach a node.
2. create connection pool
3. attach the node.
4. reuse the connection pool
2008-03-27 17:26 y-asaba
* doc/pgpool-ja.html (1.46): Remove a wrong restriction.
2008-03-27 16:54 y-asaba
* doc/: pgpool-en.html (1.30, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2),
pgpool-ja.html (1.45), pgpool.css (1.6, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2), tutorial-en.html
(1.6, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2), tutorial-ja.html (1.5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2): Add copyright.
2008-03-27 16:24 y-asaba
* doc/: tutorial-en.html (1.5), tutorial-ja.html (1.4): Add an
example to rotate pgpool log files.
2008-03-27 11:53 y-asaba
* pool_process_query.c (1.105): Improve network I/O routine.
2008-03-27 11:51 t-ishii
* doc/pgpool-en.html (1.29): Add description about the timing of
recovery command invocation
2008-03-27 11:49 t-ishii
* TODO (1.13): Add TODO items
2008-03-26 18:18 t-ishii
* doc/pgpool-ja.html (1.44): Add description about the timing of
recovery command invocation
2008-03-25 14:15 t-ishii
* TODO (1.12): Add more TODO
2008-03-25 10:00 t-ishii
* TODO (1.11): Translate into English
2008-03-20 17:33 t-ishii
* doc/: pgpool-en.html (1.28), pgpool-ja.html (1.43): Enhance
reset_query_list description.
2008-03-20 16:33 t-ishii
* doc/: pgpool-en.html (1.27), pgpool-ja.html (1.42): Add info
about pgpool-II download page.
2008-03-18 17:39 y-asaba
* pgpool.conf.sample (1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2):
Remove ";" in recovery_timeout.
2008-03-14 16:09 y-asaba
* doc/: pgpool-en.html (1.26), pgpool-ja.html (1.41) (utags:
V2_1_0_BETA1):
* Changed title from README to user manual.
* Emphasized load balancing note.
2008-03-14 16:06 y-asaba
* doc/pgpool.css (1.5, V2_1_0_BETA1): Add <h4> style.
2008-03-14 15:57 y-asaba
* NEWS (1.17, V2_1_0_BETA1): Reviewed.
2008-03-14 15:53 y-asaba
* doc/pgpool-en.html (1.25): Updated English documentation.
2008-03-14 15:30 y-asaba
* doc/pgpool-ja.html (1.40): Add recovery_timeout description.
2008-03-14 14:45 y-asaba
* NEWS (1.16): Added 2.1 beta release note. I hope to review it.
2008-03-14 11:43 y-asaba
* doc/pgpool-ja.html (1.39): Added 2.1 release note.
2008-03-14 11:00 y-asaba
* pgpool.conf.sample (1.20, V2_1_0_BETA1): Add comment for '%M'
format.
2008-03-14 10:35 y-asaba
* ChangeLog (1.31, V2_1_0_BETA1): Add entries.
2008-03-13 22:11 y-asaba
* pool_process_query.c (1.104, V2_1_0_BETA1):
* Fixed kind mismatch error in master slave mode with following
scenario. This bug was introduced in pgpool-II v2.0.
BEGIN;
SET client_encoding TO SJIS;
* Fixed load balancing in master slave mode. This bug was introduced
in pgpool-II v2.0.
2008-03-13 16:01 y-asaba
* pg_md5.c (1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1): Fix compile error on FreeBSD. Per
report by ISHIDA Akio.
2008-03-13 12:46 y-asaba
* ylwrap (1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1): Add ylwrap generated by
automake 1.10.
2008-03-13 03:22 devrim
* pgpool.spec (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Update to 2.1
beta1
2008-03-12 21:33 y-asaba
* configure (1.21), configure.in (1.19) (utags: V2_1_0_BETA1):
Stamp beta1.
2008-03-12 18:33 t-ishii
* pgpool.conf.sample (1.19): Fix comments for load_balance_mode
which were no longer true.
2008-03-12 18:32 y-asaba
* pool_config.c (1.24, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1): Run flex v2.5.33
2008-03-12 18:32 y-asaba
* version.h (1.4, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
Change version string.
2008-03-12 18:31 y-asaba
* child.c (1.20, V2_1_0_BETA1), pool_process_query.c (1.103): If
load_balance_mode is false, then pgpool does not calculate load
balancing node.
2008-03-12 14:06 y-asaba
* main.c (1.36, V2_1_0_BETA2, V2_1_0_BETA1): health_check_timeout
did not work correctly. Report and patch by Kenichi Sawada.
2008-03-12 14:00 y-asaba
* main.c (1.35): Improve bind(2) and unlink(2) error message.
Patch contributed by Jun Kuriyama.
2008-03-12 13:53 y-asaba
* pcp/pcp_recovery_node.c (1.3, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1): Fix typos in pcp_recovery_node.c usage. Patch
contributed by Jun Kuriyama.
2008-03-12 13:51 y-asaba
* Makefile.in (1.21, V2_1_0_BETA2, V2_1_0_BETA1), aclocal.m4 (1.14,
V2_1_0_BETA2, V2_1_0_BETA1), config.h.in (1.6, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), configure (1.20),
configure.in (1.18), parser/Makefile.in (1.14, V2_1_0_BETA2,
V2_1_0_BETA1), pcp/Makefile.in (1.13, V2_1_0_BETA2,
V2_1_0_BETA1): Support set_ps_display on FreeBSD. Patch
contributed by ISHIDA Akio.
2008-03-12 12:54 t-ishii
* pool_auth.c (1.12, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1): Add detailed error messages when auth phase fail.
Current messages:
pool_read_message_length: message length (8 ) in slot 1 does not
match with slot 0(12)
is confusing and does very little help.
2008-03-12 11:01 y-asaba
* pool_process_query.c (1.102): Fixed DEALLOCATE ALL processing.
2008-03-11 12:04 y-asaba
* ChangeLog (1.30): Added entries.
2008-03-11 11:54 y-asaba
* main.c (1.34), doc/pgpool-en.html (1.24), doc/pgpool-ja.html
(1.38):
* Add '%M'format to obtain old master node ID into failover_command
and failback_command.
* When master node was down, killed all children process during
executing failover_command.
* Fixed SIGSEGV if backend0 was undefined.
2008-03-11 11:49 y-asaba
* pool_process_query.c (1.101): Fixed hang up if a node was
executed immediate shutdown.
2008-03-11 00:08 t-ishii
* pool_auth.c (1.11): Fix using uninialized varible in
pool_read_message_length()
2008-03-10 13:37 t-ishii
* pool_process_query.c (1.100): [no log message]
2008-03-04 16:58 y-asaba
* ChangeLog (1.29): Add entries.
2008-03-03 12:39 y-asaba
* pool_process_query.c (1.99): Fix hang up after processing "show
pool_status". Per report by ISHIDA Akio.
2008-02-29 13:49 yamaguti
* ChangeLog (1.28): added entry for the change in pg_md5.c
2008-02-29 13:40 yamaguti
* pg_md5.c (1.2):
* implement password prompt with option "-p" (patch contributed by
Volkan Yazici)
* disable ECHO while reading password from stdin
2008-02-26 18:55 y-asaba
* main.c (1.33):
- Add comment.
- Add -v option, which prints version info.
2008-02-25 20:22 y-asaba
* recovery.c (1.10, V2_1_0_BETA1): Improve error message.
2008-02-25 11:58 y-asaba
* pool_process_query.c (1.98): Fix asynchronous query handling.
When ReadyForQuery message was received, pgpool set off
loadbalancing flag, internal transaction flag and so on. If client
sended a Query message before receiving the ReadyForQuery message,
pgpool reported error message.
So, we block the Query message while backend nodes process a query.
2008-02-20 19:12 y-asaba
* pool_process_query.c (1.97): Return TRUE in is_select_query() if
a query is "COPY TO STDOUT". kind mismatching error was caused by
pg_dump or pg_dumpall. Per report by Bruno Lustosa.
2008-02-19 14:54 y-asaba
* Makefile.in (1.20), aclocal.m4 (1.13), configure (1.19),
configure.in (1.17): Stamp 2.1-devel. We hope to release 2.1 on
March.
2008-02-19 14:46 y-asaba
* pool_process_query.c (1.96): Fix HINT clause handling in extended
query protocol. pgpool did not replicate the following query with
extended query protocol.
/* REPLICATION */ SELECT func();
Per report by Sagar Thapa.
2008-02-19 14:18 y-asaba
* pool_process_query.c (1.95): Fix misspell. Patch contributed by
Jun Kuriyama.
2008-02-18 18:58 y-asaba
* pool_stream.c (1.11, V2_1_0_BETA2, V2_1_0_BETA1): Add error
checking.
2008-02-15 18:43 y-asaba
* main.c (1.32): Polling signals per 3 secs when health check is
disabled.
2008-02-15 18:36 y-asaba
* main.c (1.31): Fix zombie process problem. "switching" flag did
not clear when invalid node ID was detached.
2008-02-15 15:19 y-asaba
* pool_process_query.c (1.94): Fix DISCARD statement handling.
2008-02-15 13:04 y-asaba
* main.c (1.30): Fix compiler warning.
2008-02-14 14:48 y-asaba
* main.c (1.29): Add comment.
2008-02-14 14:24 y-asaba
* ChangeLog (1.27): Add ChangeLog items.
2008-02-14 14:09 y-asaba
* main.c (1.28): Fix a failover bug that pgpool did not determine a
next master node in raw_mode.
2008-02-14 14:05 y-asaba
* pool_connection_pool.c (1.11, V2_1_0_BETA1): Do not create
connection cache to standby nodes in raw_mode. As a result, we can
use pgpool-II + warm standby with raw_mode.
2008-02-12 20:16 y-asaba
* child.c (1.19), pgpool.conf.sample (1.18), pool.h (1.29,
V2_1_0_BETA2, V2_1_0_BETA1), pool_config.c (1.23), pool_config.l
(1.21, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pool_process_query.c (1.93), pool_stream.c (1.10),
doc/pgpool-en.html (1.23), doc/pgpool-ja.html (1.37): Remove
"replication_timeout" parameter.
This parameter was enabled if replication_strict = false. However
replication_strict was already removed.
2008-02-12 16:29 yamaguti
* pool.h (1.28): Fix a bug in raw mode where only 1 of multiple
nodes were recognized by pgpool.
2008-02-08 19:57 y-asaba
* pool_stream.c (1.9): Fix wrong timeout handling in pool_read2()
and pool_read_string().
2008-02-08 17:10 yamaguti
* pcp/pcp.c (1.7, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
Disabled PCP client's timeout.
PCP commands still take timeout option, but ignores and set
notimeout.
2008-02-08 15:47 y-asaba
* sql/pgpool-recovery/pgpool-recovery.c (1.5, V2_1_0_BETA2,
V2_1_0_BETA1): PostgreSQL superuser can *only* execute
pgpool_recovery and pgpool_remote_start functions because of
security issue.
2008-02-08 15:47 yamaguti
* main.c (1.27), pcp_child.c (1.10, V2_1_0_BETA1), recovery.c
(1.9): Implemented configuration file "reload" function into PCP.
2008-02-08 13:11 yamaguti
* recovery.c (1.8): Use "recovery_timeout" to decide how long
pgpool should wait before online-recovery fails.
2008-02-08 13:10 yamaguti
* pgpool.conf.sample (1.17), pool.h (1.27), pool_config.c (1.22),
pool_config.l (1.20): added a new configuration parameter
"recovery_timeout".
pgpool waits so many seconds, specified by recovery_timeout, for:
1) all client connections are closed before the 2nd stage
2) a remote host to start up in the final stage
Note that "recovery_timeout = 0" means NO WAIT; not no timeout.
2008-02-05 19:05 y-asaba
* pool_auth.c (1.10): Fix minor bug introduced by previous commit.
2008-02-05 18:57 y-asaba
* pool_auth.c (1.9): Fix authentication error when master was down.
2008-02-05 11:13 y-asaba
* pool_process_query.c (1.92): Remove unneccesary flushing output
buffer.
2008-01-29 11:01 y-asaba
* doc/pgpool-ja.html (1.36): Add description of recovery script.
2008-01-29 10:56 y-asaba
* ChangeLog (1.26), child.c (1.18), main.c (1.26), pcp_child.c
(1.9), pool.h (1.26), pool_auth.c (1.8), pool_config.c (1.21),
pool_config.l (1.19), pool_connection_pool.c (1.10), pool_error.c
(1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pool_hba.c (1.4, V2_1_0_BETA1), pool_ip.c (1.2,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pool_ip.h (1.2, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pool_ipc.h (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_params.c
(1.3, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pool_path.c (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_path.h (1.2,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), pool_process_query.c (1.91),
pool_query_cache.c (1.9, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_rewrite_query.c
(1.9, V2_1_0_BETA2, V2_1_0_BETA1), pool_rewrite_query.h (1.6,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_sema.c
(1.4, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pool_shmem.c (1.3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), pool_signal.c (1.3, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pool_signal.h (1.4, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_stream.c
(1.8), pool_system.c (1.5, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pool_type.h (1.8,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), ps_status.c
(1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), recovery.c
(1.7), strlcpy.c (1.2, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), COPYING (1.3,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pcp/Makefile.in (1.12), pcp/pcp.c (1.6), pcp/pcp.h (1.3, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_attach_node.c
(1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/Makefile.in (1.13), parser/copyfuncs.c (1.3, V2_2_7,
V2_2_6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/gram.c (1.9,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pcp/pcp_detach_node.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pcp/pcp_error.c (1.2, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pcp/pcp_node_count.c (1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pcp/pcp_node_info.c (1.2, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_proc_count.c (1.3, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_proc_info.c
(1.2, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
pcp/pcp_recovery_node.c (1.2), pcp/pcp_stop_pgpool.c (1.2,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_stream.c
(1.4, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), pcp/pcp_stream.h (1.2, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), pcp/pcp_systemdb_info.c (1.2, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1),
sql/pgpool-recovery/pgpool-recovery.c (1.4), parser/gram.h (1.8,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/gram.y
(1.5, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/keywords.c (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/keywords.h (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/list.c (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/makefuncs.c (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/makefuncs.h (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/memnodes.h (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/nodes.c (1.2, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/nodes.h (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/outfuncs.c (1.6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/parsenodes.h (1.3, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/parser.h (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pg_list.h
(1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_memory.c (1.10, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/pool_memory.h (1.5, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/pool_parser.h (1.5, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/pool_string.c (1.4, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/pool_string.h (1.4, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/primnodes.h (1.3, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/scan.c (1.8, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1),
parser/scan.l (1.5, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/scansup.h
(1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1), parser/value.c (1.3, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1), parser/value.h (1.3, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1):
Update copyright.
2008-01-28 11:31 y-asaba
* ChangeLog (1.25): Add item.
2008-01-28 11:26 y-asaba
* pool_process_query.c (1.90): Change log level of the following
message from ERROR to LOG.
ProcessFrontendResponse: failed to read kind from frontend. fronend
abnormally exited
This means that pgpool detects unexpected EOF. This is not pgpool's
error.
2008-01-25 18:49 y-asaba
* ChangeLog (1.24): Add item.
2008-01-25 16:20 y-asaba
* pool_process_query.c (1.89): Load balancing node was changed
after processing transaction. For example,
SELECT 1; <-- node 1
BEGIN;
SELECT 2; <-- node 0(master)
END;
SELECT 3; <-- node 0(master)
"SELECT 3" was sended to a master node, not a load balancing node.
VALID_BACKEND macro does not check node validation if
in_load_balancing is 1. So we do not use VALID_BACKEND macro to
check whether load balancing node is down.
2008-01-19 18:49 y-asaba
* pool_process_query.c (1.88): Add comments.
2008-01-15 11:10 y-asaba
* pool_process_query.c (1.87): Remove unused variable.
2008-01-11 12:11 y-asaba
* pool_process_query.c (1.86): Add comments.
2008-01-11 11:30 y-asaba
* ChangeLog (1.23), main.c (1.25), pool_hba.c (1.3),
pool_process_query.c (1.85), parser/parser.c (1.5, V2_2_7,
V2_2_6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1), parser/pool_memory.c
(1.9), parser/pool_memory.h (1.4): Fix memory leak at prepared
statement list.
pgpool caches a parse tree in prepared statement list. The parse
tree copy deeply, but we freed only the top node of the parse tree.
2008-01-09 18:10 y-asaba
* recovery.c (1.6): Refactoring recovery code.
2008-01-08 13:31 y-asaba
* main.c (1.24): Fix compile error.
2008-01-08 11:20 y-mori
* doc/: tutorial-en.html (1.4), tutorial-ja.html (1.3) (utags:
V2_1_0_BETA1): FIX tutorial
Because replicate_def table is confused dist_def table when a
parallel mode is set according to the tutorial, data is not
divided.
2008-01-02 17:32 t-ishii
* main.c (1.23): Fix bug in previous commit Fix typo
2007-12-27 12:00 y-asaba
* ChangeLog (1.22): Add ChangeLog items.
2007-12-27 11:21 y-asaba
* main.c (1.22), pgpool.conf.sample (1.16), doc/pgpool-en.html
(1.22), doc/pgpool-ja.html (1.35): Allow '%m' character to obtain
master node id in failover_command and failback_command.
2007-12-26 16:05 y-asaba
* doc/: pgpool-en.html (1.21), pgpool-ja.html (1.34): Add
multi-statement restriction.
2007-12-26 11:40 y-asaba
* pool_process_query.c (1.84): Fix internal transaction handling in
extended query protocol. pgpool did not send "COMMIT" to close an
internal transaction block.
2007-12-22 09:11 t-ishii
* recovery.c (1.5): Add lots of pool_log to show the recovery steps
2007-12-11 12:59 t-ishii
* main.c (1.21): Change "starting health checking" and "retrying %d
th health checking" log messages to DEBUG messages since they are
too verbose.
2007-12-07 15:35 y-asaba
* TODO (1.10, V2_1_0_BETA1): TODO: Add replication function list.
2007-12-07 14:08 y-asaba
* child.c (1.17), config.h.in (1.5), configure (1.18), configure.in
(1.16), pcp_child.c (1.8), pool_config.c (1.20), pool_config.l
(1.18), pcp/pcp.c (1.5): Fix compile error and warning on Solaris
10.
2007-12-06 13:59 y-mori
* pool_rewrite_query.c (1.8): FIX: INSERT statment in a parallel
mode How to count the Value Clause list was wrong
2007-12-05 17:15 y-asaba
* pool_stream.c (1.7): Improve buffering algorithm in pool_write().
2007-12-03 10:47 y-asaba
* pool_process_query.c (1.83): Don't output log if PostgreSQL send
a warning message in do_command().
2007-12-02 11:45 y-asaba
* pool_process_query.c (1.82): Fix segmentation fault if
CloseComplete command was received.
2007-12-01 23:50 y-asaba
* pool_process_query.c (1.81): Fix memory leak when PREPARE or
DEALLOCATE is failed.
2007-12-01 22:26 y-asaba
* pool_process_query.c (1.80): Remove debug log.
2007-11-30 16:38 y-mori
* pool_rewrite_query.c (1.7): Fix: The INSERT statment did not
correspond to the parser of postgresql 8.3 that pgpool-II 2.0 had.
Therefore, the following errors occur if INSERT is done in a
parallel mode
ERROR: pgpool2 sql restriction
DETAIL: cannot use SElectStmt in InserStmt
2007-11-24 22:04 t-ishii
* doc/: pgpool-en.html (1.20), pgpool-ja.html (1.33): Fix english
docs. Add a link to tutorial.
2007-11-23 09:14 t-ishii
* pool_config.c (1.19), pool_config.l (1.17): Add missing
replicate_select entry. per bug report on [pgsql-jp: 38968].
2007-11-22 04:35 devrim
* pgpool.spec (1.10): Update to 2.0.1
2007-11-21 19:18 y-asaba
* configure (1.17), configure.in (1.15) (utags: V2_0_1): Prepare
for 2.0.1.
2007-11-21 19:09 y-asaba
* NEWS (1.15), doc/pgpool-ja.html (1.32) (utags: V2_0_1): Release
note for pgpool-II 2.0.1.
2007-11-21 18:39 y-asaba
* ChangeLog (1.21, V2_0_1): update.
2007-11-21 18:37 y-asaba
* pool_process_query.c (1.79, V2_0_1): Fix segmentation fault when
UPDATE or DELETE is executed. The bug is critical so we must
release 2.0.1 as soon as possible.
2007-11-21 13:47 y-asaba
* recovery.c (1.4, V2_0_1): Use snprintf() instead of sprintf().
2007-11-21 10:47 y-asaba
* pool_process_query.c (1.78): Send a syntax error query to a
master node when master_slave is true.
2007-11-16 14:29 y-mori
* doc/: pgpool-en.html (1.19, V2_0_1), pgpool-ja.html (1.31)
(utags: V2_0_0): ADD: documents (Setting method of Query cache)
2007-11-16 11:52 y-asaba
* pool_auth.c (1.7, V2_0_1, V2_0_0): Fix segmentation fault in a
password authentication when a node is down.
2007-11-16 10:56 y-asaba
* ChangeLog (1.20, V2_0_0): pgpool-II 2.0
2007-11-16 10:51 y-asaba
* Makefile.in (1.19, V2_0_1), aclocal.m4 (1.12, V2_0_1), configure
(1.16), parser/Makefile.in (1.12, V2_0_1), parser/gram.c (1.8,
V2_0_1), parser/gram.h (1.7, V2_0_1), pcp/Makefile.in (1.11,
V2_0_1) (utags: V2_0_0): Prepare for pgpool-II 2.0.
2007-11-16 10:39 y-asaba
* doc/: pgpool-en.html (1.18), pgpool-ja.html (1.30):
- Fix the sample script of online recovery.
- Add note about timeout of pcp_recovery_node.
2007-11-16 09:20 gleu
* doc/pgpool-en.html (1.17): Typo fix.
2007-11-15 09:39 y-mori
* pool_rewrite_outfuncs.c (1.11, V2_1_0_BETA1),
pool_rewrite_query.h (1.5) (utags: V2_0_0, V2_0_1): FIX: It
corresponed to the following Queries. ex) select * from (select
a,b,c from t1) as t2(d,e,f) ~~~~~
2007-11-14 16:46 y-mori
* pool_process_query.c (1.77, V2_0_0): FIX: The load-balnace was
not functioning in a parallel mode
2007-11-14 13:59 y-mori
* pool_rewrite_outfuncs.c (1.10): FIX:
It made a mistake in the processing of OUTER JOIN (syntax of C
lang)
2007-11-14 12:59 y-mori
* pool.h (1.25, V2_0_1, V2_0_0), pool_process_query.c (1.76),
pool_stream.c (1.6, V2_0_1, V2_0_0): fix:
-When the setting of replication_timeout was effective,
SELECT that the execution time is long did the time-out
in only a parallel mode.
-A wrong number was displayed when replicated table was
updated or deleted in only a parallel mode.
2007-11-13 10:44 y-asaba
* configure.in (1.14, V2_0_0): Prepare for pgpool-II 2.0.
2007-11-13 03:12 devrim
* doc/pgpool-en.html (1.16): Removed some garbage chars Fixed
indendation of some paragraphs Fixed some typos
There seems a lot to do btw.
2007-11-12 18:04 y-asaba
* NEWS (1.14, V2_0_0), doc/pgpool-ja.html (1.29): Prepare for
pgpool-II 2.0.
2007-11-12 18:02 y-asaba
* doc/pgpool-ja.html (1.28): Fix typo.
2007-11-12 17:34 y-mori
* doc/tutorial-en.html (1.3, V2_0_1, V2_0_0): add: pgpoo-II 2.0
tutorial -parallel-query section
2007-11-12 15:40 y-mori
* doc/: pgpool-en.html (1.15), pgpool-ja.html (1.27): add:
pgpool-II 2.0 manual.
-add parallel-query section
fix:
Japanese manual.
- typo
2007-11-09 16:25 y-mori
* doc/: pgpool-ja.html (1.26), pgpool.css (1.4, V2_0_1, V2_0_0),
tutorial-ja.html (1.2, V2_0_1, V2_0_0): pgpoo-ll 2.0 manual &
tutorial (Japanese)
- Add parallel query section
2007-11-09 15:09 y-mori
* sample/replicate_def_pgbench.sql (1.1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0): ADD Sample SQL file
2007-11-09 13:56 y-mori
* sql/system_db.sql (1.2, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1,
V2_0_0): ADD "replicate_def" table in "pgpool_catalog" schema
2007-11-09 13:41 y-asaba
* pgpool.8.in (1.3, V2_1_0_BETA1, V2_0_1, V2_0_0): Add reload
option.
2007-11-09 13:37 y-asaba
* main.c (1.20, V2_0_1, V2_0_0): Add pgpool reload in usage().
2007-11-09 12:00 y-asaba
* Makefile.am (1.19), test/jdbc/README.euc_jp (1.1, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1) (utags: V2_0_0, V2_0_1, V2_1_0_BETA1,
V2_1_0_BETA2): Add README.euc_jp
2007-11-08 10:43 y-asaba
* doc/pgpool-en.html (1.14): pgpool-II 2.0 manual.
- Add online recovery section.
- Add new parameters.
TODO: review my English...
2007-11-07 19:05 y-asaba
* pool_process_query.c (1.75): Send Sync message before calling
insert_lock().
2007-11-07 15:35 y-mori
* pool_rewrite_outfuncs.c (1.9): fix: join rule for /*NOT*/SQL99
type join,CROSS JOIN and NATURAL JOIN
2007-11-06 16:07 y-asaba
* test/jdbc/InsertTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), test/jdbc/RunTest.java (1.2, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), test/jdbc/pgpool.properties (1.2,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0),
test/jdbc/prepare.sql (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), test/jdbc/expected/insert (1.1, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), Makefile.am (1.18): Add INSERT
statement test.
2007-11-05 14:26 y-asaba
* pool_process_query.c (1.74): Fix insert_lock with extended query
protocol.
2007-11-05 11:08 y-asaba
* pool_process_query.c (1.73): Use FD_SETSIZE instead of 1024 at
set_fd, isset_fd and zero_fd.
2007-11-05 10:41 y-asaba
* pool_process_query.c (1.72): Ignore white space in
need_insert_lock().
2007-11-02 18:20 y-mori
* pool_process_query.c (1.71): Fix: compile error at FreeBSD4.1
2007-11-02 01:57 devrim
* pgpool.spec (1.9, V2_0_1, V2_0_0): Update spec file for 2.0 beta1
2007-11-01 19:14 y-asaba
* Makefile.am (1.17): Fix compile error with SUN's cc.
2007-11-01 19:11 y-asaba
* configure.in (1.13), pool_process_query.c (1.70),
parser/Makefile.am (1.4, V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), pcp/Makefile.am (1.3, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0): Fix compile error with SUN's cc.
2007-11-01 17:17 y-asaba
* pcp/pcp_proc_count.c (1.2, V2_0_1, V2_0_0): Fix warning with
SUN's cc.
2007-11-01 11:08 t-ishii
* Makefile.in (1.18, V2_0_0_BETA1): Rerun autoconf
2007-11-01 11:01 y-asaba
* Makefile.am (1.16, V2_0_0_BETA1): Remove test.diff
2007-11-01 10:45 t-ishii
* Makefile.in (1.17), aclocal.m4 (1.11, V2_0_0_BETA1), configure
(1.15, V2_0_0_BETA1), pool_config.c (1.18, V2_0_1, V2_0_0,
V2_0_0_BETA1), parser/Makefile.in (1.11, V2_0_0_BETA1),
pcp/Makefile.in (1.10, V2_0_0_BETA1): Run autoconf
2007-10-31 19:45 y-asaba
* NEWS (1.13), pgpool.conf.sample (1.15, V2_0_1, V2_0_0), pool.h
(1.24), pool_config.l (1.16, V2_0_1, V2_0_0),
pool_process_query.c (1.69), doc/pgpool-en.html (1.13),
doc/pgpool-ja.html (1.25) (utags: V2_0_0_BETA1): Remove
replicate_strict derective. pgpool-II 2.x always set to true.
2007-10-31 19:13 y-asaba
* ChangeLog (1.19, V2_0_0_BETA1): pgpool-II 2.0 beta1
2007-10-31 18:41 y-mori
* test/pdo-test/README.euc_jp (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1): ADD: pdo test program
manual(Japanese)
2007-10-31 15:10 y-asaba
* doc/pgpool-ja.html (1.24): Add comments about reloadable
derectives.
2007-10-31 13:15 y-asaba
* pool_config.l (1.15): Allow to reload pcp_timeout.
2007-10-31 12:49 y-mori
* pool_rewrite_outfuncs.c (1.8, V2_0_0_BETA1): FIX: "IN" predicate
at query rewriting
2007-10-31 12:31 y-asaba
* NEWS (1.12): pgpool-II 2.0(beta1) release note.
2007-10-30 21:44 t-ishii
* pool_auth.c (1.6, V2_0_0_BETA1): Fix confusing variable name
Enhance error message Check unsupported auth method
2007-10-30 16:13 y-asaba
* pool_process_query.c (1.68): Fix segfault with "SHOW
pool_status".
2007-10-30 16:09 y-asaba
* Makefile.am (1.15): Remove gprof option.
2007-10-30 15:58 y-asaba
* doc/: pgpool-ja.html (1.23), pgpool.css (1.3, V2_0_0_BETA1):
Improve online-recovery documentation.
2007-10-30 11:35 y-asaba
* configure.in (1.12, V2_0_0_BETA1): Prepare for pgpool-II 2.0
beta1.
2007-10-30 11:11 y-asaba
* pool_auth.c (1.5): Previous commit did not support V2 protocol.
2007-10-30 10:53 y-asaba
* pool_auth.c (1.4): Send the following error message to frontend
if client auth method is md5 password in replication, master-slave
and parallel modes.
MD5 authentication is unsupported in replication, master-slave and
parallel modes.
2007-10-29 17:12 y-asaba
* Makefile.am (1.14): Merge V1_STABLE branch.
2007-10-29 15:55 y-asaba
* pgpool.spec (1.8, V2_0_0_BETA1): Merge V1_STABLE branch.
2007-10-29 15:28 y-asaba
* redhat/: pgpool.init (1.2), pgpool.sysconfig (1.2, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1) (utags: V2_0_0,
V2_0_0_BETA1, V2_0_1, V2_1_0_BETA1, V2_1_0_BETA2): Merge redhat
scripts from V1_STABLE branch.
2007-10-29 15:09 y-asaba
* doc/pgpool-ja.html (1.22): Fix insert_lock description.
2007-10-29 14:52 y-asaba
* doc/pgpool-ja.html (1.21): Add new directives and update
description of online recovery.
2007-10-29 14:50 y-asaba
* pgpool.conf.sample (1.14), pool.h (1.23), pool_config.l (1.14),
pool_process_query.c (1.67), recovery.c (1.3, V2_0_0,
V2_0_0_BETA1): Add new directives "recovery_1st_stage_command"
and "recovery_2nd_stage_command".
pgpool don't block client connections and data update operations
while executing recovery_1st_stage_command. In
recovery_2nd_stage_command, pgpool block them.
If you recover by PITR, the first stage command get a base backup.
Then you switch XLOG in the second stage command.
2007-10-29 13:37 y-asaba
* sql/pgpool-recovery/: pgpool-recovery.c (1.3),
pgpool-recovery.sql.in (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1)
(utags: V2_0_0, V2_0_0_BETA1, V2_0_1): Change pgpool_recovery
signature from pgpol_recovery(text, text) to pgpool_recovery(text,
text, text). The first argument is script name.
* pgpool_recovery arguments:
#1: script name
#2: remote host name
#3: remote database cluster path
return value:
command status (= "$?" value)
2007-10-29 13:16 y-mori
* pool_process_query.c (1.66), pool_rewrite_outfuncs.c (1.7),
pool_rewrite_query.h (1.4, V2_0_0_BETA1), parser/outfuncs.c (1.5,
V2_0_1, V2_0_0, V2_0_0_BETA1): add optimization of aggregate
function and group by clause in parallel mode
2007-10-29 10:20 t-ishii
* Makefile.in (1.16), pgpool.conf.sample (1.13), pool.h (1.22),
pool_config.c (1.17), pool_config.l (1.13), pool_process_query.c
(1.65), parser/gram.c (1.7, V2_0_0_BETA1), parser/scan.c (1.7,
V2_0_1, V2_0_0, V2_0_0_BETA1): Change child_idle_limit to
client_idle_limit
2007-10-26 20:28 y-asaba
* pool_process_query.c (1.64): All signals are blocked while
sending a "COMMIT" command.
2007-10-26 16:41 y-asaba
* pool_process_query.c (1.63): Check return value of pool_flush().
2007-10-23 16:32 y-asaba
* sql/pgpool-recovery/pgpool-recovery.c (1.2): Change error
message.
2007-10-23 13:44 y-asaba
* Makefile.am (1.13), doc/pgpool-ja.html (1.20),
sample/pgpool_recovery_pitr (1.1, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1): Add online recovery script using pitr.
2007-10-22 17:59 y-asaba
* test/jdbc/.cvsignore (1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1): Add .cvsignore file.
2007-10-22 17:55 y-asaba
* Makefile.am (1.12): Add test/jdbc/* into tar ball.
2007-10-22 17:47 y-asaba
* test/jdbc/: AutoCommitTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), BatchTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), ColumnTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), LockTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), PgpoolTest.java (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), RunTest.java (1.1), SelectTest.java (1.1,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), UpdateTest.java
(1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0), pgpool.properties
(1.1), prepare.sql (1.1), run.sh (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0), expected/autocommit (1.1, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), expected/batch (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), expected/column (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), expected/lock (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), expected/select (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0), expected/update (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0) (utags: V2_0_0_BETA1): Add test
program using Java+JDBC driver.
2007-10-22 13:23 y-asaba
* NEWS (1.11), doc/pgpool-ja.html (1.19): Merge from V1_STABLE
branch.
2007-10-18 18:55 y-asaba
* pool_query_cache.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Although
the second argument of PQunescapeBytea() requires size_t which size
is 8 byte in 64bit machine, pgpool passed 4 byte variable. It
caused segfault. So fixed passing size_t variable.
2007-10-18 18:52 y-mori
* test/pdo-test/: collections.inc (1.1), def.inc (1.1), log.txt
(1.1), pdotest.php (1.1), regsql.inc (1.1), SQLlist/test1.sql
(1.1), SQLlist/test2.sql (1.1), mod/database.inc (1.1),
mod/def.inc (1.1), mod/errorhandler.inc (1.1) (utags: V2_0_0,
V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2,
V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1,
V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4, V2_2_5, V2_2_6,
V2_2_7, V2_3, V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): ADD:
extend protocol test tool
2007-10-18 17:24 y-asaba
* sample/pgpool_recovery (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1): execute rsync as background jobs.
2007-10-18 13:48 y-asaba
* sample/pgpool_recovery (1.2):
* Add --update option.
* Sync pg_twophase directory.
2007-10-18 11:54 y-asaba
* pool_process_query.c (1.62): Fix compile warning on Solaris.
2007-10-18 10:21 y-asaba
* pool_config.c (1.16), pool_config.l (1.12): Set failback_command
default value to empty string;
2007-10-17 19:23 y-asaba
* main.c (1.19, V2_0_0_BETA1): Fix segfault when failover_command
is empty.
2007-10-17 15:31 y-mori
* pool_rewrite_outfuncs.c (1.6): FIX: lost alias name of column in
query rewriting when it was used at GRUP BY CLAUSE..etc
2007-10-17 12:00 y-mori
* pool.h (1.21), pool_process_query.c (1.61),
pool_rewrite_outfuncs.c (1.5): Fix: compiler's warning
2007-10-16 12:44 y-asaba
* pool_process_query.c (1.60): Fix hang up in load balancing mode.
2007-10-15 22:56 y-mori
* pool_rewrite_outfuncs.c (1.4): fix Type Casting of Constant value
was not supported
2007-10-15 21:56 y-mori
* pool_process_query.c (1.59): FIX wrong file descriptor was used
at pool_prallel_exec
2007-10-15 19:38 y-mori
* pool_process_query.c (1.58), pool_rewrite_query.c (1.6, V2_0_1,
V2_0_0, V2_0_0_BETA1): FIX insert rule in parallel mode
2007-10-15 19:20 y-asaba
* test/parser/: expected/create.out (1.2, V2_2_7, V2_2_6),
expected/select.out (1.2), input/select.sql (1.3) (utags: V2_0_0,
V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2,
V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1,
V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4, V2_2_5): Add test
cases.
2007-10-15 19:18 y-asaba
* parser/outfuncs.c (1.4): Support interval operator.
2007-10-15 18:51 y-asaba
* parser/: gram.y (1.4), scan.l (1.4) (utags: V2_0_0, V2_0_0_BETA1,
V2_0_1): Fix core dump with the following SQL.
SELECT * FROM tbl LIMIT 1,0;
2007-10-15 16:05 y-asaba
* pool_process_query.c (1.57): Fix invalid memory access when
pgpool processed DEALLOCATE statement.
2007-10-15 15:56 y-mori
* pool_config.c (1.15), pool_process_query.c (1.56),
pool_rewrite_outfuncs.c (1.3), pool_rewrite_query.c (1.5),
pool_rewrite_query.h (1.3), pool_system.c (1.4, V2_0_1, V2_0_0,
V2_0_0_BETA1), pool_type.h (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1):
ADD query rewriting to main trunc
2007-10-15 15:11 y-asaba
* parser/pool_memory.c (1.8, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix
core dump with a large SQL.
2007-10-12 21:27 t-ishii
* pgpool.conf.sample (1.12), pool.h (1.20), pool_config.c (1.14),
pool_process_query.c (1.55), parser/scan.c (1.6): Add pool_status
entry for child_idle_limit Fix comments
2007-10-12 18:15 y-asaba
* pgpool.conf.sample (1.11): Add new directive
"authentication_timeout" into pgpool.conf.sample.
2007-10-12 15:56 y-asaba
* doc/pgpool-ja.html (1.18): Add authentication_timeout.
2007-10-12 14:55 y-asaba
* main.c (1.18): Fix compiler warning.
2007-10-12 14:30 y-asaba
* parser/: parser.c (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1),
pool_parser.h (1.4, V2_0_1, V2_0_0, V2_0_0_BETA1), scan.l (1.3):
Fix scanner's error handling. If there was a unterminated
double-quote identifier, scanner entered infinite-loop.
2007-10-12 13:51 y-asaba
* child.c (1.16, V2_0_1, V2_0_0, V2_0_0_BETA1), pool.h (1.19),
pool_config.c (1.13), pool_config.l (1.11), pool_process_query.c
(1.54): Add new directive "authentication_timeout". The directive
means the maximum time in seconds to complete client authentication.
The default value is 60.
2007-10-12 13:50 y-asaba
* TODO (1.9, V2_0_1, V2_0_0, V2_0_0_BETA1): Remove some items.
2007-10-12 13:39 y-asaba
* test/parser/input/select.sql (1.2): Add test cases.
2007-10-12 13:38 y-asaba
* parser/outfuncs.c (1.3): Support for XmlExprt object.
2007-10-12 13:35 y-asaba
* pcp_child.c (1.7, V2_0_1, V2_0_0, V2_0_0_BETA1): recovery request
can be accepted only in replication mode.
2007-10-12 13:34 t-ishii
* Makefile.am (1.11), Makefile.in (1.15), pgpool.conf.sample
(1.10), pool.h (1.18), pool_config.c (1.12), pool_config.l
(1.10), pool_process_query.c (1.53), parser/Makefile.am (1.3,
V2_0_0_BETA1), parser/Makefile.in (1.10), parser/gram.c (1.6),
parser/gram.h (1.6, V2_0_0_BETA1): Add child_idle_limit. # If
child_idle_limit is n (n > 0), the child is forced to be #
disconnected after n seconds idle between transactions. # 0 means
no disconnect.
Need to work on show pool_status and docs.
2007-10-11 17:32 y-asaba
* child.c (1.15), pool.h (1.17): Check startup packet length. If
the length is greater than 10,000 byte, pgpool reject the
connection.
2007-10-11 10:49 y-asaba
* TODO (1.8): Add graceful {shutodwn, attach, detach} into TODO
list.
* TODO for TODO list translate Japanse into English.
2007-10-04 13:17 y-asaba
* doc/: pgpool-ja.html (1.17), pgpool.css (1.2): Update Japanse
manual.
- Add release note for pgpool-II 2.0
- Add failover_command and failback_command description
2007-10-04 12:00 y-asaba
* doc/pgpool-en.html (1.12): Merge V1_STABLE branch.
2007-10-04 11:36 y-asaba
* version.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Change
PGPOOLVERSION to "hikitsuboshi".
2007-10-03 15:19 y-asaba
* TODO (1.7): Remove TODO items.
2007-10-03 14:21 y-asaba
* pool_process_query.c (1.52): Reset a prepared statement list when
DISCARD ALL or DISCARD PLANS statement is completed.
2007-10-03 13:52 y-asaba
* test/parser/: README (1.2), run-test (1.2) (utags: V2_0_0,
V2_0_0_BETA1, V2_0_1, V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2,
V2_1_0_RC1, V2_2_0, V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1,
V2_2_0_RC2, V2_2_1, V2_2_2, V2_2_3, V2_2_4, V2_2_5, V2_2_6,
V2_2_7, V2_3, V2_3_1, V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3):
Translate from Japanese into English.
2007-10-03 13:47 y-asaba
* Makefile.am (1.10), Makefile.in (1.14), test/parser/.cvsignore
(1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/Makefile (1.1, V2_2_7, V2_2_6, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/README
(1.1), test/parser/main.c (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/parse_schedule (1.1,
V2_2_7, V2_2_6, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1), test/parser/pool.h (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/run-test (1.1),
test/parser/expected/copy.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/create.out (1.1),
test/parser/expected/cursor.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/delete.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/drop.out (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/expected/insert.out
(1.1, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/misc.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/prepare.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/privileges.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/select.out (1.1),
test/parser/expected/transaction.out (1.1, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/update.out (1.1, V2_2_7, V2_2_6, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/expected/var.out (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/alter.sql (1.1,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/copy.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/create.sql (1.1,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/cursor.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/delete.sql (1.1,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/drop.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/insert.sql (1.1,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/misc.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/prepare.sql
(1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6,
V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/privileges.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/select.sql
(1.1), test/parser/input/transaction.sql (1.1, V2_3_3, V2_2_7,
V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4,
V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1),
test/parser/input/update.sql (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), test/parser/input/var.sql (1.1,
V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3,
V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2,
V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1,
V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1): Add
SQL parser test.
2007-10-03 13:25 y-asaba
* Makefile.in (1.13), aclocal.m4 (1.10), config.sub (1.2, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1), configure (1.14),
ltmain.sh (1.3, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1), pool_hba.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
pool_process_query.c (1.51), pool_rewrite_outfuncs.c (1.2),
pool_rewrite_query.c (1.4), parser/Makefile.in (1.9),
parser/copyfuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/gram.c (1.5), parser/gram.h (1.5), parser/gram.y (1.3),
parser/gramparse.h (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), parser/keywords.c (1.2, V2_0_1,
V2_0_0, V2_0_0_BETA1), parser/keywords.h (1.2, V2_0_1, V2_0_0,
V2_0_0_BETA1), parser/list.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/makefuncs.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/makefuncs.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/nodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/outfuncs.c (1.2), parser/parsenodes.h (1.2, V2_0_1,
V2_0_0, V2_0_0_BETA1), parser/parser.c (1.3), parser/parser.h
(1.2, V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pg_list.h (1.2,
V2_0_1, V2_0_0, V2_0_0_BETA1), parser/pool_parser.h (1.3),
parser/primnodes.h (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/scan.c (1.5), parser/scan.l (1.2), parser/value.c (1.2,
V2_0_1, V2_0_0, V2_0_0_BETA1), parser/value.h (1.2, V2_0_1,
V2_0_0, V2_0_0_BETA1), pcp/Makefile.in (1.9): Import PostgreSQL
8.3 SQL parser. The revision of gram.y is 2.603.
2007-10-03 13:17 y-asaba
* pgpool.conf.sample (1.9), pool_config.c (1.11), pool_config.l
(1.9): The default value of ignore_leading_white_space is true in
pgpool-II 2.x.
2007-09-27 18:38 gleu
* pool_process_query.c (1.50): Typo fix.
2007-09-27 11:48 y-asaba
* TODO (1.6): Remove TODO item.
2007-09-27 11:46 y-asaba
* pool_process_query.c (1.49): Call read_kind_from_backend()
function instead of pool_read_kind() in Execute(), Parse() and
SimpleForwardToFrontend().
2007-09-26 18:09 y-asaba
* pool_process_query.c (1.48): Remove debug message.
2007-09-26 17:56 y-asaba
* pool_process_query.c (1.47): SET, PREPARE and DEALLOCATE
statements are replicated in master/slave mode.
2007-09-26 14:29 y-asaba
* main.c (1.17), pool.h (1.16), pool_process_query.c (1.46),
pool_stream.c (1.5, V2_0_0_BETA1): pgpool-II could not detach
multiple node when message kinds were mismatched.
For example:
node-1(master): success
node-2: fail
node-3: success
node-4: fail
node-5: success
node-2 was only detached.
Now it determine detached nodes by "majority voting rule". And it
can detach them at the same time.
For example:
node-1(master): success
node-2: fail
node-3: success
node-4: fail
node-5: success
node-2 and node-4 are detached because they are minority.
node-1(master): success
node-2: fail
node-3: fail
node-4: success
The number of the group which gain "success" is same as the number
of the group which gain "fail". In this case, node-2 and node-3 are
detached because these don't belong to the group which master
belongs to.
2007-09-26 12:32 y-asaba
* pool_sema.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Fix initializing
semaphore values.
2007-09-16 11:08 y-asaba
* pgpool.conf.sample (1.8): Add comments abount failover_command
and failback_command.
2007-09-14 22:36 y-asaba
* main.c (1.16), pgpool.conf.sample (1.7), pool.h (1.15),
pool_config.c (1.10), pool_config.l (1.8), pool_process_query.c
(1.45), parser/gram.c (1.4), parser/gram.h (1.4), parser/gram.y
(1.2), parser/pool_string.c (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1),
parser/pool_string.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1): Add
"failover_command" and "failback_command" directives. If failover
or failback occur, pgpool execute setting command by system(3).
These directives evaluate special characters with the following
rule.
%d: node id
%h: backend's hostname
%p: backend's port number
%D: backend's data directory
example) pgpool.conf: ---
failover_command = 'echo %h %p %D %d > /tmp/failover'
failback_command = 'echo %h %p %D %d > /tmp/failback'
backend_hostname1 = 'localhost'
backend_port1 = 5433
backend_weight1 = 1
backend_data_directory1 = '/home/postgres/pgdata/data5433' ---
When node 1 is down, pgpool execute the following failover command.
failover localhost 5433 /home/postgres/pgdata/data5433 1
/tmp/failover is created.
% cat /tmp/failover
failover localhost 5433 /home/postgres/pgdata/data5433 1
2007-09-14 20:11 y-asaba
* child.c (1.14), pool.h (1.14), pool_process_query.c (1.44): Fix
hang up when load balancing node was down.
2007-09-10 22:29 t-ishii
* pool_process_query.c (1.43): Modfify pool_send_error_message() so
that it won't be blocked by sending packet to the closing frontend
connection. Also rename set_non_block() and unset_non_block() to
pool_sen_non_block() and pool_unset_non_block() respectively to make
them public functions.
2007-09-10 22:25 t-ishii
* child.c (1.13), pool.h (1.13): Modfify pool_send_error_message()
so that it won't be blocked by sending packet to the closing
frontend connection. Also rename set_non_block() and
unset_non_block() to pool_sen_non_block() and pool_unset_non_block()
respectively to make them public functions.
2007-09-10 21:47 t-ishii
* child.c (1.12): Fix misspell in a comment
2007-09-07 18:08 y-asaba
* pool_process_query.c (1.42), parser/parser.c (1.2),
parser/pool_memory.c (1.7), parser/pool_memory.h (1.3, V2_0_1,
V2_0_0, V2_0_0_BETA1): Improve performance.
- Reuse parser memory space in free_parser().
- Check node type before comparing with "show pool_status()".
2007-09-06 10:43 y-asaba
* doc/pgpool-en.html (1.11): Fix restricted query section.
2007-08-29 15:49 y-asaba
* pool_query_cache.c (1.7), pcp/pcp.c (1.4, V2_0_1, V2_0_0,
V2_0_0_BETA1), pcp/pcp_stream.c (1.3, V2_0_1, V2_0_0,
V2_0_0_BETA1): Fix compile error on FreeBSD 4.11.
2007-08-29 15:48 y-asaba
* recovery.c (1.2): Fix compile error.
2007-08-29 15:01 y-asaba
* pool_process_query.c (1.41): Read response messages in Parse()
until receiving ParseComplete or ErrorResponse message.
2007-08-28 19:07 y-asaba
* pool_process_query.c (1.40): Add checking deadlock error message
in Parse().
2007-08-28 11:28 y-asaba
* pool_process_query.c (1.39):
* Fix handling Parse message. Parse message including
INSERT/UPDATE/DELETE query acquires RowExclusiveLock. However pgpool
did not wait a response from each node. It was possible to occur
deadlock problem.
* Fix memory leak in reset_prepared_list()
2007-08-17 10:50 t-ishii
* TODO (1.5), doc/pgpool-ja.html (1.16): Enhance documentation.
2007-08-13 11:23 y-asaba
* pgpool.conf.sample (1.6), pool.h (1.12), pool_config.l (1.7),
pool_process_query.c (1.38): Add new parameter named
"replicate_select". Default value is 'false'.
If it is true, pgpool replicates SELECT queries when load balancing
is disabled. This is a old specification which was V1.0.
If it is false, pgpool only sends them to the master node. This is a
current specification.
2007-08-06 10:42 y-asaba
* pool_process_query.c (1.37): Fix memory leak.
2007-08-01 13:27 y-asaba
* child.c (1.11): Remove compiler warning.
2007-07-27 10:19 y-asaba
* doc/pgpool-ja.html (1.15): Merge from V1_STABLE branch
2007-07-26 19:15 y-asaba
* child.c (1.10), pool.h (1.11), pool_connection_pool.c (1.9,
V2_0_1, V2_0_0, V2_0_0_BETA1): SIGALRM handler didn't safe.
Because it called non-reentrant functions. We only set a flag in
SIGALRM handler. Then we close expired connections in safe places.
2007-07-26 14:15 y-asaba
* pool_connection_pool.c (1.8): Fix memory leak when connection
slot is full.
2007-07-26 11:28 t-ishii
* aclocal.m4 (1.9), configure (1.13), pool_config.c (1.9): Run
autoconf
2007-07-26 11:21 y-asaba
* pool_config.l (1.6): Fix using uninitialized value.
2007-07-25 21:31 y-asaba
* pool_process_query.c (1.36): Fix hang up and SEGV if Parse
message contains a warning statement.
SELECT '\'';
WARNING: nonstandard use of \' in a string literal
If pgpool receives a warning message that is NoticeMessage('N')
under the extended query protocol, it reads a next message.
2007-07-24 18:02 y-asaba
* pool.h (1.10), pool_process_query.c (1.35): Detect deadlock in
do_command(). When insert_lock was true, kind mismatch error
occured.
2007-07-23 14:32 y-asaba
* pool_process_query.c (1.34): Fixed that
start_internal_transaction() was only called under replication mode
or parallel mode.
2007-07-23 14:24 y-asaba
* main.c (1.15): Remove debug code.
2007-07-23 13:37 y-asaba
* child.c (1.9), main.c (1.14), pool.h (1.9), pool_config.c (1.8),
pool_config.l (1.5), pool_process_query.c (1.33), pool_type.h
(1.6): Add reloading config files. pgpool can reload pgpool.conf,
pool_hba.conf and distributed rules from system DB. If reload, you
type the following command.
% pgpool reload
Or you send SIGHUP signal to the pgpool parent process.
2007-07-17 15:04 y-asaba
* pool_process_query.c (1.32): Fix hang up when backend node did
fast or immediate shutdown.
If shutdown occured, postgres send an error which error code is
"57P01" and error message is "terminating connection due to
administrator command".
However, another nodes did not send any messages. pgpool waited for
a message from them. when the error is sended, pgpool reads the
message and degenerate.
2007-07-17 11:33 y-asaba
* pool_process_query.c (1.31, ROOT_OF_V2_0_PARALLEL_UNSTABLE):
Rearrange detect_deadlock_error().
2007-07-10 18:56 y-asaba
* main.c (1.13, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.8,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.30),
pool_stream.c (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE):
* Change type of InRecovery variable to sig_atomic_t*
* Fixed kind mismatch error when deadlock error occured. The
problem is the following senario.
A: BEGIN:
B: BEGIN;
A: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE;
B: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE;
A: LOCK TABLE t2 IN SHARE ROW EXCLUSIVE MODE;
B: LOCK TABLE t1 IN SHARE ROW EXCLUSIVE MODE;
Transaction "A" aborts on master node, but it completes on another
nodes. It causes wrong failover.
So pgpool checks deadlock error(code == '40P01') and sends error
query to another nodes.
2007-07-09 14:18 y-asaba
* main.c (1.12): Add comments.
2007-07-09 13:23 y-asaba
* main.c (1.11): Fix race condition between flag checking and
signal blocking.
Normally, this case solve to call pselect(2). But Linux's pselect(2)
is emulated by select(2) and sigprocmask(2). It contains this race.
So pgpool archieves using the self-pipe trick.
See 'man pselect' if you want to get more information.
2007-07-09 10:29 y-asaba
* config.guess (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE), config.h.in (1.4,
V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
configure (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), configure.in
(1.11, ROOT_OF_V2_0_PARALLEL_UNSTABLE), ltmain.sh (1.2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4 (1.8,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), child.c (1.8,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp_child.c (1.6,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_connection_pool.c (1.7,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool_process_query.c (1.29),
pool_query_cache.c (1.6, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
pool_stream.c (1.3): configure checks that OS has sys/select.h.
If it exists, include it.
2007-07-06 17:32 y-asaba
* child.c (1.7), pool_process_query.c (1.28), pool_type.h (1.5,
ROOT_OF_V2_0_PARALLEL_UNSTABLE): Load balancing node was chosen
before sending "SELECT" statement. But this way had the following
problems.
psql>\d accounts
Did not find any relation with OID XXX
pgpool chooses it after receiving AuthenticationOK('R') message. So
pgpool load balance to the same node inside a same session.
2007-07-05 18:12 y-asaba
* main.c (1.10): Improve signal handling.
We fixed signal handling at revision 1.6. That fix was to set a flag
in signal handler, then pgpool checked flags in safe points. However
It has a race condition in the following case.
CHECK_REQUEST; <-- check flags
<signal handler> <-- set flags
pause(); <-- wait for signals
So, we modified to deliver signals in safe places which are in
pause() and sleep().
2007-07-05 11:14 y-asaba
* pool_process_query.c (1.27):
* Remove debug code.
* Refactor ReadyForQuery() and do_command().
2007-07-04 17:18 y-asaba
* pool_process_query.c (1.26): In replication mode, pgpool checks
the numbers of insert/update/delete tuples in CommandComplete
message. If these numbers are not same, a transaction is aborted by
pgpool. It is for data consistency.
TODO: This behavior will be able to switch by pgpool.conf.
2007-07-03 18:23 y-asaba
* TODO (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Rearrange TODO list.
2007-06-29 23:15 y-asaba
* main.c (1.9): Fix race condition between unsetting SIGCHLD flag
and unblocking SIGCHLD signal.
2007-06-28 21:35 y-asaba
* main.c (1.8): Fix SIGUSR2 handling. The signal handler only set
flag. Then, pgpool call SIGUSR2 handler in CHECK_REQUEST macro.
2007-06-27 18:29 y-asaba
* ChangeLog (1.18, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h (1.7),
pool_process_query.c (1.25): Fix hang up when a SELECT query has
error inside transaction block. It occurs only in simple query
protocol.
2007-06-27 18:04 y-asaba
* sample/pgpool_remote_start (1.2, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE):
Fix checking the number of arguments.
2007-06-26 10:35 y-asaba
* pcp_child.c (1.5): Remove unused variable.
2007-06-22 19:10 t-ishii
* Makefile.in (1.12, ROOT_OF_V2_0_PARALLEL_UNSTABLE), aclocal.m4
(1.7), configure (1.11), parser/Makefile.in (1.8,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c (1.4,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.8,
ROOT_OF_V2_0_PARALLEL_UNSTABLE): run autoconf and flex
2007-06-22 18:50 y-asaba
* Makefile.am (1.9, ROOT_OF_V2_0_PARALLEL_UNSTABLE), Makefile.in
(1.11), aclocal.m4 (1.6), child.c (1.6), configure (1.10),
configure.in (1.10), main.c (1.7), pcp_child.c (1.4),
pgpool.conf.sample (1.5, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pool.h
(1.6), pool_config.c (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
pool_config.l (1.4, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
pool_process_query.c (1.24), pool_type.h (1.4), recovery.c (1.1,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html (1.14,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/Makefile.in (1.7),
pcp/Makefile.am (1.2, V2_0_0_BETA1,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/Makefile.in (1.7), pcp/pcp.c
(1.3, ROOT_OF_V2_0_PARALLEL_UNSTABLE), pcp/pcp.h (1.2, V2_0_1,
V2_0_0, V2_0_0_BETA1, ROOT_OF_V2_0_PARALLEL_UNSTABLE),
pcp/pcp_recovery_node.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_recovery (1.1,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), sample/pgpool_remote_start
(1.1), sql/pgpool-recovery/Makefile (1.1, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1), sql/pgpool-recovery/pgpool-recovery.c (1.1),
sql/pgpool-recovery/pgpool-recovery.sql.in (1.1): Add new
features in pgpool-II 2.0.
* support online-recovery in replication mode.
- based on physical data copy
* improve replication mode.
- employ "primary copy method" to enhance the performance
- more stable replication
2007-06-21 10:17 y-asaba
* ChangeLog (1.17): update ChangeLog.
2007-06-20 18:09 y-asaba
* main.c (1.6): Fix SIGCHLD and SIGUSR1 signal handling. Signal
handlers set flags only, then a parent process checks flags in
signal safe places.
2007-06-20 17:14 t-ishii
* pool_config.c (1.6), parser/gram.c (1.3, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/gram.h (1.3, V1_3,
V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE), parser/scan.c
(1.3, V1_2_1, V1_2): run flex
2007-06-18 11:40 y-asaba
* pool_process_query.c (1.23): Fix memory leak in
NotificationResponse().
2007-06-18 11:37 y-asaba
* ChangeLog (1.16): update ChangeLog.
2007-06-18 11:34 y-asaba
* pool_process_query.c (1.22):
* Fix compile warning.
* Fix memory leak in CursorResponse().
2007-06-18 10:33 t-ishii
* Makefile.in (1.10, V1_2_1, V1_2): run autoconf
2007-06-15 22:35 devrim
* pgpool.spec (1.7, ROOT_OF_V2_0_PARALLEL_UNSTABLE): Update spec
file
2007-06-15 12:21 y-asaba
* NEWS (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE), doc/pgpool-ja.html
(1.13) (utags: V1_1_1): Update release note.
2007-06-15 11:57 t-ishii
* configure (1.9, V1_1_1): Run autoconf.
2007-06-15 11:55 t-ishii
* doc/pgpool-ja.html (1.12): Fix typo.
2007-06-14 16:44 y-asaba
* ChangeLog (1.15, V1_1_1): Prepare for 1.1.1
2007-06-12 10:49 y-asaba
* NEWS (1.9): Prepare for 1.1.1
2007-06-11 15:37 y-asaba
* configure.in (1.9, V1_1_1), doc/pgpool-ja.html (1.11): Prepare
for 1.1.1
2007-06-11 12:06 y-asaba
* ChangeLog (1.14): Update ChangeLog.
2007-06-11 12:01 y-asaba
* pool_process_query.c (1.21, V1_1_1): Fix kind mismatch error when
load_balance_mode is true.
2007-06-07 11:38 y-asaba
* pool_process_query.c (1.20): Fix handling nullmap (V2 only).
2007-06-06 17:32 yamaguti
* doc/: pgpool-en.html (1.10, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1), pgpool-ja.html (1.10): added an explanation about
command line option "-a" for HBA file.
2007-06-02 09:54 y-asaba
* pool_process_query.c (1.19): Fix typo EmptyQueryResponse message.
pgpool hung up in EXECUTE command. (Patch contributed by Kenichi
Sawada)
2007-05-29 10:58 y-asaba
* pool_process_query.c (1.18): Fix handling protocol version 2.
2007-05-28 18:13 y-asaba
* pool_process_query.c (1.17): Fix handling protocol version 2.
2007-05-25 12:02 y-asaba
* Makefile.am (1.8, V1_2_1, V1_2), Makefile.in (1.9) (utags: V1_1,
V1_1_1): Fix typo
2007-05-25 11:45 y-asaba
* ChangeLog (1.13, V1_1): Prepare for 1.1
2007-05-25 11:37 y-asaba
* doc/: pgpool-en.html (1.9), pgpool-ja.html (1.9) (utags: V1_1):
Add handling "SELECT nextval".
2007-05-25 11:30 y-asaba
* doc/pgpool-ja.html (1.8): Add Japanese release note for 1.1
2007-05-24 23:27 t-ishii
* Makefile.in (1.8), aclocal.m4 (1.5, V1_3, V1_2_1, V1_2, V1_1_1,
V1_1), configure (1.8, V1_1), parser/Makefile.in (1.6, V1_3,
V1_2_1, V1_2, V1_1_1, V1_1), pcp/Makefile.in (1.6, V1_3, V1_2_1,
V1_2, V1_1_1, V1_1): Resync files generated by configure.in
2007-05-24 23:25 t-ishii
* TODO (1.3, V1_3, V1_2_1, V1_2, V1_1_1, V1_1): update
TODO(Japanese)
2007-05-24 15:42 y-asaba
* NEWS (1.8, V1_1): update NEWS
2007-05-24 15:38 y-asaba
* parser/pool_memory.c (1.6, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), ChangeLog (1.12):
Fix core dump in pool_memory_realloc().
2007-05-23 11:01 yamaguti
* ChangeLog (1.11), NEWS (1.7):
fixed pgpool.pam so it is installed under $PREFIX/share/pgpool-II/
2007-05-23 10:59 yamaguti
* ac_func_accept_argtypes.m4 (1.1, V2_3_3, V2_2_7, V2_3_2_2,
V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3,
V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), pool_hba.c (1.1),
pool_hba.conf.sample (1.1, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1,
V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2,
V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2,
V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1,
V2_0_1, V2_0_0, V2_0_0_BETA1), pool_ip.c (1.1, V2_0_1, V2_0_0,
V2_0_0_BETA1), pool_ip.h (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1),
pool_path.c (1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), pool_path.h
(1.1, V2_0_1, V2_0_0, V2_0_0_BETA1), ps_status.c (1.1, V2_0_1,
V2_0_0, V2_0_0_BETA1), strlcpy.c (1.1, V2_0_1, V2_0_0,
V2_0_0_BETA1) (utags: ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1,
V1_1_1, V1_2, V1_2_1, V1_3):
new files for HBA, ps display, log_hostname & log_connections
2007-05-22 15:28 y-asaba
* pool_process_query.c (1.16, V1_1): Add checking a message length
is valid. (Reported by Fujii Masao)
2007-05-21 14:49 y-asaba
* NEWS (1.6), configure.in (1.8, V1_1), version.h (1.2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Prepare for 1.1
2007-05-21 11:16 yamaguti
* Makefile.am (1.7), Makefile.in (1.7): pgpool.pam and
system_db.sql is now installed under share/pgpool-II/
2007-05-17 15:46 yamaguti
* ChangeLog (1.10), Makefile.am (1.6), Makefile.in (1.6),
aclocal.m4 (1.4), child.c (1.5, V1_1_1, V1_1), config.h.in (1.3,
V1_1_1, V1_1), configure (1.7), configure.in (1.7), main.c (1.5,
V1_1_1, V1_1), pcp_child.c (1.3, V1_3, V1_2_1, V1_2, V1_1_1,
V1_1), pgpool.conf.sample (1.4, V1_1_1, V1_1), pool.h (1.5,
V1_1_1, V1_1), pool_config.c (1.5, V1_1_1, V1_1), pool_config.l
(1.3, V1_1_1, V1_1), pool_process_query.c (1.15),
pool_query_cache.c (1.5, V1_2, V1_1_1, V1_1), pool_type.h (1.3,
V1_1_1, V1_1), doc/pgpool-en.html (1.8), doc/pgpool-ja.html
(1.7), parser/Makefile.in (1.5), parser/gram.c (1.2, V1_1_1,
V1_1), parser/gram.h (1.2, V1_1_1, V1_1), parser/pool_parser.h
(1.2, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1,
V1_1), pcp/Makefile.in (1.5), sample/pgpool.pam (1.1, V2_3_3,
V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1, V2_2_6, V2_3, V2_2_5,
V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0, V2_2_0_RC2, V2_2_0_RC1,
V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0, V2_1_0_RC1, V2_1_0_BETA2,
V2_1_0_BETA1, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1):
* Support HBA authentication.
* Support log_connections
* Support log_hostname
* Support "ps" status display
* Fixed compiler warning in pool_query_cache.c
* sample/pgpool.pam: PAM service configuration file. It will be
installed to "$PREFIX/share/"
* doc/pgpool-ja.html: Added pool_hba description.
* doc/pgpool-en.html: Added pool_hba description.
* Updated ChangeLog
2007-04-26 14:26 y-asaba
* ChangeLog (1.9), pool_connection_pool.c (1.6, V1_1_1, V1_1):
Retry connect() when it is interrupted by signal.
2007-04-20 16:18 y-asaba
* ChangeLog (1.8): Add entry.
2007-04-20 15:41 y-asaba
* pool_process_query.c (1.14): Enhance that the query that begins
with "SELECT nextval()" or "SELECT setval()" are always replicated
under replication mode.
Then, SELECT statements are only executed by MASTER node if
load_balance_mode is false. If need to replicate select statement,
add a comment in the begining of the query.
Example:
SELECT foo() -> /*REPLICATION*/ SELECT foo()
2007-04-15 20:26 t-ishii
* pool_process_query.c (1.13): Fix read_kind_from_backend(). It
calls notice_backend_error() with fixed db node number 1. Make it
the db node which returns different packet kind from master.
2007-04-12 17:30 devrim
* pool_process_query.c (1.12): Patch to surpress compiler warnings,
per Ralf Corsepius
2007-03-01 13:06 y-asaba
* ChangeLog (1.7), pool_process_query.c (1.11): Support load
balancing with extended protocol. (Parallel query isn't supported
extended protocol yet.)
2007-03-01 12:03 y-asaba
* ChangeLog (1.6), parser/Makefile.am (1.2, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1), parser/copyfuncs.c
(1.1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1,
V1_1): Porting deep copy functions for tree nodes from
PostgreSQL.
2007-02-28 20:04 y-asaba
* ChangeLog (1.5): Add ChangeLog entry.
2007-02-28 19:44 y-asaba
* Makefile.am (1.5): Fix link error on Solaris. Solaris's ld does
not have --rpath option. So it uses libtool's -rpath option instead
of ld's option.
2007-02-21 04:38 devrim
* pgpool.spec (1.6, V1_1_1, V1_1): Fixes from Jarod Wilson
<jwilson@redhat.com>
- Create proper devel package, drop -libs package
- Nuke rpath
- Don't install libtool archive and static lib
- Clean up %%configure line
- Use proper %%_smp_mflags
- Install config files properly, without .sample on the end
- Preserve timestamps on header files
2007-02-20 18:20 devrim
* pgpool.spec (1.5):
- Update to 1.0.2-1
- Fix various build problems and prepared for Fedora Submission
----------------------------------------------------------------------
2007-02-20 15:02 devrim
* pgpool.conf.sample (1.3): Update header so that we can see that
it is pgpool-II conf file (I was confused after removing pgpool and
installing pgpool-II :) )
2007-02-16 22:56 t-ishii
* Makefile.in (1.5), configure (1.6), parser/Makefile.in (1.4),
pcp/Makefile.in (1.4): automake & autoconf
2007-02-16 20:31 y-asaba
* ChangeLog (1.4), Makefile.am (1.4), configure.in (1.6),
pool_connection_pool.c (1.5), pool_query_cache.c (1.4), pcp/pcp.c
(1.2, V1_2, V1_1_1, V1_1), pcp/pcp_stream.c (1.2, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1): Fixed compile
error on MacOS X. MacOS's ld does not have rpath option. So add
--disable-rpath option to configure for MacOS X.
2007-02-13 12:44 y-asaba
* ChangeLog (1.3, V1_0_2):
* Add entries using cvs2cl.
2007-02-12 16:23 y-asaba
* doc/pgpool-ja.html (1.6, V1_0_2): Add release note.
2007-02-12 15:51 y-asaba
* doc/pgpool-ja.html (1.5): Add Japanese release note into
pgpool-ja.html.
2007-02-12 11:32 y-asaba
* child.c (1.4), pool.h (1.4), pool_connection_pool.c (1.4) (utags:
V1_0_2): pgpool *only* checks backend connection when connection
pool is reused.
2007-02-09 12:54 y-asaba
* NEWS (1.5, V1_0_2): fix indent.
2007-02-09 12:50 y-asaba
* NEWS (1.4): Remove '\000'.
2007-02-08 22:08 t-ishii
* doc/pgpool-en.html (1.7, V1_0_2): prepare for 1.0.2
2007-02-08 21:52 t-ishii
* NEWS (1.3), config.h.in (1.2, V1_0_2), configure (1.5, V1_0_2):
Prepare for 1.0.2
2007-02-08 17:56 y-asaba
* doc/pgpool-ja.html (1.4): Add new loadbalancing rule in
replication mode section.
2007-02-08 17:34 y-asaba
* pool_query_cache.c (1.3), configure.in (1.5), pool_system.c (1.3,
V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1)
(utags: V1_0_2): Fixed configure error if libpq version is 7.4.x.
7.4 does not have PQprepare(). So when version is 7.4, pgpool uses
PREPARE statement instead of PQprepare().
2007-02-08 00:44 y-asaba
* configure.in (1.4): Prepare for 1.0.2
2007-02-07 19:08 t-ishii
* Makefile.in (1.4, V1_0_2), aclocal.m4 (1.3, V1_0_2), configure
(1.4), configure.in (1.3), pool_config.c (1.4, V1_0_2),
parser/Makefile.in (1.3, V1_0_2), pcp/Makefile.in (1.3, V1_0_2):
update configure.in to use pg_config. Patch made by Yoshiyuki
Asaba.
2007-02-06 11:46 y-asaba
* pool_connection_pool.c (1.3): Add checking socket state when
connection pool is reused. If socket is closed, pgpool try to
create new connection pool.
2007-01-30 11:25 y-asaba
* pool_process_query.c (1.10, V1_0_2): Disable to load balance in
the following cases.
- SELECT FOR UPDATE
- SELECT INTO
- /* xxx */ SELECT ... (This is pgpool-I spec.)
2007-01-13 23:56 yamaguti
* pool_signal.h (1.3, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2):
fixed #ifndef ~ #define macro for that it could have been included
redundantly.
2007-01-10 04:02 y-asaba
* pool_process_query.c (1.9): Fix auto-deallocation. If a client
used PDO interface, pgpool didn't clean prepared statement.
2007-01-05 02:27 devrim
* COPYING (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), child.c
(1.3), main.c (1.4, V1_0_2), pcp_child.c (1.2, V1_0_2),
pgpool.8.in (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2), pool.h
(1.3), pool_auth.c (1.3, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
pool_config.c (1.3), pool_config.l (1.2, V1_0_2),
pool_connection_pool.c (1.2), pool_error.c (1.2, V2_0_1, V2_0_0,
V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1, V1_1, V1_0_2), pool_ipc.h (1.2, V2_0_1, V2_0_0,
V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1, V1_1, V1_0_2), pool_params.c (1.2, V2_0_1, V2_0_0,
V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1, V1_1, V1_0_2), pool_process_query.c (1.8),
pool_query_cache.c (1.2), pool_rewrite_query.c (1.3, V1_3,
V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1,
V1_0_2), pool_rewrite_query.h (1.2, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
pool_sema.c (1.2, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
pool_shmem.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
pool_signal.c (1.2, V2_0_1, V2_0_0, V2_0_0_BETA1, V1_3, V1_2_1,
V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
pool_signal.h (1.2), pool_stream.c (1.2, V1_1_1, V1_1, V1_0_2),
pool_system.c (1.2), pool_type.h (1.2, V1_0_2),
parser/pool_memory.c (1.5, V1_0_2), parser/pool_memory.h (1.2,
V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1,
V1_0_2), parser/pool_string.c (1.2, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2),
parser/pool_string.h (1.2, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2): Copyright
update
2006-12-25 19:14 y-asaba
* Makefile.am (1.3, V1_0_2), Makefile.in (1.3): Fix libpq link
error (Reported by ISHIDA Akio).
2006-12-04 14:49 t-ishii
* pool_process_query.c (1.7): Fix bug with replication mode. With
UPDATE/DELETE, the number of affcted rows should not be sum of each
node.
2006-12-02 22:41 t-ishii
* pool_process_query.c (1.6): Add backend status info to show
pool_status
2006-12-02 22:40 t-ishii
* main.c (1.3): enhance logging to make it clear what kind of
failover/failback event ocuured.
2006-12-02 22:38 t-ishii
* TODO (1.2, V1_0_2): update TODO document to reflect current
status
2006-11-30 07:33 devrim
* child.c (1.2), pool_auth.c (1.2): Fix small typos in messages
2006-11-30 06:54 devrim
* pgpool.conf.sample (1.2, V1_0_2): Fix small typos in config file
2006-11-15 18:30 y-asaba
* pool_process_query.c (1.5): Fix an extended query protocol
handling.
2006-11-13 14:02 y-asaba
* parser/pool_memory.c (1.4): Fix SIGSEGV under parallel mode.
2006-11-10 12:48 y-asaba
* parser/pool_memory.c (1.3):
* Add NULL checking in pool_memory_free().
* Fix SIGSEGV in pool_memory_alloc() if allocate size is 8192 byte.
void *x;
pool_memory = pool_memory_create();
x = pool_memory_alloc(pool_memory, 8192);
2006-11-04 16:38 y-asaba
* parser/pool_memory.c (1.2): Fixed a inifinite loop in
pool_memory_free().
2006-10-04 14:57 y-asaba
* pool_rewrite_query.c (1.2): Fix rewriting a query which refers
pg_catalog. Patch contributed by Yoshiharu Mori.
2006-10-04 04:31 devrim
* pgpool.spec (1.4, V1_0_2):
- Added -libs and -devel RPM
- Fix .so link problem
- Cosmetic changes to spec file
2006-10-04 04:29 devrim
* pgpool.spec (1.3): [no log message]
2006-09-27 14:45 devrim
* pgpool.spec (1.2):
* Thu Sep 27 2006 - Devrim GUNDUZ <devrim@commandprompt.com> 1.0.1-3
- Fix spec, per Yoshiyuki Asaba
* Thu Sep 26 2006 - Devrim GUNDUZ <devrim@commandprompt.com> 1.0.1-2
- Fixed rpmlint errors
- Fixed download url
- Added ldconfig for .so files
** Thu Sep 21 2006 - David Fetter <david@fetter.org> 1.0.1-1
- Initial build pgpool-II 1.0.1 for PgPool Global Development Group
2006-09-27 11:14 y-asaba
* pool_process_query.c (1.4): Fix load balancing algorithm. Patch
contributed by Jeff Davis.
See the following URL for more details.
http://pgfoundry.org/pipermail/pgpool-hackers/2006-September/000034.html
2006-09-25 12:03 y-asaba
* doc/: pgpool-en.html (1.6), pgpool-ja.html (1.3): Add pam
authentication in supported authentication protocol list. Reported
by Jeff Davis.
2006-09-22 15:04 t-ishii
* Makefile.am (1.2), Makefile.in (1.2), aclocal.m4 (1.2), configure
(1.3), pool_config.c (1.2), parser/Makefile.in (1.2),
parser/scan.c (1.2, V1_1_1, V1_1, V1_0_2), pcp/Makefile.in (1.2)
(utags: V1_0_1): Update Makefile.am to reflect the fact that some
doc names have been changed.
2006-09-22 14:39 t-ishii
* ChangeLog (1.2, V1_0_1), NEWS (1.2, V1_0_1), configure (1.2),
configure.in (1.2, V1_0_1): Version 1.0.1
2006-09-15 15:06 y-asaba
* doc/pgpool-ja.html (1.2, V1_0_1): A restriction of extended
protocol is *only* in parallel mode. Fixed the description.
2006-09-14 11:04 t-ishii
* pool.h (1.2, V1_0_1): Fix NUM_BACKENDS macro when operated in
MASTER_SLAVE mode. See following message for more details.
Subject: [Pgpool-general] pgpool-II master/slave mode, BackendError
From: Jeff Davis <pgpool@j-davis.com> To:
pgpool-general@pgfoundry.org Date: Tue, 12 Sep 2006 16:48:49 -0700
2006-09-14 11:00 t-ishii
* pool_process_query.c (1.3, V1_0_1): Fix debug message in
simpleQuery() so that it correctly prints query string when operated
in MASTER_SLAVE mode.
2006-09-14 10:56 t-ishii
* main.c (1.2, V1_0_1): enhance health check error messages
2006-09-13 19:21 y-asaba
* pool_process_query.c (1.2): Fix kind mismatch error in COPY FROM
STDIN.
2006-09-11 23:50 y-asaba
* doc/pgpool-en.html (1.5, V1_0_1): Remove multibyte character.
2006-09-11 15:47 y-asaba
* doc/tutorial-ja.html (1.1, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
Rename `tutorial.html' to `tutorial-ja.html'.
2006-09-11 15:42 y-asaba
* README.euc_jp (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2,
V2_3_1, V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1,
V2_2_0, V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1,
V2_1_0, V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1, V1_1, V1_0_2, V1_0_1), doc/pgpool-ja.html (1.1):
* Rename `doc/pgpool.html' to `doc/pgpool-ja.html'.
* Merge Devrim's patch.
2006-09-11 15:32 y-asaba
* doc/pgpool-en.html (1.4): Remove Japanese comment.
2006-09-11 15:13 y-asaba
* doc/tutorial-en.html (1.2, V2_0_0_BETA1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
Remove Japanese characters.
2006-09-11 14:53 y-asaba
* README (1.2, V2_3_3, V2_2_7, V2_3_2_2, V2_3_2_1, V2_3_2, V2_3_1,
V2_2_6, V2_3, V2_2_5, V2_2_4, V2_2_3, V2_2_2, V2_2_1, V2_2_0,
V2_2_0_RC2, V2_2_0_RC1, V2_2_0_BETA2, V2_2_0_BETA1, V2_1_0,
V2_1_0_RC1, V2_1_0_BETA2, V2_1_0_BETA1, V2_0_1, V2_0_0,
V2_0_0_BETA1, V1_3, V1_2_1, V1_2, ROOT_OF_V2_0_PARALLEL_UNSTABLE,
V1_1_1, V1_1, V1_0_2, V1_0_1): Update README.
2006-09-08 21:01 devrim
* doc/pgpool-en.html (1.3): Far better look for HTML page, suitable
for web and local browsing.
2006-09-08 20:09 devrim
* doc/pgpool-en.html (1.2): comment last modified line for a better
look
2006-09-08 20:05 devrim
* doc/pgpool.css (1.1, V1_3, V1_2_1, V1_2,
ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_1_1, V1_1, V1_0_2, V1_0_1):
Add pgpool.css for readme files. This is the same stylesheet that we
use in pgpool page.
2006-09-08 19:16 devrim
* doc/: pgpool-en.html (1.1), tutorial-en.html (1.1):
Renamed files so that some browsers won't complain.
2006-09-08 12:35 t-ishii
* README (1.1), configure.in (1.1), Makefile.am (1.1), aclocal.m4
(1.1), Makefile.in (1.1), config.h.in (1.1), configure (1.1),
COPYING (1.1), ChangeLog (1.1), NEWS (1.1), TODO (1.1),
config.guess (1.1), config.sub (1.1), ltmain.sh (1.1), pg_md5.c
(1.1), pool_config.c (1.1), README.euc_jp (1.1), main.c (1.1),
md5.c (1.1), pgpool.conf.sample (1.1), pgpool.spec (1.1), pool.h
(1.1), pool_type.h (1.1), version.h (1.1), child.c (1.1),
pool_auth.c (1.1), pool_config.l (1.1), pool_error.c (1.1),
pool_connection_pool.c (1.1), pool_params.c (1.1),
pool_process_query.c (1.1), pool_signal.c (1.1), pool_signal.h
(1.1), pool_stream.c (1.1), pcp_child.c (1.1), pool_ipc.h (1.1),
pool_sema.c (1.1), pool_shmem.c (1.1), pool_system.c (1.1),
pool_rewrite_query.c (1.1), pool_rewrite_query.h (1.1),
pool_rewrite_outfuncs.c (1.1), pgpool.8.in (1.1),
pool_query_cache.c (1.1), parser/Makefile.am (1.1),
parser/Makefile.in (1.1), sql/system_db.sql (1.1), parser/gram.c
(1.1), parser/gram.h (1.1), parser/gram.y (1.1),
parser/gramparse.h (1.1), parser/list.c (1.1), parser/makefuncs.c
(1.1), parser/makefuncs.h (1.1), parser/memnodes.h (1.1),
parser/nodes.c (1.1), parser/nodes.h (1.1), parser/parsenodes.h
(1.1), parser/parser.c (1.1), parser/parser.h (1.1),
parser/pg_list.h (1.1), parser/pool_memory.c (1.1),
parser/pool_memory.h (1.1), parser/pool_string.c (1.1),
parser/pool_string.h (1.1), parser/keywords.c (1.1),
parser/keywords.h (1.1), parser/pool_parser.h (1.1),
parser/primnodes.h (1.1), parser/scansup.h (1.1), parser/value.c
(1.1), parser/value.h (1.1), parser/outfuncs.c (1.1),
parser/scan.c (1.1), parser/scan.l (1.1), pcp/Makefile.am (1.1),
pcp/Makefile.in (1.1), pcp/pcp.h (1.1), pcp/md5.c (1.1),
pcp/pcp.c (1.1), pcp/pcp_attach_node.c (1.1),
pcp/pcp_detach_node.c (1.1), pcp/pcp_error.c (1.1),
pcp/pcp_node_count.c (1.1), pcp/pcp_stream.c (1.1),
pcp/pcp_stream.h (1.1), pcp/pcp_node_info.c (1.1),
pcp/pcp_proc_count.c (1.1), pcp/pcp_proc_info.c (1.1),
pcp/pcp_stop_pgpool.c (1.1), pcp/pcp_systemdb_info.c (1.1):
Initial revision
2006-09-08 12:35 t-ishii
* AUTHORS (1.1.1.1), INSTALL (1.1.1.1), depcomp (1.1.1.1),
install-sh (1.1.1.1), missing (1.1.1.1), mkinstalldirs (1.1.1.1),
md5.h (1.1.1.1), pcp.conf.sample (1.1.1.1),
sample/dist_def_pgbench.sql (1.1.1.1), pcp/md5.h (1.1.1.1)
(utags: ROOT_OF_V2_0_PARALLEL_UNSTABLE, V1_0_0, V1_0_1, V1_0_2,
V1_1, V1_1_1, V1_2, V1_2_1, V1_3, V2_0_0, V2_0_0_BETA1, V2_0_1,
V2_1_0, V2_1_0_BETA1, V2_1_0_BETA2, V2_1_0_RC1, V2_2_0,
V2_2_0_BETA1, V2_2_0_BETA2, V2_2_0_RC1, V2_2_0_RC2, V2_2_1,
V2_2_2, V2_2_3, V2_2_4, V2_2_5, V2_2_6, V2_2_7, V2_3, V2_3_1,
V2_3_2, V2_3_2_1, V2_3_2_2, V2_3_3): pgpool-II initial release
