[Bug 275261] New: Akonadi on NFS mounted home directories is very fragile

[krienke at uni-koblenz.de]

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

           Summary: Akonadi on NFS mounted home directories is very
                    fragile
           Product: Akonadi
           Version: 4.6
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: general
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: krienke at uni-koblenz.de


Version:           4.6 (using KDE 4.6.3) 
OS:                Linux

In our environment every user has his home directory on a NFS mounted
directory. As a consequence the akonadi database (in ~/.local/share/akonadi) is
located on NFS as well. Basically this works.

However if the computer hangs and has to be restarted or the system does not
wake up from a suspend to disk and has to rebooted or quite any other crash
that might happen turns akonadi permanently unusable because the mysql database
seems to be completely broken so it cannot be repaired when akonadi starts (see
attached error log below). The only way to repair I know is to remove the
broken database or to restore an older version from my personal backup.

For a regular user  without deeper knowlegde about kde and akonadi such a crash
renders his KDE session quite unusable: no kmail, no knode and no kontact. 

The big problem: KDE does *not* offer *any options* for the user to get out of
this situation. This probably will cause frustation.

I think KDE must offer some help if the database is broken to get back into a
usable state, or there must be an option to live without akonadi if it fails
and thus blocks the most important applications for daily work  like kmail or
korganizer.

A possible solution would be to offer the user at least a way to restore a
backup of the akonadi database, which of course means there must be an
automatic backup before. The user should be able to configure where the backup
should be located.

Reproducible: Sometimes

Steps to Reproduce:
crash the system by any means, sometimes it is already enough to terminate a
KDE session by CTRL-ALT-BACKSPACE .

Actual Results:  
Akonadi is not running and so preventing kdepim-apps from starting


The akonadi errorlog:

The akonadi errorlog:

ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
search paths:  ("/bin", "/usr/bin", "/sbin", "/usr/sbin", "/opt/kde3/bin",
"/opt/kde/bin", "/opt/gnome/bin", "/usr/local/bin", "/usr/local/sbin",
"/opt/Acrobat3/bin", "/import/sw/frame5.5.6/bin",
"/home/krienke/bin/unknown-linux", "/home/krienke/bin", ".", "/usr/sbin",
"/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/krienke/.local/share/akonadi//mysql.conf",
"--datadir=/home/krienke/.local/share/akonadi/db_data/",
"--socket=/home/krienke/.local/share/akonadi/socket-bliss/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x44dd19]
1: akonadiserver() [0x44e282]
2: /lib64/libc.so.6(+0x32b30) [0x7fe9bedd9b30]
3: /lib64/libc.so.6(gsignal+0x35) [0x7fe9bedd9ab5]
4: /lib64/libc.so.6(abort+0x186) [0x7fe9beddafb6]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fe9c0abc924]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xab) [0x45054b]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7fe9c0b4a747]
8: /usr/lib64/libQtCore.so.4(+0x106ac6) [0x7fe9c0b52ac6]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fe9c0b5b9ab]
10: akonadiserver(_ZN6QDebugD1Ev+0x4b) [0x4492db]
11: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x1a18) [0x4d5f58]
12: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xd8)
[0x450958]
13: akonadiserver() [0x4535c8]
14: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x35) [0x454be5]
15: akonadiserver(main+0x21f) [0x4486cf]
16: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7fe9bedc5bfd]
17: akonadiserver() [0x4483b9]
]
"
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.