View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000555 | Pgpool-II | Bug | public | 2019-11-04 01:25 | 2019-11-05 08:57 |
| Reporter | GeorgBerlin | Assigned To | |||
| Priority | urgent | Severity | block | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Platform | Virtual Machine / KVM | OS | CentOS Linux | OS Version | 7 (core) |
| Product Version | 4.1.0 | ||||
| Summary | 0000555: pgpool does not start without any notice even in debug mode | ||||
| Description | By the help of Salt I set up a Postgres cluster with two instances. PGPool is used to handle the streaming replication and the failover. Since approximately six days, the last time when when the full installation worked, PGPool does not start in the new created setups. -> pgpool-II version pgpool-II-12-4.1.0-1.rhel7.x86_64 pgpool-II-12-extensions-4.1.0-1.rhel7.x86_64 pgpool-II-12-debuginfo-4.1.0-1.rhel7.x86_64 pgpool-II-12-devel-4.1.0-1.rhel7.x86_64 -> PostgreSQL version postgresql12-12.0-1PGDG.rhel7.x86_64 postgresql12-plperl-12.0-1PGDG.rhel7.x86_64 postgresql12-devel-12.0-1PGDG.rhel7.x86_64 postgresql12-libs-12.0-1PGDG.rhel7.x86_64 postgresql12-server-12.0-1PGDG.rhel7.x86_64 postgresql12-contrib-12.0-1PGDG.rhel7.x86_64 | ||||
| Steps To Reproduce | Basic installation of CentOS Adjusting the Repositories to use the Repos for Postgres and PGPool Installing Postgres and PGPool pgpool-configs for master and standby attached Project is published at https://github.com/ionos-enterprise/automated-ha-setup If it is needed I can start the script to create a virtual data center right away and import public keys for access at any time. | ||||
| Additional Information | It is my first post on this mailing list and I am quit unsure if I may have overseen something in my Postgres and PGPool setup. Nevertheless when something went wrong in the past I got some log message of any kind. This time not. The classification as 'Blocker' and priority 'Immediate' explains how I am facing the issue. Hopefully you can help me fixing that. Many thanks in advance Georg | ||||
| Tags | pgpool-II, streaming replication | ||||
|
|
|
|
|
The streaming replication is done by Postgres itself, not by PGPool. |
|
|
Still investigating. PGPool is now running. |
|
|
For Postgresql10 and PGpool10 I still observer the aforementioned behavior. For Postgresql12 and PGPool12 the program starts and waits for connections. |
|
|
Sorry for bothering you. I found the culprit with strace, it was an incorrect entry in the pgpool.conf Please consider this 'bug'-report as solved. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-11-04 01:25 | GeorgBerlin | New Issue | |
| 2019-11-04 01:25 | GeorgBerlin | File Added: pgpool.conf_Master | |
| 2019-11-04 01:25 | GeorgBerlin | File Added: pgpool.conf_Standby | |
| 2019-11-04 01:25 | GeorgBerlin | Tag Attached: pgpool-II | |
| 2019-11-04 01:25 | GeorgBerlin | Tag Attached: streaming replication | |
| 2019-11-04 01:58 | GeorgBerlin | Note Added: 0002953 | |
| 2019-11-04 02:14 | GeorgBerlin | Note Added: 0002954 | |
| 2019-11-04 03:03 | GeorgBerlin | Note Added: 0002955 | |
| 2019-11-04 05:45 | GeorgBerlin | Note Added: 0002956 | |
| 2019-11-05 08:57 | administrator | Status | new => resolved |
| 2019-11-05 08:57 | administrator | Description Updated | |
| 2019-11-05 08:57 | administrator | Steps to Reproduce Updated | |
| 2019-11-05 08:57 | administrator | Additional Information Updated |
