Difference between revisions of "pgpool-II 3.6 development"

From pgpool Wiki
Jump to: navigation, search
Line 56: Line 56:
 
| Usama
 
| Usama
 
| deal with pg_terminate_backend
 
| deal with pg_terminate_backend
| [beta] in progress need to assign or expecting patches from user, postpone to 3.6
+
| [3.6 beta] in progress need to assign or expecting patches from user, postpone to 3.6
 
|-
 
|-
 
| 7
 
| 7
Line 64: Line 64:
 
| Peng
 
| Peng
 
|  
 
|  
| [beta] [In progress] Will start after PostgreSQL 9.6 beta released
+
| [3.6 beta] [In progress] Will start after PostgreSQL 9.6 beta released
 
|-style="background:silver"
 
|-style="background:silver"
 
| 8
 
| 8
Line 80: Line 80:
 
| Usama
 
| Usama
 
| Tool set porting work time estimate
 
| Tool set porting work time estimate
| [master] Estimating work hours to determine the shedule. He estimated as "3.5D".
+
| [3.6 beta] Estimating work hours to determine the shedule. He estimated as "3.5D".
 
|- style="background:silver"
 
|- style="background:silver"
 
| 9-2
 
| 9-2
Line 88: Line 88:
 
| Usama
 
| Usama
 
| Tool set porting
 
| Tool set porting
| [beta] PostgreSQL docs trees are ported as well. Confirmed to be able to generate HTML files
+
| [3.6 beta] PostgreSQL docs trees are ported as well. Confirmed to be able to generate HTML files
 
|- style="background:silver"
 
|- style="background:silver"
 
| 9-3
 
| 9-3
Line 96: Line 96:
 
| Tatsuo
 
| Tatsuo
 
| Prune PostgreSQL's SGML files to prepare for creating pgpool-II docs
 
| Prune PostgreSQL's SGML files to prepare for creating pgpool-II docs
| [beta]  
+
| [3.6 beta]  
 
|-
 
|-
 
| 9-4
 
| 9-4
Line 104: Line 104:
 
| Tatsuo, Peng, Usama
 
| Tatsuo, Peng, Usama
 
| Create/migrate actual pgpool-II document in SGML format
 
| Create/migrate actual pgpool-II document in SGML format
| [beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/
+
| [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/
 
|-
 
|-
 
| 9-5
 
| 9-5
Line 112: Line 112:
 
| Tatsuo
 
| Tatsuo
 
| Create/migrate actual pgpool-II document in SGML format
 
| Create/migrate actual pgpool-II document in SGML format
| [beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Preface, Tutorial.Getting Started, Server Administration.pgpool-II Installation from Source Code, Server Administration.Server Setup and Operation
+
| [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Preface, Tutorial.Getting Started, Server Administration.pgpool-II Installation from Source Code, Server Administration.Server Setup and Operation
 
|-
 
|-
 
| 9-6
 
| 9-6
Line 120: Line 120:
 
| Usama
 
| Usama
 
| Create/migrate actual pgpool-II document in SGML format
 
| Create/migrate actual pgpool-II document in SGML format
| [beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Tutorial.Watchdog, Server Administration.Server Configuration, Server Administration.Client Authentication, Examples
+
| [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Tutorial.Watchdog, Server Administration.Server Configuration, Server Administration.Client Authentication, Examples
 
|-
 
|-
 
| 9-7
 
| 9-7
Line 128: Line 128:
 
| Pengbo
 
| Pengbo
 
| Create/migrate actual pgpool-II document in SGML format
 
| Create/migrate actual pgpool-II document in SGML format
| [beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Reference
+
| [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Reference
 
|- style="background:white"
 
|- style="background:white"
 
| 10
 
| 10
Line 533: Line 533:
 
| Tatsuo
 
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=209
 
| http://www.pgpool.net/mantisbt/view.php?id=209
| [beta] assigned
+
| [3.6 beta] assigned
 
|-style="background:silver"
 
|-style="background:silver"
 
| 60
 
| 60
Line 557: Line 557:
 
| Usama
 
| Usama
 
| http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004819.html  
 
| http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004819.html  
| [beta]  assigned
+
| [3.6 beta]  assigned
 
|-
 
|-
 
| 63
 
| 63
Line 581: Line 581:
 
| Usama
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=215
 
| http://www.pgpool.net/mantisbt/view.php?id=215
| [beta] waiting for feedback
+
| [3.6 beta] waiting for feedback
 
|-
 
|-
 
| 66
 
| 66
Line 597: Line 597:
 
| Tatsuo
 
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=225
 
| http://www.pgpool.net/mantisbt/view.php?id=225
| feedback
+
| [3.6 beta] feedback
 
|-
 
|-
 
| 68
 
| 68

Revision as of 07:52, 2 August 2016

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

ID Registered/start Date Target Date Person in charge Overview Status
1 pgpool-general:3907 2015/08/02 2015/10/28 Usama watchdog info Done in [pgpool-general: 4452]
2 pgpool-general:3923 2015/08/06 2016/07/08 Tatsuo pgpool_status needs discussion, postpone to 3.6. Usama will review this until 12 June. follow up by Usama in [pgpool-general: 4721] http://www.pgpool.net/pipermail/pgpool-general/2016-June/004779.html -- done on 2016/07/12
3 pgpool-hackers:994 2015/08/05 2016/5/13 Tatsuo connect to necessary DB nodes proposal, feedback, postpone to 3.6, strongly connected to item 11.--> Not necessary any more.
4 pgpool:330 2015/08/12 2016/06/17 Ahsan, Tatsuo mesuring pgpool-II overhead [in progress] Tatsuo will review the result, postpone to 3.6
5 pgpool-hackers:1034 2015/09/03 - - add new child if it goes down need to assign, postpone to 3.6
6 pgpool-general:4016 2015/09/02 2016/08/11 Usama deal with pg_terminate_backend [3.6 beta] in progress need to assign or expecting patches from user, postpone to 3.6
7 Import PostgreSQL 9.6 parser 2016/2/15 2016/8/31 Peng [3.6 beta] [In progress] Will start after PostgreSQL 9.6 beta released
8 Add SET command 2016/2/15 2016/5/19 Usama - Add set command to configure session level configuraiton pgpool paramaeters. Change the pgpool load balance parameter on the fly. Done on 2016/5/21.
9-1 Convert the pgpool documentation to SGML 2016/2/15 2016/2/15 Usama Tool set porting work time estimate [3.6 beta] Estimating work hours to determine the shedule. He estimated as "3.5D".
9-2 Convert the pgpool documentation to SGML 2016/2/16 2016/2/19 Usama Tool set porting [3.6 beta] PostgreSQL docs trees are ported as well. Confirmed to be able to generate HTML files
9-3 Convert the pgpool documentation to SGML 2016/2/26 2016/2/29 Tatsuo Prune PostgreSQL's SGML files to prepare for creating pgpool-II docs [3.6 beta]
9-4 Convert the pgpool documentation to SGML 2016/2/27 2016/8/31 Tatsuo, Peng, Usama Create/migrate actual pgpool-II document in SGML format [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/
9-5 Convert the pgpool documentation to SGML (Tatsuo) 2016/6/6 2016/8/31 Tatsuo Create/migrate actual pgpool-II document in SGML format [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Preface, Tutorial.Getting Started, Server Administration.pgpool-II Installation from Source Code, Server Administration.Server Setup and Operation
9-6 Convert the pgpool documentation to SGML (Usama) 2016/6/6 2016/8/31 Usama Create/migrate actual pgpool-II document in SGML format [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Tutorial.Watchdog, Server Administration.Server Configuration, Server Administration.Client Authentication, Examples
9-7 Convert the pgpool documentation to SGML (Pengbo) 2016/6/6 2016/8/31 Pengbo Create/migrate actual pgpool-II document in SGML format [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Reference
10 Make PCP set configuration command public 2016/2/15 - Usama - Low priority
11 Keep current session alive in-case of failover 2016/2/15 2016/5/13 Tatsuo http://www.pgpool.net/pipermail/pgpool-hackers/2016-March/001452.html Proposal already posted. At this point pcp_detach_node does not break in certain cases (load balance node is not detached)
12 Yet another stuck connection problem 2016/2/19 2016/2/23 Usama pgpool-general: 4457
13 Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS 2016/2/26 Usama Will do after #8 and #8 are finished
14 Allow to use multiple pgpool-II instances with in-memory query cache enabled 2016/3/4 http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_pg_rewind_in_online_recovery Low priority
15 Health-check timeout for each backend node 2016/3/4 http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node Low priority
16 Worker Processes Exit and Are Not Re-spawned 2016/3/7 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-March/004577.html
17 Extended query hangs 2016/2/22 2016/3/27 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=167 Fix confirmed (2016/3/30).
18 Buildfarm not working 2016/3/16 Yugo Should be fixed as soon as possible. It turned out that it was caused by disk full.
19 failback_command finishes,pgpool-II DONNOT restart all child processes 2016/3/18 Usama http://www.pgpool.net/mantisbt/view.php?id=172
20 pgpool child processes exit unexpectedly and don't restart after online recovery of a standby node 2016/3/18 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=174
21 find_primay_node fails to find the primary node 2016/3/22 Tatsuo pgpool-general: 4560 Waiting for feedback but no response since 2016/3/30. So close this now...
22 kind mismatch among backends with COMMIT; 2016/3/23 Usama pgpool-general: 4565 Waiting for feedback.-> no reply since 2016/3/24. Closed
23 Error with JDBC memory_cache_enabled = on 2016/3/22 2016/5/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=152 resolved on 2016/5/21
24 Enironment Variable PG_CONFIG Ignored 2016/3/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=178 Topic not suitable for Mantis because it's not related to a bug. I suggested the reporter to move to mailing list.
25 Run Continuously attaching two degenerate backend,the second backend WILLNOT SUCCESS 2016/3/23 Usama http://www.pgpool.net/mantisbt/view.php?id=179 Responded back, nothing to be done for that
26 regression test failure with 004.watchdog 2016/3/22 Usama The test fails Ubuntu after commit:http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e55c230d674ea221c09e8266a68d119f1a3a2dac Usama found that this was caused my race condition while writing to a log file. Tatsuo fixed this by redirecting process output to cat command.
27 Pgpool child hangs with full cpu load after permission error message from backend 2016/3/24 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=182 Already fixed in 3.5 stable tree?->Fix confirmed on 2016/3/29
28 Online recovery: existing connections did not close in 90 sec. 2016/3/23 2016/4/30 Tatsuo pgpool-II 3.3.6, client_idle_limit_in_recovery = -1 doesn't work (pgpool-general: 4570) [in progress]
29 Pgppol not sending query error back to client 2016/3/25 2016/6/21 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=183 [in progress] Already fixed in 3.5 stable tree? Waiting for feedback->Confirmed on 2016/3/28
30 PGPoolII-3.5 : segfault during pcp_recovery 2016/3/23 2016/4/4 Usama pgpool-general: 4569 fixed commit:http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=64696fd839da70e6fd8daacd73da11b6e8a1f1c9
31 pgpool-II minor releases 2016/4/4 Yugo pgpool-II 3.5.1, 3.4.5, 3.3.9, 3.2.14, 3.1.17, pgpoolAdmin 3.5.1
32 plugs out the network cable,the pgpool will not work。 2016/3/28 Usama http://www.pgpool.net/mantisbt/view.php?id=185
33 Hibernate + Pgpool-II Connection Failure 2016/3/18 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=175 Fix confirmed (in 3.5.1)
34 What is the execution order of ‘follow_master_command' and 'failover_command'? 2016/3/19 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=176 Waiting for feedback -> No feedback for a month. Close now...
35 Pgpool stops accepting connections when Postgresql slave goes down 2016/3/20 Usama http://www.pgpool.net/mantisbt/view.php?id=177 Should be already fixed. [pgpool-hackers: 1531]
36 pcp_proc_count truncates PIDs over 5 characters long 2016/4/6 2016/4/20 Peng http://www.pgpool.net/mantisbt/view.php?id=188 fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=bd11fcf420fe0e9cd1705673b0594aab39307cb9
37 pgpool web console gets pgpool.conf parameters incorrectly 2016/4/7 Nozomi http://www.pgpool.net/mantisbt/view.php?id=158 assigned [Pgpool:1102] Bug 158-->assign changed to Nozomi because this is an pgpoolAdmin issue
38 Always PostgreSQL1 node is down frequently from PGpool console 2016/4/7 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=161 feedback--> No response over one month. Closed.
39 Connections not released if client exit ungracefully 2016/4/7 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=163 feedback--> No response over one month. Closed.
40 pcp_* functions call interface changed in pgpool 3.5 but pgpooladmin use old call mechanism 2016/4/7 2016/4/11 Nozomi http://www.pgpool.net/mantisbt/view.php?id=187 fix committed
41 kind mismatch error on master_slave_mode=on / load_lalance_mode=off 2016/4/8 2016/4/15 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=189 fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=a3227199ddb688c54d8170c2f12f14cf041a43ab
42 PgPool hangs in load balance mode, when using JDBC driver and sending empty query 2016/4/11 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=190 fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=a5fdf78e6e86c5a8a1d4ce5b1eb273a59f5ecfb9
43 pgpool-II shouldn't forward set default_transaction_isolation to 'serializable' to Hot Standby slaves 2016/4/14 2016/5/09 Peng http://www.pgpool.net/mantisbt/view.php?id=191 fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f97aa57fa89bd5c57dafb74f07e5531009d2391c
44 kind does not match error in pgpool [pgpool-hackers:1501] 2016/4/20 2016/7/15 Usama http://www.pgpool.net/pipermail/pgpool-hackers/2016-April/001501.html fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=866575c8fe89da2127a6c1bb19746b03b61bbfd4
45 ERROR: unable to read data from frontend [pgpool-general: 4662] 2016/5/9 2016/5/11 Yugo http://www.sraoss.jp/pipermail/pgpool-general/2016-May/004720.html The problem isn't reproducable. [Pgpool:1248]
46 pgpool error with PAM [pgpool-general: 4670] 2016/5/10 2016/5/11 Yugo http://www.sraoss.jp/pipermail/pgpool-general/2016-May/004728.html No response yet. [Pgpool:1248]
47 New Defects reported by Coverity Scan for pgpool-II [Pgpool:1227] 2016/5/11 2016/06/21 Usama [Pgpool:1227] changes committed waiting for new scan
48 "statement timeout" causes kind mismatch errors 2016/5/16 t-ishii http://www.pgpool.net/mantisbt/view.php?id=194 fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=efb2162215f0a99103a49c0094da825640ff036f
49 pgpool routes queries with "SET TRANSACTION READ ONLY" to master 2016/5/18 2016/6/30 t-ishii http://www.pgpool.net/mantisbt/view.php?id=195 low priority
50 pgpool hangs connections to database when interface of standby/second backend 2016/5/23 2016/6/10 Usama http://www.pgpool.net/mantisbt/view.php?id=197 fixed git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=6ae42e74d48391b8cfaa97927e00bd65aec68fe8
51 Connections stuck - Recv-Q fills up 2016/6/2 2016/7/26 Usama http://www.pgpool.net/mantisbt/view.php?id=203 in progress
52 healthcheck get stuck 2016/6/2 2016/6/10 Yugo http://www.pgpool.net/mantisbt/view.php?id=204 fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=634c1d6c01234b773002ceb763eeba4bc6b83206
53 failed to create INET domain socket 2016/6/2 2016/8/15 pengbo http://www.pgpool.net/mantisbt/view.php?id=202 feedback
54 testing of new failover code 2016/6/6 Ahsan assigned (Not started yet, plan to start after #04)
55 Re: [pgpool-II 0000192]: Human readable option for pcp_node_info 2016/6/10 2016/7/30 Usama fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=541451eab2647151aa8c04a1e1a1fe9e42f2dd7e
56 pgpool runs out of memory 2016/7/4 Usama http://www.pgpool.net/mantisbt/view.php?id=212 waiting for feedback
57 Cannot accept() new connection. all backends are down restart 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=205 waiting for feedback
58 write on frontend failed with error :"Broken pipe" 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=206 waiting for feedback
59 Query cache invalidation performed too late 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=209 [3.6 beta] assigned
60 received degenerate backend request for node_id: 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=210 fixed
61 YCSB can't connect to PGPool-II in master-slave mode. 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=211 waiting for feedback
62 [pgpool-general: 4761] show pool_nodes returns different result when run on master and on slave 2016/7/7 Usama http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004819.html [3.6 beta] assigned
63 ERROR: node recovery failed, waiting connection closed in the other pgpools timeout 2016/7/12 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=213 waiting for feedback
64 plugs out the network cable, pgpool not change backend status and blocking connections 2016/7/5 Usama http://www.pgpool.net/mantisbt/view.php?id=214 waiting for feedback
65 pgpool doesnt escalate ip in case of another node inavailability 2016/7/12 Usama http://www.pgpool.net/mantisbt/view.php?id=215 [3.6 beta] waiting for feedback
66 Sometimes Failover command isn't executed. 2016/7/26 Usama http://www.pgpool.net/mantisbt/view.php?id=222 Feedback
67 pgpool segfault 2016/7/27 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=225 [3.6 beta] feedback
68 pgpool doesn't support jdbc well trigger jdbc 'exception' 2016/8/2 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=226 waiting for feedback
69 failover not performed by stanby node 2016/8/2 Usama http://www.pgpool.net/mantisbt/view.php?id=227 assigned
70 pgpool doesnt de-escalate IP in case netowkr restored 2016/8/2 Usama http://www.pgpool.net/mantisbt/view.php?id=228 assigned
100 Platform freeze 2016/2/19 2016/3/15 - - All the new platforms that we want to support and add to BF should be decided by this date. It seems we will not add any new supported platforms.
101 Feature requirement freeze 2016/2/19 2016/3/15 - - We need to ensure all the features that we intend to add to 3.6 are speced out by this date
102 Feature Freeze 2016/2/19 2016/8/15 - - Ensure all the agreed upon features are committed to master by this date. This should be feature complete and we should only focus on bug fixed after this point.
103 Code Freeze 2016/2/19 2016/9/15 - - At-least one month period between feature and code freeze to ensure all new features are stable and critical bugs are fixed by this date.
104 pgpool-II 3.6 beta1 2016/2/19 2016/9/30 - - First Beta
105 pgpool-II 3.6 RC1 2016/2/19 2016/10/28 - - One month after beta1
106 pgpool-II 3.6.0 official release 2016/2/19 2016/11/11 - -