Difference between revisions of "Pgpool-II 4.0 development"

From pgpool Wiki
Jump to: navigation, search
(Created page with "Last update: 2017/11/10 (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...")
 
 
(213 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Last update: 2017/11/10 (gray items are done, yellow items are behind schedule, pink items are new features for 3.7)
+
Last update: 2018/10/09 (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.
 
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
Line 11: Line 11:
 
! Overview
 
! Overview
 
! Status
 
! Status
|-style="background:silver"
+
|-style="background:pink"
| 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?)
 
|-style="background:white"
 
 
| 2
 
| 2
 
| pgpool-hackers:1034
 
| pgpool-hackers:1034
Line 26: Line 18:
 
| Usama
 
| Usama
 
| add new child if it goes down
 
| add new child if it goes down
| [Feature: small]->postpone to 3.8
+
| [Feature: small]->postpone to 4.1
|- style="background:white"
+
|- style="background:pink"
 
| 3
 
| 3
 
| Make PCP set configuration command public  
 
| Make PCP set configuration command public  
Line 34: Line 26:
 
| Usama
 
| Usama
 
| -
 
| -
| [Feature: small]->postpone to 3.8
+
| [Feature: small]->postpone to 4.1
 
|-style="background:silver"
 
|-style="background:silver"
| 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
 
|
 
|
 
|-style="background:white"
 
 
| 5
 
| 5
 
| Allow to use multiple pgpool-II instances with in-memory query cache enabled
 
| Allow to use multiple pgpool-II instances with in-memory query cache enabled
| 2016/3/4
+
| 2016/4/6
 
|
 
|
 
| Tatsuo
 
| Tatsuo
 
| http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_multiple_pgpool-II_instances_with_in-memory_query_cache_enabled
 
| 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
+
| [Feature: small] [medium size implementation] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/query_cache -> This item is deleted. https://www.pgpool.net/pipermail/pgpool-hackers/2018-June/002845.html
|-
+
|-style="background:orange"
|-style="background:silver"
+
| 43
| 6
+
| new feature candidate: verify standby node while finding primary node
| [Feature] Health-check timeout for each backend node
+
| 2017/1/12
| 2016/3/4
+
| 2018/4/18
| 2017/5/31
+
| Tatsuo
| Ishii
+
| http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002759.html http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html
| http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node
+
| Completed.
| [Feature: medium] [medium size implementation] Proposal: http://www.pgpool.net/pipermail/pgpool-hackers/2017-March/002213.html
+
|-style="background:orange"
|-style="background:silver"
+
| 62
| 7
+
| [Feature] New feature candidate: SCRAM authentication and certification base authentication
| pgpool routes queries with "SET TRANSACTION READ ONLY" to master
+
| 2017/3/23
| 2016/5/18
+
| 2018/8/10
| 2016/6/30
 
| t-ishii
 
| http://www.pgpool.net/mantisbt/view.php?id=195
 
| [SL: 3] Closed.
 
|-style="background:silver"
 
| 8
 
| Connections stuck - Recv-Q fills up
 
| 2016/6/2
 
| 2016/7/26
 
 
| Usama
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=203
 
| [SL: 3] [Feedback 2017/3/1]
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 10
 
| testing of new failover code
 
| 2016/6/6
 
| 2017/2/28
 
| Ahsan
 
 
|
 
|
| [SL : 3] assigned (Not started yet, plan to start after #04)
+
| 2018/4/17: Ready for review(Include small Readme for testing). <br /> 2018/4/24: Documentation done. <br />2018/4/27: Regression done.
|-style="background:silver"
+
|-style="background:pink"
| 11
+
| 63
| ERROR: node recovery failed, waiting connection closed in the other pgpools timeout
+
| New feature candidate: Seamless Application Failover
| 2016/7/12
 
 
| 2017/3/23
 
| 2017/3/23
| Tatsuo
+
|  
| http://www.pgpool.net/mantisbt/view.php?id=213
+
| Ahsan
| [SL: 3] Not reproduced here. Waiting for feedback.(2017/2/23)->Closed (2017/3/26).
+
| Similar to Oracle's "Transparent Application Failover".
|-style="background:silver"
+
| postpone to 4.1
| 12
+
|-style="background:orange"
| failover not performed by stanby node
+
| 72
| 2016/8/2
+
| New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)
| 2016/10/7
+
| 2017/4/17
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=227
 
| [3.6 RC1] in progress
 
|- style="background:silver"
 
| 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
 
| <del>[3.6 beta]</del> In progress -> done (2016/12/20)
 
|- style="background:silver"
 
| 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]
 
|- style="background:silver"
 
| 15
 
| watchdog can start even in case VIP is brought up in other nodes.
 
| 2016/8/23
 
 
|  
 
|  
 
| Usama
 
| Usama
 
|
 
|
| Not a bug: Expected behavior with new watchdog (2017/2/8)
+
| postpone to 4.1
|-style="background:silver"
+
|-style="background:white"
| 16
+
| 83
| watchdog can start even in case trusted servers are not reachable.
+
| [pgpool-hackers: 2400] Garbage output
| 2016/8/23
+
| 2017/6/19
 
|  
 
|  
| Usama
+
|Usama
 
|
 
|
| Not a bug: Expected behavior with new watchdog (2017/2/8)
+
| Follow up: [pgpool-hackers: 2798]
 
|-style="background:silver"
 
|-style="background:silver"
| 17
+
| 92
| watchdogs with different VIP can exist in a cluster.
+
| 0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive
| 2016/8/23
+
| 2017/7/21
|
 
| Usama
 
 
|
 
|
| Not a bug: Expected behavior with new watchdog (2017/2/8)
+
| Tatsuo
 +
|https://www.pgpool.net/mantisbt/view.php?id=322
 +
| Close. (2018/10/09)
 
|-style="background:silver"
 
|-style="background:silver"
| 18
+
| 104
| Behavior when watchdog process is killed
+
| 0000329: Newly elected(promoted) Pgpool does connect to any backend
| 2016/8/23
+
| 2017/8/11
|  
+
| 2017/12/11
 
| Usama
 
| Usama
|
+
| http://www.pgpool.net/mantisbt/view.php?id=329
| [SL:1] done (2017/2/8)
+
| Close. (2018/10/09)
 
|-style="background:silver"
 
|-style="background:silver"
| 19
+
| 106
| Changed behavior when all heartbeat LAN are disconnected
+
| 0000332: Watch dog issue
| 2016/8/23
+
| 2017/8/24
|
 
| Usama
 
 
|
 
|
| Not a bug: Expected behavior with new watchdog (2017/2/8)
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=234
+
| http://www.pgpool.net/mantisbt/view.php?id=332
| <del>[3.6 beta]</del>(same as #79)assigned
+
| Closed.(2018/1/9) Doesn't seems like an issue. Replied on Mantis.
 
|-style="background:silver"
 
|-style="background:silver"
| 22
+
| 111
| [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5)
+
| 0000339: Failover does not occurr if master Pgpool-II and primary PostgreSQL servers are stopped at the same time
| 2016/9/9
+
| 2017/9/13
| 2016/9/30
 
| Usama
 
|
 
| Done (2017/2/8)
 
|-style="background:silver"
 
| 23
 
| watchdog sometimes fails de-escalation
 
| 2016/9/21
 
 
|  
 
|  
 
| Usama
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=249
+
| https://www.pgpool.net/mantisbt/view.php?id=339
| Resolved
+
| 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.
 
|-style="background:silver"
 
|-style="background:silver"
| 24
+
| 120
| Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface
+
| 0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC
| 2016/9/28
+
| 2017/10/5
| 2017/3/25
+
|
| Usama
+
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=250
+
| https://www.pgpool.net/mantisbt/view.php?id=349
| [SL:2] in progress
+
| 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.
 
|-style="background:silver"
 
|-style="background:silver"
| 25
+
| 123
| failover_command not executed
+
| [pgpoolAdmin] 0000361: Can't detach node from pgpoolAdmin UI, while pcp_detach_node works fine
| 2016/9/28
+
| 2017/11/01
|
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=251
 
| assigned [Need verification: Should already be fixed in the latest version.](2017/2/8)
 
|-style="background:silver"
 
| 26
 
| pgpoolAdmin 3.6 release
 
 
|
 
|
| 2016/12/31
 
 
| Peng
 
| Peng
|  
+
| https://www.pgpool.net/mantisbt/view.php?id=361
 +
| Done. 2017/11/24
 +
|-style="background:silver"
 +
| 125
 +
| 0000348: pgpool failover scenario ERROR - pgpool 3.6.6 (postgres 9.3.5)
 +
| 2017/11/09
 
|
 
|
|-style="background:silver"
 
| 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.
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 30
 
| Standby server Pgpool shutdown when master server postgresql down due to ipc key conflict
 
| 2016/12/20
 
|
 
 
| Usama
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=266
+
| https://www.pgpool.net/mantisbt/view.php?id=348
| [SL: 2] Assigned
+
| Close. (2018/10/09)
 
|-style="background:silver"
 
|-style="background:silver"
| 31
+
| 126
| log_destination is set to syslog but pgpool does not use /dev/log
+
| 0000342: On master fail slave not able to convert itself to master
| 2016/12/20
+
| 2017/11/09
|  
+
|
 
| Usama
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=267
+
| https://www.pgpool.net/mantisbt/view.php?id=342
| [SL: 2] Assigned
+
| Close. (2018/10/09)
 
|-style="background:silver"
 
|-style="background:silver"
| 32
+
| 127
| pgpool block on issue_command_to_watchdog() for ever when the primary's network is cut off
+
| [pgpoolAdmin]0000364: PGPool hangs when then number of connections are greater than num_init_children
| 2016/12/20
+
| 2017/11/10
|  
+
|
| Usama
+
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=268
+
| https://www.pgpool.net/mantisbt/view.php?id=364
| Assigned [Fixed in latest version]
+
| Close(2018/04/02)
 
|-style="background:silver"
 
|-style="background:silver"
| 33
+
| 128
| authentication timeout with connection_life_time
+
| [pgpoolAdmin] 0000369: yum's baseurl does not exist and it can not be used
| 2016/12/20
+
| 2017/11/24
|
+
|
| Yugo
 
| http://www.pgpool.net/mantisbt/view.php?id=269
 
| Assigned
 
|-style="background:silver"
 
| 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)
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 36
 
| pgpool not releasing shared memory segments
 
| 2016/12/20
 
|
 
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=272
 
| [SL: 2] Fix committed.
 
|-style="background:silver"
 
| 37
 
| ERROR: unable to read data from frontend
 
| 2016/12/20
 
| 2017/4/30
 
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=273
+
| https://www.pgpool.net/mantisbt/view.php?id=369
| [SL:1] Closed. (2017/07/07)
+
| Done. (2017/11/27)
 
|-style="background:silver"
 
|-style="background:silver"
| 38
+
| 129
| PgPool showing all the nodes as standby even though pg_is_in_recovery() shows correctly as master/standby?
+
| [pgpool-hackers: 2635] Some problems in Makefile.am
| 2016/12/20
+
| 2017/12/08
|
+
|
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=274
 
| Assigned
 
|-style="background:silver"
 
| 39
 
| superuser: unknown (Connection error) in pgpoolAdmin
 
| 2017/01/06
 
| 2017/2/16
 
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=276
+
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002635.html
| [SL: 2] Fixed https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=ab3ece87c77cf2eeb09799465ec42285966be3d1
+
| Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
 
|-style="background:silver"
 
|-style="background:silver"
| 40
+
| 130
| pgpoolAdmin is missing in yum repository pgpool36
+
| $(top_srcdir) was created in src/parser/.
| 2017/01/06
+
| 2017/12/08
| 2017/2/28
+
|
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=277
 
| [SL:2] Assigned
 
|-style="background:silver"
 
| 41
 
| Issue 0000248 reproduced in "pgpool-II version 3.6beta2 (subaruboshi)"
 
| 2016/11/10
 
 
|  
 
|  
 +
| Done. 2018/1/8 https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e9bbe227a3fbd92a947f87afd0aace7e0c5c4bec
 +
|-style="background:orange"
 +
| 131
 +
| Logging client message
 +
| 2017/12/08
 +
|
 
| Tatsuo
 
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=260
+
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002638.html
| [SL: 2] not reproduced -> close (2017/2/8)
+
| Completed.
 
|-style="background:silver"
 
|-style="background:silver"
| 42
+
| 132
| Load balancing error
+
| 0000370: Pgpool get stuck with db exception followed by select
| 2016/9/23
+
| 2017/12/11
|  
+
|
 
| Tatsuo
 
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=244
+
| https://www.pgpool.net/mantisbt/view.php?id=370
| [SL: 2] Same issue as bug271 (item 35)
+
| Close. (2018/3/5) Patch provided. Waiting for feedback.-> Resolved.
|-style="background:white"
 
| 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
 
|-style="background:silver"
 
| 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)
 
 
|-style="background:silver"
 
|-style="background:silver"
| 45
+
| 133
| stack smashing detected
+
| Failed in 002.native_replication. (Pgpool-II couldn't rewrite DEFAULT)
| 2017/1/18
+
| 2017/12/14
|
+
| 2017/12/18
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=280
 
| Done (2017/2/8)
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 48
 
| PGPool hangs in Master/Slave mode with Slony submodule
 
| 2017/2/8
 
| 2017/4/30
 
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=283
 
| [SL: 2] Closed. (2017/07/07)
 
|-style="background:silver"
 
| 49
 
| pgpool-II native replication loses sync every 1-2 days
 
| 2017/2/8
 
 
|  
 
|  
| Usama
+
| Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=b974f5f3b59b62ca3f0c5c0ccfdea125abbbc19b
| http://www.pgpool.net/mantisbt/view.php?id=284
 
| [SL: 2] Done
 
 
|-style="background:silver"
 
|-style="background:silver"
| 50
+
| 134
| pgpool hangs with hibernate and spring
+
| [pgpoolAdmin] Pull Request
| 2017/2/8
+
| 2017/12/14
| 2017/2/28
+
|
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=286
 
| [SL: 2] waiting for feedback -> no feedback. Closed.
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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)
 
|-style="background:silver"
 
| 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)
 
|-style="background:silver"
 
| 55
 
| Inconsistent backend state
 
| 2017/2/28
 
| 2017/4/05
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=289
 
| [SL: 3] Assigned (resolved)
 
|-style="background:silver"
 
| 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] Closed. 2017/11/10
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 60
 
| Notice: Undefined variable: msgPcpPassFile in $PATH/checkParameter.php on line 427
 
| 2017/3/21
 
| 2017/5/10
 
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=297
+
| https://github.com/pgpool/pgpooladmin/compare/master...remodoy:postgresql_connect_timeout
| [SL: 3] Done.
+
| Done. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=579833e695e011f8d47a6fff994a3393f9d8a37d
 
|-style="background:silver"
 
|-style="background:silver"
| 61
+
| 135
| [Feature] New feature candidate: import PostgreSQL 10.0 SQL parser
+
| Modify pgpool.service to output log.
| 2017/3/23
+
| 2017/12/15
| 2017/9/22
 
| Peng
 
 
|  
 
|  
| Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=57196ae03cab9989c0c15deee49c3d4642450112
 
|-style="background:pink"
 
| 62
 
| [Feature] New feature candidate: certification base authentication
 
| 2017/3/23
 
|
 
|
 
|
 
| postpone to 3.8
 
|-style="background:white"
 
| 63
 
| New feature candidate: Seamless Application Failover
 
| 2017/3/23
 
|
 
|
 
| Similar to Oracle's "Transparent Application Failover".
 
| Postpone to 3.8 or later
 
|-style="background:silver"
 
| 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
 
| Peng
 
|  
 
|  
|
+
| Done. 2017/12/21 <br> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=63886312c702811f7ed53fac266c22946ba2212e
|-style="background:silver"
+
|-style="background:orange"
| 65
+
| 136
| PgpoolAdmin shows Port instead Status (MASTER/SLAVE) of Pgpool Servers in Watchdog
+
| allow to specify load balance weight ratio for load balance parameters
| 2017/3/23
+
| 2017/12/15
| 2017/4/14
+
| 2018/8/10
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=293
+
| https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html
| Done
+
| Done.
|-style="background:silver"
+
|-style="background:orange"
| 66
+
| 137
| pcp_watchdog_info command error occurred. Notice: Undefined offset: 2 in $PATH/command.php on line 156
+
| Load-balancing control for specific queries
| 2017/3/24
+
| 2017/12/15
|  
+
| 2018/05/11
 
| Peng
 
| Peng
| http://www.pgpool.net/mantisbt/view.php?id=298
+
|https://www.pgpool.net/pipermail/pgpool-hackers/2017-November/002594.html
| Fixed. (.pcppass file is required.)
+
| Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=search;s=Bo+Peng;st=author
 
|-style="background:silver"
 
|-style="background:silver"
| 67
+
| 138
| Minor release
+
| Minor releases (3.7.1, 3.6.8 etc.)
| 2017/3/27
+
| 2017/12/15
| 2017/4/30
+
| 2018/1/9
 
| Peng
 
| Peng
|
 
| Released on 4/28
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 69
 
| New Defects reported by Coverity Scan for pgpool-II
 
| 2017/4/4
 
|
 
| Usama
 
|
 
|
 
|-style="background:silver"
 
| 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
 
|-style="background:silver"
 
| 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)
 
|-style="background:white"
 
| 72
 
| New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE)
 
| 2017/4/17
 
|
 
| Usama
 
 
|
 
|
| Postpone to 3.8
+
| Done. 2018/1/9
 
|-style="background:silver"
 
|-style="background:silver"
| 73
+
| 139
| Update mantis
+
| 0000373: pgpool failed over
| 2017/4/25
+
| 2017/12/21
 
|  
 
|  
| pengbo
+
| Tatsuo
|
+
| http://www.pgpool.net/mantisbt/view.php?id=373
|
+
| Waiting for feedback.-> no response. Closed.
|-style="background:silver"
 
| 74
 
| Pgpool steals back MASTER status
 
| 2017/4/25
 
| 2017/5/11
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=306
 
| Fix committed
 
 
|-style="background:silver"
 
|-style="background:silver"
| 75
+
| 140
| Inconsistent node status with watchdog configuration
+
| 0000374: md5 authentication is broken
| 2017/4/20
+
| 2017/12/23
 
|  
 
|  
| Usama
+
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=305
+
| http://www.pgpool.net/mantisbt/view.php?id=374
| Waiting for feedback (2017/6/6)->closed (2017/7/24)
+
| Waiting for feedback.-> no response. Closed.
 
|-style="background:silver"
 
|-style="background:silver"
| 76
+
| 141
| pgpool failed after pool_check_fd call failed with an error "Interrupted system call"
+
| 0000375: extended query error
| 2017/4/27
+
| 2018/01/08
 
|  
 
|  
| 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).
 
|-style="background:silver"
 
| 77
 
| Pgpool-II 3.6.4, 3.5.8 release
 
| 2017/5/8
 
| 2017/5/11
 
 
| Peng
 
| Peng
|
+
| http://www.pgpool.net/mantisbt/view.php?id=375
| Released. 2017/05/11
+
| Close.2018/4/27
 
|-style="background:silver"
 
|-style="background:silver"
| 78
+
| 142
| 0000310: INSERT ... ON CONFLICT ... DO UPDATE queries hang
+
| 0000376: child process was terminated by segmentation fault
| 2017/6/13
+
| 2018/01/12
 
|  
 
|  
| ishii
+
| Tatsuo
|https://www.pgpool.net/mantisbt/view.php?id=310
+
| http://www.pgpool.net/mantisbt/view.php?id=376
| waiting for feedback (2017/6/13)->closed (2017/7/19)
+
| Closed. (2018/2/6)
|-style="background:silver"
+
|-style="background:white"
| 79
+
| 143
| 0000312: Node stays at 0 on pgpool
+
| [pgpool-general: 5863] pgpool frequnet authentication timeout
| 2017/6/13
+
| 2018/01/19
 
|  
 
|  
| ishii
 
|https://www.pgpool.net/mantisbt/view.php?id=312
 
| waiting for feedback (2017/6/13)->closed (2017/7/19)
 
|-style="background:silver"
 
| 80
 
| 0000309: bind socket failed with error: "Address already in use"
 
| 2017/6/13
 
|
 
 
| Usama
 
| Usama
|https://www.pgpool.net/mantisbt/view.php?id=309
+
| http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005921.html
| Closed. (2017/8/28)
+
| In progress.
 
|-style="background:silver"
 
|-style="background:silver"
| 81
+
| 144
| 0000315: High CPU usage when commiting large transactions and using in (shared) memory cache
+
| [pgpool-general: 5864] Troubleshooting assistance on node failure and connections blocking
| 2017/6/20
+
| 2018/01/19
 
|  
 
|  
| Usama
+
| Tatsuo
|https://www.pgpool.net/mantisbt/view.php?id=315
+
| http://www.sraoss.jp/pipermail/pgpool-general/2018-January/005922.html
| Fix committed (2017/6/29)
+
| Waiting for feedback (2017/1/19)-> No response from the poster over 1 month. Issue closed.
|-style="background:silver"
+
|-style="background:white"
| 82
+
| 145
| 0000316: One postgresql backend node is marked down often
+
| [pgpool-general: 5899] Master Election - Priority
| 2017/6/26
+
| 2018/01/30
 
|  
 
|  
 
| Usama
 
| Usama
|https://www.pgpool.net/mantisbt/view.php?id=316
+
| https://www.pgpool.net/pipermail/pgpool-general/2018-January/005957.html
| closed (2017/7/24)
 
|-style="background:white"
 
| 83
 
| [pgpool-hackers: 2400] Garbage output
 
| 2017/6/19
 
|
 
|Usama
 
 
|
 
|
 
|-style="background:silver"
 
|-style="background:silver"
| 84
+
| 146
| 0000304: Hibernate is hanging in connect PGPOOL-II
+
| 0000378: Pgpool fails all connections when secondary goes down
| 2017/4/20
+
| 2018/02/06
|
 
|Ishii
 
|https://www.pgpool.net/mantisbt/view.php?id=304
 
|Waiting for feedback (2017/6/28)->No response. Issue closed(2017/08/04)
 
|-style="background:silver"
 
| 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).
 
|-style="background:silver"
 
| 86
 
| Pgpool-II minor release
 
 
|  
 
|  
| 2017/7/11
+
| Tatsuo
|Peng
+
| https://www.pgpool.net/mantisbt/view.php?id=378
|
+
| No response over 1 month. I am going to close the issue.
|
 
|-style="background:silver"
 
| 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)
 
|-style="background:silver"
 
| 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)
 
 
|-style="background:silver"
 
|-style="background:silver"
| 89
+
| 147
| New feature candidate: deal with logical replication
+
| 0000379: Many connections go into state 'idle in transaction'
| 2017/7/7
+
| 2018/02/07
 
|
 
|
|ishii
+
| Tatsuo
|https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002444.html
+
| http://www.pgpool.net/mantisbt/view.php?id=379
| Closed. (2017/8/28)
+
| Patch provided. Waiting for feedback (2018/2/28)
 
|-style="background:silver"
 
|-style="background:silver"
| 90
+
| 148
| 0000320: Index Error Violations are never returned to the application
+
| 0000380: When a node is down, the first query to the cluster fails
| 2017/7/16
+
| 2018/02/14
 
|
 
|
|Ishii
+
| Tatsuo
|https://www.pgpool.net/mantisbt/view.php?id=320
+
| http://www.pgpool.net/mantisbt/view.php?id=380
| Closed. (2017/8/28)
+
| It turned out a problem with user's setting.
|-style="background:silver"
+
|-style="background:pink"
| 91
+
| 149
| 0000323: After error : the connection is marked as "idle in transaction (aborted)
+
| Proposal: Enhancing pool_process and pool_pools
| 2017/7/20
+
| 2018/02/13
|
 
|Ishii
 
|https://www.pgpool.net/mantisbt/view.php?id=323
 
| Closed. (2017/8/28)
 
|-style="background:yellow"
 
| 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
 
 
|
 
|
 +
| Tatsuo
 +
| http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html
 +
| postpone to 4.1
 +
|-style="background:orange"
 +
| 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)
 
|-style="background:silver"
 
|-style="background:silver"
| 93
+
| 151
| Add some Japanese document.
+
| 0000385: arping, if_up_cmd' failed and failed to acquire delegate Ip
| 2017/7/21
+
| 2018/03/16
 
|
 
|
 
| Peng
 
| Peng
|
+
| https://www.pgpool.net/mantisbt/view.php?id=385
| Done.
+
| Close. (2018/3/26)
|-style="background:silver"
 
| 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)
 
|-style="background:silver"
 
| 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.
 
 
|-style="background:silver"
 
|-style="background:silver"
| 96
+
| 152
| [pgpool-general: 5653] pgpoolAdmin-3.6.1-1pgdg.rhel7.noarch.rpm does not have js direcotry.
+
| 0000386: Pgpool fails to start with a watchdog error
| 2017/7/31
+
| 2018/03/16
 
|
 
|
 
| Peng
 
| Peng
|https://www.pgpool.net/pipermail/pgpool-general/2017-July/005711.html
+
| https://www.pgpool.net/mantisbt/view.php?id=386
| Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=649f0bb0b7be9c824c9fe19f3287639d3f0e0109
+
| Close. (2018/04/27)
 
|-style="background:silver"
 
|-style="background:silver"
| 97
+
| 153
| [pgpool-general: 5660] pgpoolAdmin can not set expectedly Pgpool-II params related to bool type ones in "pgpool.conf Setting"
+
| 0000388: pgpool-II 3.6.1 child process remain waiting for a non-existing client socket to send queries
| 2017/7/31
+
| 2018/03/18
 
|
 
|
| Peng
+
| Tatsuo
|https://www.pgpool.net/pipermail/pgpool-general/2017-July/005718.html
+
| https://www.pgpool.net/mantisbt/view.php?id=388
| Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=8e919744217efae6d6f71a1a07a681183e79c813
+
| Assigned (2018/04/06)-> Waiting for feedback (2018/05/07)->No feedback. Closed.
 
|-style="background:silver"
 
|-style="background:silver"
| 98
+
| 154
| 0000324: backend consumes large amount of RAM with long sessions
+
| 0000394: When multiple failover happens the pgpool pool node status is going into standby -stanby state
| 2017/7/31
+
| 2018/04/21
 
|
 
|
|Ishii
+
| Usama
|https://www.pgpool.net/mantisbt/view.php?id=324
+
| https://www.pgpool.net/mantisbt/view.php?id=394
| 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.
+
| Close. (2018/10/09)
|-style="background:silver"
+
|-style="background:white"
| 99
+
| 155
|0000325: pool_check_fd call failed with an error "Interrupted system call"
+
| [pgpool-general: 6069] failover_require_consensus does not work.
| 2017/08/02
+
| 2018/05/03
 
|
 
|
|Ishii
+
| Usama
|https://www.pgpool.net/mantisbt/view.php?id=325
+
| https://www.pgpool.net/pipermail/pgpool-general/2018-May/006127.html
| Waiting for feedback (2017/8/03)->it turned out configuration problem.
+
| Assigned (2018/05/07)
|-style="background:silver"
+
|-style="background:white"
| 100
+
| 156
|[pgpool-general: 5683] Postgres error not processed by pgpool
+
| [pgpool-hackers: 2807] client_min_messages
| 2017/08/04
+
| 2018/05/25
|
 
|Ishii
 
|https://www.pgpool.net/pipermail/pgpool-general/2017-August/005741.html
 
| Waiting for feedback (2017/8/04)-> Solved (2017/8/7)
 
|-style="background:silver"
 
| 101
 
| New feature candidate: Need to support hostname in pool_hba.conf, currently only IP addresses are support
 
 
|
 
|
| 2017/9/30
 
 
| Usama
 
| Usama
 +
| http://www.sraoss.jp/pipermail/pgpool-hackers/2018-May/002807.html
 +
| Assigned (2018/05/25)
 +
|-style="background:orange"
 +
| 157
 +
| [Feature] Proposal: Add last state change timestamp to "show pool_nodes"
 +
| 2018/06/11
 
|
 
|
| Target date includes English documentation
+
| Tatsuo
 +
| http://www.sraoss.jp/pipermail/pgpool-hackers/2018-June/002822.html
 +
| Done. (2018/06/12)
 
|-style="background:silver"
 
|-style="background:silver"
| 102
+
| 158
| 0000326: pcp_node_info command error occurred on pgpool admin
+
| 0000403: About : 0000402: write on backend 0 failed with error :"Success"
 +
| 2018/06/15
 
|
 
|
|
+
| Tatsuo
| Peng
+
| https://www.pgpool.net/mantisbt/view.php?id=403
| http://www.pgpool.net/mantisbt/view.php?id=326
+
| Assigned.(2018/6/15) ->Waiting for feedback (2018/6/15)->The reporter's skill is not enough to test the patch. So I commited/pushed the patch.
| Waiting for feedback. (2017/8/20)
+
|-style="background:orange"
|-style="background:silver"
+
| 159
| 103
+
| [Feature] Add "last status change" to pcp_node_info and pgpool_adm like "show pool_nodes".
| 0000327: Cannot connect to PGPool when caching is enabled (Redshift)
+
| 2018/06/15
| 2017/8/9
+
|
 +
| Tatsuo
 +
|
 +
| Done.
 +
|-style="background:orange"
 +
| 160
 +
| [Feature] Add pid info to pcp_proc_info output.
 +
| 2018/06/15
 
|
 
|
| Ishii
+
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=327
 
| Waiting for feedback (2017/8/16)
 
|-style="background:yellow"
 
| 104
 
| 0000329: Newly elected(promoted) Pgpool does connect to any backend
 
| 2017/8/11
 
 
|  
 
|  
| Usama
+
| Done (2018/7/9).
| http://www.pgpool.net/mantisbt/view.php?id=329
 
| fix in 3.7 done. Needs back patching
 
 
|-style="background:silver"
 
|-style="background:silver"
| 105
+
| 161
| 0000330: Unable to connect to pgpool-II using jdbc
+
| 0000405: ERROR: unable to read message length DETAIL: message length (8) in slot 1 does not match with slot 0(12) bash-4.1$
| 2017/8/14
+
| 2018/06/22
 
|
 
|
| Ishii
+
|  
| http://www.pgpool.net/mantisbt/view.php?id=330
+
| https://www.pgpool.net/mantisbt/view.php?id=405
| Fixed.
+
| Closed. (2018/8/6) 
|-style="background:yellow"
 
| 106
 
| 0000332: Watch dog issue
 
| 2017/8/24
 
|
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=332
 
| Assigned.
 
 
|-style="background:silver"
 
|-style="background:silver"
| 107
+
| 162
| 0000333: watchdog fails to add node to master when wd_authkey is not an empty string; pgpool member shuts down
+
| 0000406: failover called with old-primary = -1
| 2017/8/24
+
| 2018/06/22
 
|
 
|
 
| Usama
 
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=333
+
| https://www.pgpool.net/mantisbt/view.php?id=406
| Fixed.
+
| Closed.(2018/8/6)
 
|-style="background:silver"
 
|-style="background:silver"
| 108
+
| 163
| Pgpool-II minor release.
+
| 0000407: health check process doesn't start in some cases
| 2017/9/5
+
| 2018/06/22
 
|
 
|
| Peng
+
| Tatsuo
|  
+
| https://www.pgpool.net/mantisbt/view.php?id=407
| Done.
+
| Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=f9149dd4992eb6cbbbdf5d8a3f0a00ef2c0f3071
 
|-style="background:silver"
 
|-style="background:silver"
| 109
+
| 164
| 0000336: During load the server in production would fail connectivity with a slave and itself, resulting in removing nodes
+
| [pgpool-general: 6134] kind mismatch among backends with multiple clients and prepared statements
| 2017/8/29
+
| 2018/06/22
 
|
 
|
| Ishii
+
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=336
+
| http://www.sraoss.jp/pipermail/pgpool-general/2018-June/006192.html
| Waiting for feedback (2017/9/6)
+
| Closed. (2018/8/6)
|-style="background:silver"
+
|-style="background:orange"
| 110
+
| 165
| [pgpoolAdmin] Add support for PHP7
+
| [Feature] Import PostgreSQL 11 parser.
| 2017/9/11
+
| 2018/06/22
| 2017/10/30
 
| Peng
 
|
 
| Done.https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=694502da1929a643875c661fe34b278e6efaa142
 
|-style="background:yellow"
 
| 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
 
|-style="background:silver"
 
| 112
 
| [pgpoolAdmin] [pgpool-general: 5720] "Return" node automatically
 
| 2017/9/15
 
| 2017/9/30
 
| Peng
 
|
 
| Done.[pgpool-general: 5743] 
 
|-style="background:silver"
 
| 113
 
| 3.7 release-note
 
| 2017/10/1
 
| 2017/10/5
 
 
| Peng
 
| Peng
 
|  
 
|  
 
| Done.
 
| Done.
|-style="background:silver"
+
|-style="background:orange"
| 114
+
| 166
| Failover bug in replication mode
+
| [Feature] Logging client message.
| 2017/9/20
+
| 2018/07/27
| 2017/9/22
 
| Ishii
 
| https://www.pgpool.net/pipermail/pgpool-general/2017-September/005786.html
 
| Fix pushed.
 
|-style="background:silver"
 
| 115
 
| 0000343: Pgpool log is empty after upgrade
 
| 2017/9/26
 
 
|
 
|
| Peng
+
| Hoshiai
| http://www.pgpool.net/mantisbt/view.php?id=343
+
| http://www.sraoss.jp/pipermail/pgpool-hackers/2017-December/002638.html
| In progress.
+
| Done. (https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=54503f4c87f1853ec1e71e65331adddc05531312)
|-style="background:silver"
+
|-style="background:orange"
| 116
+
| 167
| 0000345: pgpool node.js prepared statement
+
| Run pg_ident.
| 2017/10/3
+
| 2018/08/02
|
+
| 2018/08/13
| ishii
+
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=345
 
| Patch provided. Waiting for feedback.
 
|-style="background:silver"
 
| 117
 
| new featue candidate: add "role" column to pcp_node_info command
 
| 2017/10/3
 
| 2017/10/4
 
| ishii
 
 
|  
 
|  
 
| Done.
 
| Done.
|-style="background:silver"
+
|-style="background:orange"
| 118
+
| 168
| 0000347: backend response with kind 'E' when expecting 'R'
+
| 4.0 Release-notes. (English)
| 2017/10/4
+
| 2018/08/06
|
+
| 2018/08/13
| ishii
 
| http://www.pgpool.net/mantisbt/view.php?id=347
 
| Waiting for feedback.
 
|-style="background:silver"
 
| 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.
 
|-style="background:white"
 
| 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)
 
|-style="background:silver"
 
| 121
 
| Add RPMs for PostgreSQL 10
 
|
 
| 2017/11/01
 
 
| Peng
 
| Peng
 
|  
 
|  
 
| Done.
 
| Done.
 
|-style="background:silver"
 
|-style="background:silver"
| 122
+
| 169
| 0000356: pg_terminate_backend() causing failover despite setting flag
+
| 0000426: Pgpool-II contines to emit warning messages
| 2017/10/19
+
| 2018/8/27
|
+
|  
 
| Usama
 
| Usama
| https://www.pgpool.net/mantisbt/view.php?id=356
+
| https://www.pgpool.net/mantisbt/view.php?id=426
| Fixed in master, 3.6 and 3.5 stable branch. Waiting for feedback.
+
| 4.0 alpha2 blocker.
|-style="background:white"
 
| 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.
 
 
|-style="background:silver"
 
|-style="background:silver"
| 124
+
| 170
| 0000363: health check not detect node after down
+
| 0000427: pg_enc emits wrong warnings
| 2017/11/09
+
| 2018/8/27
|
+
|  
| Peng
 
| https://www.pgpool.net/mantisbt/view.php?id=363
 
| Closed.2017/11/9
 
|-style="background:white"
 
| 125
 
| 0000348: pgpool failover scenario ERROR - pgpool 3.6.6 (postgres 9.3.5)
 
| 2017/11/09
 
|
 
 
| Usama
 
| Usama
| https://www.pgpool.net/mantisbt/view.php?id=348
+
| https://www.pgpool.net/mantisbt/view.php?id=427
|
+
| 4.0 alpha2 blocker.
|-style="background:white"
+
|-style="background:silver"
| 126
+
| 171
| 0000342: On master fail slave not able to convert itself to master
+
| 0000428: Secure TCP/IP Connections with SSL does not work any more
| 2017/11/09
+
| 2018/8/27
|
+
|  
 
| Usama
 
| Usama
| https://www.pgpool.net/mantisbt/view.php?id=342
+
| https://www.pgpool.net/mantisbt/view.php?id=428
|
+
| 4.0 alpha2 blocker.
 
|-style="background:white"
 
|-style="background:white"
| 127
+
| 172
| 0000364: PGPool hangs when then number of connections are greater than num_init_children
+
| pgpoolAdmin 4.0
| 2017/11/10
+
| 2018/10/05
|
+
|  
 
| Peng
 
| Peng
| https://www.pgpool.net/mantisbt/view.php?id=364
+
|  
| Assigned.
+
|  
 
|-style="background:silver"
 
|-style="background:silver"
 
| 200
 
| 200
 
| Feature Agreement
 
| Feature Agreement
 
|  
 
|  
| 2017/3/31
+
| 2018/3/31
 
|  
 
|  
 
|
 
|
Line 1,037: Line 517:
 
|-style="background:silver"
 
|-style="background:silver"
 
| 201
 
| 201
| Code Freeze including English docs except release notes
+
| Feature Freeze
 
|  
 
|  
| 2017/9/30
+
| 2018/7/31
 
|  
 
|  
 
|
 
|
|
+
|  
 
|-style="background:silver"
 
|-style="background:silver"
 
| 202
 
| 202
| Beta 1 including release notes and Japanese docs
+
| Code Freeze
 
|  
 
|  
| 2017/10/17
+
| 2018/9/30
 
|  
 
|  
 
|
 
|
 +
|
 +
|-style="background:silver"
 +
| 203
 +
| Alpha 1 Release
 
|  
 
|  
 +
| 2018/8/21
 +
|
 +
|
 +
| Done.
 
|-style="background:white"
 
|-style="background:white"
| 203
+
| 204
| RC1 Release.
+
| Alpha 2 Release
 +
|
 +
| 2018/9/5
 +
|
 +
|
 
|
 
|
| 2017/11/13
+
|-style="background:white"
 +
| 205
 +
| Beta 1 Release
 
|  
 
|  
 +
| 2018/9/19
 +
|
 +
|
 
|
 
|
 +
|-style="background:white"
 +
| 206
 +
| RC 1 Release
 
|  
 
|  
 +
| 2018/10/3
 +
|
 +
|
 +
|
 
|-style="background:white"
 
|-style="background:white"
| 204
+
| 207
| Pgpool-II 3.7 official release
+
| Official Release
 +
|
 +
| 2018/10/17
 +
|  
 
|
 
|
| 2017/11/22
 
 
|
 
|
|
 
|
 
 
|}
 
|}

Latest revision as of 08:03, 9 October 2018

Last update: 2018/10/09 (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 4.1
3 Make PCP set configuration command public 2016/2/15 - Usama - [Feature: small]->postpone to 4.1
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] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/query_cache -> This item is deleted. https://www.pgpool.net/pipermail/pgpool-hackers/2018-June/002845.html
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/8/10 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". postpone to 4.1
72 New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE) 2017/4/17 Usama postpone to 4.1
83 [pgpool-hackers: 2400] Garbage output 2017/6/19 Usama Follow up: [pgpool-hackers: 2798]
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 Close. (2018/10/09)
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 Close. (2018/10/09)
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 Close. (2018/10/09)
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 Close. (2018/10/09)
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 Completed.
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 2018/8/10 Peng https://www.pgpool.net/pipermail/pgpool-hackers/2017-December/002651.html Done.
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 Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=search;s=Bo+Peng;st=author
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 postpone to 4.1
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)-> Waiting for feedback (2018/05/07)->No feedback. Closed.
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 Close. (2018/10/09)
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)
156 [pgpool-hackers: 2807] client_min_messages 2018/05/25 Usama http://www.sraoss.jp/pipermail/pgpool-hackers/2018-May/002807.html Assigned (2018/05/25)
157 [Feature] Proposal: Add last state change timestamp to "show pool_nodes" 2018/06/11 Tatsuo http://www.sraoss.jp/pipermail/pgpool-hackers/2018-June/002822.html Done. (2018/06/12)
158 0000403: About : 0000402: write on backend 0 failed with error :"Success" 2018/06/15 Tatsuo https://www.pgpool.net/mantisbt/view.php?id=403 Assigned.(2018/6/15) ->Waiting for feedback (2018/6/15)->The reporter's skill is not enough to test the patch. So I commited/pushed the patch.
159 [Feature] Add "last status change" to pcp_node_info and pgpool_adm like "show pool_nodes". 2018/06/15 Tatsuo Done.
160 [Feature] Add pid info to pcp_proc_info output. 2018/06/15 Tatsuo Done (2018/7/9).
161 0000405: ERROR: unable to read message length DETAIL: message length (8) in slot 1 does not match with slot 0(12) bash-4.1$ 2018/06/22 https://www.pgpool.net/mantisbt/view.php?id=405 Closed. (2018/8/6)
162 0000406: failover called with old-primary = -1 2018/06/22 Usama https://www.pgpool.net/mantisbt/view.php?id=406 Closed.(2018/8/6)
163 0000407: health check process doesn't start in some cases 2018/06/22 Tatsuo https://www.pgpool.net/mantisbt/view.php?id=407 Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=f9149dd4992eb6cbbbdf5d8a3f0a00ef2c0f3071
164 [pgpool-general: 6134] kind mismatch among backends with multiple clients and prepared statements 2018/06/22 Tatsuo http://www.sraoss.jp/pipermail/pgpool-general/2018-June/006192.html Closed. (2018/8/6)
165 [Feature] Import PostgreSQL 11 parser. 2018/06/22 Peng Done.
166 [Feature] Logging client message. 2018/07/27 Hoshiai http://www.sraoss.jp/pipermail/pgpool-hackers/2017-December/002638.html Done. (https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=54503f4c87f1853ec1e71e65331adddc05531312)
167 Run pg_ident. 2018/08/02 2018/08/13 Tatsuo Done.
168 4.0 Release-notes. (English) 2018/08/06 2018/08/13 Peng Done.
169 0000426: Pgpool-II contines to emit warning messages 2018/8/27 Usama https://www.pgpool.net/mantisbt/view.php?id=426 4.0 alpha2 blocker.
170 0000427: pg_enc emits wrong warnings 2018/8/27 Usama https://www.pgpool.net/mantisbt/view.php?id=427 4.0 alpha2 blocker.
171 0000428: Secure TCP/IP Connections with SSL does not work any more 2018/8/27 Usama https://www.pgpool.net/mantisbt/view.php?id=428 4.0 alpha2 blocker.
172 pgpoolAdmin 4.0 2018/10/05 Peng
200 Feature Agreement 2018/3/31
201 Feature Freeze 2018/7/31
202 Code Freeze 2018/9/30
203 Alpha 1 Release 2018/8/21 Done.
204 Alpha 2 Release 2018/9/5
205 Beta 1 Release 2018/9/19
206 RC 1 Release 2018/10/3
207 Official Release 2018/10/17