[Pkg-systemd-maintainers] Bug#731862: Bug#731862: systemd does not start postgresql (through LSB script)

[Michael Stapelberg]

Hi Vincent,

Vincent Bernat <bernat at debian.org> writes:
> systemctl status postgresql.service gives me this:
>
> postgresql.service - LSB: PostgreSQL RDBMS server
>    Loaded: loaded (/etc/init.d/postgresql)
>    Active: active (exited) since mar. 2013-12-10 16:33:51 CET; 23min ago
>
> déc. 10 16:33:51 alucard systemd[1]: Starting LSB: PostgreSQL RDBMS server...
> déc. 10 16:33:51 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:33:54 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:39:36 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:39:50 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:40:17 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:44:22 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:47:26 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:50:47 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
> déc. 10 16:51:05 alucard systemd[1]: Started LSB: PostgreSQL RDBMS server.
>
> I have nothing else in the logs. I am a bit clueless to give you more
> information on what is wrong. My installation is pretty recent (one
> week).
Unfortunately, given that init scripts are just scripts, systemd cannot
provide as much information as it can for services that are using native
service files.

There are multiple strategies to debug this, but I think the most
effective one in terms of captured data is to strace what’s going on
like this:

# strace -f -o /tmp/strace.log -s 2048 -p 1 & systemctl restart postgresql.service

Then, after a couple of seconds, fg into the strace process, cancel it,
and provide the strace.log in this bugreport.

> Running through the init script works:
>
> # env _SYSTEMCTL_SKIP_REDIRECT="true" /etc/init.d/postgresql start
> Starting PostgreSQL 9.3 database server: main.
>
> I also had a similar problem with ssh but I remember a bug report
> saying that was upstart integration that could have done that. But
> there is no such thing for PostgreSQL.
This is really weird. FWIW, postgresql works just fine for me with
systemd on multiple machines. Hopefully the strace will shed some light
on what’s going wrong here.

-- 
Best regards,
Michael