Difference between revisions of "pgpool-II 3.6 development"
Line 158: | Line 158: | ||
| 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 | ||
| 2016/2/26 | | 2016/2/26 | ||
− | | | + | | 2016/8/31 |
| Usama | | Usama | ||
| | | | ||
− | | | + | | Write in the new SGML format document |
|- | |- | ||
| 14 | | 14 |
Revision as of 02:21, 19 August 2016
Last update: 2016/8/18 (gray items are done, yellow items are behind schedule)
ID | Registered/start Date | Target Date | Person in charge | Overview | Status | |
---|---|---|---|---|---|---|
1 | pgpool-general:3907 | 2015/08/02 | 2015/10/28 | Usama | watchdog info | Done in [pgpool-general: 4452] |
2 | pgpool-general:3923 | 2015/08/06 | 2016/07/08 | Tatsuo | pgpool_status | needs discussion, postpone to 3.6. Usama will review this until 12 June. follow up by Usama in [pgpool-general: 4721] http://www.pgpool.net/pipermail/pgpool-general/2016-June/004779.html -- done on 2016/07/12 |
3 | pgpool-hackers:994 | 2015/08/05 | 2016/5/13 | Tatsuo | connect to necessary DB nodes | proposal, feedback, postpone to 3.6, strongly connected to item 11.--> Not necessary any more. |
4 | 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 |
5 | pgpool-hackers:1034 | 2015/09/03 | - | - | add new child if it goes down | need to assign, postpone to 3.7 |
6 | pgpool-general:4016 | 2015/09/02 | 2016/08/11 | Usama | deal with pg_terminate_backend | [3.6 beta] in progress need to assign or expecting patches from user, postpone to 3.6 |
7 | Import PostgreSQL 9.6 parser | 2016/2/15 | 2016/8/31 | Peng | [3.6 beta] [In progress] Will start after PostgreSQL 9.6 beta released | |
8 | Add SET command | 2016/2/15 | 2016/5/19 | Usama | - | Add set command to configure session level configuraiton pgpool paramaeters. Change the pgpool load balance parameter on the fly. Done on 2016/5/21. |
9-1 | Convert the pgpool documentation to SGML | 2016/2/15 | 2016/2/15 | Usama | Tool set porting work time estimate | [3.6 beta] Estimating work hours to determine the shedule. He estimated as "3.5D". |
9-2 | Convert the pgpool documentation to SGML | 2016/2/16 | 2016/2/19 | Usama | Tool set porting | [3.6 beta] PostgreSQL docs trees are ported as well. Confirmed to be able to generate HTML files |
9-3 | Convert the pgpool documentation to SGML | 2016/2/26 | 2016/2/29 | Tatsuo | Prune PostgreSQL's SGML files to prepare for creating pgpool-II docs | [3.6 beta] |
9-4 | Convert the pgpool documentation to SGML | 2016/2/27 | 2016/8/31 | Tatsuo, Peng, Usama | Create/migrate actual pgpool-II document in SGML format | [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ |
9-5 | Convert the pgpool documentation to SGML (Tatsuo) | 2016/6/6 | 2016/8/31 | Tatsuo | Create/migrate actual pgpool-II document in SGML format | [3.6 beta] [in progress] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Preface, Tutorial.Getting Started, Server Administration.pgpool-II Installation from Source Code, Server Administration.Server Setup and Operation |
9-6 | Convert the pgpool documentation to SGML (Usama) | 2016/6/6 | 2016/8/31 | Usama | Create/migrate actual pgpool-II document in SGML format | [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Tutorial.Watchdog, Server Administration.Server Configuration, Server Administration.Client Authentication, Examples |
9-7 | Convert the pgpool documentation to SGML (Pengbo) | 2016/6/6 | 2016/8/31 | Pengbo | Create/migrate actual pgpool-II document in SGML format | [3.6 beta] See compiled HTML files here: http://tatsuo-ishii.github.io/pgpool-II/3.6/ Responsible part: Reference |
10 | Make PCP set configuration command public | 2016/2/15 | - | Usama | - | Low priority |
11 | Keep current session alive in-case of failover | 2016/2/15 | 2016/5/13 | Tatsuo | http://www.pgpool.net/pipermail/pgpool-hackers/2016-March/001452.html | Proposal already posted. At this point pcp_detach_node does not break in certain cases (load balance node is not detached) |
12 | Yet another stuck connection problem | 2016/2/19 | 2016/2/23 | Usama | pgpool-general: 4457 | |
13 | Tutorial along with sample of escalation and de-escalation scripts for using pgpool-II watchdog on AWS | 2016/2/26 | 2016/8/31 | Usama | Write in the new SGML format document | |
14 | 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 | ||
15 | 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 | ||
16 | Worker Processes Exit and Are Not Re-spawned | 2016/3/7 | Usama | http://www.pgpool.net/pipermail/pgpool-general/2016-March/004577.html | ||
17 | Extended query hangs | 2016/2/22 | 2016/3/27 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=167 | Fix confirmed (2016/3/30). |
18 | Buildfarm not working | 2016/3/16 | Yugo | Should be fixed as soon as possible. It turned out that it was caused by disk full. | ||
19 | failback_command finishes,pgpool-II DONNOT restart all child processes | 2016/3/18 | Usama | http://www.pgpool.net/mantisbt/view.php?id=172 | ||
20 | pgpool child processes exit unexpectedly and don't restart after online recovery of a standby node | 2016/3/18 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=174 | ||
21 | find_primay_node fails to find the primary node | 2016/3/22 | Tatsuo | pgpool-general: 4560 | Waiting for feedback but no response since 2016/3/30. So close this now... | |
22 | kind mismatch among backends with COMMIT; | 2016/3/23 | Usama | pgpool-general: 4565 | Waiting for feedback.-> no reply since 2016/3/24. Closed | |
23 | Error with JDBC memory_cache_enabled = on | 2016/3/22 | 2016/5/31 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=152 | resolved on 2016/5/21 |
24 | Enironment Variable PG_CONFIG Ignored | 2016/3/23 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=178 | Topic not suitable for Mantis because it's not related to a bug. I suggested the reporter to move to mailing list. | |
25 | Run Continuously attaching two degenerate backend,the second backend WILLNOT SUCCESS | 2016/3/23 | Usama | http://www.pgpool.net/mantisbt/view.php?id=179 | Responded back, nothing to be done for that | |
26 | regression test failure with 004.watchdog | 2016/3/22 | Usama | The test fails Ubuntu after commit:http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e55c230d674ea221c09e8266a68d119f1a3a2dac | Usama found that this was caused my race condition while writing to a log file. Tatsuo fixed this by redirecting process output to cat command. | |
27 | Pgpool child hangs with full cpu load after permission error message from backend | 2016/3/24 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=182 | Already fixed in 3.5 stable tree?->Fix confirmed on 2016/3/29 | |
28 | Online recovery: existing connections did not close in 90 sec. | 2016/3/23 | 2016/8/31 | Tatsuo | pgpool-II 3.3.6, client_idle_limit_in_recovery = -1 doesn't work (pgpool-general: 4570) | [Feedback] |
29 | Pgppol not sending query error back to client | 2016/3/25 | 2016/6/21 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=183 | [in progress] Already fixed in 3.5 stable tree? Waiting for feedback->Confirmed on 2016/3/28 |
30 | PGPoolII-3.5 : segfault during pcp_recovery | 2016/3/23 | 2016/4/4 | Usama | pgpool-general: 4569 | fixed commit:http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=64696fd839da70e6fd8daacd73da11b6e8a1f1c9 |
31 | pgpool-II minor releases | 2016/4/4 | Yugo | pgpool-II 3.5.1, 3.4.5, 3.3.9, 3.2.14, 3.1.17, pgpoolAdmin 3.5.1 | ||
32 | plugs out the network cable,the pgpool will not work。 | 2016/3/28 | Usama | http://www.pgpool.net/mantisbt/view.php?id=185 | ||
33 | Hibernate + Pgpool-II Connection Failure | 2016/3/18 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=175 | Fix confirmed (in 3.5.1) | |
34 | What is the execution order of ‘follow_master_command' and 'failover_command'? | 2016/3/19 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=176 | Waiting for feedback -> No feedback for a month. Close now... | |
35 | Pgpool stops accepting connections when Postgresql slave goes down | 2016/3/20 | Usama | http://www.pgpool.net/mantisbt/view.php?id=177 | Should be already fixed. [pgpool-hackers: 1531] | |
36 | pcp_proc_count truncates PIDs over 5 characters long | 2016/4/6 | 2016/4/20 | Peng | http://www.pgpool.net/mantisbt/view.php?id=188 | fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=bd11fcf420fe0e9cd1705673b0594aab39307cb9 |
37 | pgpool web console gets pgpool.conf parameters incorrectly | 2016/4/7 | Nozomi | http://www.pgpool.net/mantisbt/view.php?id=158 | assigned [Pgpool:1102] Bug 158-->assign changed to Nozomi because this is an pgpoolAdmin issue | |
38 | Always PostgreSQL1 node is down frequently from PGpool console | 2016/4/7 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=161 | feedback--> No response over one month. Closed. | |
39 | Connections not released if client exit ungracefully | 2016/4/7 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=163 | feedback--> No response over one month. Closed. | |
40 | pcp_* functions call interface changed in pgpool 3.5 but pgpooladmin use old call mechanism | 2016/4/7 | 2016/4/11 | Nozomi | http://www.pgpool.net/mantisbt/view.php?id=187 | fix committed |
41 | kind mismatch error on master_slave_mode=on / load_lalance_mode=off | 2016/4/8 | 2016/4/15 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=189 | fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=a3227199ddb688c54d8170c2f12f14cf041a43ab |
42 | PgPool hangs in load balance mode, when using JDBC driver and sending empty query | 2016/4/11 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=190 | fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=a5fdf78e6e86c5a8a1d4ce5b1eb273a59f5ecfb9 | |
43 | pgpool-II shouldn't forward set default_transaction_isolation to 'serializable' to Hot Standby slaves | 2016/4/14 | 2016/5/09 | Peng | http://www.pgpool.net/mantisbt/view.php?id=191 | fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f97aa57fa89bd5c57dafb74f07e5531009d2391c |
44 | kind does not match error in pgpool [pgpool-hackers:1501] | 2016/4/20 | 2016/7/15 | Usama | http://www.pgpool.net/pipermail/pgpool-hackers/2016-April/001501.html | fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=866575c8fe89da2127a6c1bb19746b03b61bbfd4 |
45 | ERROR: unable to read data from frontend [pgpool-general: 4662] | 2016/5/9 | 2016/5/11 | Yugo | http://www.sraoss.jp/pipermail/pgpool-general/2016-May/004720.html | The problem isn't reproducable. [Pgpool:1248] |
46 | pgpool error with PAM [pgpool-general: 4670] | 2016/5/10 | 2016/5/11 | Yugo | http://www.sraoss.jp/pipermail/pgpool-general/2016-May/004728.html | No response yet. [Pgpool:1248] |
47 | New Defects reported by Coverity Scan for pgpool-II [Pgpool:1227] | 2016/5/11 | 2016/06/21 | Usama | [Pgpool:1227] | changes committed waiting for new scan |
48 | "statement timeout" causes kind mismatch errors | 2016/5/16 | t-ishii | http://www.pgpool.net/mantisbt/view.php?id=194 | fixed http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=efb2162215f0a99103a49c0094da825640ff036f | |
49 | 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 |
50 | pgpool hangs connections to database when interface of standby/second backend | 2016/5/23 | 2016/6/10 | Usama | http://www.pgpool.net/mantisbt/view.php?id=197 | fixed git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=6ae42e74d48391b8cfaa97927e00bd65aec68fe8 |
51 | Connections stuck - Recv-Q fills up | 2016/6/2 | 2016/7/26 | Usama | http://www.pgpool.net/mantisbt/view.php?id=203 | in progress |
52 | healthcheck get stuck | 2016/6/2 | 2016/6/10 | Yugo | http://www.pgpool.net/mantisbt/view.php?id=204 | fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=634c1d6c01234b773002ceb763eeba4bc6b83206 |
53 | failed to create INET domain socket | 2016/6/2 | 2016/8/15 | pengbo | http://www.pgpool.net/mantisbt/view.php?id=202 | feedback |
54 | testing of new failover code | 2016/6/6 | Ahsan | assigned (Not started yet, plan to start after #04) | ||
55 | Re: [pgpool-II 0000192]: Human readable option for pcp_node_info | 2016/6/10 | 2016/7/30 | Usama | fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=541451eab2647151aa8c04a1e1a1fe9e42f2dd7e | |
56 | pgpool runs out of memory | 2016/7/4 | Usama | http://www.pgpool.net/mantisbt/view.php?id=212 | waiting for feedback | |
57 | Cannot accept() new connection. all backends are down restart | 2016/7/4 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=205 | ||
58 | write on frontend failed with error :"Broken pipe" | 2016/7/4 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=206 | ||
59 | Query cache invalidation performed too late | 2016/7/4 | 2016/8/31 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=209 | [3.6 beta] feedback |
60 | received degenerate backend request for node_id: | 2016/7/4 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=210 | fixed | |
61 | YCSB can't connect to PGPool-II in master-slave mode. | 2016/7/4 | 2016/8/31 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=211 | Feedback |
62 | [pgpool-general: 4761] show pool_nodes returns different result when run on master and on slave | 2016/7/7 | Usama | http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004819.html | [3.6 beta] fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=72573ca6d45ca2fc985a06936c0c52808fe78ef1 | |
63 | 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 | |
64 | plugs out the network cable, pgpool not change backend status and blocking connections | 2016/7/5 | Usama | http://www.pgpool.net/mantisbt/view.php?id=214 | waiting for feedback | |
65 | pgpool doesnt escalate ip in case of another node inavailability | 2016/7/12 | Usama | http://www.pgpool.net/mantisbt/view.php?id=215 | [3.6 beta] https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=024eaeaa0fea3cd5acda4c41d791835887e11d02 | |
66 | Sometimes Failover command isn't executed. | 2016/7/26 | Usama | http://www.pgpool.net/mantisbt/view.php?id=222 | Feedback | |
67 | pgpool segfault | 2016/7/27 | 2016/8/26 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=225 | [3.6 beta] feedback |
68 | pgpool doesn't support jdbc well trigger jdbc 'exception' | 2016/8/2 | 2016/9/2 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=226 | waiting for feedback |
69 | failover not performed by stanby node | 2016/8/2 | Usama | http://www.pgpool.net/mantisbt/view.php?id=227 | assigned | |
70 | pgpool doesnt de-escalate IP in case netowkr restored | 2016/8/2 | Usama | http://www.pgpool.net/mantisbt/view.php?id=228 | fixed https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=3b2db66c3a10444cb31d3f6285d6bf09994d167c | |
71 | [pgpool-general: 4885] pgpool log errors | 2016/8/9 | Usama | http://www.sraoss.jp/pipermail/pgpool-general/2016-August/004943.html | assigned | |
72 | pgpool does not return result set if the statement fetchSize is smaller than the result row count. | 2016/8/9 | 2016/8/15 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=230 | waiting for feedback |
73 | pcp_stop_pgpool emit an error message: ERROR: unable to read data from socket | 2016/8/10 | Usama | http://www.pgpool.net/mantisbt/view.php?id=232 | assigned | |
74 | packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2'] | 2016/8/15 | 2016/9/15 | Tatsuo | http://www.pgpool.net/mantisbt/view.php?id=231 | Patch proposed. waiting for feedback |
75 | [pgpool-hackers: 1760] https://github.com/udp/json-parser/ | 2016/8/17 | Usama | http://www.pgpool.net/pipermail/pgpool-hackers/2016-August/001760.html | assigned | |
76 | [pgpool-general: 4912] Pgpool and IP bonding | 2016/8/18 | Usama | http://www.pgpool.net/pipermail/pgpool-general/2016-August/004970.html | assigned | |
77 | Testing watchdog | 2016/8/5 | 2016/8/19 | Yugo | assigned | |
78 | minor release | 2016/8/18 | 2016/8/31 | Pengbo | assigned | |
100 | Platform freeze | 2016/2/19 | 2016/3/15 | - | - | All the new platforms that we want to support and add to BF should be decided by this date. It seems we will not add any new supported platforms. |
101 | Feature requirement freeze | 2016/2/19 | 2016/3/15 | - | - | We need to ensure all the features that we intend to add to 3.6 are speced out by this date |
102 | Feature Freeze | 2016/2/19 | 2016/8/15 | - | - | Ensure all the agreed upon features are committed to master by this date. This should be feature complete and we should only focus on bug fixed after this point. |
103 | Code Freeze | 2016/2/19 | 2016/9/15 | - | - | At-least one month period between feature and code freeze to ensure all new features are stable and critical bugs are fixed by this date. |
104 | pgpool-II 3.6 beta1 | 2016/2/19 | 2016/9/30 | - | - | First Beta |
105 | pgpool-II 3.6 RC1 | 2016/2/19 | 2016/10/28 | - | - | One month after beta1 |
106 | pgpool-II 3.6.0 official release | 2016/2/19 | 2016/11/11 | - | - |