Difference between revisions of "Pgpool-II 4.1 development"

From pgpool Wiki
Jump to: navigation, search
Line 23: Line 23:
 
|
 
|
 
| Removed from 4.1. 2018/11/29
 
| Removed from 4.1. 2018/11/29
−
|-style="background:white"
+
|-style="background:beige"
 
| 002
 
| 002
 
| [FEATURE] Add new child if it goes down
 
| [FEATURE] Add new child if it goes down
Line 53: Line 53:
 
| <s>Similar to Oracle's "Transparent Application Failover".</s>
 
| <s>Similar to Oracle's "Transparent Application Failover".</s>
 
| Removed from 4.1. 2018/11/29
 
| Removed from 4.1. 2018/11/29
−
|-style="background:white"
+
|-style="background:beige"
 
| 005
 
| 005
 
| [FEATURE] Enhancing pool_process and pool_pools
 
| [FEATURE] Enhancing pool_process and pool_pools
Line 73: Line 73:
 
| <s>[http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]</s>  
 
| <s>[http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]</s>  
 
| Removed from 4.1. 2018/11/29
 
| Removed from 4.1. 2018/11/29
−
|-style="background:white"
+
|-style="background:beige"
 
| 007
 
| 007
 
| [FEATURE] shared relation cache
 
| [FEATURE] shared relation cache
Line 83: Line 83:
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]]
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]]
 
|  
 
|  
−
|-style="background:white"
+
|-style="background:beige"
−
| 008
+
| rowspan="2" | 008
−
| [FEATURE] Enhance performance
+
| rowspan="2" | [FEATURE] Enhance performance
 
| 2018/11/20
 
| 2018/11/20
 
|  
 
|  
 +
| High
 +
| Small
 +
| Usama
 +
|
 
|  
 
|  
−
|  
+
|-style="background:beige"
 +
| 2018/11/20
 +
|
 +
|
 +
| XLarge
 
| Usama
 
| Usama
 
|
 
|
 
|  
 
|  
−
|-style="background:white"
+
|-style="background:beige"
 
| 009
 
| 009
 
| [FEATURE] Enhance Documentation
 
| [FEATURE] Enhance Documentation
Line 103: Line 111:
 
| Add a quik start guid.<br> Update to latest version.
 
| Add a quik start guid.<br> Update to latest version.
 
|  
 
|  
−
|-style="background:white"
+
|-style="background:beige"
 
| 010
 
| 010
 
| [FEATURE] Master watchdog sets quarantine state to primary node
 
| [FEATURE] Master watchdog sets quarantine state to primary node
Line 123: Line 131:
 
| [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:white"
+
|-style="background:beige"
 
| 012  
 
| 012  
 
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list and queries specified in black_query_pattern_list
 
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list and queries specified in black_query_pattern_list
Line 133: Line 141:
 
| [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]]
 
|  
 
|  
−
|-style="background:white"
+
|-style="background:beige"
 
| 013  
 
| 013  
 
| [FEATURE] Support for LDAP authentication  
 
| [FEATURE] Support for LDAP authentication  
Line 143: Line 151:
 
|
 
|
 
|
 
|
−
|-style="background:white"
+
|-style="background:beige"
 
| 014
 
| 014
 
| [FEATURE] Support for PostgreSQL 12.
 
| [FEATURE] Support for PostgreSQL 12.
Line 153: Line 161:
 
| recovery.conf <br> table OID
 
| recovery.conf <br> table OID
 
|
 
|
−
|-style="background:white"
+
|-style="background:beige"
 
| 015
 
| 015
 
| [FEATURE] Import PostgreSQL 12 parser.
 
| [FEATURE] Import PostgreSQL 12 parser.
Line 163: Line 171:
 
|  
 
|  
 
|  
 
|  
−
|-style="background:white"
+
|-style="background:beige"
 
| 016
 
| 016
 
| [FEATURE] Statement level load balancing
 
| [FEATURE] Statement level load balancing
Line 172: Line 180:
 
| Peng
 
| Peng
 
|
 
|
−
|  
+
|
 
|-style="background:#D8D8D8"
 
|-style="background:#D8D8D8"
 
| 101
 
| 101
Line 178: Line 186:
 
| 2018/10/19
 
| 2018/10/19
 
|  
 
|  
−
| Peng
 
 
|  
 
|  
 
|  
 
|  
 +
| Peng
 
| [http://www.pgpool.net/mantisbt/view.php?id=433 bug433]
 
| [http://www.pgpool.net/mantisbt/view.php?id=433 bug433]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d53292592a9808b260171f8569752ca89d7412fc commit] <br>Regression test should be added.
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d53292592a9808b260171f8569752ca89d7412fc commit] <br>Regression test should be added.
Line 188: Line 196:
 
| 2018/10/19
 
| 2018/10/19
 
|  
 
|  
−
| Hoshiai
 
 
|  
 
|  
 
|  
 
|  
 +
| Hoshiai
 
| [https://www.pgpool.net/mantisbt/view.php?id=434 bug434]
 
| [https://www.pgpool.net/mantisbt/view.php?id=434 bug434]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=5e6d598b964ac88f41a18280f6289ca5e78ffad5 commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=5e6d598b964ac88f41a18280f6289ca5e78ffad5 commit]
Line 197: Line 205:
 
| pool_passwd is corrupted.
 
| pool_passwd is corrupted.
 
| 2018/10/22
 
| 2018/10/22
 +
|
 +
|
 
|  
 
|  
 
| Hoshiai, Usama
 
| Hoshiai, Usama
−
|
 
−
|
 
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-October/003081.html [pgpool-hackers: 3081]]
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-October/003081.html [pgpool-hackers: 3081]]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d48cc28a7b2ac42185b48873608ff876f9298d89 commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=d48cc28a7b2ac42185b48873608ff876f9298d89 commit]
Line 207: Line 215:
 
| [pgpool-hackers: 3025] Compile warns
 
| [pgpool-hackers: 3025] Compile warns
 
| 2018/10/22
 
| 2018/10/22
 +
|
 +
|
 
|  
 
|  
 
| Hoshiai
 
| Hoshiai
−
|
 
−
|
 
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-August/003025.html [pgpool-hackers: 3025]]
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-August/003025.html [pgpool-hackers: 3025]]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=bc9119f61b187577d64b63ebffb6f5412202f24f commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=bc9119f61b187577d64b63ebffb6f5412202f24f commit]
Line 217: Line 225:
 
| 0000443: Segmentation fault occurs when a certain Bind message is sent in native replication mode.
 
| 0000443: Segmentation fault occurs when a certain Bind message is sent in native replication mode.
 
| 2018/11/08
 
| 2018/11/08
 +
|
 +
|
 
|  
 
|  
 
| Peng
 
| Peng
−
|
 
−
|
 
 
| [https://www.pgpool.net/mantisbt/view.php?id=443 bug443]
 
| [https://www.pgpool.net/mantisbt/view.php?id=443 bug443]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1d8d03237a2ad507f8f1fb8fb0c84b3084f57cdc commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1d8d03237a2ad507f8f1fb8fb0c84b3084f57cdc commit]
Line 227: Line 235:
 
| 0000444: pgpool does not take into account parameters order in startup packet
 
| 0000444: pgpool does not take into account parameters order in startup packet
 
| 2018/11/13
 
| 2018/11/13
 +
|
 +
|
 
|  
 
|  
 
| Hoshiai
 
| Hoshiai
−
|
 
−
|
 
 
| [https://www.pgpool.net/mantisbt/view.php?id=444 bug444]
 
| [https://www.pgpool.net/mantisbt/view.php?id=444 bug444]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ffb998517bb91c512b77fbe1ca8ee331e492f131 commit]
 
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ffb998517bb91c512b77fbe1ca8ee331e492f131 commit]
Line 237: Line 245:
 
| 0000448: pgpool holds the connections as idle_in_transaction which are timed out due to idle_in_transaction setting on backend nodes
 
| 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
 
| 2018/11/29
 +
|
 +
|
 
|  
 
|  
 
| Ishii
 
| Ishii
−
|
 
−
|
 
 
| [https://www.pgpool.net/mantisbt/view.php?id=448 bug448]
 
| [https://www.pgpool.net/mantisbt/view.php?id=448 bug448]
 
| Waiting for feedback.
 
| Waiting for feedback.

Revision as of 09:03, 6 December 2018

Last update: 2018/12/06 (gray items are done, yellow items are behind schedule, orange items are new features for 4.0, and pink items are other TODO)

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
001 [FEATURE] Cert authentication between Pgpool-II and PostgreSQL Removed from 4.1. 2018/11/29
002 [FEATURE] Add new child if it goes down 2015/09/03 - Low Small pgpool-hackers:1034 [Feature: samll] [Priority: low]
003 [FEATURE] Make PCP set configuration command public Removed from 4.1. 2018/11/29
004 [FEATURE] Seamless Application Failover Similar to Oracle's "Transparent Application Failover". Removed from 4.1. 2018/11/29
005 [FEATURE] Enhancing pool_process and pool_pools 2018/02/13 Low Small [pgpool-hackers: 2721] [Priority: low]
006 [FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE) [pgpool-hackers: 2721] Removed from 4.1. 2018/11/29
007 [FEATURE] shared relation cache 2018/11/20 High Large Ishii [pgpool-hackers: 3124]
008 [FEATURE] Enhance performance 2018/11/20 High Small Usama
2018/11/20 XLarge Usama
009 [FEATURE] Enhance Documentation 2018/11/20 High Extra Large Add a quik start guid.
Update to latest version.
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 and queries specified in black_query_pattern_list 2018/11/29 Normal Small Peng [pgpool-hackers: 3157]
013 [FEATURE] Support for LDAP authentication 2018/11/29 High Medium Usama
014 [FEATURE] Support for PostgreSQL 12. 2018/11/29 High Small recovery.conf
table OID
015 [FEATURE] Import PostgreSQL 12 parser. 2018/11/29 High Medium Peng
016 [FEATURE] Statement level load balancing 2018/12/06 High Large Peng
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 Waiting for feedback.
201 Feature Agreement
202 Feature Freeze
202 Code Freeze
Retrieved from "https://pgpool.net/mediawiki/index.php?title=Pgpool-II_4.1_development&oldid=2841"