Incident #10372: Authorization service: pgpool problem - D4Science Infrastructure - D4science

Actions

Copy link

Incident #10372

closed

Authorization service: pgpool problem

Added by Roberto Cirillo over 7 years ago. Updated over 7 years ago.

Status:

Closed

Priority:

Immediate

Assignee:

Andrea Dell'Amico

Category:

System Application

Target version:

UnSprintable

Start date:

Nov 20, 2017

Due date:

% Done:

100%

Estimated time:

Infrastructure:

Development, Pre-Production

Description

The pgpool cluster seems to be blocked. I've tried the restore procedure without success. Please, could you take a look?

postgres1-d-d4s
postgres2-d-d4s

Related issues

Actions

Copy link

Updated by Lucio Lelii over 7 years ago

the error from the authorization service is

Internal Exception: org.postgresql.util.PSQLException: ERROR: pgpool is not accepting any new connections
  Detail: all backend nodes are down, pgpool requires at least one valid node
  Hint: repair the backend nodes and restart pgpool
Error Code: 0

Actions

Copy link

Updated by Pasquale Pagano over 7 years ago

Priority changed from Urgent to Immediate

Actions

Copy link

Updated by Roberto Cirillo over 7 years ago

I've tried to restart postgres and pgpool but nothing change. After that, I've tried to perform the procedure to failover the cluster but I've the following error:

ERROR: connection to host "localhost" failed with error "Connection refused"

Actions

Copy link

Updated by Andrea Dell'Amico over 7 years ago

Status changed from New to In Progress

Actions

Copy link

Updated by Massimiliano Assante over 7 years ago

Has duplicate Incident #10373: Authorisation service dev and preprod is broken added

Actions

Copy link

Updated by Andrea Dell'Amico over 7 years ago

Status changed from In Progress to Feedback
% Done changed from 0 to 100

The auth service is connected to the pgpool service now. I still need to investigate what's happened. I've found that the auth service was down, I restarted it and it seems working.

On the pgpool cluster, one of the postgresql servers was marked as down but it's not a problem, it happened often in the past and it's harmless.

I'm trying to understand what happened.

Actions

Copy link