Bug#821402: postgresql: fails to start
Package: akonadi-backend-postgresql
Version: 1.13.0-8
Severity: normal
Hello,
I recently removed old postgresql versions on jessie and only kept 9.5,
and now akonadi refuses to start:
(the system is set up as per http://enricozini.org/blog/2015/akonadi-install/)
$ akonadictl start
Starting Akonadi Server...
done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
enrico@viaza:~$ Failed to use database "akonadi-enrico"
Database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
Trying to create database now...
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
"
Unable to open database "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x41829a]
1: akonadiserver() [0x41856b]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x33500) [0x7f0a758b9500]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f0a758b9478]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f0a758ba8fa]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0xa5) [0x7f0a7713cf15]
6: akonadiserver() [0x41a77d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xa7) [0x7f0a771df5e7]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x120426) [0x7f0a771ed426]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7f0a771f6e81]
10: akonadiserver() [0x41e684]
11: akonadiserver() [0x4ff3b9]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1d1) [0x7f0a77271db1]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7f0a7725790d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x376) [0x7f0a7725b3c6]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1bb0f3) [0x7f0a772880f3]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7f0a74f83137]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a390) [0x7f0a74f83390]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f0a74f8343c]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x64) [0x7f0a77288244]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x3f) [0x7f0a7725618f]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1b5) [0x7f0a772564f5]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7f0a7725c4b9]
23: akonadiserver() [0x41348d]
24: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f0a758a6610]
25: akonadiserver() [0x413d7e]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
Failed to use database "akonadi-enrico"
Database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
Trying to create database now...
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
"
Unable to open database "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x41829a]
1: akonadiserver() [0x41856b]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x33500) [0x7fc729ee7500]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7fc729ee7478]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fc729ee88fa]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0xa5) [0x7fc72b76af15]
6: akonadiserver() [0x41a77d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xa7) [0x7fc72b80d5e7]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x120426) [0x7fc72b81b426]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fc72b824e81]
10: akonadiserver() [0x41e684]
11: akonadiserver() [0x4ff3b9]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1d1) [0x7fc72b89fdb1]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7fc72b88590d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x376) [0x7fc72b8893c6]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1bb0f3) [0x7fc72b8b60f3]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7fc7295b1137]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a390) [0x7fc7295b1390]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc7295b143c]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x64) [0x7fc72b8b6244]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x3f) [0x7fc72b88418f]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1b5) [0x7fc72b8844f5]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7fc72b88a4b9]
23: akonadiserver() [0x41348d]
24: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fc729ed4610]
25: akonadiserver() [0x413d7e]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
Failed to use database "akonadi-enrico"
Database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
Trying to create database now...
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
"
Unable to open database "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x41829a]
1: akonadiserver() [0x41856b]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x33500) [0x7f380a2b8500]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f380a2b8478]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f380a2b98fa]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0xa5) [0x7f380bb3bf15]
6: akonadiserver() [0x41a77d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xa7) [0x7f380bbde5e7]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x120426) [0x7f380bbec426]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7f380bbf5e81]
10: akonadiserver() [0x41e684]
11: akonadiserver() [0x4ff3b9]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1d1) [0x7f380bc70db1]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7f380bc5690d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x376) [0x7f380bc5a3c6]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1bb0f3) [0x7f380bc870f3]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7f3809982137]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a390) [0x7f3809982390]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f380998243c]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x64) [0x7f380bc87244]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x3f) [0x7f380bc5518f]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1b5) [0x7f380bc554f5]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7f380bc5b4b9]
23: akonadiserver() [0x41348d]
24: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f380a2a5610]
25: akonadiserver() [0x413d7e]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
Failed to use database "akonadi-enrico"
Database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
Trying to create database now...
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database error: Cannot open database.
Last driver error: "QPSQL: Unable to connect"
Last database error: "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
"
Unable to open database "could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x41829a]
1: akonadiserver() [0x41856b]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x33500) [0x7fac260f0500]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7fac260f0478]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fac260f18fa]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0xa5) [0x7fac27973f15]
6: akonadiserver() [0x41a77d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xa7) [0x7fac27a165e7]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x120426) [0x7fac27a24426]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fac27a2de81]
10: akonadiserver() [0x41e684]
11: akonadiserver() [0x4ff3b9]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1d1) [0x7fac27aa8db1]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7fac27a8e90d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x376) [0x7fac27a923c6]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1bb0f3) [0x7fac27abf0f3]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7fac257ba137]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a390) [0x7fac257ba390]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fac257ba43c]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x64) [0x7fac27abf244]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x3f) [0x7fac27a8d18f]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1b5) [0x7fac27a8d4f5]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7fac27a934b9]
23: akonadiserver() [0x41348d]
24: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fac260dd610]
25: akonadiserver() [0x413d7e]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.3.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages akonadi-backend-postgresql depends on:
ii libqt4-sql-psql 4:4.8.7+dfsg-6+b1
Versions of packages akonadi-backend-postgresql recommends:
ii akonadi-server 1.13.0-8
ii postgresql 9.5+173
akonadi-backend-postgresql suggests no packages.
-- no debconf information
Reply to: