Project

General

Profile

Bug #9182

Multiple errors "The postgresql process was not running and has been restarted"

Added by Alexandre Anriot about 1 year ago. Updated about 1 year ago.

Status:
Released
Priority:
1
Category:
Initial promises & sys tech
Target version:
Target version (plugin):
Severity:
User visibility:
Effort required:
Priority:
Tags: Sponsored

Description

Alexis,

As seen on IRC, we have spotted that Rudder checks that its PostgreSQL instance is running through the process list, looking for the postgres: writer process pattern.

(ref: /var/rudder/cfengine-community/inputs/server-roles/1.0/component-check.cf)

But on Debian 8.5 with PostgreSQL 9.5, the writer process appears as postgres: 9.5/main: writer process.

Thanks.

Associated revisions

Revision be7907be
Added by Nicolas CHARLES about 1 year ago

Fixes #9182: Multiple errors \"The postgresql process was not running and has been restarted\"

History

#1 Updated by Alexis MOUSSET about 1 year ago

  • Category set to Initial promises & sys tech
  • Target version set to 3.1.15

Jessie repositories contain PostgreSQL 9.4, are you using a package from backports or an external repo?

#2 Updated by Alexandre Anriot about 1 year ago

Hello,

For the record, I have upgraded the Pg cluster to 9.6 and I'm now using:

"service[rudder_reports][binary]" string => "postgres:.*writer process";

#3 Updated by Vincent MEMBRÉ about 1 year ago

  • Target version changed from 3.1.15 to 3.1.16

#4 Updated by Vincent MEMBRÉ about 1 year ago

  • Target version changed from 3.1.16 to 3.1.17

#5 Updated by Nicolas CHARLES about 1 year ago

  • Tags set to Sponsored
  • Priority changed from N/A to 1

#6 Updated by Nicolas CHARLES about 1 year ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES

#7 Updated by Nicolas CHARLES about 1 year ago

a postgres 9.6, from the postgresql official repo, has the following string

postgres: 9.6/main: writer process

#8 Updated by Nicolas CHARLES about 1 year ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Alexis MOUSSET
  • Pull Request set to https://github.com/Normation/rudder-techniques/pull/1087

#9 Updated by Nicolas CHARLES about 1 year ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100

#10 Updated by Vincent MEMBRÉ about 1 year ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 4.0.1, 3.1.16 and 3.2.10 which were released today.

Also available in: Atom PDF