Re: [Akonadi + PostgreSQL] akonadictl tries to start outdated version of PostgreSQL server

a side note : Akonadi + PostgreSQL could be a cool feature for big email
accounts , did you like the solution ? and if have a better
performance ? and benchmark ?

On Wed, 2012-01-25 at 14:15 +0100, 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@merkaba:~/.config/akonadi> akonadictl start  
> Starting Akonadi Server...
>    done.
> Connecting to deprecated signal 
> QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> martin@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") 
> Could not start database server!
> executable: ""
> arguments: ("-w", "-t10", "start", "-
> D/home/martin/.local/share/akonadi/db_data")
> process error: "No such file or directory"
> "[
> 0: akonadiserver() [0x417c44]
> 1: akonadiserver() [0x417fce]
> 2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f00908e4480]
> 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f00908e4405]
> 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f00908e7680]
> 5: /usr/lib/x86_64-linux-
> gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111) 
> [0x7f00925b4871]
> 6: akonadiserver() [0x419642]
> 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) 
> [0x7f009265070f]
> 8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f009265bcc2]
> 9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) 
> [0x7f0092664b59]
> 10: akonadiserver() [0x413856]
> 11: akonadiserver() [0x4a1e75]
> 12: akonadiserver() [0x419ac2]
> 13: akonadiserver() [0x41b28c]
> 14: akonadiserver() [0x41c8c7]
> 15: akonadiserver() [0x412e52]
> 16: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) 
> [0x7f00908d0ead]
> 17: 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") 
> Could not start database server!
> executable: ""
> arguments: ("-w", "-t10", "start", "-
> D/home/martin/.local/share/akonadi/db_data")
> process error: "No such file or directory"
> "[
> 0: akonadiserver() [0x417c44]
> 1: akonadiserver() [0x417fce]
> 2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f7ce213f480]
> 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f7ce213f405]
> 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f7ce2142680]
> 5: /usr/lib/x86_64-linux-
> gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111) 
> [0x7f7ce3e0f871]
> 6: akonadiserver() [0x419642]
> 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) 
> [0x7f7ce3eab70f]
> 8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f7ce3eb6cc2]
> 9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) 
> [0x7f7ce3ebfb59]
> 10: akonadiserver() [0x413856]
> 11: akonadiserver() [0x4a1e75]
> 12: akonadiserver() [0x419ac2]
> 13: akonadiserver() [0x41b28c]
> 14: akonadiserver() [0x41c8c7]
> 15: akonadiserver() [0x412e52]
> 16: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) 
> [0x7f7ce212bead]
> 17: 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") 
> Could not start database server!
> executable: ""
> arguments: ("-w", "-t10", "start", "-
> D/home/martin/.local/share/akonadi/db_data")
> process error: "No such file or directory"
> "[
> 0: akonadiserver() [0x417c44]
> 1: akonadiserver() [0x417fce]
> 2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f63855f3480]
> 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f63855f3405]
> 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f63855f6680]
> 5: /usr/lib/x86_64-linux-
> gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111) 
> [0x7f63872c3871]
> 6: akonadiserver() [0x419642]
> 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) 
> [0x7f638735f70f]
> 8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f638736acc2]
> 9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) 
> [0x7f6387373b59]
> 10: akonadiserver() [0x413856]
> 11: akonadiserver() [0x4a1e75]
> 12: akonadiserver() [0x419ac2]
> 13: akonadiserver() [0x41b28c]
> 14: akonadiserver() [0x41c8c7]
> 15: akonadiserver() [0x412e52]
> 16: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) 
> [0x7f63855dfead]
> 17: 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") 
> Could not start database server!
> executable: ""
> arguments: ("-w", "-t10", "start", "-
> D/home/martin/.local/share/akonadi/db_data")
> process error: "No such file or directory"
> "[
> 0: akonadiserver() [0x417c44]
> 1: akonadiserver() [0x417fce]
> 2: /lib/x86_64-linux-gnu/libc.so.6(+0x32480) [0x7f1e3c735480]
> 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f1e3c735405]
> 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f1e3c738680]
> 5: /usr/lib/x86_64-linux-
> gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x111) 
> [0x7f1e3e405871]
> 6: akonadiserver() [0x419642]
> 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) 
> [0x7f1e3e4a170f]
> 8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ecc2) [0x7f1e3e4accc2]
> 9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) 
> [0x7f1e3e4b5b59]
> 10: akonadiserver() [0x413856]
> 11: akonadiserver() [0x4a1e75]
> 12: akonadiserver() [0x419ac2]
> 13: akonadiserver() [0x41b28c]
> 14: akonadiserver() [0x41c8c7]
> 15: akonadiserver() [0x412e52]
> 16: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) 
> [0x7f1e3c721ead]
> 17: akonadiserver() [0x4136e1]
> ]
> "
> ProcessControl: Application 'akonadiserver' returned with exit code 255 
> (Unknown error)
> "akonadiserver" crashed too often and will not be restarted! 
> 
> 
> I think I will report this as bug as well, but maybe someone knows an easy 
> workaround.
> 
> Ciao,

-- 
Sérgio M. B.

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users