Difference between revisions of "Pgpool-II 4.1 development"

From pgpool Wiki
Jump to: navigation, search
m (Admin moved page New page to Pgpool-II 4.1 development)
Line 1: Line 1:
Pgpool-II 4.0 development
+
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)
 +
 
 +
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
 +
 
 +
{| class="wikitable"
 +
!
 +
! ID
 +
! Registered/start Date
 +
! Target Date
 +
! Person in charge
 +
! Overview
 +
! Status
 +
|-style="background:pink"
 +
| 2
 +
| pgpool-hackers:1034
 +
| 2015/09/03
 +
| -
 +
| Usama
 +
| add new child if it goes down
 +
| [Feature: small]->postpone to 3.8
 +
|- style="background:pink"
 +
| 3
 +
| Make PCP set configuration command public
 +
| 2016/2/15
 +
| -
 +
| 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
 +
| 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"
 +
| 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.
 +
|-style="background:orange"
 +
| 62
 +
| [Feature] New feature candidate: SCRAM authentication and certification base authentication
 +
| 2017/3/23
 +
| 2018/8/10
 +
| Usama
 +
|
 +
| 2018/4/17: Ready for review(Include small Readme for testing). <br /> 2018/4/24: Documentation done. <br />2018/4/27: Regression done.
 +
|-style="background:pink"
 +
| 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
 +
|-style="background:orange"
 +
| 72
 +
| New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)
 +
| 2017/4/17
 +
|
 +
| Usama
 +
|
 +
| Postpone to 3.8
 +
|-style="background:white"
 +
| 83
 +
| [pgpool-hackers: 2400] Garbage output
 +
| 2017/6/19
 +
|
 +
|Usama
 +
|
 +
| Follow up: [pgpool-hackers: 2798]
 +
|-style="background:yellow"
 +
| 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)
 +
|-style="background:yellow"
 +
| 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
 +
|-style="background:silver"
 +
| 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.
 +
|-style="background:silver"
 +
| 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.
 +
|-style="background:silver"
 +
| 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.
 +
|-style="background:silver"
 +
| 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
 +
|-style="background:white"
 +
| 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
 +
|-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"
 +
| 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)
 +
|-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"
 +
| 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
 +
|-style="background:silver"
 +
| 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
 +
|-style="background:pink"
 +
| 131
 +
| Logging client message
 +
| 2017/12/08
 +
|
 +
| Tatsuo
 +
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002638.html
 +
|
 +
|-style="background:silver"
 +
| 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.
 +
|-style="background:silver"
 +
| 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
 +
|-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"
 +
| 135
 +
| Modify pgpool.service to output log.
 +
| 2017/12/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"
 +
| 139
 +
| 0000373: pgpool failed over
 +
| 2017/12/21
 +
|
 +
| Tatsuo
 +
| http://www.pgpool.net/mantisbt/view.php?id=373
 +
| Waiting for feedback.-> no response. Closed.
 +
|-style="background:silver"
 +
| 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.
 +
|-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"
 +
| 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.
 +
|-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"
 +
| 207
 +
| Official Release
 +
|
 +
| 2018/10/17
 +
|
 +
|
 +
|
 +
|}

Revision as of 05:53, 5 October 2018

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)

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/8/10 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 2018/8/10 Peng https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html Done.
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
207 Official Release 2018/10/17