Pgpool-II 4.0 development

Last update: 2018/05/07 (gray items are done, yellow items are behind schedule, orange items are new features for 4.0, and pink items are other TODO)

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
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
5	Allow to use multiple pgpool-II instances with in-memory query cache enabled	2016/4/6		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
43	new feature candidate: verify standby node while finding primary node	2017/1/12	2018/4/18	Tatsuo	http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002759.html http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html	Completed.
62	[Feature] New feature candidate: SCRAM authentication and certification base authentication	2017/3/23	2018/4/17 (Ready for review)	Usama		2018/4/17: Ready for review(Include small Readme for testing). 2018/4/24: Documentation done. 2018/4/27: Regression done.
63	New feature candidate: Seamless Application Failover	2017/3/23		Ahsan	Similar to Oracle's "Transparent Application Failover".	Ahsan will post a proposal to pgpool-hackers
72	New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)	2017/4/17		Usama		Postpone to 3.8
83	[pgpool-hackers: 2400] Garbage output	2017/6/19		Usama
92	0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive	2017/7/21		Tatsuo	https://www.pgpool.net/mantisbt/view.php?id=322	Waiting for feedback (2018/3/22)
104	0000329: Newly elected(promoted) Pgpool does connect to any backend	2017/8/11	2017/12/11	Usama	http://www.pgpool.net/mantisbt/view.php?id=329	fix in 3.7 done. Needs back patching
106	0000332: Watch dog issue	2017/8/24		Usama	http://www.pgpool.net/mantisbt/view.php?id=332	Closed.(2018/1/9) Doesn't seems like an issue. Replied on Mantis.
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	Closed. (2017/12/15) (Done in 3.6, 3.5, 3.7. Working on 3.4 and 3.3 --> Impossible due to technical reasons. Mantis updated). The report claimed that the bug was not fixed in 3.6.7. So reopen this item.
120	0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC	2017/10/5		Tatsuo	https://www.pgpool.net/mantisbt/view.php?id=349	Waiting for feedback.(2017/10/6)-->asking to close the issue (2017/12/8)-->They said they are going to upgrade on 2018/15 but no reply as of 2018/1/12 and waiting for feedback. The reporter said it will take more time because the organization is large (2018/2/28). Still no response. Polling again (2018/04/06). Still no response. Will close this issue on beginning of May.
123	[pgpoolAdmin] 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	Done. 2017/11/24
125	0000348: pgpool failover scenario ERROR - pgpool 3.6.6 (postgres 9.3.5)	2017/11/09		Usama	https://www.pgpool.net/mantisbt/view.php?id=348	Waiting for reply with message: Please try 3.6.7
126	0000342: On master fail slave not able to convert itself to master	2017/11/09		Usama	https://www.pgpool.net/mantisbt/view.php?id=342	Waiting for reply with message: Please try 3.6.7
127	[pgpoolAdmin]0000364: PGPool hangs when then number of connections are greater than num_init_children	2017/11/10		Peng	https://www.pgpool.net/mantisbt/view.php?id=364	Close(2018/04/02)
128	[pgpoolAdmin] 0000369: yum's baseurl does not exist and it can not be used	2017/11/24		Peng	https://www.pgpool.net/mantisbt/view.php?id=369	Done. (2017/11/27)
129	[pgpool-hackers: 2635] Some problems in Makefile.am	2017/12/08		Peng	https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002635.html	Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
130	$(top_srcdir) was created in src/parser/.	2017/12/08		Peng		Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
131	Logging client message	2017/12/08		Tatsuo	https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002638.html
132	0000370: Pgpool get stuck with db exception followed by select	2017/12/11		Tatsuo	https://www.pgpool.net/mantisbt/view.php?id=370	Close. (2018/3/5) Patch provided. Waiting for feedback.-> Resolved.
133	Failed in 002.native_replication. (Pgpool-II couldn't rewrite DEFAULT)	2017/12/14	2017/12/18	Peng		Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b974f5f3b59b62ca3f0c5c0ccfdea125abbbc19b
134	[pgpoolAdmin] Pull Request	2017/12/14		Peng	https://github.com/pgpool/pgpooladmin/compare/master...remodoy:postgresql_connect_timeout	Done. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=579833e695e011f8d47a6fff994a3393f9d8a37d
135	Modify pgpool.service to output log.	2017/12/15		Peng		Done. 2017/12/21 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=63886312c702811f7ed53fac266c22946ba2212e
136	allow to specify load balance weight ratio for load balance parameters	2017/12/15		Peng	https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html
137	Load-balancing control for specific queries	2017/12/15	2018/05/11	Peng	https://www.pgpool.net/pipermail/pgpool-hackers/2017-November/002594.html	In progress.
138	Minor releases (3.7.1, 3.6.8 etc.)	2017/12/15	2018/1/9	Peng		Done. 2018/1/9
139	0000373: pgpool failed over	2017/12/21		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=373	Waiting for feedback.-> no response. Closed.
140	0000374: md5 authentication is broken	2017/12/23		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=374	Waiting for feedback.-> no response. Closed.
141	0000375: extended query error	2018/01/08		Peng	http://www.pgpool.net/mantisbt/view.php?id=375	Close.2018/4/27
142	0000376: child process was terminated by segmentation fault	2018/01/12		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=376	Closed. (2018/2/6)
143	[pgpool-general: 5863] pgpool frequnet authentication timeout	2018/01/19		Usama	http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005921.html	In progress.
144	[pgpool-general: 5864] Troubleshooting assistance on node failure and connections blocking	2018/01/19		Tatsuo	http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005922.html	Waiting for feedback (2017/1/19)-> No response from the poster over 1 month. Issue closed.
145	[pgpool-general: 5899] Master Election - Priority	2018/01/30		Usama	https://www.pgpool.net/pipermail/pgpool-general/2018-January/005957.html
146	0000378: Pgpool fails all connections when secondary goes down	2018/02/06		Tatsuo	https://www.pgpool.net/mantisbt/view.php?id=378	No response over 1 month. I am going to close the issue.
147	0000379: Many connections go into state 'idle in transaction'	2018/02/07		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=379	Patch provided. Waiting for feedback (2018/2/28)
148	0000380: When a node is down, the first query to the cluster fails	2018/02/14		Tatsuo	http://www.pgpool.net/mantisbt/view.php?id=380	It turned out a problem with user's setting.
149	Proposal: Enhancing pool_process and pool_pools	2018/02/13		Tatsuo	http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html
150	Proposal: Disabling load balance after writing query	2018/02/16	2018/04/23	Tatsuo	http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002726.html	Done (2018/4/23)
151	0000385: arping, if_up_cmd' failed and failed to acquire delegate Ip	2018/03/16		Peng	https://www.pgpool.net/mantisbt/view.php?id=385	Close. (2018/3/26)
152	0000386: Pgpool fails to start with a watchdog error	2018/03/16		Peng	https://www.pgpool.net/mantisbt/view.php?id=386	Close. (2018/04/27)
153	0000388: pgpool-II 3.6.1 child process remain waiting for a non-existing client socket to send queries	2018/03/18		Tatsuo	https://www.pgpool.net/mantisbt/view.php?id=388	Assigned (2018/04/06)
154	0000394: When multiple failover happens the pgpool pool node status is going into standby -stanby state	2018/04/21		Usama	https://www.pgpool.net/mantisbt/view.php?id=394	Assigned (2018/04/24)
155	[pgpool-general: 6069] failover_require_consensus does not work.	2018/05/03		Usama	https://www.pgpool.net/pipermail/pgpool-general/2018-May/006127.html	Assigned (2018/05/07)
200	Feature Agreement		2018/3/31
201	Feature Freeze		2018/8/31
202	Code Freeze		2018/9/30