[kdepim-users] [Akonadi + PostgreSQL] akonadictl tries to start outdated version of PostgreSQL server

Thu Jan 26 10:06:45 GMT 2012

Am Donnerstag, 26. Januar 2012 schrieb Martin Steigerwald:
> Am Mittwoch, 25. Januar 2012 schrieb Ingo Klöcker:
> > On Wednesday 25 January 2012, Martin Steigerwald wrote:
> > > Hi!
> > > 
> > > Reported as:
> > > 
> > > Bug 292393 - [PostgreSQL backend] akonadictl tries to start
> > > outdated version of PostgreSQL server and crashes
> > > 
> > > https://bugs.kde.org/292393
> > > 
> > > but I thought I ask here - maybe there is an easy workaround.
> > > 
> > > I tried setting Akonadi-Server to start the database server itself.
> > > 
> > > Currently I do use a central PostgreSQL server that works fine. But
> > > to have the Akonadi data in my home directory or central backup of
> > > all user data and to have akonadictl stop all whats being needed to
> > > make Akonadi data consistent in that it also stops the PostgreSQL
> > > server, I tried setting it to Startserver=true like this:
> > > 
> > > [QPSQL]
> > > Name=
> > > Host=
> > > Options=
> > > StartServer=true
> > > 
> > > 
> > > But then Akonadi fails to start the PostgreSQL server since it
> > > tries with an outdated version thats not installed. I have:
> > > 
> > > merkaba:~> apt-show-versions | grep postgresql
> > > akonadi-backend-postgresql/experimental uptodate 1.6.2-1
> > > postgresql/wheezy uptodate 9.1+128
> > > postgresql-9.1/sid uptodate 9.1.2-4
> > > postgresql-client-9.1/sid uptodate 9.1.2-4
> > > postgresql-client-common/wheezy uptodate 128
> > > postgresql-common/wheezy uptodate 128
> > > postgresql-contrib-9.1/sid uptodate 9.1.2-4
> > > 
> > > 
> > > The output of akonadictl start:
> > > 
> > > martin at merkaba:~/.config/akonadi> akonadictl start
> > > Starting Akonadi Server...
> > > 
> > >    done.
> > > 
> > > Connecting to deprecated signal
> > > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QStri
> > > ng ) 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")
> > 
> > This looks suspiously like the contents of $PATH. What does 'echo
> > $PATH' say? Did you grep ~/.kde for "/usr/lib/postgresql/8.4/bin"?
> 
> martin at merkaba:~> echo $PATH
> ~/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games
> 
> martin at merkaba:~> su -
> Passwort:
> merkaba:~> echo $PATH
> ~/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
> 
> (but that should not matter, since Akonadi is started from the user)
> 
> I bet Akonadi changes the path prior trying to start the database
> server.
> 
> martin at merkaba:~> grep -I --devices=skip -ir
> "/usr/lib/postgresql/8.4/bin" .kde
> .kde/share/apps/kmail/autosave/cur/1327566532.2597.VSpi2:> >
> "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin")
> .kde/share/apps/kmail/autosave/cur/1327566532.2597.VSpi2:> $PATH' say?
> Did you grep ~/.kde for "/usr/lib/postgresql/8.4/bin"?
> martin at merkaba:~>
> 
> But I found:
> 
> [QPSQL]
> StartServer=true
> Name=akonadi
> Host=/home/alvanx/.local/share/akonadi/socket-alvanx
> Options=
> ServerPath=/usr/bin/postgres #same results with pg_ctl, I do believe
> "postgres" was preset though
> InitDbPath=/usr/bin/initdb
> User=
> Password=
> Port=5432
> 
> http://forum.kde.org/viewtopic.php?f=20&t=97306
> 
> 
> So I think it should be possible to override the default path and I
> will try this.

[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.

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

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.

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! 

Thanks,
-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users