pgpool-II 3.6 development

Last update: 2016/9/9 (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.7
6	pgpool-general:4016	2015/09/02	2016/08/11	Usama	deal with pg_terminate_backend	[3.6 beta] code done with some limitations. document needs to be updated.
7	Import PostgreSQL 9.6 parser	2016/2/15	2016/9/9	Peng		[3.6 beta] commit/push is completed,but some error need to be fixed.COPY (UPDATE...RETURNING..) is returned by error.
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
9-8	Translate SGML docs to Japanese	2016/9/1	2016/9/30	Pengbo, Yugo, ishii	Start after English SGML docs done.	Need to finish before beta1 is out
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	2016/8/31	Usama		Write in the new SGML format document
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/8/31	Tatsuo	pgpool-II 3.3.6, client_idle_limit_in_recovery = -1 doesn't work (pgpool-general: 4570)	[Feedback]
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
58	write on frontend failed with error :"Broken pipe"	2016/7/4		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=206
59	Query cache invalidation performed too late	2016/7/4	2016/8/31	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=209	[3.6 beta] feedback
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	2016/8/31	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=211	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] fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=72573ca6d45ca2fc985a06936c0c52808fe78ef1
63	ERROR: node recovery failed, waiting connection closed in the other pgpools timeout	2016/7/12	2016/8/26	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=213
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] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=024eaeaa0fea3cd5acda4c41d791835887e11d02
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	2016/8/26	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	2016/9/2	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=226	[3.6 beta] waiting for feedback-> no response. Closed.
69	failover not performed by stanby node	2016/8/2		Usama	http://www.pgpool.net/mantisbt/view.php?id=227	[3.6 beta] assigned
70	pgpool doesnt de-escalate IP in case netowkr restored	2016/8/2		Usama	http://www.pgpool.net/mantisbt/view.php?id=228	fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=3b2db66c3a10444cb31d3f6285d6bf09994d167c
71	[pgpool-general: 4885] pgpool log errors	2016/8/9		Usama	http://www.sraoss.jp/pipermail/pgpool-general/2016-August/004943.html	[3.6 beta] assigned
72	pgpool does not return result set if the statement fetchSize is smaller than the result row count.	2016/8/9	2016/8/15	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=230	waiting for feedback
73	pcp_stop_pgpool emit an error message: ERROR: unable to read data from socket	2016/8/10		Usama	http://www.pgpool.net/mantisbt/view.php?id=232	assigned
74	packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2']	2016/8/15	2016/9/15	Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=231	[3.6 beta] In progress
75	[pgpool-hackers: 1760] https://github.com/udp/json-parser/	2016/8/17		Usama	http://www.pgpool.net/pipermail/pgpool-hackers/2016-August/001760.html	done
76	[pgpool-general: 4912] Pgpool and IP bonding	2016/8/18	2016/9/7	Usama	http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html	[3.6 beta] assigned
77	Testing watchdog	2016/8/5	2016/8/19	Yugo		in progress
78	minor release	2016/8/18	2016/8/31	Pengbo		assigned
79	watchdog can start even in case VIP is brought up in other nodes.	2016/8/23		Usama		assigned
80	watchdog can start even in case trusted servers are not reachable.	2016/8/23		Usama		assigned
81	watchdogs with different VIP can exist in a cluster.	2016/8/23		Usama		assigned
82	Behavior when watchdog process is killed	2016/8/23		Usama		assigned
83	Interlocking of failover_command sometimes doesn't work.	2016/8/23		Usama		[3.6 beta] assigned
84	Changed behavior when all heartbeat LAN are disconnected	2016/8/23		Usama		assigned
85	Pgpool-II fails to start if listen_addresses is empty string	2016/8/29		Usama	http://www.pgpool.net/mantisbt/view.php?id=237	fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=9fd7256e4bdf9a9fa6b61a3b1d66fcd658dbda70
86	Performance of selects queries	2016/8/30		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=238	assigned--> resolved
87	invalid pcp socket directory	2016/8/30		Usama	http://www.pgpool.net/mantisbt/view.php?id=239	assigned
88	Connections remains open when backend dettach during a transaction	2016/9/2		Pengbo	http://www.pgpool.net/mantisbt/view.php?id=240	assigned
89	The repository package not works correctly	2016/9/6		Pengbo	http://www.pgpool.net/mantisbt/view.php?id=241	waiting for feedback
90	pgpool fails to run failover script if the sever running primary pgpool node and postgresql server dies	2016/9/6		Usama	http://www.pgpool.net/mantisbt/view.php?id=234	assigned
91	show pool_nodes tells both nodes are standby	2016/9/6		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=242	waiting for feedback-->resolved
92	pgpool ignores backend weight in balancing	2016/9/6		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=243	waiting for feedback
93	[Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5)	2016/9/9		Usama		assigned
94	[Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (6)-(8)	2016/9/9		Tatsuo		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	-	-
107	pgpool-II 3.6 release note		2016/9/30	Tatsuo,Peng	-