pgpool-II 3.7 development

From pgpool Wiki
Revision as of 04:52, 28 February 2017 by Pengbo (talk | contribs)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Last update: 2017/02/28 (gray items are done, yellow items are behind schedule)

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 - Low priority
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 Usama 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] in progress
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][SL: 3] assigned
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/07 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
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/2/16 Peng http://www.pgpool.net/mantisbt/view.php?id=258 [SL:3] Assigned
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/2/28 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=270 Assigned
35 balanced requests after started transaction 2016/12/20 2017/2/28 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=271 [SL: 1] patch created and waiting for feedback.
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 Peng http://www.pgpool.net/mantisbt/view.php?id=273 [SL:1] Assigned
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 http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html
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 http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001974.html [Feature: large][Medium size implementation]
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 Peng http://www.pgpool.net/mantisbt/view.php?id=283 [SL: 2] Assigned
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] (waiting for feedback)
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] waiting for feedback
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
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] waiting for feedback
53 FATAL: failed to read kind from backend 2017/2/23 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] waiting for feedback (code committed)
55 Inconsistent backend state 2017/2/28 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 Usama http://www.pgpool.net/mantisbt/view.php?id=290 [SL: 3] Assigned
100 Feature Agreement 2017/3/31
101 Feature Freeze 2017/8/31