[pgpool-hackers: 1858] Re: [pgpool-II 0000252]: authentication failed error when PCP command is cancelled by other pgpool
Tatsuo Ishii
ishii at sraoss.co.jp
Mon Oct 17 16:16:41 JST 2016
Usama,
Can you please take care of this? This is related to pcp commands.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From: pgpool Bug Tracker <bugtracker at pgpool.net>
Subject: [pgpool-II 0000252]: authentication failed error when PCP command is cancelled by other pgpool
Date: Tue, 11 Oct 2016 10:39:24 +0900
Message-ID: <f20644de710e0a23847b554421405872 at www.pgpool.net>
>
> The following issue has been SUBMITTED.
> ======================================================================
> http://www.pgpool.net/mantisbt/view.php?id=252
> ======================================================================
> Reported By: nagata
> Assigned To:
> ======================================================================
> Project: pgpool-II
> Issue ID: 252
> Category: Bug
> Reproducibility: always
> Severity: minor
> Priority: normal
> Status: new
> ======================================================================
> Date Submitted: 2016-10-11 10:39 JST
> Last Modified: 2016-10-11 10:39 JST
> ======================================================================
> Summary: authentication failed error when PCP command is
> cancelled by other pgpool
> Description:
> With watchdog, when I run pcp_attach_node command and the request is cancelled
> by other pgpool because failover is in progress in the other node, the pcp
> command fails (this expected) and "authentication failed" error appears in log
> messages, though it has no relation with authentication.
>
>
>
> Steps to Reproduce:
> You can reproduce this artificially by the following patch, which makes
> wd_send_failback_request() return COMMAND_FAILED.
>
> +++ b/src/watchdog/wd_commands.c
> @@ -432,6 +433,8 @@ wd_send_failback_request(int node_id)
> char* func;
> unsigned int *shared_key = get_ipc_shared_key();
>
> + return COMMAND_FAILED;
> +
> /* if failback packet is received already, do nothing */
> if (wd_chk_node_mask_for_failback_req(&n,1))
> return COMMAND_OK;
>
> Run the following command
>
> $ pcp_attach_node 0
>
> Then, pgpool log says "FAITAL: authentication failed ..."
>
> 2016-10-11 10:23:36: pid 20035: LOG: received failback request for node_id: 0
> from pid [20035]
> 2016-10-11 10:23:36: pid 20035: ERROR: failback request for node_id: 0 from pid
> [20035] is canceled by other pgpool
> 2016-10-11 10:23:36: pid 20035: FATAL: authentication failed for new PCP
> connection
> 2016-10-11 10:23:36: pid 20035: DETAIL: connection not authorized
> ======================================================================
>
> Issue History
> Date Modified Username Field Change
> ======================================================================
> 2016-10-11 10:39 nagata New Issue
> ======================================================================
>
More information about the pgpool-hackers
mailing list