Difference between revisions of "pgpool-II 3.5 development"

From pgpool Wiki
Jump to: navigation, search
 
(42 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Last update: 2015/11/12 (gray items are done, yellow items are behind schedule)
+
Last update: 2016/2/15 (gray items are done, yellow items are behind schedule)
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 41: Line 41:
 
| pgpool-II 3.5 watchdog enhancement (test plan)
 
| pgpool-II 3.5 watchdog enhancement (test plan)
 
| Done
 
| Done
|-
+
|- style="background:silver"
 
| 1-5
 
| 1-5
 
| -
 
| -
Line 48: Line 48:
 
| Yugo
 
| Yugo
 
| pgpool-II 3.5 watchdog enhancement (review)
 
| pgpool-II 3.5 watchdog enhancement (review)
| In progress...will email Usama about comments and question for the watchdog code on Monday
+
| Done.
|-
+
|-style="background:silver"
 
| 1-6
 
| 1-6
 
| -
 
| -
 
| -
 
| -
| 2015/11/20
+
| 2015/12/04
 
| Yugo
 
| Yugo
| pgpool-II 3.5 watchdog enhancement (test)
+
| pgpool-II 3.5 watchdog test
| This task will get started from Monday 16/11 and it requires a week worth of testing.
+
| I assume all of the tests have been done.
 
|- style="background:silver"
 
|- style="background:silver"
|-
 
 
| 1-7
 
| 1-7
 
| -
 
| -
Line 65: Line 64:
 
| Tatsuo
 
| Tatsuo
 
| pgpool-II 3.5 ensure pgpool watchdog BF test case are passing
 
| pgpool-II 3.5 ensure pgpool watchdog BF test case are passing
| Usama is looking into this, he needs access to BF machine. It is passing on Usama's machine so seem like configuration or test case issue. So Tatsuo will look at this further
+
| Done (2015/11/26)
|-
+
|- style="background:silver"
 
| 1-8
 
| 1-8
 
| -
 
| -
Line 73: Line 72:
 
| Usama
 
| Usama
 
| pgpool-II 3.5 make the necessary changes to pgpool documentation for the new watchdog.
 
| pgpool-II 3.5 make the necessary changes to pgpool documentation for the new watchdog.
| This is mostly done...Usama need to make a few corrections..
+
| 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 106: 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:yellow"
+
|- style="background:silver"
 
| 5
 
| 5
 
| bug#135
 
| bug#135
Line 114: Line 121:
 
| delegate ip does not up
 
| 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.
 
| 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:white"
+
|- style="background:silver"
 
| 6
 
| 6
 
| bug#138
 
| bug#138
Line 122: Line 129:
 
| address already used
 
| address already used
 
| issue closed
 
| issue closed
|- style="background:yellow"
+
|- style="background:silver"
 
| 7
 
| 7
 
| bug#139
 
| bug#139
Line 129: Line 136:
 
| Usama
 
| Usama
 
| broken arping_cmd
 
| broken arping_cmd
| This is fixed and needed to be backpatched, it is committed in the 3.5 branch but needs to be back patched. Usama will do the back patch and update the ticket once watchdog testing is complete. This will be done by EOD Monday.
+
| This is fixed and back patched. Ticket is also updated.
 
|- style="background:silver"
 
|- style="background:silver"
 
| 8
 
| 8
Line 138: 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
Line 145: Line 152:
 
| Tatsuo
 
| Tatsuo
 
| Stuck connections
 
| Stuck connections
| Usama has sent the patch to Tatsuo for review...This is a issue in both pgpool version 3.4 and 3.5. This is a must-have
+
| This is committed to 3.4 and master. Done.
|- style="background:white"
+
|- style="background:silver"
 
| 10
 
| 10
 
| bug#141
 
| bug#141
Line 234: 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:yellow"
+
|- style="background:silver"
 
| 21
 
| 21
 
| pgpool-general:4006
 
| pgpool-general:4006
Line 266: 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
Line 282: Line 289:
 
| pgpoolAdmin
 
| pgpoolAdmin
 
| done (2015/10/14)
 
| done (2015/10/14)
|-
+
|- style="background:silver"
 
| 27
 
| 27
 
| bug#149
 
| bug#149
Line 290: Line 297:
 
| pgpoolAdmin
 
| pgpoolAdmin
 
| This one is fixed.
 
| This one is fixed.
|-
+
|--style="background:silver"
 
| 28
 
| 28
 
| bug#151
 
| bug#151
Line 297: Line 304:
 
| Tatsuo
 
| Tatsuo
 
| pgpoolAdmin
 
| pgpoolAdmin
| assigned
+
| Fix committed by Usama
|- style="background:yellow"
+
|-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
Line 321: Line 328:
 
| Yugo
 
| Yugo
 
| 3.5 alpha 1
 
| 3.5 alpha 1
| assigned, will be released on Monday.
+
| 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/30
+
| 2015/12/14
 
| Yugo
 
| Yugo
 
| 3.5 beta 1
 
| 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
| assigned
+
| delayed to 2016/1/29
|-
+
|-style="background:silver"
 
| 30-4
 
| 30-4
 
| pgpool-II 3.5 release note
 
| pgpool-II 3.5 release note
 
| 2015/10/30
 
| 2015/10/30
| 2015/11/30
+
| 2015/12/14
 
| Yugo
 
| Yugo
 
| shipped with beta1
 
| shipped with beta1
 
| assigned
 
| assigned
|-
+
|-style="background:silver"
 
|31
 
|31
 
| pgpool_adm
 
| pgpool_adm
 
| 2015/10/26
 
| 2015/10/26
| 2015/12/15
+
| 2015/12/14
|  
+
| Tatsuo
 
| there's no docs/regression tests for pgpool_adm
 
| there's no docs/regression tests for pgpool_adm
| not assigned
+
| Done except a regression test. I don't see particular reason we need to add the test.
|-
+
|-style="background:silver"
 
|32
 
|32
 
| CentOS7 RPM issues ([pgpool-hackers: 1124])
 
| CentOS7 RPM issues ([pgpool-hackers: 1124])
 
| 2015/10/27
 
| 2015/10/27
| 2015/12/15
+
| 2015/12/14
 
|  
 
|  
 
| peer auth, socketdir
 
| peer auth, socketdir
 
| not assigned
 
| not assigned
|-
+
|- style="background:silver"
 
|33
 
|33
 
| New feature wiki
 
| New feature wiki
Line 369: Line 376:
 
| Ahsan, Usama and Tatsuo
 
| Ahsan, Usama and Tatsuo
 
| Write articles about 3.5 new features on the wiki page
 
| Write articles about 3.5 new features on the wiki page
| Watchdog part (Ahsan, Usama), rest of all (Tatsuo)
+
| Watchdog part (Ahsan, Usama), rest of all (Tatsuo - done)
 
|- style="background:silver"
 
|- style="background:silver"
 
|34
 
|34
Line 378: Line 385:
 
| [pgpool-general: 4163] "Heartbeat random fails between pgpool instances"
 
| [pgpool-general: 4163] "Heartbeat random fails between pgpool instances"
 
| done (2015/11/04)
 
| 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