pgpool-II 3.7 development: Difference between revisions

From pgpool Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Pengbo (talk | contribs)
745 edits
No edit summary
Pengbo (talk | contribs)
745 edits
No edit summary
Line 9: Line 9:
! Overview
! Overview
! Status
! Status
|--style="background:yellow"
| 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
|-
|-
| 1
| 2
| pgpool-hackers:1034
| pgpool-hackers:1034
| 2015/09/03
| 2015/09/03
Line 18: Line 26:
| need to assign, postpone to 3.7
| need to assign, postpone to 3.7
|- style="background:white"
|- style="background:white"
| 2
| 3
| Make PCP set configuration command public  
| Make PCP set configuration command public  
| 2016/2/15
| 2016/2/15
Line 25: Line 33:
| -
| -
| Low priority
| Low priority
|-style="background:yellow"
| 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
|
| [RC1]
|-
|-
| 3
| 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
Line 35: Line 51:
|-
|-
|-
|-
| 4
| 6
| Health-check timeout for each backend node
| Health-check timeout for each backend node
| 2016/3/4
| 2016/3/4
Line 43: Line 59:
| Low priority
| Low priority
|-
|-
| 5
| 7
| pgpool routes queries with "SET TRANSACTION READ ONLY" to master
| pgpool routes queries with "SET TRANSACTION READ ONLY" to master
| 2016/5/18
| 2016/5/18
Line 50: Line 66:
| http://www.pgpool.net/mantisbt/view.php?id=195
| http://www.pgpool.net/mantisbt/view.php?id=195
| low priority
| low priority
|-style="background:yellow"
| 8
| Connections stuck - Recv-Q fills up
| 2016/6/2
| 2016/7/26
| Usama
| http://www.pgpool.net/mantisbt/view.php?id=203
| in progress
|-style="background:yellow"
| 9
| failed to create INET domain socket
| 2016/6/2
| 2016/8/15
| pengbo
| http://www.pgpool.net/mantisbt/view.php?id=202
| waiting for feedback
|-
|-
| 6
| 10
| testing of new failover code
| testing of new failover code
| 2016/6/6
| 2016/6/6
Line 58: Line 90:
|
|
| assigned (Not started yet, plan to start after #04)
| assigned (Not started yet, plan to start after #04)
|-style="background:yellow"
| 11
| ERROR: node recovery failed, waiting connection closed in the other pgpools timeout
| 2016/7/12
| 2016/8/26
| Tatsuo
| http://www.pgpool.net/mantisbt/view.php?id=213
|
|-style="background:yellow"
| 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
|-
|-
| 7
| 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']
| 2016/8/15
| 2016/8/15
Line 66: Line 114:
| 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
|-style="background:yellow"
| 14
| [pgpool-general: 4912] Pgpool and IP bonding
| 2016/8/18
| 2016/9/20
| Usama
| http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html
| [3.6 RC1] assigned
|-
|-
| 8
| 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.
| 2016/8/23
| 2016/8/23
Line 75: Line 131:
| assigned
| assigned
|-
|-
| 9
| 16
| watchdog can start even in case trusted servers are not reachable.
| watchdog can start even in case trusted servers are not reachable.
| 2016/8/23
| 2016/8/23
Line 83: Line 139:
| assigned
| assigned
|-
|-
| 10
| 17
| watchdogs with different VIP can exist in a cluster.
| watchdogs with different VIP can exist in a cluster.
| 2016/8/23
| 2016/8/23
Line 91: Line 147:
| assigned
| assigned
|-
|-
| 11
| 18
| Behavior when watchdog process is killed
| Behavior when watchdog process is killed
| 2016/8/23
| 2016/8/23
Line 99: Line 155:
| assigned
| assigned
|-
|-
| 12
| 19
| Changed behavior when all heartbeat LAN are disconnected
| Changed behavior when all heartbeat LAN are disconnected
| 2016/8/23
| 2016/8/23
Line 106: Line 162:
|
|
| assigned
| assigned
|-style="background:yellow"
| 20
| Connections remains open when backend dettach during a transaction
| 2016/9/2
|
| Pengbo
| http://www.pgpool.net/mantisbt/view.php?id=240
| waiting for feedback (It wasn't reproduced)-->There was an already feedback on 10/3.
|-
|-
| 13
| 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
| 2016/9/6
| 2016/9/6
Line 114: Line 178:
| 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"
| 22
| [Pgpool:1815] Re: Fw: New Defects reported by Coverity Scan for pgpool-II (1)-(5)
| 2016/9/9
| 2016/9/30
| Usama
|
| [3.6 RC1] assigned
|-
|-
| 14
| 23
| watchdog sometimes fails de-escalation
| watchdog sometimes fails de-escalation
| 2016/9/21
| 2016/9/21
Line 123: Line 195:
| assigned
| assigned
|-
|-
| 15
| 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
Line 131: Line 203:
| assigned
| assigned
|-
|-
| 16
| 25
| failover_command not executed
| failover_command not executed
| 2016/9/28
| 2016/9/28
Line 139: Line 211:
| assigned
| assigned
|-style="background:white"
|-style="background:white"
| 17
| 26
| pgpoolAdmin 3.6 release
| pgpoolAdmin 3.6 release
|
|

Revision as of 05:50, 7 December 2016

Last update: 2016/12/07 (gray items are done, yellow items are behind schedule)

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
2 pgpool-hackers:1034 2015/09/03 - - add new child if it goes down need to assign, postpone to 3.7
3 Make PCP set configuration command public 2016/2/15 - Usama - Low priority
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 [RC1]
5 Allow to use multiple pgpool-II instances with in-memory query cache enabled 2016/3/4 http://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_pg_rewind_in_online_recovery Low priority
6 Health-check timeout for each backend node 2016/3/4 http://pgpool.net/mediawiki/index.php/TODO#Health-check_timeout_for_each_backend_node Low priority
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 low priority
8 Connections stuck - Recv-Q fills up 2016/6/2 2016/7/26 Usama http://www.pgpool.net/mantisbt/view.php?id=203 in progress
9 failed to create INET domain socket 2016/6/2 2016/8/15 pengbo http://www.pgpool.net/mantisbt/view.php?id=202 waiting for feedback
10 testing of new failover code 2016/6/6 Ahsan 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 2016/8/26 Tatsuo http://www.pgpool.net/mantisbt/view.php?id=213
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
14 [pgpool-general: 4912] Pgpool and IP bonding 2016/8/18 2016/9/20 Usama http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html [3.6 RC1] assigned
15 watchdog can start even in case VIP is brought up in other nodes. 2016/8/23 Usama assigned
16 watchdog can start even in case trusted servers are not reachable. 2016/8/23 Usama assigned
17 watchdogs with different VIP can exist in a cluster. 2016/8/23 Usama assigned
18 Behavior when watchdog process is killed 2016/8/23 Usama assigned
19 Changed behavior when all heartbeat LAN are disconnected 2016/8/23 Usama assigned
20 Connections remains open when backend dettach during a transaction 2016/9/2 Pengbo http://www.pgpool.net/mantisbt/view.php?id=240 waiting for feedback (It wasn't reproduced)-->There was an already feedback on 10/3.
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 [3.6 RC1] assigned
23 watchdog sometimes fails de-escalation 2016/9/21 Usama http://www.pgpool.net/mantisbt/view.php?id=249 assigned
24 Not proper behaviour of Pgpool when one node of cluster goes disconnect by down interface 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=250 assigned
25 failover_command not executed 2016/9/28 Usama http://www.pgpool.net/mantisbt/view.php?id=251 assigned
26 pgpoolAdmin 3.6 release 2016/12/31 -
Retrieved from "https://pgpool.net/mediawiki/index.php?title=pgpool-II_3.7_development&oldid=1771"