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

Custom queries

03. VRE Plan
04. All Projects Deliverables
04. All Projects Milestones
06. D4Science Projects Activities
All open Issues
D4Science Infrastructure Upgrade
My InProgress Tasks
My Paused Tasks
My Watched Tasks
Not Closed Assigned To Me
Not Closed Assigned To Me (No Releases, No Project Tasks)
Not Closed Opened by Me
Open Issues
Upgrade Plan
Upgrade Plan Clear

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

Related to D4Science Infrastructure - Task #10377: Disable SSL from the pgpool-clustered postgresql instances

Closed

Andrea Dell'Amico

Nov 20, 2017

Nov 30, 2017

Actions

Issue # Delay: days Cancel

History
Notes
Property changes

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