pgpool-II 3.7 development

Last update: 2017/02/23 (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	2016/9/20	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	assigned
24	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	[SL:2] assigned
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		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] Assigned
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] Assigned
50	pgpool hangs with hibernate and spring	2017/2/8		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=286	[SL: 2] waiting for feedback
100	Feature Agreement		2017/3/31
101	Feature Freeze		2017/8/31