Difference between revisions of "pgpool-II 3.6 development"

From pgpool Wiki
Jump to: navigation, search
Line 789: Line 789:
| Usama
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=234
| http://www.pgpool.net/mantisbt/view.php?id=234
| <del>[3.6 beta]</del>assigned
| <del>[3.6 beta]</del>(same as #79)assigned  
| 91
| 91

Revision as of 08:14, 30 September 2016

Last update: 2016/9/30 (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.7
6 pgpool-general:4016 2015/09/02 2016/08/11 Usama deal with pg_terminate_backend [3.6 beta] code done with some limitations. document needs to be updated.
7 Import PostgreSQL 9.6 parser 2016/2/15 2016/9/9 Peng [3.6 beta] [done]https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b38f68433a873f1e2c514fa822f153b0e87ece65;hp=233f5bce00883dbef6de9186804d15f16537bb76
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/9/30 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/10/7 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/10/3 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/9/30 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, https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=06a1c4211ffd2ab504b511239ffa806b571fafa0
9-8 Translate SGML docs to Japanese 2016/9/1 2016/10/15 Pengbo, Yugo, ishii Start after English SGML docs done. Need to finish before beta1 is out
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 2016/8/31 Usama Write in the new SGML format document
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/8/31 Tatsuo pgpool-II 3.3.6, client_idle_limit_in_recovery = -1 doesn't work (pgpool-general: 4570) [Feedback] No feedback over 1 month. Closed
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 assigned
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-> no response from the reporter. Issue closed.
57 Cannot accept() new connection. all backends are down restart 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=205
58 write on frontend failed with error :"Broken pipe" 2016/7/4 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=206
59 Query cache invalidation performed too late 2016/7/4 2016/8/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=209 [3.6 beta] done
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 2016/8/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=211 Feedback->no response over 2 months. Issue closed.
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] fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=72573ca6d45ca2fc985a06936c0c52808fe78ef1
63 ERROR: node recovery failed, waiting connection closed in the other pgpools timeout 2016/7/12 2016/8/26 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=213
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->no response from the reporter. Closed.
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] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=024eaeaa0fea3cd5acda4c41d791835887e11d02
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 2016/8/26 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=225 [3.6 beta] feedback->no feedback for over 1 month. Closed.
68 pgpool doesn't support jdbc well trigger jdbc 'exception' 2016/8/2 2016/9/2 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=226 [3.6 beta] waiting for feedback-> no response. Closed.
69 failover not performed by stanby node 2016/8/2 2016/10/7 Usama http://www.pgpool.net/mantisbt/view.php?id=227 [3.6 beta] in progress
70 pgpool doesnt de-escalate IP in case netowkr restored 2016/8/2 Usama http://www.pgpool.net/mantisbt/view.php?id=228 fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=3b2db66c3a10444cb31d3f6285d6bf09994d167c
71 [pgpool-general: 4885] pgpool log errors 2016/8/9 Usama http://www.sraoss.jp/pipermail/pgpool-general/2016-August/004943.html [3.6 beta] done
72 pgpool does not return result set if the statement fetchSize is smaller than the result row count. 2016/8/9 2016/8/15 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=230 waiting for feedback
73 pcp_stop_pgpool emit an error message: ERROR: unable to read data from socket 2016/8/10 Usama http://www.pgpool.net/mantisbt/view.php?id=232 assigned
74 packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2'] 2016/8/15 2016/9/30 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=231 [3.6 beta] In progress
75 [pgpool-hackers: 1760] https://github.com/udp/json-parser/ 2016/8/17 Usama http://www.pgpool.net/pipermail/pgpool-hackers/2016-August/001760.html done
76 [pgpool-general: 4912] Pgpool and IP bonding 2016/8/18 2016/9/20 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html [3.6 beta] assigned
77 Testing watchdog 2016/8/5 2016/8/19 Yugo in progress
78 minor release 2016/8/18 2016/8/31 Pengbo assigned
79 watchdog can start even in case VIP is brought up in other nodes. 2016/8/23 Usama assigned
80 watchdog can start even in case trusted servers are not reachable. 2016/8/23 Usama assigned
81 watchdogs with different VIP can exist in a cluster. 2016/8/23 Usama assigned
82 Behavior when watchdog process is killed 2016/8/23 Usama assigned
83 Interlocking of failover_command sometimes doesn't work. 2016/9/15 Usama [3.6 beta] assigned
84 Changed behavior when all heartbeat LAN are disconnected 2016/8/23 Usama assigned
85 Pgpool-II fails to start if listen_addresses is empty string 2016/8/29 Usama http://www.pgpool.net/mantisbt/view.php?id=237 fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=9fd7256e4bdf9a9fa6b61a3b1d66fcd658dbda70
86 Performance of selects queries 2016/8/30 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=238 assigned--> resolved
87 invalid pcp socket directory 2016/8/30 Usama http://www.pgpool.net/mantisbt/view.php?id=239 assigned
88 Connections remains open when backend dettach during a transaction 2016/9/2 Pengbo http://www.pgpool.net/mantisbt/view.php?id=240 waiting for feedback (It wasn't reproduced)
89 The repository package not works correctly 2016/9/6 Pengbo http://www.pgpool.net/mantisbt/view.php?id=241 fixed
90 pgpool fails to run failover script if the sever running primary pgpool node and postgresql server dies 2016/9/6 2016/9/30 Usama http://www.pgpool.net/mantisbt/view.php?id=234 [3.6 beta](same as #79)assigned
91 show pool_nodes tells both nodes are standby 2016/9/6 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=242 waiting for feedback-->resolved
92 pgpool ignores backend weight in balancing 2016/9/6 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=243 waiting for feedback-> closed, due to user's misunderstanding.
93 [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5) 2016/9/9 2016/9/30 Usama [3.6 beta] assigned
94 [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (6)-(8) 2016/9/9 Tatsuo [3.6 beta] assigned
95 [pgpool-general: 4993] pgpoolAdmin - /var/www/html/pgpoolAdmin-3.5.3/conf/pgmgt.conf.php write denied 2016/9/14 Peng http://www.pgpool.net/pipermail/pgpool-general/2016-September/005051.html waiting for feedback http://www.sraoss.jp/pipermail/pgpool-general/2016-September/005090.html
96 [pgpool-general: 4997] Avoiding downtime when pgpool changes require a restart 2016/9/15 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-September/005055.html assigned
97 watchdog sometimes fails de-escalation 2016/9/21 Usama http://www.pgpool.net/mantisbt/view.php?id=249 assigned
98 Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=250 assigned
99 failover_command not executed 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=251 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/10/7 - - (except translation to Jap. docs) 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/10/21 - - 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 - -
107 pgpool-II 3.6 release note 2016/9/30 Tatsuo,Peng -