Difference between revisions of "Pgpool-II 4.1 development"

From pgpool Wiki
Jump to: navigation, search
Line 1: Line 1:
Last update: 2019/06/24
+
Last update: 2019/06/25
  
 
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.
Line 71: Line 71:
 
|  
 
|  
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0c9f716714dce156fe74469a933046b39896a072 commit] [http://www.pgpool.net/docs/latest/en/html/example-cluster.html doc]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0c9f716714dce156fe74469a933046b39896a072 commit] [http://www.pgpool.net/docs/latest/en/html/example-cluster.html doc]
|-style="background:beige"
+
|-style="background:orange"
 
| 010
 
| 010
 
| [FEATURE] Master watchdog sets quarantine state to primary node
 
| [FEATURE] Master watchdog sets quarantine state to primary node
Line 81: Line 81:
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002756.html [pgpool-hackers: 2756]] <br>[https://www.pgpool.net/pipermail/pgpool-general-jp/2018-March/001503.html [pgpool-general-jp: 1504]]
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002756.html [pgpool-hackers: 2756]] <br>[https://www.pgpool.net/pipermail/pgpool-general-jp/2018-March/001503.html [pgpool-general-jp: 1504]]
 
|  
 
|  
|-style="background:silver"
+
|-style="background:orange"
 
| 011
 
| 011
 
| [FEATURE] limiting number of frontends differently
 
| [FEATURE] limiting number of frontends differently
Line 91: Line 91:
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-November/003153.html [pgpool-hackers: 3153]]
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-November/003153.html [pgpool-hackers: 3153]]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc commit]
|-style="background:beige"
+
|-style="background:orange"
 
| 012  
 
| 012  
 
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list
 
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list
Line 101: Line 101:
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003157.html [pgpool-hackers: 3157]]
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003157.html [pgpool-hackers: 3157]]
 
| Implementation is done. TODO: Test & Doc.
 
| Implementation is done. TODO: Test & Doc.
|-style="background:beige"
+
|-style="background:orange"
| 013
 
| [FEATURE] Support for LDAP authentication
 
| 2018/11/29
 
|
 
| High
 
| Medium
 
| Usama
 
|
 
|
 
|-style="background:silver"
 
 
| 014
 
| 014
 
| [FEATURE] Support for PostgreSQL 12.
 
| [FEATURE] Support for PostgreSQL 12.
Line 121: Line 111:
 
| recovery.conf <br> pgpool_setup <br> pgppol-recovery extension
 
| recovery.conf <br> pgpool_setup <br> pgppol-recovery extension
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=fda13a93a1025b498bb2a674fb49406d9e3e509c pgpool-recovery extension] <br> [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=23fb4c1250f0464a867f2ac69006d74f134213e3 pgpool_setup]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=fda13a93a1025b498bb2a674fb49406d9e3e509c pgpool-recovery extension] <br> [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=23fb4c1250f0464a867f2ac69006d74f134213e3 pgpool_setup]
|-style="background:beige"
+
|-style="background:orange"
 
| 015
 
| 015
 
| [FEATURE] Import PostgreSQL 12 parser.
 
| [FEATURE] Import PostgreSQL 12 parser.
Line 131: Line 121:
 
|  
 
|  
 
| Start after PostgreSQL beta release.
 
| Start after PostgreSQL beta release.
|-style="background:silver"
+
|-style="background:orange"
 
| 016
 
| 016
 
| [FEATURE] Statement level load balancing
 
| [FEATURE] Statement level load balancing
Line 141: Line 131:
 
|
 
|
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb commit]
|-style="background:beige"
+
|-style="background:orange"
| 017
 
| [FEATURE] Add IPv6 sppport for Pgpool-II
 
| 2019/01/17
 
|
 
| Low
 
|
 
| Ishii
 
|
 
|
 
|-style="background:silver"
 
 
| 018
 
| 018
 
| [FEATURE] Add new columns to "show pool_nodes" command
 
| [FEATURE] Add new columns to "show pool_nodes" command
Line 161: Line 141:
 
| Discussion: [https://www.pgpool.net/pipermail/pgpool-hackers/2019-April/003315.html [pgpool-hackers: 3315]]
 
| Discussion: [https://www.pgpool.net/pipermail/pgpool-hackers/2019-April/003315.html [pgpool-hackers: 3315]]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35cb1dc2d9d9f4887bd0407f150558660b7826e1 Commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35cb1dc2d9d9f4887bd0407f150558660b7826e1 Commit]
|-style="background:silver"
+
|-style="background:orange"
 
| 019
 
| 019
 
| [FEATURE][Document] Add new performance section
 
| [FEATURE][Document] Add new performance section
Line 171: Line 151:
 
|  
 
|  
 
|
 
|
|-style="background:beige"
+
|-style="background:orange"
 
| 020
 
| 020
 
| [FEATURE] auto failback
 
| [FEATURE] auto failback
Line 181: Line 161:
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003328.html [pgpool-hackers: 3328]]
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003328.html [pgpool-hackers: 3328]]
 
|
 
|
|-style="background:beige"
+
|-style="background:orange"
 
| 021
 
| 021
 
| [FEATURE] allow to use md5 password in health_check_password and sr_check_password
 
| [FEATURE] allow to use md5 password in health_check_password and sr_check_password
Line 191: Line 171:
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003334.html [pgpool-hackers: 3334]]
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003334.html [pgpool-hackers: 3334]]
 
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=dc9742678dd04719a08a747d40cd4c0781fce49a commit]
 
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=dc9742678dd04719a08a747d40cd4c0781fce49a commit]
|-style="background:beige"
+
|-style="background:orange"
 
| 022
 
| 022
 
| [FEATURE] Routing relcache queries to load balance node
 
| [FEATURE] Routing relcache queries to load balance node
Line 201: Line 181:
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]]
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]]
 
|
 
|
|-style="background:beige"
+
|-style="background:orange"
 
| 023
 
| 023
 
| [FEATURE] Support ECDH key exchange with SSL
 
| [FEATURE] Support ECDH key exchange with SSL
Line 355: Line 335:
 
| Feature Freeze  
 
| Feature Freeze  
 
|  
 
|  
| 2019/05/31
+
| 2019/07/31
 
|  
 
|  
 
|  
 
|  
Line 365: Line 345:
 
| Code Freeze  
 
| Code Freeze  
 
|  
 
|  
| 2019/06/30
+
| 2019/08/31
 
|  
 
|  
 
|  
 
|  

Revision as of 04:15, 25 June 2019

Last update: 2019/06/25

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

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 2018/11/20 XLarge Usama
[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
[Documentation] Update the examples to latest version. 2018/11/20 High Peng Done. commit doc
010 [FEATURE] Master watchdog sets quarantine state to primary node 2018/11/26 Normal Small Usama [pgpool-hackers: 2756]
[pgpool-general-jp: 1504]
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] Implementation is done. TODO: Test & Doc.
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 Start after PostgreSQL beta release.
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
020 [FEATURE] auto failback 2019/5/23 2019/7/5 Medium Hoshiai [pgpool-hackers: 3328]
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] commit
022 [FEATURE] Routing relcache queries to load balance node Medium Ishii [pgpool-hackers: 3342]
023 [FEATURE] Support ECDH key exchange with SSL Medium Hoshiai 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. cimmit
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 Waiting for review->the patch did not work.
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
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
201 Feature Agreement
202 Feature Freeze 2019/07/31
202 Code Freeze 2019/08/31