pgpool-II 3.7 development

From pgpool Wiki
Revision as of 07:25, 26 March 2017 by Ishii (talk | contribs)
Jump to: navigation, search

Last update: 2017/03/24 (gray items are done, yellow items are behind schedule, pink items are new features for 3.7)

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
1 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 -> the data taken was not using provisioned IO and the data is not very useful. Remove the item and expect another chance (PGECons?)
2 pgpool-hackers:1034 2015/09/03 - Usama add new child if it goes down [Feature: small]
3 Make PCP set configuration command public 2016/2/15 - Usama - [Feature: small]
4 Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS 2016/2/26 2016/8/31 Usama
5 Allow to use multiple pgpool-II instances with in-memory query cache enabled 2016/3/4 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]
6 Health-check timeout for each backend node 2016/3/4 Ishii http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node [Feature: medium] [medium size implementation]
7 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 [SL: 3] Closed.
8 Connections stuck - Recv-Q fills up 2016/6/2 2016/7/26 Usama http://www.pgpool.net/mantisbt/view.php?id=203 [SL: 3] [Feedback 2017/3/1]
9 failed to create INET domain socket 2016/6/2 2016/8/15 pengbo http://www.pgpool.net/mantisbt/view.php?id=202 fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=39d24e7f7ff88dfa780982059421ff6f405e63db
10 testing of new failover code 2016/6/6 2017/2/28 Ahsan [SL : 3] assigned (Not started yet, plan to start after #04)
11 ERROR: node recovery failed, waiting connection closed in the other pgpools timeout 2016/7/12 2017/3/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=213 [SL: 3] Not reproduced here. Waiting for feedback.(2017/2/23)
12 failover not performed by stanby node 2016/8/2 2016/10/7 Usama http://www.pgpool.net/mantisbt/view.php?id=227 [3.6 RC1] in progress
13 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 -> done (2016/12/20)
14 [pgpool-general: 4912] Pgpool and IP bonding 2016/8/18 2017/3/10 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html [3.6 RC1][closed 2017/2/28][unable to reproduce] [no response from user]
15 watchdog can start even in case VIP is brought up in other nodes. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
16 watchdog can start even in case trusted servers are not reachable. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
17 watchdogs with different VIP can exist in a cluster. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
18 Behavior when watchdog process is killed 2016/8/23 Usama [SL:1] done (2017/2/8)
19 Changed behavior when all heartbeat LAN are disconnected 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
20 Connections remains open when backend dettach during a transaction 2016/9/2 Pengbo http://www.pgpool.net/mantisbt/view.php?id=240 [SL: 1] not reproduced
21 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
22 [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5) 2016/9/9 2016/9/30 Usama Done (2017/2/8)
23 watchdog sometimes fails de-escalation 2016/9/21 Usama http://www.pgpool.net/mantisbt/view.php?id=249 Resolved
24 Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface 2016/9/28 2017/3/25 Usama http://www.pgpool.net/mantisbt/view.php?id=250 [SL:2] in progress
25 failover_command not executed 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=251 assigned [Need verification: Should already be fixed in the latest version.](2017/2/8)
26 pgpoolAdmin 3.6 release 2016/12/31 Peng
27 pgpool-II sometimes hangs on restart 2016/12/06 Ishii http://www.pgpool.net/mantisbt/view.php?id=265 [SL: 2] fix committed on 2017/1/12. Issue closed.
28 [pgpool-general: 5172] Version 3.6 is missing pgpool_adm extension 2016/12/19 2016/12/22 Peng http://www.sraoss.jp/pipermail/pgpool-general/2016-December/005230.html Fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f8a157a1288c1ee452e981151b58875540a5cc90
29 While attaching nodes in replication mode "show pool_nodes" is showing different values on each node 2016/12/20 2017/3/10 Peng http://www.pgpool.net/mantisbt/view.php?id=258 [SL:3] Assigned->waiting for feedback (2017/3/12)
30 Standby server Pgpool shutdown when master server postgresql down due to ipc key conflict 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=266 [SL: 2] Assigned
31 log_destination is set to syslog but pgpool does not use /dev/log 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=267 [SL: 2] Assigned
32 pgpool block on issue_command_to_watchdog() for ever when the primary's network is cut off 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=268 Assigned [Fixed in latest version]
33 authentication timeout with connection_life_time 2016/12/20 Yugo http://www.pgpool.net/mantisbt/view.php?id=269 Assigned
34 pgpool system hung cause parallel many query 2016/12/20 2017/3/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=270 Assigned
35 balanced requests after started transaction 2016/12/20 2017/3/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=271 [SL: 1] in progress
36 pgpool not releasing shared memory segments 2016/12/20 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=272 [SL: 2] Fix committed.
37 ERROR: unable to read data from frontend 2016/12/20 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=273 [SL:1] in progress
38 PgPool showing all the nodes as standby even though pg_is_in_recovery() shows correctly as master/standby? 2016/12/20 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=274 Assigned
39 superuser: unknown (Connection error) in pgpoolAdmin 2017/01/06 2017/2/16 Peng http://www.pgpool.net/mantisbt/view.php?id=276 [SL: 2] Fixed https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=ab3ece87c77cf2eeb09799465ec42285966be3d1
40 pgpoolAdmin is missing in yum repository pgpool36 2017/01/06 2017/2/28 Peng http://www.pgpool.net/mantisbt/view.php?id=277 [SL:2] Assigned
41 Issue 0000248 reproduced in "pgpool-II version 3.6beta2 (subaruboshi)" 2016/11/10 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=260 [SL: 2] not reproduced -> close (2017/2/8)
42 Load balancing error 2016/9/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=244 [SL: 2] Same issue as bug271 (item 35)
43 new feature candidate: verify standby node while finding primary node 2017/1/12 Tatsuo/Usama http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html [Feature: Medium][medium size implementation]
44 [pgpool-general: 5223] Questionable Failover 2017/1/12 Usama http://www.pgpool.net/pipermail/pgpool-general/2017-January/005281.html Done (2017/2/8)
45 stack smashing detected 2017/1/18 Usama http://www.pgpool.net/mantisbt/view.php?id=280 Done (2017/2/8)
46 new feature candidate: Proposal to make backend node failover mechanism quorum aware 2017/1/10 2017/3/10 Usama http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001974.html [Feature: large][Medium size implementation] waiting feedback from Usama
47 "segmentation fault" when execute pcp_attach_node 2017/1/27 Usama http://www.pgpool.net/mantisbt/view.php?id=281 [SL: 2] in progress
48 PGPool hangs in Master/Slave mode with Slony submodule 2017/2/8 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=283 [SL: 2] in progress
49 pgpool-II native replication loses sync every 1-2 days 2017/2/8 Usama http://www.pgpool.net/mantisbt/view.php?id=284 [SL: 2] Done
50 pgpool hangs with hibernate and spring 2017/2/8 2017/2/28 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=286 [SL: 2] In porgress
51 Syntax Error in Query Using CURRENT_TIMESTAMP 2017/2/23 2017/3/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=287 [SL: 3] waiting for feedback from 3017/2/23. Will close on 3/23->Closed on 3/26
52 Pgpool hangs on query and doesn't send it to backend 2017/2/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=282 [SL: 3] Done
53 FATAL: failed to read kind from backend 2017/2/23 2017/3/31 Usama http://www.pgpool.net/mantisbt/view.php?id=288 [SL: 3] Assigned
54 [pgpool-general: 5315] pg_terminate_backend 2017/2/23 Usama http://www.pgpool.net/pipermail/pgpool-general/2017-February/005373.html [SL: 3] (code committed)
55 Inconsistent backend state 2017/2/28 2017/3/31 Usama http://www.pgpool.net/mantisbt/view.php?id=289 [SL: 3] Assigned
56 [safety violation] master without quorum execute failover procedure 2017/2/28 Depend on #46 Usama http://www.pgpool.net/mantisbt/view.php?id=290 [SL: 3] Assigned
57 [pgpool-general: 5350] pgpooladmin version issue 2017/3/3 2017/3/31 Peng http://www.pgpool.net/pipermail/pgpool-general/2017-February/005408.html [SL: 3] Assigned
58 Pgpool service fails to start on the load of OS 2017/3/15 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=294 [SL: 3] Assigned
59 PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking' 2017/3/21 2017/3/31 Usama http://www.pgpool.net/mantisbt/view.php?id=296 [SL: 3] Assigned
60 Notice: Undefined variable: msgPcpPassFile in $PATH/checkParameter.php on line 427 2017/3/21 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=297 [SL: 3] Assigned
61 New feature candidate: import PostgreSQL 10.0 SQL parser 2017/3/23 Peng
62 New feature candidate: certification base authentication 2017/3/23
63 New feature candidate: Seamless Application Failover 2017/3/23 Similar to Oracle's "Transparent Application Failover".
64 Pgpool-II minor releases (3.6.2, 3.5.6, 3.4.10, 3.3.14, 3.2.19) 2017/3/17 2017/3/17 Peng
65 PgpoolAdmin shows Port instead Status (MASTER/SLAVE) of Pgpool Servers in Watchdog 2017/3/23 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=293 Assigned
66 pcp_watchdog_info command error occurred. Notice: Undefined offset: 2 in $PATH/command.php on line 156 2017/3/24 Peng http://www.pgpool.net/mantisbt/view.php?id=298 Assigned
100 Feature Agreement 2017/3/31
101 Feature Freeze 2017/8/31