pgpool-II 3.6 development

Last update: 2016/8/2 (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.6
6	pgpool-general:4016	2015/09/02	2016/08/11	Usama	deal with pg_terminate_backend	[3.6 beta] in progress need to assign or expecting patches from user, postpone to 3.6
7	Import PostgreSQL 9.6 parser	2016/2/15	2016/8/31	Peng		[3.6 beta] [In progress] Will start after PostgreSQL 9.6 beta released
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/8/31	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/8/31	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/8/31	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/8/31	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
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		Usama		Will do after #8 and #8 are finished
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/4/30	Tatsuo	pgpool-II 3.3.6, client_idle_limit_in_recovery = -1 doesn't work (pgpool-general: 4570)	[in progress]
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	feedback
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
57	Cannot accept() new connection. all backends are down restart	2016/7/4		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=205	waiting for feedback
58	write on frontend failed with error :"Broken pipe"	2016/7/4		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=206	waiting for feedback
59	Query cache invalidation performed too late	2016/7/4		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=209	[3.6 beta] assigned
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		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=211	waiting for feedback
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] assigned
63	ERROR: node recovery failed, waiting connection closed in the other pgpools timeout	2016/7/12		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=213	waiting for feedback
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
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] waiting for feedback
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		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=225	[3.6 beta] feedback
68	pgpool doesn't support jdbc well trigger jdbc 'exception'	2016/8/2		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=226	waiting for feedback
69	failover not performed by stanby node	2016/8/2		Usama	http://www.pgpool.net/mantisbt/view.php?id=227	assigned
70	pgpool doesnt de-escalate IP in case netowkr restored	2016/8/2		Usama	http://www.pgpool.net/mantisbt/view.php?id=228	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/9/15	-	-	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/9/30	-	-	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	-	-