Difference between revisions of "pgpool-II 3.5 development"

From pgpool Wiki
Jump to: navigation, search
 
(70 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Last update: 2015/10/22
+
Last update: 2016/2/15 (gray items are done, yellow items are behind schedule)
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 25: Line 25:
 
| pgpool-II 3.5 watchdog enhancement (documentation)
 
| pgpool-II 3.5 watchdog enhancement (documentation)
 
| done (2015/10/22)
 
| done (2015/10/22)
|- style="background:yellow"
+
|- style="background:silver"
 
| 1-3
 
| 1-3
 
| -
 
| -
 
| -
 
| -
| 2015/10/22
+
| 2015/11/02
 
| Usama
 
| Usama
 
| pgpool-II 3.5 watchdog enhancement (commit to master branch)
 
| pgpool-II 3.5 watchdog enhancement (commit to master branch)
| not started
+
| done (2015/10/30)
|- style="background:yellow"
+
|- style="background:silver"
 
| 1-4
 
| 1-4
 
| -
 
| -
 
| -
 
| -
| 2015/10/23
+
| 2015/11/06
 
| Usama, Ahsan
 
| Usama, Ahsan
 
| pgpool-II 3.5 watchdog enhancement (test plan)
 
| pgpool-II 3.5 watchdog enhancement (test plan)
| not started - Ahsan will provide his thoughts by 21 and then Usama will spend one day on it
+
| Done
|-
+
|- style="background:silver"
 
| 1-5
 
| 1-5
 
| -
 
| -
 
| -
 
| -
| 2015/10/28
+
| 2015/11/13
 +
| Yugo
 +
| pgpool-II 3.5 watchdog enhancement (review)
 +
| Done.
 +
|-style="background:silver"
 +
| 1-6
 +
| -
 +
| -
 +
| 2015/12/04
 
| Yugo
 
| Yugo
| pgpool-II 3.5 watchdog enhancement (test and review)
+
| pgpool-II 3.5 watchdog test
| not started
+
| I assume all of the tests have been done.
 +
|- style="background:silver"
 +
| 1-7
 +
| -
 +
| -
 +
| 2015/11/16
 +
| Tatsuo
 +
| pgpool-II 3.5 ensure pgpool watchdog BF test case are passing
 +
| Done (2015/11/26)
 +
|- style="background:silver"
 +
| 1-8
 +
| -
 +
| -
 +
| 2015/11/15
 +
| Usama
 +
| pgpool-II 3.5 make the necessary changes to pgpool documentation for the new watchdog.
 +
| Done. Usama has committed the documentation changes.
 +
|-style="background:silver"
 +
| 1-9
 +
| -
 +
| -
 +
| 2015/12/04
 +
| Usama
 +
| pgpool-II 3.5 -  Fix all the must-have watchdog issues raised by Yugo as part of his watchdog code review and testing.
 +
| Their are two watchdog issues remaining to the be fixed. Usama is currently working on the watchdog issue related to unplugging the network cable from a pgpool node that is part of the watchdog cluster. The solution that we are considering so far is the isolated node killing itself when it becomes isolated from the cluster for a certain period of time. This seems like a quick and easy solution but we are doing more research to find a more amicable solution. The second issue which is not as high priority is code clean-up, some code refactoring and adding more comments to the code. The goal is to have these issues completed before release candidate.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 2
 
| 2
Line 81: Line 113:
 
| remove Parallel query for pgpool-II 3.5
 
| remove Parallel query for pgpool-II 3.5
 
| done (2015/08/25)
 
| done (2015/08/25)
|-
+
|- style="background:silver"
 
| 5
 
| 5
 
| bug#135
 
| bug#135
 
| 2015/05/20
 
| 2015/05/20
| 2015/10/28
+
| 2015/11/13
 
| Usama
 
| Usama
 
| delegate ip does not up
 
| delegate ip does not up
| assigned
+
| This issue is fixed in the new version of watchdog but it can't be back patched to previous versions of watchdog. Usama will update the ticket today.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 6
 
| 6
Line 97: Line 129:
 
| address already used
 
| address already used
 
| issue closed
 
| issue closed
|-
+
|- style="background:silver"
 
| 7
 
| 7
 
| bug#139
 
| bug#139
 
| 2015/07/17
 
| 2015/07/17
| 2015/10/28
+
| 2015/11/16
 
| Usama
 
| Usama
 
| broken arping_cmd
 
| broken arping_cmd
| assigned
+
| This is fixed and back patched. Ticket is also updated.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 8
 
| 8
Line 113: Line 145:
 
| inconsistent sequence in replication mode
 
| inconsistent sequence in replication mode
 
| done (2015/8/19)
 
| done (2015/8/19)
|- style="background:silver"
+
|-style="background:silver"
 
| 9
 
| 9
 
| bug#124
 
| bug#124
 
| 2015/07/29
 
| 2015/07/29
| -
+
| 2015/11/16
| Usama
+
| Tatsuo
 
| Stuck connections
 
| Stuck connections
| done (2015/8/18)
+
| This is committed to 3.4 and master. Done.
|-
+
|- style="background:silver"
 
| 10
 
| 10
 
| bug#141
 
| bug#141
Line 128: Line 160:
 
| Usama
 
| Usama
 
| watchdog
 
| watchdog
| assigned
+
| Usama tested this by kept the watchdog running for long hrs and didn't find this issue. So Issue is not reproducible so we need to close this issue.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 11
 
| 11
Line 137: Line 169:
 
| unexpected rollback
 
| unexpected rollback
 
| closed
 
| closed
|-
+
|- style="background:yellow"
 
| 12
 
| 12
 
| pgpool-general:3907
 
| pgpool-general:3907
Line 144: Line 176:
 
| Usama
 
| Usama
 
| watchdog info
 
| watchdog info
| assigned
+
| It is a not a bug so need to reply back to user. This is not a priority.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 13
 
| 13
Line 209: Line 241:
 
| mesuring pgpool-II overhead
 
| mesuring pgpool-II overhead
 
| in progress, Tatsuo will review the result, postpone to 3.6
 
| in progress, Tatsuo will review the result, postpone to 3.6
|-
+
|- style="background:silver"
 
| 21
 
| 21
 
| pgpool-general:4006
 
| pgpool-general:4006
Line 216: Line 248:
 
| Nozomi
 
| Nozomi
 
| pgpoolAdmin (How to start pgpool-II after reboot)
 
| pgpoolAdmin (How to start pgpool-II after reboot)
| assigned
+
| Fixed and also responded to the user.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 22
 
| 22
Line 241: Line 273:
 
| deal with pg_terminate_backend
 
| deal with pg_terminate_backend
 
| need to assign or expecting patches from user, postpone to 3.6
 
| need to assign or expecting patches from user, postpone to 3.6
|- style="background:yellow"
+
|- style="background:silver"
 
| 25
 
| 25
 
| pgpool-hackers:1035
 
| pgpool-hackers:1035
 
| 2015/09/03
 
| 2015/09/03
| 2015/10/23
+
| 2015/11/02
 
| Yugo
 
| Yugo
 
| enhance buildfarm
 
| enhance buildfarm
| assigned
+
| This task is finished, we can close this.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 26
 
| 26
Line 257: Line 289:
 
| pgpoolAdmin
 
| pgpoolAdmin
 
| done (2015/10/14)
 
| done (2015/10/14)
|-
+
|- style="background:silver"
 
| 27
 
| 27
 
| bug#149
 
| bug#149
Line 264: Line 296:
 
| Nozomi
 
| Nozomi
 
| pgpoolAdmin
 
| pgpoolAdmin
| assigned
+
| This one is fixed.
|-
+
|--style="background:silver"
 
| 28
 
| 28
 
| bug#151
 
| bug#151
 
| 2015/10/13
 
| 2015/10/13
 
| -
 
| -
| Nozomi
+
| Tatsuo
 
| pgpoolAdmin
 
| pgpoolAdmin
| assigned
+
| Fix committed by Usama
|-
+
|-style="background:silver"
 
| 29-1
 
| 29-1
 
| pgpoolAdmin
 
| pgpoolAdmin
 
| 2015/10/25
 
| 2015/10/25
| 2015/10/31
+
| 2015/12/09
 
| Nozomi
 
| Nozomi
 
| pgpoolAdmin (adopt to new pcp command usage)
 
| pgpoolAdmin (adopt to new pcp command usage)
| in progress
+
| Done (2015/12/08)
|-
+
|--style="background:silver"
 
| 29-2
 
| 29-2
 
| pgpoolAdmin
 
| pgpoolAdmin
 
| 2015/10/31
 
| 2015/10/31
| 2015/11/20
+
| 2015/12/14
 
| Nozomi
 
| Nozomi
 
| pgpoolAdmin 3.5 beta1
 
| pgpoolAdmin 3.5 beta1
 
| assigned
 
| assigned
|-
+
|-style="background:silver"
 
| 30-1
 
| 30-1
 
| pgpool-II 3.5
 
| pgpool-II 3.5
 
| 2015/10/23
 
| 2015/10/23
| 2015/11/02
+
| 2015/11/16
 
| Yugo
 
| Yugo
| 3.5 alpha1
+
| 3.5 alpha 1
| assigned
+
| assigned, will be released on Monday. Done.
|-
+
|--style="background:silver"
 
| 30-2
 
| 30-2
 
| pgpool-II 3.5
 
| pgpool-II 3.5
 
| 2015/11/02
 
| 2015/11/02
| 2015/11/23
+
| 2015/12/14
 
| Yugo
 
| Yugo
| 3.5 beta1
+
| 3.5 beta 1
 
| assigned
 
| assigned
|-
+
|- style="background:silver"
 
| 30-3
 
| 30-3
 
| pgpool-II 3.5
 
| pgpool-II 3.5
 
| 2015/11/23
 
| 2015/11/23
| 2015/12/15
+
| 2016/01/15
 
| Yugo
 
| Yugo
 
| 3.5.0 official release
 
| 3.5.0 official release
 +
| delayed to 2016/1/29
 +
|-style="background:silver"
 +
| 30-4
 +
| pgpool-II 3.5 release note
 +
| 2015/10/30
 +
| 2015/12/14
 +
| Yugo
 +
| shipped with beta1
 
| assigned
 
| assigned
 +
|-style="background:silver"
 +
|31
 +
| pgpool_adm
 +
| 2015/10/26
 +
| 2015/12/14
 +
| Tatsuo
 +
| there's no docs/regression tests for pgpool_adm
 +
| Done except a regression test. I don't see particular reason we need to add the test.
 +
|-style="background:silver"
 +
|32
 +
| CentOS7 RPM issues ([pgpool-hackers: 1124])
 +
| 2015/10/27
 +
| 2015/12/14
 +
|
 +
| peer auth, socketdir
 +
| not assigned
 +
|- style="background:silver"
 +
|33
 +
| New feature wiki
 +
| 2015/10/30
 +
| 2015/11/20
 +
| Ahsan, Usama and Tatsuo
 +
| Write articles about 3.5 new features on the wiki page
 +
| Watchdog part (Ahsan, Usama), rest of all (Tatsuo - done)
 +
|- style="background:silver"
 +
|34
 +
| Watchdog bug?
 +
| 2015/11/04
 +
| 2015/11/06
 +
| Yugo
 +
| [pgpool-general: 4163] "Heartbeat random fails between pgpool instances"
 +
| done (2015/11/04)
 +
|-style="background:silver"
 +
|35
 +
| pgpool startup mechanism
 +
|
 +
| 2015/12/04
 +
| Usama
 +
| Changes to startup mechanism of pgpool
 +
| In progress
 +
|- style="background:silver"
 +
|36
 +
| Chinese docs and pgpoolAdmin message catalog
 +
|
 +
| 2016/01/15
 +
| Bambo Hunga, Bo Peng
 +
|
 +
| In progress
 +
|- style="background:silver"
 +
|37
 +
| Add Chinese translation for new watchdog parameter doc
 +
|
 +
| 2016/01/29
 +
| Bo Peng
 +
|
 +
| In progress
 +
|- style="background:silver"
 +
|38
 +
| Add Japanese translation for new watchdog parameter doc
 +
|
 +
| 2016/01/29
 +
| Yugo
 +
|
 +
| In progress
 +
|- style="background:silver"
 +
|39
 +
| Add new watchdog parameter to pgpoolAdmin and translate Japanese message catalog
 +
|
 +
| 2016/01/29
 +
| Nozomi
 +
|
 +
| In progress
 +
|- style="background:silver"
 +
|40
 +
| Translate new watchdog parameter in pgpoolAdmin for Chinese
 +
|
 +
| 2016/01/29
 +
| Bo Peng
 +
|
 +
| In progress
 +
|- style="background:silver"
 +
|41
 +
| Fix JDBC regression test occasional failure
 +
|
 +
| 2016/01/29
 +
| Tatsuo
 +
|
 +
| In progress
 
|}
 
|}

Latest revision as of 04:43, 15 February 2016

Last update: 2016/2/15 (gray items are done, yellow items are behind schedule)

ID Registered/start Date Target Date Person in charge Overview Status
1-1 - - 2015/10/20 Usama pgpool-II 3.5 watchdog enhancement (dev branch commit) done (2015/10/19)
1-2 - - 2015/10/21 Usama pgpool-II 3.5 watchdog enhancement (documentation) done (2015/10/22)
1-3 - - 2015/11/02 Usama pgpool-II 3.5 watchdog enhancement (commit to master branch) done (2015/10/30)
1-4 - - 2015/11/06 Usama, Ahsan pgpool-II 3.5 watchdog enhancement (test plan) Done
1-5 - - 2015/11/13 Yugo pgpool-II 3.5 watchdog enhancement (review) Done.
1-6 - - 2015/12/04 Yugo pgpool-II 3.5 watchdog test I assume all of the tests have been done.
1-7 - - 2015/11/16 Tatsuo pgpool-II 3.5 ensure pgpool watchdog BF test case are passing Done (2015/11/26)
1-8 - - 2015/11/15 Usama pgpool-II 3.5 make the necessary changes to pgpool documentation for the new watchdog. Done. Usama has committed the documentation changes.
1-9 - - 2015/12/04 Usama pgpool-II 3.5 - Fix all the must-have watchdog issues raised by Yugo as part of his watchdog code review and testing. Their are two watchdog issues remaining to the be fixed. Usama is currently working on the watchdog issue related to unplugging the network cable from a pgpool node that is part of the watchdog cluster. The solution that we are considering so far is the isolated node killing itself when it becomes isolated from the cluster for a certain period of time. This seems like a quick and easy solution but we are doing more research to find a more amicable solution. The second issue which is not as high priority is code clean-up, some code refactoring and adding more comments to the code. The goal is to have these issues completed before release candidate.
2 - - 2015/09/25 Tatsuo pgpool-II 3.5 extended protocol performance done (2015/09/24)
3-1 - 2015/08/12 2015/10/12 Yugo Import PostgreSQL 9.5 parser for pgpool-II 3.5 (commit to master branch) done (2015/10/13)
3-2 - 2015/10/13 2015/10/19 Yugo Import PostgreSQL 9.5 parser for pgpool-II 3.5 (pass regression tests, fix compile errors and coverity issues done (2015/10/20)
4 - 2015/08/12 - Yugo remove Parallel query for pgpool-II 3.5 done (2015/08/25)
5 bug#135 2015/05/20 2015/11/13 Usama delegate ip does not up This issue is fixed in the new version of watchdog but it can't be back patched to previous versions of watchdog. Usama will update the ticket today.
6 bug#138 2015/07/19 - Tatsuo address already used issue closed
7 bug#139 2015/07/17 2015/11/16 Usama broken arping_cmd This is fixed and back patched. Ticket is also updated.
8 pgpool-general:3894 - 2015/07/24 Yugo inconsistent sequence in replication mode done (2015/8/19)
9 bug#124 2015/07/29 2015/11/16 Tatsuo Stuck connections This is committed to 3.4 and master. Done.
10 bug#141 2015/08/13 2015/10/28 Usama watchdog Usama tested this by kept the watchdog running for long hrs and didn't find this issue. So Issue is not reproducible so we need to close this issue.
11 pgpool-general:3908 2015/08/02 - Yugo unexpected rollback closed
12 pgpool-general:3907 2015/08/02 2015/10/28 Usama watchdog info It is a not a bug so need to reply back to user. This is not a priority.
13 pgpool-general:3922 2015/08/06 - Tatsuo pgpool_status+fsync done
14 pgpool-general:3923 2015/08/06 - Tatsuo pgpool_status needs discussion, postpone to 3.6
15 bug#142 2015/08/14 - Yugo rpm done (2015/8/20)
16 bug#143 2015/08/14 - Yugo test done (2015/8/20)
17 pgpool-general:3944 2015/08/10 - Tatsuo serializing accept(2) done (2015/10/04)
18 pgpool-hackers:994 2015/08/05 - Tatsuo connect to necessary DB nodes proposal, feedback, postpone to 3.6
19 pgpool-hackers:995 2015/08/05 - Tatsuo allow to specify health check and replication delay check DB done (2015/10/03)
20 pgpool:330 2015/08/12 - Ahsan, Tatsuo mesuring pgpool-II overhead in progress, Tatsuo will review the result, postpone to 3.6
21 pgpool-general:4006 2015/08/27 2015/10/30 Nozomi pgpoolAdmin (How to start pgpool-II after reboot) Fixed and also responded to the user.
22 pgpool:406 2015/09/01 - Yugo document bug done (2015/09/04)
23 pgpool-hackers:1034 2015/09/03 - - add new child if it goes down need to assign, postpone to 3.6
24 pgpool-general:4016 2015/09/02 - - deal with pg_terminate_backend need to assign or expecting patches from user, postpone to 3.6
25 pgpool-hackers:1035 2015/09/03 2015/11/02 Yugo enhance buildfarm This task is finished, we can close this.
26 bug#148 2015/10/13 - Nozomi pgpoolAdmin done (2015/10/14)
27 bug#149 2015/10/13 - Nozomi pgpoolAdmin This one is fixed.
28 bug#151 2015/10/13 - Tatsuo pgpoolAdmin Fix committed by Usama
29-1 pgpoolAdmin 2015/10/25 2015/12/09 Nozomi pgpoolAdmin (adopt to new pcp command usage) Done (2015/12/08)
29-2 pgpoolAdmin 2015/10/31 2015/12/14 Nozomi pgpoolAdmin 3.5 beta1 assigned
30-1 pgpool-II 3.5 2015/10/23 2015/11/16 Yugo 3.5 alpha 1 assigned, will be released on Monday. Done.
30-2 pgpool-II 3.5 2015/11/02 2015/12/14 Yugo 3.5 beta 1 assigned
30-3 pgpool-II 3.5 2015/11/23 2016/01/15 Yugo 3.5.0 official release delayed to 2016/1/29
30-4 pgpool-II 3.5 release note 2015/10/30 2015/12/14 Yugo shipped with beta1 assigned
31 pgpool_adm 2015/10/26 2015/12/14 Tatsuo there's no docs/regression tests for pgpool_adm Done except a regression test. I don't see particular reason we need to add the test.
32 CentOS7 RPM issues ([pgpool-hackers: 1124]) 2015/10/27 2015/12/14 peer auth, socketdir not assigned
33 New feature wiki 2015/10/30 2015/11/20 Ahsan, Usama and Tatsuo Write articles about 3.5 new features on the wiki page Watchdog part (Ahsan, Usama), rest of all (Tatsuo - done)
34 Watchdog bug? 2015/11/04 2015/11/06 Yugo [pgpool-general: 4163] "Heartbeat random fails between pgpool instances" done (2015/11/04)
35 pgpool startup mechanism 2015/12/04 Usama Changes to startup mechanism of pgpool In progress
36 Chinese docs and pgpoolAdmin message catalog 2016/01/15 Bambo Hunga, Bo Peng In progress
37 Add Chinese translation for new watchdog parameter doc 2016/01/29 Bo Peng In progress
38 Add Japanese translation for new watchdog parameter doc 2016/01/29 Yugo In progress
39 Add new watchdog parameter to pgpoolAdmin and translate Japanese message catalog 2016/01/29 Nozomi In progress
40 Translate new watchdog parameter in pgpoolAdmin for Chinese 2016/01/29 Bo Peng In progress
41 Fix JDBC regression test occasional failure 2016/01/29 Tatsuo In progress