Package: postgresql-11 Version: 11.5-3sid2 Severity: important Since yesterday [email protected] fails to start and systemctl status ends with: [email protected]: Failed with result 'protocol'. Failed to start PostgreSQL Cluster 11-main.
In /var/log/postgresql/postgresql-11-main.log I see this: 2019-10-07 13:29:48.816 CEST [1058] LOG: listening on IPv6 address "::1", port 5432 2019-10-07 13:29:48.816 CEST [1058] LOG: listening on IPv4 address "127.0.0.1", port 5432 2019-10-07 13:29:48.820 CEST [1058] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2019-10-07 13:29:48.845 CEST [1060] LOG: database system was shut down at 2019-10-07 07:54:57 CEST 2019-10-07 13:29:48.864 CEST [1058] LOG: database system is ready to accept connections 2019-10-07 13:29:49.395 CEST [1098] [unknown]@[unknown] LOG: incomplete startup packet 2019-10-07 13:43:20.898 CEST [1058] LOG: received fast shutdown request 2019-10-07 13:43:20.904 CEST [1058] LOG: aborting any active transactions 2019-10-07 13:43:20.905 CEST [1058] LOG: background worker "logical replication launcher" (PID 1066) exited with exit code 1 2019-10-07 13:43:20.905 CEST [1061] LOG: shutting down 2019-10-07 13:43:20.979 CEST [1058] LOG: database system is shut down 2019-10-07 13:44:00.487 CEST [1086] FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2019-10-07 13:44:00.487 CEST [1086] LOG: database system is shut down pg_ctl: could not start server Examine the log output. And then the last 4 lines get repeated many times. A bit further up the log file, when postgresql-11 got upgraded to this version, there are these lines: 2019-10-06 23:23:42.714 CEST [2172] diederik@akonadi_diederik FATAL: terminating connection due to administrator command 2019-10-06 23:23:42.714 CEST [1054] LOG: background worker "logical replication launcher" (PID 1064) exited with exit code 1 The FATAL line appears ~30 times, all within the same second. Downgrading postgresql-11 and postgresql-client-11 to the version in testing (11.5-2+b1) did not fix the issue. I then tried to access /etc/ssl/private/ssl-cert-snakeoil.key (as user postgres) and indeed couldn't access that file. User postgres is in group ssl-cert and this was the permissions to the private dir: drwx--x--- 2 root ssl-cert 4096 okt 7 18:13 private When I changed it to this: drwxr-x--- 2 root ssl-cert 4096 okt 7 18:13 private I could access the ssl-cert-snakeoil.key file as user postgres, but this did not resolve the issue. It kept reporting "Permission denied". Since 2019-10-07 13:44:00.487 CEST, I only get those last 4 lines. I don't know if it's relevant, but together with the upgrade of postgresql-11, apparmor and llvm got upgraded. And the FATAL line appeared when perl got upgraded from 5.28 to 5.30. I mention those other upgrades as downgrading the postgresql packages to the testing versions did not fix the issue (which it often does). As I'm therefor not 100% sure the issue is (directly) in the postgresql packages, I set the severity to important instead of grave. Anyway, the result is no running postgresql, thus no akonadi, thus no working kmail for me. -- System Information: Debian Release: bullseye/sid APT prefers unstable-debug APT policy: (500, 'unstable-debug'), (500, 'unstable'), (500, 'testing'), (101, 'experimental'), (1, 'experimental-debug') Architecture: amd64 (x86_64) Kernel: Linux 5.2.0-3-amd64 (SMP w/16 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages postgresql-11 depends on: ii debconf [debconf-2.0] 1.5.73 ii libc6 2.29-2 ii libgcc1 1:9.2.1-8 ii libgssapi-krb5-2 1.17-6 ii libicu63 63.2-2 ii libldap-2.4-2 2.4.48+dfsg-1+b1 ii libllvm9 1:9-2 ii libpam0g 1.3.1-5 ii libpq5 12.0-1+b1 ii libselinux1 2.9-2+b2 ii libssl1.1 1.1.1d-1 ii libstdc++6 9.2.1-8 ii libsystemd0 242-7 ii libuuid1 2.34-0.1 ii libxml2 2.9.4+dfsg1-7+b3 ii libxslt1.1 1.1.32-2.1 ii locales 2.29-2 ii postgresql-client-11 11.5-3sid2 ii postgresql-common 207 ii ssl-cert 1.0.39 ii tzdata 2019c-3 ii zlib1g 1:1.2.11.dfsg-1+b1 Versions of packages postgresql-11 recommends: ii sysstat 12.0.6-1 postgresql-11 suggests no packages. -- debconf information: postgresql-11/postrm_purge_data: true
