pgsql resource agent should check for stats_temp_directory

Bug #1762492 reported by Mario Splivalo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
resource-agents (Ubuntu)
Fix Released
Undecided
Mario Splivalo
Xenial
New
Undecided
Mario Splivalo
Artful
Invalid
Undecided
Mario Splivalo
Bionic
New
Undecided
Mario Splivalo

Bug Description

[Impact]

 * Default postgres installation in Ubuntu (and Debian) configures stats_temp_directory inside /var/run/postgresql. However, this directory is not created after reboot. Usually this directory is created by pg_ctlcluster, which is a pg_ctl wraper called by systemd/upstart. However postgres resource agent is not using pg_ctlcluster when starting postgres, it calls pg_ctl directly, which won't recreate missing directories.
This will prevent resource agent to properly start postgres.

 * This bug is already fixed in upstream: https://github.com/ClusterLabs/resource-agents/pull/1102/

 * This SRU cherrypicks the commit from the upstream - the commit checks if configured stats directory exists, and if it does not it tries to create it.

Revision history for this message
Mario Splivalo (mariosplivalo) wrote :

This does not apply to Trusty as stats directory for postgres is not configured there.

I am creating a patches for remaining series and I will update the SRU template with the test cases shortly.

Changed in resource-agents (Ubuntu):
assignee: nobody → Mario Splivalo (mariosplivalo)
Changed in resource-agents (Ubuntu Xenial):
assignee: nobody → Mario Splivalo (mariosplivalo)
Changed in resource-agents (Ubuntu Artful):
assignee: nobody → Mario Splivalo (mariosplivalo)
Changed in resource-agents (Ubuntu Artful):
status: New → Invalid
Revision history for this message
Mario Splivalo (mariosplivalo) wrote :

This also does apply only to Xenial an Bionic as Cosmic and later series have versions where upstream fixed this.

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

Setting dev version to fix released per last comment.

Changed in resource-agents (Ubuntu):
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.