Difference between revisions of "pgpool-II 3.7 development"

From pgpool Wiki
Jump to: navigation, search
 
(404 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
Last update: 2016/12/07 (gray items are done, yellow items are behind schedule)
+
Last update: 2017/11/24 (gray items are done, yellow items are behind schedule, pink items are new features for 3.7)
 +
 
 +
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 9: Line 11:
 
! Overview
 
! Overview
 
! Status
 
! Status
−
|--style="background:yellow"
+
|-style="background:silver"
 
| 1
 
| 1
 
| pgpool:330
 
| pgpool:330
Line 16: Line 18:
 
| Ahsan, Tatsuo
 
| Ahsan, Tatsuo
 
| mesuring pgpool-II overhead
 
| mesuring pgpool-II overhead
−
| [in progress]  Tatsuo will review the result, postpone to 3.6
+
| [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
 
| 2015/09/03
 
| 2015/09/03
 
| -
 
| -
−
| -
+
| Usama
 
| add new child if it goes down
 
| add new child if it goes down
−
| need to assign, postpone to 3.7
+
| [Feature: small]->postpone to 3.8
 
|- style="background:white"
 
|- style="background:white"
 
| 3
 
| 3
Line 32: Line 34:
 
| Usama
 
| Usama
 
| -
 
| -
−
| Low priority
+
| [Feature: small]->postpone to 3.8
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 4
 
| 4
 
| Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS
 
| Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS
Line 40: Line 42:
 
| Usama
 
| Usama
 
|
 
|
−
| [RC1]
+
|  
−
|-
+
|-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/3/4
 
|
 
|
−
|
+
| Tatsuo
−
| http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_pg_rewind_in_online_recovery
+
| http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_multiple_pgpool-II_instances_with_in-memory_query_cache_enabled
−
| Low priority
+
| [Feature: small] [medium size implementation]->postpone to 3.8
−
|-
 
 
|-
 
|-
 +
|-style="background:silver"
 
| 6
 
| 6
−
| Health-check timeout for each backend node
+
| [Feature] Health-check timeout for each backend node
 
| 2016/3/4
 
| 2016/3/4
−
|
+
| 2017/5/31
−
|
+
| Ishii
 
| http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node
 
| http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node
−
| Low priority
+
| [Feature: medium] [medium size implementation] Proposal: http://www.pgpool.net/pipermail/pgpool-hackers/2017-March/002213.html
−
|-
+
|-style="background:silver"
 
| 7
 
| 7
 
| pgpool routes queries with "SET TRANSACTION READ ONLY" to master
 
| pgpool routes queries with "SET TRANSACTION READ ONLY" to master
Line 65: Line 67:
 
| t-ishii
 
| t-ishii
 
| http://www.pgpool.net/mantisbt/view.php?id=195
 
| http://www.pgpool.net/mantisbt/view.php?id=195
−
| low priority
+
| [SL: 3] Closed.
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 8
 
| 8
 
| Connections stuck - Recv-Q fills up
 
| Connections stuck - Recv-Q fills up
Line 73: Line 75:
 
| Usama
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=203
 
| http://www.pgpool.net/mantisbt/view.php?id=203
−
| in progress
+
| [SL: 3] [Feedback 2017/3/1]
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 9
 
| 9
 
| failed to create INET domain socket
 
| failed to create INET domain socket
Line 81: Line 83:
 
| pengbo
 
| pengbo
 
| http://www.pgpool.net/mantisbt/view.php?id=202
 
| http://www.pgpool.net/mantisbt/view.php?id=202
−
| waiting for feedback
+
| fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=39d24e7f7ff88dfa780982059421ff6f405e63db
−
|-
+
|-style="background:silver"
 
| 10
 
| 10
 
| testing of new failover code
 
| testing of new failover code
 
| 2016/6/6
 
| 2016/6/6
−
|  
+
| 2017/2/28
 
| Ahsan
 
| Ahsan
 
|
 
|
−
| assigned (Not started yet, plan to start after #04)
+
| [SL : 3] assigned (Not started yet, plan to start after #04)
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 11
 
| 11
 
| ERROR: node recovery failed, waiting connection closed in the other pgpools timeout
 
| ERROR: node recovery failed, waiting connection closed in the other pgpools timeout
 
| 2016/7/12
 
| 2016/7/12
−
| 2016/8/26
+
| 2017/3/23
 
| Tatsuo
 
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=213  
 
| http://www.pgpool.net/mantisbt/view.php?id=213  
−
|
+
| [SL: 3] Not reproduced here. Waiting for feedback.(2017/2/23)->Closed (2017/3/26).
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 12
 
| 12
 
| failover not performed by stanby node
 
| failover not performed by stanby node
Line 106: Line 108:
 
| http://www.pgpool.net/mantisbt/view.php?id=227
 
| http://www.pgpool.net/mantisbt/view.php?id=227
 
| [3.6 RC1] in progress
 
| [3.6 RC1] in progress
−
|-
+
|- style="background:silver"
 
| 13
 
| 13
 
| packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2']
 
| packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2']
Line 113: Line 115:
 
| Tatsuo
 
| Tatsuo
 
| http://www.pgpool.net/mantisbt/view.php?id=231
 
| http://www.pgpool.net/mantisbt/view.php?id=231
−
| <del>[3.6 beta]</del> In progress
+
| <del>[3.6 beta]</del> In progress -> done (2016/12/20)
−
|-style="background:yellow"
+
|- style="background:silver"
 
| 14
 
| 14
 
| [pgpool-general: 4912] Pgpool and IP bonding
 
| [pgpool-general: 4912] Pgpool and IP bonding
 
| 2016/8/18
 
| 2016/8/18
−
| 2016/9/20
+
| 2017/3/10
 
| Usama
 
| Usama
 
| http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html
 
| http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html
−
| [3.6 RC1] assigned
+
| [3.6 RC1][closed 2017/2/28][unable to reproduce] [no response from user]
−
|-
+
|- style="background:silver"
 
| 15
 
| 15
 
| watchdog can start even in case VIP is brought up in other nodes.
 
| watchdog can start even in case VIP is brought up in other nodes.
Line 129: Line 131:
 
| Usama
 
| Usama
 
|
 
|
−
| assigned
+
| Not a bug: Expected behavior with new watchdog (2017/2/8)
−
|-
+
|-style="background:silver"
 
| 16
 
| 16
 
| watchdog can start even in case trusted servers are not reachable.
 
| watchdog can start even in case trusted servers are not reachable.
Line 137: Line 139:
 
| Usama
 
| Usama
 
|
 
|
−
| assigned
+
| Not a bug: Expected behavior with new watchdog (2017/2/8)
−
|-
+
|-style="background:silver"
 
| 17
 
| 17
 
| watchdogs with different VIP can exist in a cluster.
 
| watchdogs with different VIP can exist in a cluster.
Line 145: Line 147:
 
| Usama
 
| Usama
 
|
 
|
−
| assigned
+
| Not a bug: Expected behavior with new watchdog (2017/2/8)
−
|-
+
|-style="background:silver"
 
| 18
 
| 18
 
| Behavior when watchdog process is killed
 
| Behavior when watchdog process is killed
Line 153: Line 155:
 
| Usama
 
| Usama
 
|
 
|
−
| assigned
+
| [SL:1] done (2017/2/8)
−
|-
+
|-style="background:silver"
 
| 19
 
| 19
 
| Changed behavior when all heartbeat LAN are disconnected
 
| Changed behavior when all heartbeat LAN are disconnected
Line 161: Line 163:
 
| Usama
 
| Usama
 
|
 
|
−
| assigned
+
| Not a bug: Expected behavior with new watchdog (2017/2/8)
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 20
 
| 20
 
| Connections remains open when backend dettach during a transaction
 
| Connections remains open when backend dettach during a transaction
Line 169: Line 171:
 
| Pengbo
 
| Pengbo
 
| http://www.pgpool.net/mantisbt/view.php?id=240
 
| http://www.pgpool.net/mantisbt/view.php?id=240
−
| waiting for feedback (It wasn't reproduced)-->There was an already feedback on 10/3.
+
| [SL: 1] not reproduced
−
|-
+
|-style="background:silver"
 
| 21
 
| 21
 
| pgpool fails to run failover script if the sever running primary pgpool node and postgresql server dies
 
| pgpool fails to run failover script if the sever running primary pgpool node and postgresql server dies
Line 178: Line 180:
 
| http://www.pgpool.net/mantisbt/view.php?id=234
 
| http://www.pgpool.net/mantisbt/view.php?id=234
 
| <del>[3.6 beta]</del>(same as #79)assigned  
 
| <del>[3.6 beta]</del>(same as #79)assigned  
−
|-style="background:yellow"
+
|-style="background:silver"
 
| 22
 
| 22
 
| [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5)
 
| [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5)
Line 185: Line 187:
 
| Usama
 
| Usama
 
|  
 
|  
−
| [3.6 RC1] assigned
+
| Done (2017/2/8)
−
|-
+
|-style="background:silver"
 
| 23
 
| 23
 
| watchdog sometimes fails de-escalation
 
| watchdog sometimes fails de-escalation
Line 193: Line 195:
 
| Usama
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=249
 
| http://www.pgpool.net/mantisbt/view.php?id=249
−
| assigned
+
| Resolved
−
|-
+
|-style="background:silver"
 
| 24
 
| 24
 
| Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface
 
| Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface
 
| 2016/9/28
 
| 2016/9/28
−
|  
+
| 2017/3/25
 
| Usama
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=250
 
| http://www.pgpool.net/mantisbt/view.php?id=250
−
| assigned
+
| [SL:2] in progress
−
|-
+
|-style="background:silver"
 
| 25
 
| 25
 
| failover_command not executed
 
| failover_command not executed
Line 209: Line 211:
 
| Usama
 
| Usama
 
| http://www.pgpool.net/mantisbt/view.php?id=251
 
| http://www.pgpool.net/mantisbt/view.php?id=251
−
| assigned
+
| assigned [Need verification: Should already be fixed in the latest version.](2017/2/8)
−
|-style="background:white"
+
|-style="background:silver"
 
| 26
 
| 26
 
| pgpoolAdmin 3.6 release
 
| pgpoolAdmin 3.6 release
 
|
 
|
 
| 2016/12/31
 
| 2016/12/31
 +
| Peng
 +
|
 +
|
 +
|-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
 +
| http://www.pgpool.net/mantisbt/view.php?id=266
 +
| [SL: 2] Assigned
 +
|-style="background:silver"
 +
| 31
 +
| log_destination is set to syslog but pgpool does not use /dev/log
 +
| 2016/12/20
 +
|
 +
| Usama
 +
| http://www.pgpool.net/mantisbt/view.php?id=267
 +
| [SL: 2] Assigned
 +
|-style="background:silver"
 +
| 32
 +
| pgpool block on issue_command_to_watchdog() for ever when the primary's network is cut off
 +
| 2016/12/20
 +
|
 +
| Usama
 +
| http://www.pgpool.net/mantisbt/view.php?id=268
 +
| Assigned [Fixed in latest version]
 +
|-style="background:silver"
 +
| 33
 +
| authentication timeout with connection_life_time
 +
| 2016/12/20
 +
|
 +
| 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
 +
| http://www.pgpool.net/mantisbt/view.php?id=273
 +
| [SL:1] Closed. (2017/07/07)
 +
|-style="background:silver"
 +
| 38
 +
| PgPool showing all the nodes as standby even though pg_is_in_recovery() shows correctly as master/standby?
 +
| 2016/12/20
 +
|
 +
| Tatsuo
 +
| http://www.pgpool.net/mantisbt/view.php?id=274
 +
| Assigned
 +
|-style="background:silver"
 +
| 39
 +
| superuser: unknown (Connection error) in pgpoolAdmin
 +
| 2017/01/06
 +
| 2017/2/16
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=276
 +
| [SL: 2] Fixed https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=ab3ece87c77cf2eeb09799465ec42285966be3d1
 +
|-style="background:silver"
 +
| 40
 +
| pgpoolAdmin is missing in yum repository pgpool36
 +
| 2017/01/06
 +
| 2017/2/28
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=277
 +
| [SL:2] Assigned
 +
|-style="background:silver"
 +
| 41
 +
| Issue 0000248 reproduced in "pgpool-II version 3.6beta2 (subaruboshi)"
 +
| 2016/11/10
 +
|
 +
| Tatsuo
 +
| http://www.pgpool.net/mantisbt/view.php?id=260
 +
| [SL: 2] not reproduced -> close (2017/2/8)
 +
|-style="background:silver"
 +
| 42
 +
| Load balancing error
 +
| 2016/9/23
 +
|
 +
| Tatsuo
 +
| http://www.pgpool.net/mantisbt/view.php?id=244
 +
| [SL: 2] Same issue as bug271 (item 35)
 +
|-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"
 +
| 45
 +
| stack smashing detected
 +
| 2017/1/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
 +
| 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
 +
| http://www.pgpool.net/mantisbt/view.php?id=284
 +
| [SL: 2] Done
 +
|-style="background:silver"
 +
| 50
 +
| pgpool hangs with hibernate and spring
 +
| 2017/2/8
 +
| 2017/2/28
 +
| Tatsuo
 +
| http://www.pgpool.net/mantisbt/view.php?id=286
 +
| [SL: 2] waiting for feedback -> no feedback. Closed.
 +
|-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
 +
| http://www.pgpool.net/mantisbt/view.php?id=297
 +
| [SL: 3] Done.
 +
|-style="background:silver"
 +
| 61
 +
| [Feature] New feature candidate: import PostgreSQL 10.0 SQL parser
 +
| 2017/3/23
 +
| 2017/9/22
 +
| Peng
 +
|
 +
| Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=57196ae03cab9989c0c15deee49c3d4642450112
 +
|-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
 +
|
 +
|
 +
|-style="background:silver"
 +
| 65
 +
| PgpoolAdmin shows Port instead Status (MASTER/SLAVE) of Pgpool Servers in Watchdog
 +
| 2017/3/23
 +
| 2017/4/14
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=293
 +
| Done
 +
|-style="background:silver"
 +
| 66
 +
| pcp_watchdog_info command error occurred. Notice: Undefined offset: 2 in $PATH/command.php on line 156
 +
| 2017/3/24
 +
|
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=298
 +
| Fixed. (.pcppass file is required.)
 +
|-style="background:silver"
 +
| 67
 +
| Minor release
 +
| 2017/3/27
 +
| 2017/4/30
 +
| 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
 +
|-style="background:silver"
 +
| 73
 +
| Update mantis
 +
| 2017/4/25
 +
|
 +
| pengbo
 +
|
 +
|
 +
|-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"
 +
| 75
 +
| Inconsistent node status with watchdog configuration
 +
| 2017/4/20
 +
|
 +
| Usama
 +
| http://www.pgpool.net/mantisbt/view.php?id=305
 +
| Waiting for feedback (2017/6/6)->closed (2017/7/24)
 +
|-style="background:silver"
 +
| 76
 +
| pgpool failed after pool_check_fd call failed with an error "Interrupted system call"
 +
| 2017/4/27
 +
|
 +
| ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=307
 +
| Waiting for feedback (2017/5/18)->No feedback over 1 month. Closed (2017/6/26).
 +
|-style="background:silver"
 +
| 77
 +
| Pgpool-II 3.6.4, 3.5.8 release
 +
| 2017/5/8
 +
| 2017/5/11
 +
| Peng
 +
|
 +
| Released. 2017/05/11
 +
|-style="background:silver"
 +
| 78
 +
| 0000310: INSERT ... ON CONFLICT ... DO UPDATE queries hang
 +
| 2017/6/13
 +
|
 +
| ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=310
 +
| waiting for feedback (2017/6/13)->closed (2017/7/19)
 +
|-style="background:silver"
 +
| 79
 +
| 0000312: Node stays at 0 on pgpool
 +
| 2017/6/13
 +
|
 +
| ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=312
 +
| waiting for feedback (2017/6/13)->closed (2017/7/19)
 +
|-style="background:silver"
 +
| 80
 +
| 0000309: bind socket failed with error: "Address already in use"
 +
| 2017/6/13
 +
|
 +
| Usama
 +
|https://www.pgpool.net/mantisbt/view.php?id=309
 +
| Closed. (2017/8/28)
 +
|-style="background:silver"
 +
| 81
 +
| 0000315: High CPU usage when commiting large transactions and using in (shared) memory cache
 +
| 2017/6/20
 +
|
 +
| Usama
 +
|https://www.pgpool.net/mantisbt/view.php?id=315
 +
| Fix committed (2017/6/29)
 +
|-style="background:silver"
 +
| 82
 +
| 0000316: One postgresql backend node is marked down often
 +
| 2017/6/26
 +
|
 +
| Usama
 +
|https://www.pgpool.net/mantisbt/view.php?id=316
 +
| closed (2017/7/24)
 +
|-style="background:white"
 +
| 83
 +
| [pgpool-hackers: 2400] Garbage output
 +
| 2017/6/19
 +
|
 +
|Usama
 +
|
 +
|-style="background:silver"
 +
| 84
 +
| 0000304: Hibernate is hanging in connect PGPOOL-II
 +
| 2017/4/20
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=304
 +
|Waiting for feedback (2017/6/28)->No response. Issue closed(2017/08/04)
 +
|-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
 +
|Peng
 +
|
 +
|
 +
|-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"
 +
| 89
 +
| New feature candidate: deal with logical replication
 +
| 2017/7/7
 +
|
 +
|ishii
 +
|https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002444.html
 +
| Closed. (2017/8/28)
 +
|-style="background:silver"
 +
| 90
 +
| 0000320: Index Error Violations are never returned to the application
 +
| 2017/7/16
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=320
 +
| Closed. (2017/8/28)
 +
|-style="background:silver"
 +
| 91
 +
| 0000323: After error : the connection is marked as "idle in transaction (aborted)
 +
| 2017/7/20
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=323
 +
| Closed. (2017/8/28)
 +
|-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
 +
|
 +
|-style="background:silver"
 +
| 93
 +
| Add some Japanese document.
 +
| 2017/7/21
 +
|
 +
| Peng
 +
|
 +
| Done.
 +
|-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"
 +
| 96
 +
| [pgpool-general: 5653] pgpoolAdmin-3.6.1-1pgdg.rhel7.noarch.rpm does not have js direcotry.
 +
| 2017/7/31
 +
|
 +
| Peng
 +
|https://www.pgpool.net/pipermail/pgpool-general/2017-July/005711.html
 +
| Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=649f0bb0b7be9c824c9fe19f3287639d3f0e0109
 +
|-style="background:silver"
 +
| 97
 +
| [pgpool-general: 5660] pgpoolAdmin can not set expectedly Pgpool-II params related to bool type ones in "pgpool.conf Setting"
 +
| 2017/7/31
 +
|
 +
| Peng
 +
|https://www.pgpool.net/pipermail/pgpool-general/2017-July/005718.html
 +
| Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=8e919744217efae6d6f71a1a07a681183e79c813
 +
|-style="background:silver"
 +
| 98
 +
| 0000324: backend consumes large amount of RAM with long sessions
 +
| 2017/7/31
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=324
 +
| Patch provided. Waiting for feedback (2017/8/2) It turns out that this is application's issue. They don't issue close messages -> Issue closed.
 +
|-style="background:silver"
 +
| 99
 +
|0000325: pool_check_fd call failed with an error "Interrupted system call"
 +
| 2017/08/02
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/mantisbt/view.php?id=325
 +
| Waiting for feedback (2017/8/03)->it turned out configuration problem.
 +
|-style="background:silver"
 +
| 100
 +
|[pgpool-general: 5683] Postgres error not processed by pgpool
 +
| 2017/08/04
 +
|
 +
|Ishii
 +
|https://www.pgpool.net/pipermail/pgpool-general/2017-August/005741.html
 +
| Waiting for feedback (2017/8/04)-> Solved (2017/8/7)
 +
|-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
 +
|
 +
| Target date includes English documentation
 +
|-style="background:silver"
 +
| 102
 +
| 0000326: pcp_node_info command error occurred on pgpool admin
 +
|
 +
| 
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=326
 +
| Waiting for feedback. (2017/8/20)
 +
|-style="background:silver"
 +
| 103
 +
| 0000327: Cannot connect to PGPool when caching is enabled (Redshift)
 +
| 2017/8/9
 +
|
 +
| Ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=327
 +
| Waiting for feedback (2017/8/16)
 +
|-style="background:yellow"
 +
| 104
 +
| 0000329: Newly elected(promoted) Pgpool does connect to any backend
 +
| 2017/8/11
 +
|
 +
| Usama
 +
| http://www.pgpool.net/mantisbt/view.php?id=329
 +
| fix in 3.7 done. Needs back patching
 +
|-style="background:silver"
 +
| 105
 +
| 0000330: Unable to connect to pgpool-II using jdbc
 +
| 2017/8/14
 +
|
 +
| Ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=330
 +
| Fixed.
 +
|-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"
 +
| 107
 +
| 0000333: watchdog fails to add node to master when wd_authkey is not an empty string; pgpool member shuts down
 +
| 2017/8/24
 +
|
 +
| Usama
 +
| http://www.pgpool.net/mantisbt/view.php?id=333
 +
| Fixed.
 +
|-style="background:silver"
 +
| 108
 +
| Pgpool-II minor release.
 +
| 2017/9/5
 +
|
 +
| Peng
 +
|
 +
| Done.
 +
|-style="background:silver"
 +
| 109
 +
| 0000336: During load the server in production would fail connectivity with a slave and itself, resulting in removing nodes
 +
| 2017/8/29
 +
|
 +
| Ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=336
 +
| Waiting for feedback (2017/9/6)
 +
|-style="background:silver"
 +
| 110
 +
| [pgpoolAdmin] Add support for PHP7
 +
| 2017/9/11
 +
| 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
 +
|
 +
| Done.
 +
|-style="background:silver"
 +
| 114
 +
| Failover bug in replication mode
 +
| 2017/9/20
 +
| 2017/9/22
 +
| Ishii
 +
| https://www.pgpool.net/pipermail/pgpool-general/2017-September/005786.html
 +
| Fix pushed.
 +
|-style="background:silver"
 +
| 115
 +
| 0000343: Pgpool log is empty after upgrade
 +
| 2017/9/26
 +
|
 +
| Peng
 +
| http://www.pgpool.net/mantisbt/view.php?id=343
 +
| In progress.
 +
|-style="background:silver"
 +
| 116
 +
| 0000345: pgpool node.js prepared statement
 +
| 2017/10/3
 +
|
 +
| ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=345
 +
| Patch provided. Waiting for feedback.
 +
|-style="background:silver"
 +
| 117
 +
| new featue candidate: add "role" column to pcp_node_info command
 +
| 2017/10/3
 +
| 2017/10/4
 +
| ishii
 
|  
 
|  
−
| -
+
| Done.
 +
|-style="background:silver"
 +
| 118
 +
| 0000347: backend response with kind 'E' when expecting 'R'
 +
| 2017/10/4
 +
|
 +
| ishii
 +
| http://www.pgpool.net/mantisbt/view.php?id=347
 +
| Waiting for feedback.
 +
|-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
 +
|
 +
| Done.
 +
|-style="background:silver"
 +
| 122
 +
| 0000356: pg_terminate_backend() causing failover despite setting flag
 +
| 2017/10/19
 +
|
 +
| Usama
 +
| https://www.pgpool.net/mantisbt/view.php?id=356
 +
| Fixed in master, 3.6 and 3.5 stable branch. Waiting for feedback.
 +
|-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"
 +
| 124
 +
| 0000363: health check not detect node after down
 +
| 2017/11/09
 +
|
 +
| Peng
 +
| https://www.pgpool.net/mantisbt/view.php?id=363
 +
| Closed.2017/11/9
 +
|-style="background:white"
 +
| 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
 +
|
 +
|-style="background:white"
 +
| 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
 +
|
 +
|-style="background:white"
 +
| 127
 +
| 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
 +
| Assigned.
 +
|-style="background:white"
 +
| 128
 +
| 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
 +
| Assigned.
 +
|-style="background:silver"
 +
| 200
 +
| Feature Agreement
 +
|
 +
| 2017/3/31
 +
|
 +
|
 +
|
 +
|-style="background:silver"
 +
| 201
 +
| Code Freeze including English docs except release notes
 +
|
 +
| 2017/9/30
 +
|
 +
|
 +
|
 +
|-style="background:silver"
 +
| 202
 +
| Beta 1 including release notes and Japanese docs
 +
|
 +
| 2017/10/17
 +
|
 +
|
 +
|
 +
|-style="background:silver"
 +
| 203
 +
| RC1 Release.
 +
|
 +
| 2017/11/13
 +
|
 +
|
 +
| Done. 2017/11/13
 +
|-style="background:silver"
 +
| 204
 +
| Pgpool-II 3.7 official release
 +
|
 +
| 2017/11/22
 +
|
 +
|
 +
| Done. 2017/11/22
 
|}
 
|}

Latest revision as of 00:17, 24 November 2017

Last update: 2017/11/24 (gray items are done, yellow items are behind schedule, pink items are new features for 3.7)

Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.

ID Registered/start Date Target Date Person in charge Overview Status
1 pgpool:330 2015/08/12 2016/06/17 Ahsan, Tatsuo mesuring pgpool-II overhead [in progress] Tatsuo will review the result, postpone to 3.6 -> the data taken was not using provisioned IO and the data is not very useful. Remove the item and expect another chance (PGECons?)
2 pgpool-hackers:1034 2015/09/03 - Usama add new child if it goes down [Feature: small]->postpone to 3.8
3 Make PCP set configuration command public 2016/2/15 - Usama - [Feature: small]->postpone to 3.8
4 Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS 2016/2/26 2016/8/31 Usama
5 Allow to use multiple pgpool-II instances with in-memory query cache enabled 2016/3/4 Tatsuo http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_multiple_pgpool-II_instances_with_in-memory_query_cache_enabled [Feature: small] [medium size implementation]->postpone to 3.8
6 [Feature] Health-check timeout for each backend node 2016/3/4 2017/5/31 Ishii http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node [Feature: medium] [medium size implementation] Proposal: http://www.pgpool.net/pipermail/pgpool-hackers/2017-March/002213.html
7 pgpool routes queries with "SET TRANSACTION READ ONLY" to master 2016/5/18 2016/6/30 t-ishii http://www.pgpool.net/mantisbt/view.php?id=195 [SL: 3] Closed.
8 Connections stuck - Recv-Q fills up 2016/6/2 2016/7/26 Usama http://www.pgpool.net/mantisbt/view.php?id=203 [SL: 3] [Feedback 2017/3/1]
9 failed to create INET domain socket 2016/6/2 2016/8/15 pengbo http://www.pgpool.net/mantisbt/view.php?id=202 fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=39d24e7f7ff88dfa780982059421ff6f405e63db
10 testing of new failover code 2016/6/6 2017/2/28 Ahsan [SL : 3] assigned (Not started yet, plan to start after #04)
11 ERROR: node recovery failed, waiting connection closed in the other pgpools timeout 2016/7/12 2017/3/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=213 [SL: 3] Not reproduced here. Waiting for feedback.(2017/2/23)->Closed (2017/3/26).
12 failover not performed by stanby node 2016/8/2 2016/10/7 Usama http://www.pgpool.net/mantisbt/view.php?id=227 [3.6 RC1] in progress
13 packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2'] 2016/8/15 2016/9/30 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=231 [3.6 beta] In progress -> done (2016/12/20)
14 [pgpool-general: 4912] Pgpool and IP bonding 2016/8/18 2017/3/10 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html [3.6 RC1][closed 2017/2/28][unable to reproduce] [no response from user]
15 watchdog can start even in case VIP is brought up in other nodes. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
16 watchdog can start even in case trusted servers are not reachable. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
17 watchdogs with different VIP can exist in a cluster. 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
18 Behavior when watchdog process is killed 2016/8/23 Usama [SL:1] done (2017/2/8)
19 Changed behavior when all heartbeat LAN are disconnected 2016/8/23 Usama Not a bug: Expected behavior with new watchdog (2017/2/8)
20 Connections remains open when backend dettach during a transaction 2016/9/2 Pengbo http://www.pgpool.net/mantisbt/view.php?id=240 [SL: 1] not reproduced
21 pgpool fails to run failover script if the sever running primary pgpool node and postgresql server dies 2016/9/6 2016/9/30 Usama http://www.pgpool.net/mantisbt/view.php?id=234 [3.6 beta](same as #79)assigned
22 [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5) 2016/9/9 2016/9/30 Usama Done (2017/2/8)
23 watchdog sometimes fails de-escalation 2016/9/21 Usama http://www.pgpool.net/mantisbt/view.php?id=249 Resolved
24 Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface 2016/9/28 2017/3/25 Usama http://www.pgpool.net/mantisbt/view.php?id=250 [SL:2] in progress
25 failover_command not executed 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=251 assigned [Need verification: Should already be fixed in the latest version.](2017/2/8)
26 pgpoolAdmin 3.6 release 2016/12/31 Peng
27 pgpool-II sometimes hangs on restart 2016/12/06 Ishii http://www.pgpool.net/mantisbt/view.php?id=265 [SL: 2] fix committed on 2017/1/12. Issue closed.
28 [pgpool-general: 5172] Version 3.6 is missing pgpool_adm extension 2016/12/19 2016/12/22 Peng http://www.sraoss.jp/pipermail/pgpool-general/2016-December/005230.html Fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f8a157a1288c1ee452e981151b58875540a5cc90
29 While attaching nodes in replication mode "show pool_nodes" is showing different values on each node 2016/12/20 2017/3/10 Peng http://www.pgpool.net/mantisbt/view.php?id=258 [SL:3] Closed
30 Standby server Pgpool shutdown when master server postgresql down due to ipc key conflict 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=266 [SL: 2] Assigned
31 log_destination is set to syslog but pgpool does not use /dev/log 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=267 [SL: 2] Assigned
32 pgpool block on issue_command_to_watchdog() for ever when the primary's network is cut off 2016/12/20 Usama http://www.pgpool.net/mantisbt/view.php?id=268 Assigned [Fixed in latest version]
33 authentication timeout with connection_life_time 2016/12/20 Yugo http://www.pgpool.net/mantisbt/view.php?id=269 Assigned
34 pgpool system hung cause parallel many query 2016/12/20 2017/3/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=270 waiting for feedback (2017/4/3)-> no feed back. Closed (2017/5/1)
35 balanced requests after started transaction 2016/12/20 2017/3/31 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=271 [SL: 1] closed on 2017/3/31
36 pgpool not releasing shared memory segments 2016/12/20 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=272 [SL: 2] Fix committed.
37 ERROR: unable to read data from frontend 2016/12/20 2017/4/30 Peng http://www.pgpool.net/mantisbt/view.php?id=273 [SL:1] Closed. (2017/07/07)
38 PgPool showing all the nodes as standby even though pg_is_in_recovery() shows correctly as master/standby? 2016/12/20 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=274 Assigned
39 superuser: unknown (Connection error) in pgpoolAdmin 2017/01/06 2017/2/16 Peng http://www.pgpool.net/mantisbt/view.php?id=276 [SL: 2] Fixed https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=ab3ece87c77cf2eeb09799465ec42285966be3d1
40 pgpoolAdmin is missing in yum repository pgpool36 2017/01/06 2017/2/28 Peng http://www.pgpool.net/mantisbt/view.php?id=277 [SL:2] Assigned
41 Issue 0000248 reproduced in "pgpool-II version 3.6beta2 (subaruboshi)" 2016/11/10 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=260 [SL: 2] not reproduced -> close (2017/2/8)
42 Load balancing error 2016/9/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=244 [SL: 2] Same issue as bug271 (item 35)
43 new feature candidate: verify standby node while finding primary node 2017/1/12 Tatsuo/Usama http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001979.html [Feature: Medium][medium size implementation]->postpone to 3.8
44 [pgpool-general: 5223] Questionable Failover 2017/1/12 Usama http://www.pgpool.net/pipermail/pgpool-general/2017-January/005281.html Done (2017/2/8)
45 stack smashing detected 2017/1/18 Usama http://www.pgpool.net/mantisbt/view.php?id=280 Done (2017/2/8)
46 new feature candidate: Proposal to make backend node failover mechanism quorum aware 2017/1/10 2017/9/22 Usama http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001974.html [Feature: large][Medium size implementation] Target date includes English documentation
47 "segmentation fault" when execute pcp_attach_node 2017/1/27 Usama http://www.pgpool.net/mantisbt/view.php?id=281 [SL: 2] in progress
48 PGPool hangs in Master/Slave mode with Slony submodule 2017/2/8 2017/4/30 Peng http://www.pgpool.net/mantisbt/view.php?id=283 [SL: 2] Closed. (2017/07/07)
49 pgpool-II native replication loses sync every 1-2 days 2017/2/8 Usama http://www.pgpool.net/mantisbt/view.php?id=284 [SL: 2] Done
50 pgpool hangs with hibernate and spring 2017/2/8 2017/2/28 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=286 [SL: 2] waiting for feedback -> no feedback. Closed.
51 Syntax Error in Query Using CURRENT_TIMESTAMP 2017/2/23 2017/3/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=287 [SL: 3] waiting for feedback from 3017/2/23. Will close on 3/23->Closed on 3/26
52 Pgpool hangs on query and doesn't send it to backend 2017/2/23 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=282 [SL: 3] Done
53 FATAL: failed to read kind from backend 2017/2/23 2017/4/07 Usama http://www.pgpool.net/mantisbt/view.php?id=288 [SL: 3] Assigned (resolved)
54 [pgpool-general: 5315] pg_terminate_backend 2017/2/23 Usama http://www.pgpool.net/pipermail/pgpool-general/2017-February/005373.html [SL: 3] (code committed)
55 Inconsistent backend state 2017/2/28 2017/4/05 Usama http://www.pgpool.net/mantisbt/view.php?id=289 [SL: 3] Assigned (resolved)
56 [safety violation] master without quorum execute failover procedure 2017/2/28 2017/7/31 Usama http://www.pgpool.net/mantisbt/view.php?id=290 [SL: 3] Closed. 2017/11/10
57 [pgpool-general: 5350] pgpooladmin version issue 2017/3/3 2017/3/31 Peng http://www.pgpool.net/pipermail/pgpool-general/2017-February/005408.html [SL: 3] Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=4615f807179fbfbdb18c7856e109d95f53abc201
58 Pgpool service fails to start on the load of OS 2017/3/15 2017/3/31 Peng http://www.pgpool.net/mantisbt/view.php?id=294 [SL: 3] Assigned
59 PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking' 2017/3/21 2017/3/31 Usama http://www.pgpool.net/mantisbt/view.php?id=296 Fixed on 2017/3/24
60 Notice: Undefined variable: msgPcpPassFile in $PATH/checkParameter.php on line 427 2017/3/21 2017/5/10 Peng http://www.pgpool.net/mantisbt/view.php?id=297 [SL: 3] Done.
61 [Feature] New feature candidate: import PostgreSQL 10.0 SQL parser 2017/3/23 2017/9/22 Peng Done.https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=57196ae03cab9989c0c15deee49c3d4642450112
62 [Feature] New feature candidate: certification base authentication 2017/3/23 postpone to 3.8
63 New feature candidate: Seamless Application Failover 2017/3/23 Similar to Oracle's "Transparent Application Failover". Postpone to 3.8 or later
64 Pgpool-II minor releases (3.6.2, 3.5.6, 3.4.10, 3.3.14, 3.2.19) 2017/3/17 2017/3/17 Peng
65 PgpoolAdmin shows Port instead Status (MASTER/SLAVE) of Pgpool Servers in Watchdog 2017/3/23 2017/4/14 Peng http://www.pgpool.net/mantisbt/view.php?id=293 Done
66 pcp_watchdog_info command error occurred. Notice: Undefined offset: 2 in $PATH/command.php on line 156 2017/3/24 Peng http://www.pgpool.net/mantisbt/view.php?id=298 Fixed. (.pcppass file is required.)
67 Minor release 2017/3/27 2017/4/30 Peng Released on 4/28
68 [pgpool-general: 5396] pam ldap failure 2017/3/30 Usama http://www.pgpool.net/pipermail/pgpool-general/2017-March/005454.html Fixed on 2017/3/31
69 New Defects reported by Coverity Scan for pgpool-II 2017/4/4 Usama
70 Errors on the reloading of configuration 2017/4/7 Usama http://www.pgpool.net/mantisbt/view.php?id=299 Fixed on 2017/4/12
71 0000300: pgpool-II doesn't handle lost socket file 2017/4/14 2017/5/14 t-ishii http://www.pgpool.net/mantisbt/view.php?id=300 waiting for feedback (2017/4/17)->replied that it's resolved (2017/5/15)
72 New feature candidate: Support more prefix for query routing (similar to NO LOAD BALANCE) 2017/4/17 Usama Postpone to 3.8
73 Update mantis 2017/4/25 pengbo
74 Pgpool steals back MASTER status 2017/4/25 2017/5/11 Usama http://www.pgpool.net/mantisbt/view.php?id=306 Fix committed
75 Inconsistent node status with watchdog configuration 2017/4/20 Usama http://www.pgpool.net/mantisbt/view.php?id=305 Waiting for feedback (2017/6/6)->closed (2017/7/24)
76 pgpool failed after pool_check_fd call failed with an error "Interrupted system call" 2017/4/27 ishii http://www.pgpool.net/mantisbt/view.php?id=307 Waiting for feedback (2017/5/18)->No feedback over 1 month. Closed (2017/6/26).
77 Pgpool-II 3.6.4, 3.5.8 release 2017/5/8 2017/5/11 Peng Released. 2017/05/11
78 0000310: INSERT ... ON CONFLICT ... DO UPDATE queries hang 2017/6/13 ishii https://www.pgpool.net/mantisbt/view.php?id=310 waiting for feedback (2017/6/13)->closed (2017/7/19)
79 0000312: Node stays at 0 on pgpool 2017/6/13 ishii https://www.pgpool.net/mantisbt/view.php?id=312 waiting for feedback (2017/6/13)->closed (2017/7/19)
80 0000309: bind socket failed with error: "Address already in use" 2017/6/13 Usama https://www.pgpool.net/mantisbt/view.php?id=309 Closed. (2017/8/28)
81 0000315: High CPU usage when commiting large transactions and using in (shared) memory cache 2017/6/20 Usama https://www.pgpool.net/mantisbt/view.php?id=315 Fix committed (2017/6/29)
82 0000316: One postgresql backend node is marked down often 2017/6/26 Usama https://www.pgpool.net/mantisbt/view.php?id=316 closed (2017/7/24)
83 [pgpool-hackers: 2400] Garbage output 2017/6/19 Usama
84 0000304: Hibernate is hanging in connect PGPOOL-II 2017/4/20 Ishii https://www.pgpool.net/mantisbt/view.php?id=304 Waiting for feedback (2017/6/28)->No response. Issue closed(2017/08/04)
85 0000317: pgpool sometimes fails to return a "Ready for query" causing client to hang. 2017/6/30 Ishii https://www.pgpool.net/mantisbt/view.php?id=317 Closed. (2017/8/28).
86 Pgpool-II minor release 2017/7/11 Peng
87 0000318: Exception in plpgsql function is not passed to application 2017/7/5 Peng https://www.pgpool.net/mantisbt/view.php?id=318 Closed. (2017/8/28)
88 New feature candidate: deal with Amazon Aurora 2017/7/7 ishii https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002430.html Closed. (2017/8/28)
89 New feature candidate: deal with logical replication 2017/7/7 ishii https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002444.html Closed. (2017/8/28)
90 0000320: Index Error Violations are never returned to the application 2017/7/16 Ishii https://www.pgpool.net/mantisbt/view.php?id=320 Closed. (2017/8/28)
91 0000323: After error : the connection is marked as "idle in transaction (aborted) 2017/7/20 Ishii https://www.pgpool.net/mantisbt/view.php?id=323 Closed. (2017/8/28)
92 0000322: PGPool child processes go into <defunct> state when a backend node is unresponsive 2017/7/21 Usama https://www.pgpool.net/mantisbt/view.php?id=322
93 Add some Japanese document. 2017/7/21 Peng Done.
94 Deal with OpenSSL 1.1 2017/7/25 Ishii https://www.pgpool.net/pipermail/pgpool-general/2016-July/004828.html Done (2017/9/11)
95 [pgpool-general: 5640] oom when memory_cache_enabled is on 2017/7/28 Ishii https://www.pgpool.net/pipermail/pgpool-general/2017-July/005698.html Fix pushed (2017/8/9). Waiting for the feedback.
96 [pgpool-general: 5653] pgpoolAdmin-3.6.1-1pgdg.rhel7.noarch.rpm does not have js direcotry. 2017/7/31 Peng https://www.pgpool.net/pipermail/pgpool-general/2017-July/005711.html Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=649f0bb0b7be9c824c9fe19f3287639d3f0e0109
97 [pgpool-general: 5660] pgpoolAdmin can not set expectedly Pgpool-II params related to bool type ones in "pgpool.conf Setting" 2017/7/31 Peng https://www.pgpool.net/pipermail/pgpool-general/2017-July/005718.html Fixed. https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commitdiff;h=8e919744217efae6d6f71a1a07a681183e79c813
98 0000324: backend consumes large amount of RAM with long sessions 2017/7/31 Ishii https://www.pgpool.net/mantisbt/view.php?id=324 Patch provided. Waiting for feedback (2017/8/2) It turns out that this is application's issue. They don't issue close messages -> Issue closed.
99 0000325: pool_check_fd call failed with an error "Interrupted system call" 2017/08/02 Ishii https://www.pgpool.net/mantisbt/view.php?id=325 Waiting for feedback (2017/8/03)->it turned out configuration problem.
100 [pgpool-general: 5683] Postgres error not processed by pgpool 2017/08/04 Ishii https://www.pgpool.net/pipermail/pgpool-general/2017-August/005741.html Waiting for feedback (2017/8/04)-> Solved (2017/8/7)
101 New feature candidate: Need to support hostname in pool_hba.conf, currently only IP addresses are support 2017/9/30 Usama Target date includes English documentation
102 0000326: pcp_node_info command error occurred on pgpool admin Peng http://www.pgpool.net/mantisbt/view.php?id=326 Waiting for feedback. (2017/8/20)
103 0000327: Cannot connect to PGPool when caching is enabled (Redshift) 2017/8/9 Ishii http://www.pgpool.net/mantisbt/view.php?id=327 Waiting for feedback (2017/8/16)
104 0000329: Newly elected(promoted) Pgpool does connect to any backend 2017/8/11 Usama http://www.pgpool.net/mantisbt/view.php?id=329 fix in 3.7 done. Needs back patching
105 0000330: Unable to connect to pgpool-II using jdbc 2017/8/14 Ishii http://www.pgpool.net/mantisbt/view.php?id=330 Fixed.
106 0000332: Watch dog issue 2017/8/24 Usama http://www.pgpool.net/mantisbt/view.php?id=332 Assigned.
107 0000333: watchdog fails to add node to master when wd_authkey is not an empty string; pgpool member shuts down 2017/8/24 Usama http://www.pgpool.net/mantisbt/view.php?id=333 Fixed.
108 Pgpool-II minor release. 2017/9/5 Peng Done.
109 0000336: During load the server in production would fail connectivity with a slave and itself, resulting in removing nodes 2017/8/29 Ishii http://www.pgpool.net/mantisbt/view.php?id=336 Waiting for feedback (2017/9/6)
110 [pgpoolAdmin] Add support for PHP7 2017/9/11 2017/10/30 Peng Done.https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=694502da1929a643875c661fe34b278e6efaa142
111 0000339: Failover does not occurr if master Pgpool-II and primary PostgreSQL servers are stopped at the same time 2017/9/13 Usama https://www.pgpool.net/mantisbt/view.php?id=339 Done in 3.6, 3.5, 3.7. Working on 3.4 and 3.3
112 [pgpoolAdmin] [pgpool-general: 5720] "Return" node automatically 2017/9/15 2017/9/30 Peng Done.[pgpool-general: 5743]
113 3.7 release-note 2017/10/1 2017/10/5 Peng Done.
114 Failover bug in replication mode 2017/9/20 2017/9/22 Ishii https://www.pgpool.net/pipermail/pgpool-general/2017-September/005786.html Fix pushed.
115 0000343: Pgpool log is empty after upgrade 2017/9/26 Peng http://www.pgpool.net/mantisbt/view.php?id=343 In progress.
116 0000345: pgpool node.js prepared statement 2017/10/3 ishii http://www.pgpool.net/mantisbt/view.php?id=345 Patch provided. Waiting for feedback.
117 new featue candidate: add "role" column to pcp_node_info command 2017/10/3 2017/10/4 ishii Done.
118 0000347: backend response with kind 'E' when expecting 'R' 2017/10/4 ishii http://www.pgpool.net/mantisbt/view.php?id=347 Waiting for feedback.
119 0000351: pgpool crashes after a network outage to the master 2017/10/9 ishii http://www.pgpool.net/mantisbt/view.php?id=351 Waiting for feedback.
120 0000349: Connection to PGpool Port through VIP fails to connect with JDBC, works fine with ODBC 2017/10/5 ishii http://www.pgpool.net/mantisbt/view.php?id=349 Waiting for feedback.(2017/10/6)
121 Add RPMs for PostgreSQL 10 2017/11/01 Peng Done.
122 0000356: pg_terminate_backend() causing failover despite setting flag 2017/10/19 Usama https://www.pgpool.net/mantisbt/view.php?id=356 Fixed in master, 3.6 and 3.5 stable branch. Waiting for feedback.
123 0000361: Can't detach node from pgpoolAdmin UI, while pcp_detach_node works fine 2017/11/01 Peng https://www.pgpool.net/mantisbt/view.php?id=361 Assigned.
124 0000363: health check not detect node after down 2017/11/09 Peng https://www.pgpool.net/mantisbt/view.php?id=363 Closed.2017/11/9
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
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
127 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 Assigned.
128 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 Assigned.
200 Feature Agreement 2017/3/31
201 Code Freeze including English docs except release notes 2017/9/30
202 Beta 1 including release notes and Japanese docs 2017/10/17
203 RC1 Release. 2017/11/13 Done. 2017/11/13
204 Pgpool-II 3.7 official release 2017/11/22 Done. 2017/11/22
Retrieved from "https://pgpool.net/mediawiki/index.php?title=pgpool-II_3.7_development&oldid=2401"