pgpool-II 3.7 development

Last update: 2017/10/27 (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]->postpone to 3.8
3	Make PCP set configuration command public	2016/2/15	-	Usama	-	[Feature: small]->postpone to 3.8
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]->postpone to 3.8
6	[Feature] Health-check timeout for each backend node	2016/3/4	2017/5/31	Ishii	http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node	[Feature: medium] [medium size implementation] Proposal: http://www.pgpool.net/pipermail/pgpool-hackers/2017-March/002213.html
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)->Closed (2017/3/26).
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] Closed
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	waiting for feedback (2017/4/3)-> no feed back. Closed (2017/5/1)
35	balanced requests after started transaction	2016/12/20	2017/3/31	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=271	[SL: 1] closed on 2017/3/31
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/4/30	Peng	http://www.pgpool.net/mantisbt/view.php?id=273	[SL:1] Closed. (2017/07/07)
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]->postpone to 3.8
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/9/22	Usama	http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001974.html	[Feature: large][Medium size implementation] Target date includes English documentation
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/4/30	Peng	http://www.pgpool.net/mantisbt/view.php?id=283	[SL: 2] Closed. (2017/07/07)
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] waiting for feedback -> no feedback. Closed.
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/4/07	Usama	http://www.pgpool.net/mantisbt/view.php?id=288	[SL: 3] Assigned (resolved)
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/4/05	Usama	http://www.pgpool.net/mantisbt/view.php?id=289	[SL: 3] Assigned (resolved)
56	[safety violation] master without quorum execute failover procedure	2017/2/28	2017/7/31	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] Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=4615f807179fbfbdb18c7856e109d95f53abc201
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	Fixed on 2017/3/24
60	Notice: Undefined variable: msgPcpPassFile in $PATH/checkParameter.php on line 427	2017/3/21	2017/5/10	Peng	http://www.pgpool.net/mantisbt/view.php?id=297	[SL: 3] Done.
61	[Feature] New feature candidate: import PostgreSQL 10.0 SQL parser	2017/3/23	2017/9/22	Peng		Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=57196ae03cab9989c0c15deee49c3d4642450112
62	[Feature] New feature candidate: certification base authentication	2017/3/23				postpone to 3.8
63	New feature candidate: Seamless Application Failover	2017/3/23			Similar to Oracle's "Transparent Application Failover".	Postpone to 3.8 or later
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/4/14	Peng	http://www.pgpool.net/mantisbt/view.php?id=293	Done
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	Fixed. (.pcppass file is required.)
67	Minor release	2017/3/27	2017/4/30	Peng		Released on 4/28
68	[pgpool-general: 5396] pam ldap failure	2017/3/30		Usama	http://www.pgpool.net/pipermail/pgpool-general/2017-March/005454.html	Fixed on 2017/3/31
69	New Defects reported by Coverity Scan for pgpool-II	2017/4/4		Usama
70	Errors on the reloading of configuration	2017/4/7		Usama	http://www.pgpool.net/mantisbt/view.php?id=299	Fixed on 2017/4/12
71	0000300: pgpool-II doesn't handle lost socket file	2017/4/14	2017/5/14	t-ishii	http://www.pgpool.net/mantisbt/view.php?id=300	waiting for feedback (2017/4/17)->replied that it's resolved (2017/5/15)
72	New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)	2017/4/17		Usama		Postpone to 3.8
73	Update mantis	2017/4/25		pengbo
74	Pgpool steals back MASTER status	2017/4/25	2017/5/11	Usama	http://www.pgpool.net/mantisbt/view.php?id=306	Fix committed
75	Inconsistent node status with watchdog configuration	2017/4/20		Usama	http://www.pgpool.net/mantisbt/view.php?id=305	Waiting for feedback (2017/6/6)->closed (2017/7/24)
76	pgpool failed after pool_check_fd call failed with an error "Interrupted system call"	2017/4/27		ishii	http://www.pgpool.net/mantisbt/view.php?id=307	Waiting for feedback (2017/5/18)->No feedback over 1 month. Closed (2017/6/26).
77	Pgpool-II 3.6.4, 3.5.8 release	2017/5/8	2017/5/11	Peng		Released. 2017/05/11
78	0000310: INSERT ... ON CONFLICT ... DO UPDATE queries hang	2017/6/13		ishii	https://www.pgpool.net/mantisbt/view.php?id=310	waiting for feedback (2017/6/13)->closed (2017/7/19)
79	0000312: Node stays at 0 on pgpool	2017/6/13		ishii	https://www.pgpool.net/mantisbt/view.php?id=312	waiting for feedback (2017/6/13)->closed (2017/7/19)
80	0000309: bind socket failed with error: "Address already in use"	2017/6/13		Usama	https://www.pgpool.net/mantisbt/view.php?id=309	Closed. (2017/8/28)
81	0000315: High CPU usage when commiting large transactions and using in (shared) memory cache	2017/6/20		Usama	https://www.pgpool.net/mantisbt/view.php?id=315	Fix committed (2017/6/29)
82	0000316: One postgresql backend node is marked down often	2017/6/26		Usama	https://www.pgpool.net/mantisbt/view.php?id=316	closed (2017/7/24)
83	[pgpool-hackers: 2400] Garbage output	2017/6/19		Usama
84	0000304: Hibernate is hanging in connect PGPOOL-II	2017/4/20		Ishii	https://www.pgpool.net/mantisbt/view.php?id=304	Waiting for feedback (2017/6/28)->No response. Issue closed(2017/08/04)
85	0000317: pgpool sometimes fails to return a "Ready for query" causing client to hang.	2017/6/30		Ishii	https://www.pgpool.net/mantisbt/view.php?id=317	Closed. (2017/8/28).
86	Pgpool-II minor release		2017/7/11	Peng
87	0000318: Exception in plpgsql function is not passed to application	2017/7/5		Peng	https://www.pgpool.net/mantisbt/view.php?id=318	Closed. (2017/8/28)
88	New feature candidate: deal with Amazon Aurora	2017/7/7		ishii	https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002430.html	Closed. (2017/8/28)
89	New feature candidate: deal with logical replication	2017/7/7		ishii	https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002444.html	Closed. (2017/8/28)
90	0000320: Index Error Violations are never returned to the application	2017/7/16		Ishii	https://www.pgpool.net/mantisbt/view.php?id=320	Closed. (2017/8/28)
91	0000323: After error : the connection is marked as "idle in transaction (aborted)	2017/7/20		Ishii	https://www.pgpool.net/mantisbt/view.php?id=323	Closed. (2017/8/28)
92	0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive	2017/7/21		Usama	https://www.pgpool.net/mantisbt/view.php?id=322
93	Add some Japanese document.	2017/7/21		Peng		Done.
94	Deal with OpenSSL 1.1	2017/7/25		Ishii	https://www.pgpool.net/pipermail/pgpool-general/2016-July/004828.html	Done (2017/9/11)
95	[pgpool-general: 5640] oom when memory_cache_enabled is on	2017/7/28		Ishii	https://www.pgpool.net/pipermail/pgpool-general/2017-July/005698.html	Fix pushed (2017/8/9). Waiting for the feedback.
96	[pgpool-general: 5653] pgpoolAdmin-3.6.1-1pgdg.rhel7.noarch.rpm does not have js direcotry.	2017/7/31		Peng	https://www.pgpool.net/pipermail/pgpool-general/2017-July/005711.html	Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=649f0bb0b7be9c824c9fe19f3287639d3f0e0109
97	[pgpool-general: 5660] pgpoolAdmin can not set expectedly Pgpool-II params related to bool type ones in "pgpool.conf Setting"	2017/7/31		Peng	https://www.pgpool.net/pipermail/pgpool-general/2017-July/005718.html	Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=8e919744217efae6d6f71a1a07a681183e79c813
98	0000324: backend consumes large amount of RAM with long sessions	2017/7/31		Ishii	https://www.pgpool.net/mantisbt/view.php?id=324	Patch provided. Waiting for feedback (2017/8/2) It turns out that this is application's issue. They don't issue close messages -> Issue closed.
99	0000325: pool_check_fd call failed with an error "Interrupted system call"	2017/08/02		Ishii	https://www.pgpool.net/mantisbt/view.php?id=325	Waiting for feedback (2017/8/03)->it turned out configuration problem.
100	[pgpool-general: 5683] Postgres error not processed by pgpool	2017/08/04		Ishii	https://www.pgpool.net/pipermail/pgpool-general/2017-August/005741.html	Waiting for feedback (2017/8/04)-> Solved (2017/8/7)
101	New feature candidate: Need to support hostname in pool_hba.conf, currently only IP addresses are support		2017/9/30	Usama		Target date includes English documentation
102	0000326: pcp_node_info command error occurred on pgpool admin			Peng	http://www.pgpool.net/mantisbt/view.php?id=326	Waiting for feedback. (2017/8/20)
103	0000327: Cannot connect to PGPool when caching is enabled (Redshift)	2017/8/9		Ishii	http://www.pgpool.net/mantisbt/view.php?id=327	Waiting for feedback (2017/8/16)
104	0000329: Newly elected(promoted) Pgpool does connect to any backend	2017/8/11		Usama	http://www.pgpool.net/mantisbt/view.php?id=329	fix in 3.7 done. Needs back patching
105	0000330: Unable to connect to pgpool-II using jdbc	2017/8/14		Ishii	http://www.pgpool.net/mantisbt/view.php?id=330	Fixed.
106	0000332: Watch dog issue	2017/8/24		Usama	http://www.pgpool.net/mantisbt/view.php?id=332	Assigned.
107	0000333: watchdog fails to add node to master when wd_authkey is not an empty string; pgpool member shuts down	2017/8/24		Usama	http://www.pgpool.net/mantisbt/view.php?id=333	Fixed.
108	Pgpool-II minor release.	2017/9/5		Peng		Done.
109	0000336: During load the server in production would fail connectivity with a slave and itself, resulting in removing nodes	2017/8/29		Ishii	http://www.pgpool.net/mantisbt/view.php?id=336	Waiting for feedback (2017/9/6)
110	[pgpoolAdmin] Add support for PHP7	2017/9/11	2017/10/30	Peng		In progress.
111	0000339: Failover does not occurr if master Pgpool-II and primary PostgreSQL servers are stopped at the same time	2017/9/13		Usama	https://www.pgpool.net/mantisbt/view.php?id=339	Done in 3.6, 3.5, 3.7. Working on 3.4 and 3.3
112	[pgpoolAdmin] [pgpool-general: 5720] "Return" node automatically	2017/9/15	2017/9/30	Peng		Done.[pgpool-general: 5743]
113	3.7 release-note	2017/10/1	2017/10/5	Peng		Done.
114	Failover bug in replication mode	2017/9/20	2017/9/22	Ishii	https://www.pgpool.net/pipermail/pgpool-general/2017-September/005786.html	Fix pushed.
115	0000343: Pgpool log is empty after upgrade	2017/9/26		Peng	http://www.pgpool.net/mantisbt/view.php?id=343	In progress.
116	0000345: pgpool node.js prepared statement	2017/10/3		ishii	http://www.pgpool.net/mantisbt/view.php?id=345	Patch provided. Waiting for feedback.
117	new featue candidate: add "role" column to pcp_node_info command	2017/10/3	2017/10/4	ishii		Done.
118	0000347: backend response with kind 'E' when expecting 'R'	2017/10/4		ishii	http://www.pgpool.net/mantisbt/view.php?id=347	Waiting for feedback.
119	0000351: pgpool crashes after a network outage to the master	2017/10/9		ishii	http://www.pgpool.net/mantisbt/view.php?id=351	Waiting for feedback.
120	0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC	2017/10/5		ishii	http://www.pgpool.net/mantisbt/view.php?id=349	Waiting for feedback.(2017/10/6)
121	Add RPMs for PostgreSQL 10		2017/11/01	Peng		3.7 done. need to work on 3.5 and 3.6
122	0000356: pg_terminate_backend() causing failover despite setting flag	2017/10/19		Usama	https://www.pgpool.net/mantisbt/view.php?id=356	Fixed in master, 3.6 and 3.5 stable branch. Waiting for feedback.
123	0000361: Can't detach node from pgpoolAdmin UI, while pcp_detach_node works fine	2017/11/01		Peng	https://www.pgpool.net/mantisbt/view.php?id=361	Assigned.
124	0000363: health check not detect node after down	2017/11/09		Peng	https://www.pgpool.net/mantisbt/view.php?id=363	Closed.2017/11/9
200	Feature Agreement		2017/3/31
201	Code Freeze including English docs except release notes		2017/9/30
202	Beta 1 including release notes and Japanese docs		2017/10/17
203	RC1 Release.		2017/11/13
204	Pgpool-II 3.7 official release		2017/11/22