[JIRA] (OVIRT-630) postgresql fails to start on some EL7 jenkins slaves

[Evgheni Dereveanchin (oVirt JIRA)]

     [ https://ovirt-jira.atlassian.net/browse/OVIRT-630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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.



--
This message was sent by Atlassian JIRA
(v1000.141.2#100004)