Difference between revisions of "Pgpool-II 4.1 development"

From pgpool Wiki
Jump to: navigation, search
 
(187 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
Last update: 2018/09/14 (gray items are done, yellow items are behind schedule, orange items are new features for 4.0, and pink items are other TODO)
+
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 8: Line 10:
 
! Registered/start Date
 
! Registered/start Date
 
! Target Date
 
! Target Date
 +
! Priority
 +
! Implementation
 
! Person in charge
 
! Person in charge
 
! Overview
 
! Overview
 
! Status
 
! Status
−
|-style="background:pink"
+
|-style="background:orange"
−
| 2
+
| 007
−
| pgpool-hackers:1034
+
| [FEATURE] shared relation cache
−
| 2015/09/03
+
| 2018/11/20
−
| -
+
| 2019/02/29
 +
| High
 +
| Large
 +
| Hoshiai
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46917d5458a82c75e98b247a74b7ee1827666159 commit]
 +
|-style="background:beige"
 +
| rowspan="3" | 008
 +
| [FEATURE] Enhance performance: performance regression test
 +
| 2018/11/20
 +
|
 +
| High
 +
| Small
 
| Usama
 
| Usama
−
| add new child if it goes down
+
|
−
| [Feature: small]->postpone to 3.8
+
|  
−
|- style="background:pink"
+
|-style="background:orange"
−
| 3
+
| [FEATURE] Enhance performance: performance for simple query (especially for of the large
−
| Make PCP set configuration command public
+
INSERT and UPDATE statements)
−
| 2016/2/15
+
| 2018/11/20
−
| -
+
|
 +
|
 +
| XLarge
 
| Usama
 
| Usama
−
| -
 
−
| [Feature: small]->postpone to 3.8
 
−
|-style="background:silver"
 
−
| 5
 
−
| Allow to use multiple pgpool-II instances with in-memory query cache enabled
 
−
| 2016/4/6
 
 
|
 
|
−
| Tatsuo
+
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=310c5c4a289cbe6cee01abef7d2e7bc3550944fb commit]
−
| http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_multiple_pgpool-II_instances_with_in-memory_query_cache_enabled
 
−
| [Feature: small] [medium size implementation] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/query_cache -> This item is deleted. https://www.pgpool.net/pipermail/pgpool-hackers/2018-June/002845.html
 
 
|-style="background:orange"
 
|-style="background:orange"
−
| 43
+
| [FEATURE] Enhance performance: performance for extended query
−
| new feature candidate: verify standby node while finding primary node
+
| 2019/01/17
−
| 2017/1/12
+
|
−
| 2018/4/18
+
|
−
| Tatsuo
+
|  
−
| http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002759.html http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html
+
| Ishii
−
| Completed.
+
|
 +
| (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=702f7c86f9b8f82f61e47235505715891ffe1b23 commit] <br>
 +
(2) Enhance performance for extended query message: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003230.html [pgpool-hackers: 3230]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=778f611e201d6df88ed90d01e49af77daf9f2926 commit] <br> (3) Eliminate select(2) calls in certain cases to enhance performance in simple and extended query: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003247.html [pgpool-hackers: 3247]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=cf5fe7eb89a11e3ada3833343c7ed6551ce7c662 commit]
 
|-style="background:orange"
 
|-style="background:orange"
−
| 62
+
| rowspan="2" | 009
−
| [Feature] New feature candidate: SCRAM authentication and certification base authentication
+
| [Documentation] Review and improve the current document
−
| 2017/3/23
+
| 2018/11/20
−
| 2018/8/10
+
|  
−
| Usama
+
| High
 +
| Extra Large
 +
| Hoshiai
 
|
 
|
−
| 2018/4/17: Ready for review(Include small Readme for testing). <br /> 2018/4/24: Documentation done. <br />2018/4/27: Regression done.
+
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ea1998b7350de6882bea25fc3634c4f7673adbde commit1][https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=5f259f3b5e1b56763677d0b7aa736eb8772a8968 commit2][https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=b69e94e97ed4226e335e85f01bfc373c8e11db8f commit3] <br>
−
|-style="background:pink"
+
[https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=b69e94e97ed4226e335e85f01bfc373c8e11db8f commit4]
−
| 63
+
[https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=c013bad08e67bd53d39a66835c67bc93d334d72b commit5]
−
| New feature candidate: Seamless Application Failover
+
[https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6d3939dac4d76eed5dcd1867fb16e8bc8215dc61 commit6]
−
| 2017/3/23
+
|-style="background:orange"
 +
| [Documentation] Update the examples to latest version.
 +
| 2018/11/20
 
|  
 
|  
−
| Ahsan
+
| High
−
| Similar to Oracle's "Transparent Application Failover".
+
|
−
| Ahsan will post a proposal to pgpool-hackers
+
| Peng
 +
|  
 +
| 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] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=69c6a4cd5f49384a1d719e4e784ff84855f00a9d commit]
 
|-style="background:orange"
 
|-style="background:orange"
−
| 72
+
| 010
−
| New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)
+
| [FEATURE] Master watchdog sets quarantine state to primary node
−
| 2017/4/17
+
| 2018/11/26
 
|  
 
|  
 +
| Normal
 +
| Small
 
| Usama
 
| Usama
 +
| [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]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=3922c12c1f8efbc1b5f2e7def1e0ff921aafb989  Commit]
 +
|-style="background:orange"
 +
| 011
 +
| [FEATURE] limiting number of frontends differently
 +
| 2018/11/26
 +
| 2018/12/04
 +
|
 +
|
 +
| Ishii
 +
| [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]
 +
|-style="background:orange"
 +
| 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
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003157.html [pgpool-hackers: 3157]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=3ddf9aa0b20480b22bb5e8fc6097f2eb7cb56994 commit]
 +
|-style="background:orange"
 +
| 014
 +
| [FEATURE] Support for PostgreSQL 12.
 +
| 2018/11/29
 +
|
 +
| High
 +
| Small
 +
| Ishii
 +
| 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]
 +
|-style="background:orange"
 +
| 015
 +
| [FEATURE] Import PostgreSQL 12 parser.
 +
| 2018/11/29
 +
| 2019/07/31
 +
| High
 +
| Medium
 +
| Peng
 +
|
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f694283cfd55a52750ce56697af2e5cd1d1da571 commit]
 +
|-style="background:orange"
 +
| 016
 +
| [FEATURE] Statement level load balancing
 +
| 2018/12/06
 +
| 2019/03/31
 +
| High
 +
| Large
 +
| Peng
 
|
 
|
−
| Postpone to 3.8
+
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb commit]
−
|-style="background:white"
+
|-style="background:orange"
−
| 83
+
| 018
−
| [pgpool-hackers: 2400] Garbage output
+
| [FEATURE] Add new columns to "show pool_nodes" command
−
| 2017/6/19
+
| 2019/04/22
 +
| 2019/04/24
 +
| High
 +
| Medium
 +
| Ishii
 +
| 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]
 +
|-style="background:orange"
 +
| 019
 +
| [FEATURE][Document] Add new performance section
 
|  
 
|  
−
|Usama
 
 
|
 
|
−
| Follow up: [pgpool-hackers: 2798]
+
| High
−
|-style="background:yellow"
+
| Medium
−
| 92
+
| Ishii
−
| 0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive
+
|
−
| 2017/7/21
+
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=854659a17b958536e80c461d55c9ba0f1032a128 commit]
−
|
+
|-style="background:orange"
−
| Tatsuo
+
| 020
−
|https://www.pgpool.net/mantisbt/view.php?id=322
+
| [FEATURE] auto failback
−
| Waiting for feedback (2018/3/22)
+
| 2019/5/23
−
|-style="background:yellow"
+
| 2019/7/5
 +
|
 +
| Medium
 +
| Hoshiai
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003328.html [pgpool-hackers: 3328]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=3e2ecc970864056ff054799cac57ad5b30312c48 commit]
 +
|-style="background:orange"
 +
| 021
 +
| [FEATURE] allow to use md5 password in health_check_password and sr_check_password
 +
| 2019/5/30
 +
| 2019/6/10
 +
|
 +
| Medium
 +
| Ishii
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003334.html [pgpool-hackers: 3334]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=dc9742678dd04719a08a747d40cd4c0781fce49a commit]
 +
|-style="background:orange"
 +
| 022
 +
| [FEATURE] Routing relcache queries to load balance node
 +
|
 +
|
 +
|
 +
| Medium
 +
| Ishii
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46986ebc0be77e4b011b94b097789fec9e3f5b0f commit]
 +
|-style="background:orange"
 +
| 023
 +
| [FEATURE] Support ECDH key exchange with SSL
 +
|
 +
|
 +
|
 +
| Medium
 +
| Hoshiai
 +
|
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=51bc494aaa7fd191e14038204d18effe2efb0ec8 commit1] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f63c260d7e389bc03822721a9d66a0d6c7d22f4b commit2]
 +
|-style="background:orange"
 +
| 024
 +
| [FEATURE] Reduce relcahe queries
 +
|
 +
|
 +
|
 +
| Medium
 +
| Ishii
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003344.html [pgpool-hackers: 3344]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6282805d4ae3f7a76ed607c0124420b8fe4c8320 commit]
 +
|-style="background:orange"
 +
| 025
 +
| [FEATURE] Eliminate temp table relcahe query
 +
|
 +
|
 +
|
 +
| Medium
 +
| Ishii
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003346.html [pgpool-hackers: 3346]]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=7a0471bbcc3ab06a9cab9902d91e5c4c692b3284 commit]
 +
|-style="background:orange"
 +
| 026
 +
| [FEATURE] Add new arguments in pgpool_recovery function and failover_command/failback_command/follow_master_command.
 +
|
 +
|
 +
|
 +
| Small
 +
| Peng
 +
|
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ed90a39db3664eb7be85f192f5472cc0b59a2d8f commit]
 +
|-style="background:silver"
 +
| 101
 +
| 0000433: IN (SELECT ...) can not be rewritten in native replication mode
 +
| 2018/10/19
 +
|
 +
|
 +
|
 +
| Peng
 +
| [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.
 +
|-style="background:silver"
 +
| 102
 +
| 0000434: Segmentation fault due to a query error and Sync messages in native replication mode
 +
| 2018/10/19
 +
|  
 +
|  
 +
|  
 +
| Hoshiai
 +
| [https://www.pgpool.net/mantisbt/view.php?id=434 bug434]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=5e6d598b964ac88f41a18280f6289ca5e78ffad5 commit]
 +
|-style="background:silver"
 +
| 103
 +
| pool_passwd is corrupted.
 +
| 2018/10/22
 +
|
 +
|
 +
|
 +
| Hoshiai, Usama
 +
| [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]
 +
|-style="background:silver"
 
| 104
 
| 104
−
| 0000329: Newly elected(promoted) Pgpool does connect to any backend
+
| [pgpool-hackers: 3025] Compile warns
−
| 2017/8/11
+
| 2018/10/22
−
| 2017/12/11
+
|
−
| Usama
+
|
−
| http://www.pgpool.net/mantisbt/view.php?id=329
+
|
−
| fix in 3.7 done. Needs back patching
+
| Hoshiai
 +
| [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]
 +
|-style="background:silver"
 +
| 105
 +
| 0000443: Segmentation fault occurs when a certain Bind message is sent in native replication mode.
 +
| 2018/11/08
 +
|
 +
|  
 +
|  
 +
| Peng
 +
| [https://www.pgpool.net/mantisbt/view.php?id=443 bug443]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1d8d03237a2ad507f8f1fb8fb0c84b3084f57cdc commit]
 
|-style="background:silver"
 
|-style="background:silver"
 
| 106
 
| 106
−
| 0000332: Watch dog issue
+
| 0000444: pgpool does not take into account parameters order in startup packet
−
| 2017/8/24
+
| 2018/11/13
−
|
+
|
 +
|
 +
|
 +
| Hoshiai
 +
| [https://www.pgpool.net/mantisbt/view.php?id=444 bug444]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ffb998517bb91c512b77fbe1ca8ee331e492f131 commit]
 +
|-style="background:silver"
 +
| 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
 +
| [https://www.pgpool.net/mantisbt/view.php?id=448 bug448]
 +
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=3f5986eee360f12e6a0bb77aa46f95abf5f6bc10 commit]
 +
|-style="background:silver"
 +
| 108
 +
| [pgpool-general: 6351] kind mismatch among backends, savepoint with psqlodbc
 +
| 2018/12/26
 +
|
 +
|
 +
|
 +
| Peng
 +
| [https://www.pgpool.net/pipermail/pgpool-general/2018-December/006409.html [pgpool-general: 6351]]
 +
|
 +
|-style="background:silver"
 +
| 109
 +
| 0000455: watchdog lifecheck process has segfalut in query mode
 +
| 2019/01/21
 +
|
 +
|
 +
|  
 
| Usama
 
| Usama
−
| http://www.pgpool.net/mantisbt/view.php?id=332
+
| https://www.pgpool.net/mantisbt/view.php?id=455
−
| Closed.(2018/1/9) Doesn't seems like an issue. Replied on Mantis.
+
| Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=4cde5da1b416d909d102cfe6878c0cd5189caf86
 +
|-style="background:white"
 +
| 110
 +
| Add regression test for query mode
 +
| 2019/01/21
 +
|
 +
|
 +
|
 +
| Peng
 +
|
 +
|
 
|-style="background:silver"
 
|-style="background:silver"
 
| 111
 
| 111
−
| 0000339: Failover does not occurr if master Pgpool-II and primary PostgreSQL servers are stopped at the same time
+
| 0000483: online-recovery is blocked after a child process exits abnormally with replication mode and watchdog
−
| 2017/9/13
+
| 2019/04/04
 +
|
 +
|
 
|  
 
|  
 
| Usama
 
| Usama
−
| https://www.pgpool.net/mantisbt/view.php?id=339
+
| [https://www.pgpool.net/mantisbt/view.php?id=483 bug483]
−
| Closed. (2017/12/15) (Done in 3.6, 3.5, 3.7. Working on 3.4 and 3.3 --> Impossible due to technical reasons. Mantis updated). The report claimed that the bug was not fixed in 3.6.7. So reopen this item.
+
| Done [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=c402060814ba9737e9572ba07eef1be7664c9679 commit].
 
|-style="background:silver"
 
|-style="background:silver"
−
| 120
+
| 112
−
| 0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC
+
| Fix memory leak related to watchdog and auth pointed out by coverity
−
| 2017/10/5
+
| 2019/05/22
 +
|
 +
|
 
|
 
|
−
| Tatsuo
+
| Usama
−
| https://www.pgpool.net/mantisbt/view.php?id=349
+
| 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
−
| Waiting for feedback.(2017/10/6)-->asking to close the issue (2017/12/8)-->They said they are going to upgrade on 2018/15 but no reply as of 2018/1/12 and waiting for feedback. The reporter said it will take more time because the organization is large (2018/2/28). Still no response. Polling again (2018/04/06). Still no response. Will close this issue on beginning of May.
+
| Done
 
|-style="background:silver"
 
|-style="background:silver"
−
| 123
+
| 113
−
| [pgpoolAdmin] 0000361: Can't detach node from pgpoolAdmin UI, while pcp_detach_node works fine
+
| Fix memory leak related to watchdog and auth pointed out by coverity
−
| 2017/11/01
+
| 2019/05/22
−
|
+
|  
−
| Peng
+
|  
−
| https://www.pgpool.net/mantisbt/view.php?id=361
+
|  
−
| Done. 2017/11/24
+
| ishii
−
|-style="background:white"
+
| 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
−
| 125
+
|
−
| 0000348: pgpool failover scenario ERROR - pgpool 3.6.6 (postgres 9.3.5)
+
|-style="background:red"
−
| 2017/11/09
+
| 114
−
|
+
| [https://www.pgpool.net/pipermail/pgpool-general/2019-August/006730.html pgpool-general: 6672] Query (watchdog split brain)
 +
| 2019/08/16
 +
|
 +
|
 +
|  
 
| Usama
 
| Usama
−
| https://www.pgpool.net/mantisbt/view.php?id=348
+
|  
−
| Waiting for reply with message: Please try 3.6.7
+
| Requested log sent [https://www.pgpool.net/pipermail/pgpool-general/2019-September/006753.html pgpool-general: 6695]
−
|-style="background:white"
 
−
| 126
 
−
| 0000342: On master fail slave not able to convert itself to master
 
−
| 2017/11/09
 
−
|
 
−
| Usama
 
−
| https://www.pgpool.net/mantisbt/view.php?id=342
 
−
| Waiting for reply with message: Please try 3.6.7
 
 
|-style="background:silver"
 
|-style="background:silver"
−
| 127
+
| 115
−
| [pgpoolAdmin]0000364: PGPool hangs when then number of connections are greater than num_init_children
+
| regression test 013.watchdog_failover_require_consensus failed
−
| 2017/11/10
+
| 2019/08/14
−
|
+
|
 +
|
 +
|
 +
| Ishii
 +
|
 +
|
 +
|-style="background:red"
 +
| 116
 +
| Doc:Pgpool-II + Watchdog Setup Example (for PostgreSQL 12)
 +
| 2019/09/03
 +
|
 +
|
 +
|  
 
| Peng
 
| Peng
−
| https://www.pgpool.net/mantisbt/view.php?id=364
+
|  
−
| Close(2018/04/02)
 
−
|-style="background:silver"
 
−
| 128
 
−
| [pgpoolAdmin] 0000369: yum's baseurl does not exist and it can not be used
 
−
| 2017/11/24
 
 
|
 
|
−
| Peng
 
−
| https://www.pgpool.net/mantisbt/view.php?id=369
 
−
| Done. (2017/11/27)
 
 
|-style="background:silver"
 
|-style="background:silver"
−
| 129
+
| 117
−
| [pgpool-hackers: 2635] Some problems in Makefile.am
+
| regression test 028. 028.watchdog_enable_consensus_with_half_votes failed
−
| 2017/12/08
+
| 2019/09/13
−
|
+
| 2019/09/18
−
| Peng
+
|  
−
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002635.html
+
|  
−
| Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
+
| Ishii
 +
|
 +
|
 
|-style="background:silver"
 
|-style="background:silver"
−
| 130
+
| 118
−
| $(top_srcdir) was created in src/parser/.
+
| 0000545: Quorum lost and not recovered
−
| 2017/12/08
+
| 2019/09/09
−
|
+
|
−
| Peng
+
|
 +
|
 +
| 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
 +
|  
 +
|  
 
|  
 
|  
−
| Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
+
| Usama
−
|-style="background:pink"
+
| https://www.pgpool.net/mantisbt/view.php?id=547
−
| 131
 
−
| Logging client message
 
−
| 2017/12/08
 
−
|
 
−
| Tatsuo
 
−
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002638.html
 
 
|  
 
|  
 
|-style="background:silver"
 
|-style="background:silver"
−
| 132
+
| 120
−
| 0000370: Pgpool get stuck with db exception followed by select
+
| regression test 065.bug152 failed if enable_shared_relcache is on
−
| 2017/12/11
+
| 2019/10/02
−
|
+
|  
−
| Tatsuo
+
|  
−
| https://www.pgpool.net/mantisbt/view.php?id=370
+
|  
−
| Close. (2018/3/5) Patch provided. Waiting for feedback.-> Resolved.
+
| Hoshiai
 +
|
 +
|
 
|-style="background:silver"
 
|-style="background:silver"
−
| 133
+
| 201
−
| Failed in 002.native_replication. (Pgpool-II couldn't rewrite DEFAULT)
+
| Feature Agreement
−
| 2017/12/14
+
|  
−
| 2017/12/18
+
|  
−
| Peng
+
|  
 
|  
 
|  
−
| Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b974f5f3b59b62ca3f0c5c0ccfdea125abbbc19b
 
−
|-style="background:silver"
 
−
| 134
 
−
| [pgpoolAdmin] Pull Request
 
−
| 2017/12/14
 
 
|
 
|
−
| Peng
+
|
−
| https://github.com/pgpool/pgpooladmin/compare/master...remodoy:postgresql_connect_timeout
+
|  
−
| Done. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=579833e695e011f8d47a6fff994a3393f9d8a37d
 
 
|-style="background:silver"
 
|-style="background:silver"
−
| 135
+
| 202
−
| Modify pgpool.service to output log.
+
| Feature Freeze
−
| 2017/12/15
+
|  
 +
| 2019/08/15
 
|  
 
|  
−
| Peng
 
 
|  
 
|  
−
| Done. 2017/12/21 <br> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=63886312c702811f7ed53fac266c22946ba2212e
 
−
|-style="background:orange"
 
−
| 136
 
−
| allow to specify load balance weight ratio for load balance parameters
 
−
| 2017/12/15
 
−
| 2018/8/10
 
−
| Peng
 
−
|  https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html
 
−
| Done.
 
−
|-style="background:orange"
 
−
| 137
 
−
| Load-balancing control for specific queries
 
−
| 2017/12/15
 
−
| 2018/05/11
 
−
| Peng
 
−
|https://www.pgpool.net/pipermail/pgpool-hackers/2017-November/002594.html
 
−
| Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=search;s=Bo+Peng;st=author
 
−
|-style="background:silver"
 
−
| 138
 
−
| Minor releases (3.7.1, 3.6.8 etc.)
 
−
| 2017/12/15
 
−
| 2018/1/9
 
−
| Peng
 
 
|
 
|
−
| Done. 2018/1/9
+
|
 +
|
 
|-style="background:silver"
 
|-style="background:silver"
−
| 139
+
| 203
−
| 0000373: pgpool failed over
+
| Code Freeze
−
| 2017/12/21
 
 
|  
 
|  
−
| Tatsuo
+
| 2019/08/31
−
| http://www.pgpool.net/mantisbt/view.php?id=373
+
|
−
| Waiting for feedback.-> no response. Closed.
+
|
 +
|
 +
|
 +
|
 +
|
 
|-style="background:silver"
 
|-style="background:silver"
−
| 140
+
| 204
−
| 0000374: md5 authentication is broken
+
| Release beta1
−
| 2017/12/23
 
 
|  
 
|  
−
| Tatsuo
+
| 2019/09/06
−
| http://www.pgpool.net/mantisbt/view.php?id=374
 
−
| Waiting for feedback.-> no response. Closed.
 
−
|-style="background:silver"
 
−
| 141
 
−
| 0000375: extended query error
 
−
| 2018/01/08
 
 
|  
 
|  
−
| Peng
 
−
| http://www.pgpool.net/mantisbt/view.php?id=375
 
−
| Close.2018/4/27
 
−
|-style="background:silver"
 
−
| 142
 
−
| 0000376: child process was terminated by segmentation fault
 
−
| 2018/01/12
 
 
|  
 
|  
−
| Tatsuo
+
|
−
| http://www.pgpool.net/mantisbt/view.php?id=376
+
|
−
| Closed. (2018/2/6)
+
|
 +
|
 
|-style="background:white"
 
|-style="background:white"
−
| 143
+
| 205
−
| [pgpool-general: 5863] pgpool frequnet authentication timeout
+
| RC Release
−
| 2018/01/19
 
 
|  
 
|  
−
| Usama
+
| 2019/10/11
−
| http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005921.html
 
−
| In progress.
 
−
|-style="background:silver"
 
−
| 144
 
−
| [pgpool-general: 5864] Troubleshooting assistance on node failure and connections blocking
 
−
| 2018/01/19
 
 
|  
 
|  
−
| Tatsuo
 
−
| http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005922.html
 
−
| Waiting for feedback (2017/1/19)-> No response from the poster over 1 month. Issue closed.
 
−
|-style="background:white"
 
−
| 145
 
−
| [pgpool-general: 5899] Master Election - Priority
 
−
| 2018/01/30
 
 
|  
 
|  
−
| Usama
+
|
−
| https://www.pgpool.net/pipermail/pgpool-general/2018-January/005957.html
+
|
 
|
 
|
 
|-style="background:white"
 
|-style="background:white"
−
| 207
+
| 206
 
| Official Release
 
| Official Release
 
|  
 
|  
−
| 2018/10/17
+
| 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
Retrieved from "https://pgpool.net/mediawiki/index.php?title=Pgpool-II_4.1_development&oldid=3146"