Difference between revisions of "pgpool-II 3.7 development"
Line 715: | Line 715: | ||
|https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002430.html | |https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002430.html | ||
|Proposal posted | |Proposal posted | ||
+ | |-style="background:pink" | ||
+ | | 89 | ||
+ | | Deal with logical replication | ||
+ | | 2017/7/7 | ||
+ | | | ||
+ | |ishii | ||
+ | | | ||
+ | | | ||
|-style="background:silver" | |-style="background:silver" | ||
| 100 | | 100 |
Revision as of 06:43, 7 July 2017
Last update: 2017/07/07 (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] |
3 | Make PCP set configuration command public | 2016/2/15 | - | Usama | - | [Feature: small] |
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] | |
6 | 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 | |
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 | |
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] Waiting for feedback. (2017/06/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] | |
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/7/31 | Usama | http://www.pgpool.net/pipermail/pgpool-hackers/2017-January/001974.html | [Feature: large][Medium size implementation] waiting feedback from Usama |
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] Waiting for feedback. (2017/06/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] Assigned |
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 | New feature candidate: import PostgreSQL 10.0 SQL parser | 2017/3/23 | within 2 weeks after RC | Peng | Depends of PostgreSQL RC release. | |
62 | New feature candidate: certification base authentication | 2017/3/23 | ||||
63 | New feature candidate: Seamless Application Failover | 2017/3/23 | Similar to Oracle's "Transparent Application Failover". | |||
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 | |||
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) | |
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) | |
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) | |
80 | 0000309: bind socket failed with error: "Address already in use" | 2017/6/13 | Usama | https://www.pgpool.net/mantisbt/view.php?id=309 | Waiting for feedback (2017/6/26) | |
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 | ||
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) | |
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 | Failed to reproduce the problem. | |
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 | In progress | |
88 | Deal with Amazon Aurora | 2017/7/7 | ishii | https://www.pgpool.net/pipermail/pgpool-hackers/2017-July/002430.html | Proposal posted | |
89 | Deal with logical replication | 2017/7/7 | ishii | |||
100 | Feature Agreement | 2017/3/31 | ||||
101 | Feature Freeze | 2017/8/31 |