Difference between revisions of "pgpool-II 3.7 development"

From pgpool Wiki
Jump to: navigation, search
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 -