[Bug 292393] [PostgreSQL backend] akonadictl tries to start outdated version of PostgreSQL server and crashes

Thu Jan 26 10:06:51 GMT 2012

https://bugs.kde.org/show_bug.cgi?id=292393

--- Comment #1 from Martin Steigerwald <Martin Lichtvoll de>  2012-01-26 10:06:51 ---
[QPSQL]
StartServer=true
ServerPath=/usr/lib/postgresql/9.1/bin/pg_ctl
InitDbPath=/usr/lib/postgresql/9.1/bin/initdb
Name=akonadi
Host=/home/martin/.local/share/akonadi/socket-merkaba
Options=

works.

So it seems that auto-configuring of the postgresql directory does not work.
This manual setup needs to be adapted on each major server upgrade, thus I am
wondering whether I miss from distribution specific package, but did not found
a clear candidate to install.

Name= and Host= were auto-filled. Thus not necessary to specify them.

postgres as ServerPath binary does not work, cause it doesn´t support option
-w:

martin at merkaba:~/.config/akonadi> akonadictl start 
Starting Akonadi Server...
   done.
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
martin at merkaba:~/.config/akonadi> search paths:  ("~/bin", "/usr/local/bin",
"/usr/bin", "/bin", "/usr/bin/X11", "/usr/games", "/usr/sbin",
"/usr/local/sbin", "/usr/lib/postgresql/8.4/bin") 
Die Dateien, die zu diesem Datenbanksystem gehören, werden dem Benutzer
»martin« gehören. Diesem Benutzer muss auch der Serverprozess gehören.

Der Datenbankcluster wird mit der Locale en_US.UTF-8 initialisiert werden.
Die Standarddatenbankkodierung wurde entsprechend auf UTF8 gesetzt.
Die Standardtextsuchekonfiguration wird auf »english« gesetzt.

berichtige Zugriffsrechte des bestehenden Verzeichnisses
/home/martin/.local/share/akonadi/db_data ... ok
erzeuge Unterverzeichnisse ... ok
wähle Vorgabewert für max_connections ... 100
wähle Vorgabewert für shared_buffers ... 24MB
erzeuge Konfigurationsdateien ... ok
erzeuge Datenbank template1 in /home/martin/.local/share/akonadi/db_data/base/1
... ok
initialisiere pg_authid ... ok
initialisiere Abhängigkeiten ... ok
erzeuge Systemsichten ... ok
lade Systemobjektbeschreibungen ... ok
erzeuge Sortierfolgen ... ok
erzeuge Konversionen ... ok
erzeuge Wörterbücher ... ok
setze Privilegien der eingebauten Objekte ... ok
erzeuge Informationsschema ... ok
lade Serversprache PL/pgSQL ... ok
führe Vacuum in Datenbank template1 durch ... ok
kopiere template1 nach template0 ... ok
kopiere template1 nach postgres ... ok

WARNUNG: Authentifizierung für lokale Verbindungen auf »trust« gesetzt
Sie können dies ändern, indem Sie pg_hba.conf bearbeiten oder beim
nächsten Aufruf von initdb die Option -A verwenden.

Erfolg. Sie können den Datenbankserver jetzt mit

    /usr/lib/postgresql/9.1/bin/postgres -D
/home/martin/.local/share/akonadi/db_data
oder
    /usr/lib/postgresql/9.1/bin/pg_ctl -D
/home/martin/.local/share/akonadi/db_data -l logdatei start

starten.

Database process exited unexpectedly during initial connection!
executable: "/usr/lib/postgresql/9.1/bin/postgres"
arguments: ("-w", "-t10", "start",
"-D/home/martin/.local/share/akonadi/db_data")
stdout: ""
stderr: "/usr/lib/postgresql/9.1/bin/postgres: UngÃ¼ltige Option -- w
Versuchen Sie Â»postgres --helpÂ« fÃ¼r weitere Informationen.
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x417c44]
1: akonadiserver() [0x417fce]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f529ff98480]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f529ff98405]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f529ff9b680]
5:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111)
[0x7f52a1c68871]
6: akonadiserver() [0x419642]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf)
[0x7f52a1d0470f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f52a1d0fcc2]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f52a1d18b59]
10: akonadiserver() [0x4a27ab]
11: akonadiserver() [0x419ac2]
12: akonadiserver() [0x41b28c]
13: akonadiserver() [0x41c8c7]
14: akonadiserver() [0x412e52]
15: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7f529ff84ead]
16: akonadiserver() [0x4136e1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
search paths:  ("~/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11",
"/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin") 
Database process exited unexpectedly during initial connection!
executable: "/usr/lib/postgresql/9.1/bin/postgres"
arguments: ("-w", "-t10", "start",
"-D/home/martin/.local/share/akonadi/db_data")
stdout: ""
stderr: "/usr/lib/postgresql/9.1/bin/postgres: UngÃ¼ltige Option -- w
Versuchen Sie Â»postgres --helpÂ« fÃ¼r weitere Informationen.
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x417c44]
1: akonadiserver() [0x417fce]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f2566a08480]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f2566a08405]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f2566a0b680]
5:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111)
[0x7f25686d8871]
6: akonadiserver() [0x419642]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf)
[0x7f256877470f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f256877fcc2]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f2568788b59]
10: akonadiserver() [0x4a27ab]
11: akonadiserver() [0x419ac2]
12: akonadiserver() [0x41b28c]
13: akonadiserver() [0x41c8c7]
14: akonadiserver() [0x412e52]
15: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7f25669f4ead]
16: akonadiserver() [0x4136e1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
search paths:  ("~/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11",
"/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin") 
Database process exited unexpectedly during initial connection!
executable: "/usr/lib/postgresql/9.1/bin/postgres"
arguments: ("-w", "-t10", "start",
"-D/home/martin/.local/share/akonadi/db_data")
stdout: ""
stderr: "/usr/lib/postgresql/9.1/bin/postgres: UngÃ¼ltige Option -- w
Versuchen Sie Â»postgres --helpÂ« fÃ¼r weitere Informationen.
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x417c44]
1: akonadiserver() [0x417fce]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7fabeb045480]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7fabeb045405]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7fabeb048680]
5:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111)
[0x7fabecd15871]
6: akonadiserver() [0x419642]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf)
[0x7fabecdb170f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7fabecdbccc2]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fabecdc5b59]
10: akonadiserver() [0x4a27ab]
11: akonadiserver() [0x419ac2]
12: akonadiserver() [0x41b28c]
13: akonadiserver() [0x41c8c7]
14: akonadiserver() [0x412e52]
15: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7fabeb031ead]
16: akonadiserver() [0x4136e1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
search paths:  ("~/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11",
"/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin") 
Database process exited unexpectedly during initial connection!
executable: "/usr/lib/postgresql/9.1/bin/postgres"
arguments: ("-w", "-t10", "start",
"-D/home/martin/.local/share/akonadi/db_data")
stdout: ""
stderr: "/usr/lib/postgresql/9.1/bin/postgres: UngÃ¼ltige Option -- w
Versuchen Sie Â»postgres --helpÂ« fÃ¼r weitere Informationen.
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x417c44]
1: akonadiserver() [0x417fce]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7fdcf98f0480]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7fdcf98f0405]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7fdcf98f3680]
5:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111)
[0x7fdcfb5c0871]
6: akonadiserver() [0x419642]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf)
[0x7fdcfb65c70f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7fdcfb667cc2]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fdcfb670b59]
10: akonadiserver() [0x4a27ab]
11: akonadiserver() [0x419ac2]
12: akonadiserver() [0x41b28c]
13: akonadiserver() [0x41c8c7]
14: akonadiserver() [0x412e52]
15: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7fdcf98dcead]
16: akonadiserver() [0x4136e1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted!

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.