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