Pgpool-II 4.0 development
Last update: 2018/07/02 (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 | Person in charge | Overview | Status | |
|---|---|---|---|---|---|---|
| 2 | pgpool-hackers:1034 | 2015/09/03 | - | Usama | add new child if it goes down | [Feature: small]->postpone to 3.8 |
| 3 | Make PCP set configuration command public | 2016/2/15 | - | Usama | - | [Feature: small]->postpone to 3.8 |
| 5 | Allow to use multiple pgpool-II instances with in-memory query cache enabled | 2016/4/6 | Tatsuo | 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 | |
| 43 | new feature candidate: verify standby node while finding primary node | 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 | Completed. |
| 62 | [Feature] New feature candidate: SCRAM authentication and certification base authentication | 2017/3/23 | 2018/6/28 (Ready for review) |
Usama | 2018/4/17: Ready for review(Include small Readme for testing). 2018/4/24: Documentation done. 2018/4/27: Regression done. | |
| 63 | New feature candidate: Seamless Application Failover | 2017/3/23 | Ahsan | Similar to Oracle's "Transparent Application Failover". | Ahsan will post a proposal to pgpool-hackers | |
| 72 | New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE) | 2017/4/17 | Usama | Postpone to 3.8 | ||
| 83 | [pgpool-hackers: 2400] Garbage output | 2017/6/19 | Usama | Follow up: [pgpool-hackers: 2798] | ||
| 92 | 0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive | 2017/7/21 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=322 | Waiting for feedback (2018/3/22) | |
| 104 | 0000329: Newly elected(promoted) Pgpool does connect to any backend | 2017/8/11 | 2017/12/11 | Usama | http://www.pgpool.net/mantisbt/view.php?id=329 | fix in 3.7 done. Needs back patching |
| 106 | 0000332: Watch dog issue | 2017/8/24 | Usama | http://www.pgpool.net/mantisbt/view.php?id=332 | Closed.(2018/1/9) Doesn't seems like an issue. Replied on Mantis. | |
| 111 | 0000339: Failover does not occurr if master Pgpool-II and primary PostgreSQL servers are stopped at the same time | 2017/9/13 | Usama | https://www.pgpool.net/mantisbt/view.php?id=339 | 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. | |
| 120 | 0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC | 2017/10/5 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=349 | 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. | |
| 123 | [pgpoolAdmin] 0000361: Can't detach node from pgpoolAdmin UI, while pcp_detach_node works fine | 2017/11/01 | Peng | https://www.pgpool.net/mantisbt/view.php?id=361 | Done. 2017/11/24 | |
| 125 | 0000348: pgpool failover scenario ERROR - pgpool 3.6.6 (postgres 9.3.5) | 2017/11/09 | Usama | https://www.pgpool.net/mantisbt/view.php?id=348 | Waiting for reply with message: Please try 3.6.7 | |
| 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 | |
| 127 | [pgpoolAdmin]0000364: PGPool hangs when then number of connections are greater than num_init_children | 2017/11/10 | Peng | https://www.pgpool.net/mantisbt/view.php?id=364 | Close(2018/04/02) | |
| 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) | |
| 129 | [pgpool-hackers: 2635] Some problems in Makefile.am | 2017/12/08 | 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 | |
| 130 | $(top_srcdir) was created in src/parser/. | 2017/12/08 | Peng | Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec | ||
| 131 | Logging client message | 2017/12/08 | Tatsuo | https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002638.html | ||
| 132 | 0000370: Pgpool get stuck with db exception followed by select | 2017/12/11 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=370 | Close. (2018/3/5) Patch provided. Waiting for feedback.-> Resolved. | |
| 133 | Failed in 002.native_replication. (Pgpool-II couldn't rewrite DEFAULT) | 2017/12/14 | 2017/12/18 | Peng | Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b974f5f3b59b62ca3f0c5c0ccfdea125abbbc19b | |
| 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 | |
| 135 | Modify pgpool.service to output log. | 2017/12/15 | Peng | Done. 2017/12/21 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=63886312c702811f7ed53fac266c22946ba2212e | ||
| 136 | allow to specify load balance weight ratio for load balance parameters | 2017/12/15 | Peng | https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html | In progress. | |
| 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 |
| 138 | Minor releases (3.7.1, 3.6.8 etc.) | 2017/12/15 | 2018/1/9 | Peng | Done. 2018/1/9 | |
| 139 | 0000373: pgpool failed over | 2017/12/21 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=373 | Waiting for feedback.-> no response. Closed. | |
| 140 | 0000374: md5 authentication is broken | 2017/12/23 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=374 | Waiting for feedback.-> no response. Closed. | |
| 141 | 0000375: extended query error | 2018/01/08 | Peng | http://www.pgpool.net/mantisbt/view.php?id=375 | Close.2018/4/27 | |
| 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) | |
| 143 | [pgpool-general: 5863] pgpool frequnet authentication timeout | 2018/01/19 | Usama | http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005921.html | In progress. | |
| 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. | |
| 145 | [pgpool-general: 5899] Master Election - Priority | 2018/01/30 | Usama | https://www.pgpool.net/pipermail/pgpool-general/2018-January/005957.html | ||
| 146 | 0000378: Pgpool fails all connections when secondary goes down | 2018/02/06 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=378 | No response over 1 month. I am going to close the issue. | |
| 147 | 0000379: Many connections go into state 'idle in transaction' | 2018/02/07 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=379 | Patch provided. Waiting for feedback (2018/2/28) | |
| 148 | 0000380: When a node is down, the first query to the cluster fails | 2018/02/14 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=380 | It turned out a problem with user's setting. | |
| 149 | Proposal: Enhancing pool_process and pool_pools | 2018/02/13 | Tatsuo | http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html | ||
| 150 | Proposal: Disabling load balance after writing query | 2018/02/16 | 2018/04/23 | Tatsuo | http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002726.html | Done (2018/4/23) |
| 151 | 0000385: arping, if_up_cmd' failed and failed to acquire delegate Ip | 2018/03/16 | Peng | https://www.pgpool.net/mantisbt/view.php?id=385 | Close. (2018/3/26) | |
| 152 | 0000386: Pgpool fails to start with a watchdog error | 2018/03/16 | Peng | https://www.pgpool.net/mantisbt/view.php?id=386 | Close. (2018/04/27) | |
| 153 | 0000388: pgpool-II 3.6.1 child process remain waiting for a non-existing client socket to send queries | 2018/03/18 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=388 | Assigned (2018/04/06)-> Waiting for feedback (2018/05/07)->No feedback. Closed. | |
| 154 | 0000394: When multiple failover happens the pgpool pool node status is going into standby -stanby state | 2018/04/21 | Usama | https://www.pgpool.net/mantisbt/view.php?id=394 | Assigned (2018/04/24) | |
| 155 | [pgpool-general: 6069] failover_require_consensus does not work. | 2018/05/03 | Usama | https://www.pgpool.net/pipermail/pgpool-general/2018-May/006127.html | Assigned (2018/05/07) | |
| 156 | [pgpool-hackers: 2807] client_min_messages | 2018/05/25 | Usama | http://www.sraoss.jp/pipermail/pgpool-hackers/2018-May/002807.html | Assigned (2018/05/25) | |
| 157 | [Feature] Proposal: Add last state change timestamp to "show pool_nodes" | 2018/06/11 | Tatsuo | http://www.sraoss.jp/pipermail/pgpool-hackers/2018-June/002822.html | Done. (2018/06/12) | |
| 158 | 0000403: About : 0000402: write on backend 0 failed with error :"Success" | 2018/06/15 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=403 | Assigned.(2018/6/15) ->Waiting for feedback (2018/6/15) | |
| 159 | [Feature] Add "last status change" to pcp_node_info and pgpool_adm like "show pool_nodes". | 2018/06/15 | Peng | |||
| 160 | [Feature] Add pid info to pcp_proc_info output. | 2018/06/15 | Tatsuo | |||
| 161 | 0000405: ERROR: unable to read message length DETAIL: message length (8) in slot 1 does not match with slot 0(12) bash-4.1$ | 2018/06/22 | https://www.pgpool.net/mantisbt/view.php?id=405 | Waiting for feedback. | ||
| 162 | 0000406: failover called with old-primary = -1 | 2018/06/22 | Usama | https://www.pgpool.net/mantisbt/view.php?id=406 | Assigned | |
| 163 | 0000407: health check process doesn't start in some cases | 2018/06/22 | Tatsuo | https://www.pgpool.net/mantisbt/view.php?id=407 | Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=f9149dd4992eb6cbbbdf5d8a3f0a00ef2c0f3071 | |
| 164 | [pgpool-general: 6134] kind mismatch among backends with multiple clients and prepared statements | 2018/06/22 | Tatsuo | http://www.sraoss.jp/pipermail/pgpool-general/2018-June/006192.html | Assigned. | |
| 165 | [Feature] Import PostgreSQL 11 parser. | 2018/06/22 | Peng | After PostgreSQL 11 RC. | ||
| 200 | Feature Agreement | 2018/3/31 | ||||
| 201 | Feature Freeze | 2018/8/31 | ||||
| 202 | Code Freeze | 2018/9/30 |
