Difference between revisions of "Pgpool-II 4.1 development"

From pgpool Wiki
Jump to: navigation, search
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Last update: 2019/09/05
+
Last update: 2019/10/08
  
 
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
 
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
 +
 +
Red items are open items for Pgpool-II 4.1.
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 335: Line 337:
 
| [https://www.pgpool.net/mantisbt/view.php?id=483 bug483]
 
| [https://www.pgpool.net/mantisbt/view.php?id=483 bug483]
 
| Done [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=c402060814ba9737e9572ba07eef1be7664c9679 commit].
 
| Done [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=c402060814ba9737e9572ba07eef1be7664c9679 commit].
|-style="background:white"
+
|-style="background:silver"
 
| 112
 
| 112
 
| Fix memory leak related to watchdog and auth pointed out by coverity
 
| Fix memory leak related to watchdog and auth pointed out by coverity
Line 344: Line 346:
 
| Usama
 
| Usama
 
| src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c
 
| src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c
|  
+
| Done
|-style="background:white"
+
|-style="background:silver"
 
| 113
 
| 113
 
| Fix memory leak related to watchdog and auth pointed out by coverity
 
| Fix memory leak related to watchdog and auth pointed out by coverity
Line 365: Line 367:
 
|  
 
|  
 
| Requested log sent [https://www.pgpool.net/pipermail/pgpool-general/2019-September/006753.html pgpool-general: 6695]
 
| Requested log sent [https://www.pgpool.net/pipermail/pgpool-general/2019-September/006753.html pgpool-general: 6695]
|-style="background:white"
+
|-style="background:silver"
 
| 115
 
| 115
 
| regression test 013.watchdog_failover_require_consensus failed
 
| regression test 013.watchdog_failover_require_consensus failed
Line 372: Line 374:
 
|  
 
|  
 
|  
 
|  
| Usama
+
| Ishii
 
|  
 
|  
 
|  
 
|  
|-style="background:white"
+
|-style="background:red"
 
| 116
 
| 116
| Doc:Pgpool-II + Watchdog Setup Example
+
| Doc:Pgpool-II + Watchdog Setup Example (for PostgreSQL 12)
 
| 2019/09/03
 
| 2019/09/03
 
|  
 
|  
Line 385: Line 387:
 
|  
 
|  
 
|
 
|
|-style="background:white"
+
|-style="background:silver"
 +
| 117
 +
| regression test 028. 028.watchdog_enable_consensus_with_half_votes failed
 +
| 2019/09/13
 +
| 2019/09/18
 +
|
 +
|
 +
| Ishii
 +
|
 +
|
 +
|-style="background:silver"
 +
| 118
 +
| 0000545: Quorum lost and not recovered
 +
| 2019/09/09
 +
|
 +
|
 +
|
 +
| Usama
 +
| https://www.pgpool.net/mantisbt/view.php?id=545
 +
|
 +
|-style="background:red"
 +
| 119
 +
| 0000547: We need to do arping again after recovering from split-brain.
 +
| 2019/09/12
 +
|
 +
|
 +
|
 +
| Usama
 +
| https://www.pgpool.net/mantisbt/view.php?id=547
 +
|
 +
|-style="background:silver"
 +
| 120
 +
| regression test 065.bug152 failed if enable_shared_relcache is on
 +
| 2019/10/02
 +
|
 +
|
 +
|
 +
| Hoshiai
 +
|
 +
|
 +
|-style="background:silver"
 
| 201
 
| 201
 
| Feature Agreement  
 
| Feature Agreement  
Line 395: Line 437:
 
|
 
|
 
|  
 
|  
|-style="background:white"
+
|-style="background:silver"
 
| 202
 
| 202
 
| Feature Freeze  
 
| Feature Freeze  
Line 405: Line 447:
 
|
 
|
 
|  
 
|  
|-style="background:white"
+
|-style="background:silver"
 
| 203
 
| 203
 
| Code Freeze  
 
| Code Freeze  
Line 416: Line 458:
 
|
 
|
 
|
 
|
|-style="background:white"
+
|-style="background:silver"
 
| 204
 
| 204
 
| Release beta1
 
| Release beta1
Line 429: Line 471:
 
|-style="background:white"
 
|-style="background:white"
 
| 205
 
| 205
 +
| RC Release
 +
|
 +
| 2019/10/11
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-style="background:white"
 +
| 206
 
| Official Release
 
| Official Release
 
|  
 
|  
| 2019/10/04
+
| 2019/10/15
 
|  
 
|  
 
|  
 
|  

Latest revision as of 08:11, 8 October 2019

Last update: 2019/10/08

Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.

Red items are open items for Pgpool-II 4.1.

ID Registered/start Date Target Date Priority Implementation Person in charge Overview Status
007 [FEATURE] shared relation cache 2018/11/20 2019/02/29 High Large Hoshiai [pgpool-hackers: 3124] Done. commit
008 [FEATURE] Enhance performance: performance regression test 2018/11/20 High Small Usama
[FEATURE] Enhance performance: performance for simple query (especially for of the large

INSERT and UPDATE statements)

2018/11/20 XLarge Usama Done. commit
[FEATURE] Enhance performance: performance for extended query 2019/01/17 Ishii (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): commit

(2) Enhance performance for extended query message:
[pgpool-hackers: 3230] commit
(3) Eliminate select(2) calls in certain cases to enhance performance in simple and extended query:
[pgpool-hackers: 3247] commit

009 [Documentation] Review and improve the current document 2018/11/20 High Extra Large Hoshiai commit1commit2commit3

commit4 commit5 commit6

[Documentation] Update the examples to latest version. 2018/11/20 High Peng Done. commit doc commit
010 [FEATURE] Master watchdog sets quarantine state to primary node 2018/11/26 Normal Small Usama [pgpool-hackers: 2756]
[pgpool-general-jp: 1504]
Done. Commit
011 [FEATURE] limiting number of frontends differently 2018/11/26 2018/12/04 Ishii [pgpool-hackers: 3153] Done. commit
012 [FEATURE] Don't load balance after a SELECT having functions specified in black function list 2018/11/29 2019/06/30 Normal Small Peng [pgpool-hackers: 3157] Done. commit
014 [FEATURE] Support for PostgreSQL 12. 2018/11/29 High Small Ishii recovery.conf
pgpool_setup
pgppol-recovery extension
Done. pgpool-recovery extension
pgpool_setup
015 [FEATURE] Import PostgreSQL 12 parser. 2018/11/29 2019/07/31 High Medium Peng Done. commit
016 [FEATURE] Statement level load balancing 2018/12/06 2019/03/31 High Large Peng Done. commit
018 [FEATURE] Add new columns to "show pool_nodes" command 2019/04/22 2019/04/24 High Medium Ishii Discussion: [pgpool-hackers: 3315] Done. Commit
019 [FEATURE][Document] Add new performance section High Medium Ishii Done. commit
020 [FEATURE] auto failback 2019/5/23 2019/7/5 Medium Hoshiai [pgpool-hackers: 3328] Done. commit
021 [FEATURE] allow to use md5 password in health_check_password and sr_check_password 2019/5/30 2019/6/10 Medium Ishii [pgpool-hackers: 3334] Done. commit
022 [FEATURE] Routing relcache queries to load balance node Medium Ishii [pgpool-hackers: 3342] Done. commit
023 [FEATURE] Support ECDH key exchange with SSL Medium Hoshiai Done. commit1 commit2
024 [FEATURE] Reduce relcahe queries Medium Ishii [pgpool-hackers: 3344] Done. commit
025 [FEATURE] Eliminate temp table relcahe query Medium Ishii [pgpool-hackers: 3346] Done. commit
026 [FEATURE] Add new arguments in pgpool_recovery function and failover_command/failback_command/follow_master_command. Small Peng Done. commit
101 0000433: IN (SELECT ...) can not be rewritten in native replication mode 2018/10/19 Peng bug433 Done. commit
Regression test should be added.
102 0000434: Segmentation fault due to a query error and Sync messages in native replication mode 2018/10/19 Hoshiai bug434 Done. commit
103 pool_passwd is corrupted. 2018/10/22 Hoshiai, Usama [pgpool-hackers: 3081] Done. commit
104 [pgpool-hackers: 3025] Compile warns 2018/10/22 Hoshiai [pgpool-hackers: 3025] Done. commit
105 0000443: Segmentation fault occurs when a certain Bind message is sent in native replication mode. 2018/11/08 Peng bug443 Done. commit
106 0000444: pgpool does not take into account parameters order in startup packet 2018/11/13 Hoshiai bug444 Done. commit
107 0000448: pgpool holds the connections as idle_in_transaction which are timed out due to idle_in_transaction setting on backend nodes 2018/11/29 Ishii bug448 Done. commit
108 [pgpool-general: 6351] kind mismatch among backends, savepoint with psqlodbc 2018/12/26 Peng [pgpool-general: 6351]
109 0000455: watchdog lifecheck process has segfalut in query mode 2019/01/21 Usama https://www.pgpool.net/mantisbt/view.php?id=455 Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=4cde5da1b416d909d102cfe6878c0cd5189caf86
110 Add regression test for query mode 2019/01/21 Peng
111 0000483: online-recovery is blocked after a child process exits abnormally with replication mode and watchdog 2019/04/04 Usama bug483 Done commit.
112 Fix memory leak related to watchdog and auth pointed out by coverity 2019/05/22 Usama src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c Done
113 Fix memory leak related to watchdog and auth pointed out by coverity 2019/05/22 ishii other than :src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c
114 pgpool-general: 6672 Query (watchdog split brain) 2019/08/16 Usama Requested log sent pgpool-general: 6695
115 regression test 013.watchdog_failover_require_consensus failed 2019/08/14 Ishii
116 Doc:Pgpool-II + Watchdog Setup Example (for PostgreSQL 12) 2019/09/03 Peng
117 regression test 028. 028.watchdog_enable_consensus_with_half_votes failed 2019/09/13 2019/09/18 Ishii
118 0000545: Quorum lost and not recovered 2019/09/09 Usama https://www.pgpool.net/mantisbt/view.php?id=545
119 0000547: We need to do arping again after recovering from split-brain. 2019/09/12 Usama https://www.pgpool.net/mantisbt/view.php?id=547
120 regression test 065.bug152 failed if enable_shared_relcache is on 2019/10/02 Hoshiai
201 Feature Agreement
202 Feature Freeze 2019/08/15
203 Code Freeze 2019/08/31
204 Release beta1 2019/09/06
205 RC Release 2019/10/11
206 Official Release 2019/10/15