Pgpool-II 4.1 development: Difference between revisions

From pgpool Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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