pgpool-II 3.7 development
Last update: 2017/09/11 (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] 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] | |
| 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] 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] 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)->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 | In progress | |
| 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/3/31 | Usama | |||
| 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 | ||
| 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 | Bo Peng | |||
| 200 | Feature Agreement | 2017/3/31 | ||||
| 201 | Feature Freeze | 2017/8/31 |