[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