]
Evgheni Dereveanchin reassigned OVIRT-630:
------------------------------------------
Assignee: Evgheni Dereveanchin (was: infra)
postgresql fails to start on some EL7 jenkins slaves
----------------------------------------------------
Key: OVIRT-630
URL:
https://ovirt-jira.atlassian.net/browse/OVIRT-630
Project: oVirt - virtualization made easy
Issue Type: Bug
Components: General
Reporter: Evgheni Dereveanchin
Assignee: Evgheni Dereveanchin
On several servers I've seen failures to start postgres after VM reboot:
{quote}# systemctl status postgresql
● postgresql.service - PostgreSQL database server
Loaded: loaded (/etc/systemd/system/postgresql.service; enabled; vendor preset:
disabled)
Active: failed (Result: exit-code) since Tue 2016-07-12 15:40:46 UTC; 15min ago
Jul 12 15:40:45 el7-vm05 systemd[1]: Starting PostgreSQL database server...
Jul 12 15:40:45 el7-vm05 pg_ctl[6237]: 2016-07-12 15:40:45 UTC FATAL: could not create
lock file "/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
Jul 12 15:40:46 el7-vm05 pg_ctl[6237]: pg_ctl: could not start server
Jul 12 15:40:46 el7-vm05 systemd[1]: postgresql.service: control process exited,
code=exited status=1
Jul 12 15:40:46 el7-vm05 systemd[1]: Failed to start PostgreSQL database server.
Jul 12 15:40:46 el7-vm05 systemd[1]: Unit postgresql.service entered failed state.
Jul 12 15:40:46 el7-vm05 systemd[1]: postgresql.service failed.{quote}
the temporary directory does not exist:
{quote}# ls -l /var/run/postgresql/
ls: cannot access /var/run/postgresql/: No such file or directory
# rpm -V postgresql-server
missing /var/run/postgresql
# rpm -q postgresql-server
postgresql-server-9.2.15-1.el7_2.x86_64{quote}
It is defined in systemd configs however:
{quote}# cat /usr/lib/tmpfiles.d/postgresql.conf
d /var/run/postgresql 0755 postgres postgres -
{quote}
We need to identify why systemd does not create this directory as it requires manual work
to bring such VM up.