Обсуждение: Issue repmgr 5.2.1 switchover postgres 12 on RHEL8 SELinux enforcing

Поиск
Список
Период
Сортировка

Issue repmgr 5.2.1 switchover postgres 12 on RHEL8 SELinux enforcing

От
MARIANE K
Дата:
Hi,

I have an issue with postgresql & repmgr on RHEL8.
I have installed postgres 12 and repmgr 5.2.1 on two RHEL8 servers with SELinux in enforcing mode.
The installation went fine and a switchover dry-run seems ok:

          [postgresql@serverb ] $ $/usr/pgsql-12/bin/repmgr standby switchover -f /data/repmgr.conf --dry-run
        NOTICE: checking switchover on node "serverb" (ID: 2) in --dry-run mode
        INFO: SSH connection to host "servera" succeeded
        INFO: able to execute "repmgr" on remote host "servera"
        INFO: 1 walsenders required, 5 available
        INFO: demotion candidate is able to make replication connection to promotion candidate
        INFO: 0 pending archive files
        INFO: replication lag on this standby is 0 seconds
        NOTICE: local node "serverb" (ID: 2) would be promoted to primary; current primary "servera" (ID: 1) would be demoted to standby
        INFO: following shutdown command would be run on node "servera":
          "/usr/pgsql-12/bin/pg_ctl -D $PGDATA stop -m fast"
        INFO: parameter "shutdown_check_timeout" is set to 60 seconds
        INFO: prerequisites for executing STANDBY SWITCHOVER are met

But when I start the switchover I get this:
postgresql@serverb ] $ /usr/pgsql-12/bin/repmgr standby switchover -f /data/repmgr.conf --dry-run
NOTICE: executing switchover on node "serverb" (ID: 2)
NOTICE: local node "serverb" (ID: 2) will be promoted to primary; current primary "servera" (ID: 1) will be demoted to standby
NOTICE: stopping current primary node "servera" (ID: 1)
NOTICE: issuing CHECKPOINT on node "servera" (ID: 1)
DETAIL: executing server command "/usr/pgsql-12/bin/pg_ctl -D $PGDATA stop -m fast"
INFO: checking for primary shutdown; 1 of 60 attempts ("shutdown_check_timeout")
INFO: checking for primary shutdown; 2 of 60 attempts ("shutdown_check_timeout")
...
INFO: checking for primary shutdown; 59 of 60 attempts ("shutdown_check_timeout")
INFO: checking for primary shutdown; 60 of 60 attempts ("shutdown_check_timeout")
ERROR: shutdown of the primary server could not be confirmed
HINT: check the primary server status before performing any further actions

Are there known issues with postgres 12 and repmgr 5.2.1 with RHEL8 and SELINUX in enforcing mode?
Any suggestions on how to proceed with debugging?

Thanks in advance.

Regards
Mariane

Re: Issue repmgr 5.2.1 switchover postgres 12 on RHEL8 SELinux enforcing

От
Ian Lawrence Barwick
Дата:
2021年7月23日(金) 23:48 MARIANE K <mskiesewetter@gmail.com>:
>
> Hi,
>
> I have an issue with postgresql & repmgr on RHEL8.
> I have installed postgres 12 and repmgr 5.2.1 on two RHEL8 servers with SELinux in enforcing mode.
> The installation went fine and a switchover dry-run seems ok:
>
>           [postgresql@serverb ] $ $/usr/pgsql-12/bin/repmgr standby switchover -f /data/repmgr.conf --dry-run
>         NOTICE: checking switchover on node "serverb" (ID: 2) in --dry-run mode
>         INFO: SSH connection to host "servera" succeeded
>         INFO: able to execute "repmgr" on remote host "servera"
>         INFO: 1 walsenders required, 5 available
>         INFO: demotion candidate is able to make replication connection to promotion candidate
>         INFO: 0 pending archive files
>         INFO: replication lag on this standby is 0 seconds
>         NOTICE: local node "serverb" (ID: 2) would be promoted to primary; current primary "servera" (ID: 1) would be
demotedto standby 
>         INFO: following shutdown command would be run on node "servera":
>           "/usr/pgsql-12/bin/pg_ctl -D $PGDATA stop -m fast"
>         INFO: parameter "shutdown_check_timeout" is set to 60 seconds
>         INFO: prerequisites for executing STANDBY SWITCHOVER are met
>
> But when I start the switchover I get this:
> postgresql@serverb ] $ /usr/pgsql-12/bin/repmgr standby switchover -f /data/repmgr.conf --dry-run
> NOTICE: executing switchover on node "serverb" (ID: 2)
> NOTICE: local node "serverb" (ID: 2) will be promoted to primary; current primary "servera" (ID: 1) will be demoted
tostandby 
> NOTICE: stopping current primary node "servera" (ID: 1)
> NOTICE: issuing CHECKPOINT on node "servera" (ID: 1)
> DETAIL: executing server command "/usr/pgsql-12/bin/pg_ctl -D $PGDATA stop -m fast"
> INFO: checking for primary shutdown; 1 of 60 attempts ("shutdown_check_timeout")
> INFO: checking for primary shutdown; 2 of 60 attempts ("shutdown_check_timeout")
> ...
> INFO: checking for primary shutdown; 59 of 60 attempts ("shutdown_check_timeout")
> INFO: checking for primary shutdown; 60 of 60 attempts ("shutdown_check_timeout")
> ERROR: shutdown of the primary server could not be confirmed
> HINT: check the primary server status before performing any further actions
>
> Are there known issues with postgres 12 and repmgr 5.2.1 with RHEL8 and SELINUX in enforcing mode?
> Any suggestions on how to proceed with debugging?

Please see the follow-up to your GitHub issue:

  https://github.com/EnterpriseDB/repmgr/issues/708

Regards

Ian Barwick

--
EnterpriseDB: https://www.enterprisedb.com