Launchpad has imported 6 comments from the remote bug at https://bugs.kde.org/show_bug.cgi?id=238217.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2010-05-19T19:37:50+00:00 Cubranic-w wrote: Version: (using KDE 4.4.2) OS: Linux Installed from: Ubuntu Packages I originally reported this bug in Ubuntu Launchpad: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357 I am opening it here as a wider issue: Akonadi is very fragile in the face of mysql startup problems, and that has a knock-on effect of preventing basic user applications (mail, PIM) from running. The most visible symptom of the problem was that after starting up KMail, I would get an error dialog stating that Akonadi is not running. After closing the dialog, the app would close also. I started investigating, and got voluminous, but not very helpful error output when running 'akonadictl start' from the command line. (I'll attach a copy.) Further poking and twiddling with apparmor and other workarounds suggested in various bugs and forums was unsuccessful. Eventually, I stumbled upon mysql.err in ~/.local/share/akonadi/db_data/ with the following contents: 100519 9:49:38 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Error: log file ./ib_logfile1 is of different size 0 0 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 100519 9:49:38 [ERROR] Plugin 'InnoDB' init function returned error. 100519 9:49:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 100519 9:49:38 [ERROR] Unknown/unsupported table type: innodb 100519 9:49:38 [ERROR] Aborting 100519 9:49:38 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete File 'ib_logfile1' was indeed of size zero. Deleting it and 'ib_logfile0', and then restarting 'akonadictl' seemed to fix the problem and I now have a working mail reader. I don't know how the log file got corrupted, but the system should be more robust than that. I mean, having a zero-size or corrupted log file does not need to be an unrecoverable error! It's completely reasonable in such a situation to delete it and proceed with startup. The database should still be in a consistent state, and the worst that could happen is that the last few transactions are missing. Or at the very least notify the user what the real problem is. As it is, akonadi server's output is utterly unhelpful, and it took me forever to find Akonadi's mysql.err, where the problem was actually clearly identified. Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/7 ------------------------------------------------------------------------ On 2010-05-19T19:40:53+00:00 Cubranic-w wrote: Created attachment 43736 Output of 'akonadictl start' when MySql fails to start This is the output of running 'akonadictl start' from the console before I vixed the problem by deleting the corrupted logfiles. This output actually repeats three times. (Why?) Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/8 ------------------------------------------------------------------------ On 2010-09-14T22:52:52+00:00 reagle wrote: I have the same problem too. Moving to akonadi has been a disaster for me as a user. Beside this breakage, how does one even backup one's email files even? Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/13 ------------------------------------------------------------------------ On 2010-11-10T17:59:00+00:00 João Eiras wrote: *** Bug 256527 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/15 ------------------------------------------------------------------------ On 2011-03-13T16:31:37+00:00 Ricardo Graça wrote: *** This bug has been confirmed by popular vote. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/17 ------------------------------------------------------------------------ On 2016-09-24T20:38:55+00:00 Kdenis wrote: This bug has only been reported for versions older than KDEPIM 4.14 (at most akonadi-1.3). Can anyone tell if this bug still present? If noone confirms this bug for a recent version of akonadi (part of KDE Applications 15.08 or later), it gets closed in about three months. Reply at: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/578357/comments/24 ** Changed in: akonadi Status: Unknown => Incomplete ** Changed in: akonadi Importance: Unknown => Medium -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/578357 Title: MySql log file problem prevents Akonadi startup Status in Akonadi: Incomplete Status in akonadi package in Ubuntu: Invalid Bug description: I upgraded an older PC from KUbuntu Karmic to Lucid by doing a clean install to the root partition, and keeping existing files in the separate '/home' partition untouched. I now cannot use KMail any more, because Akonadi fails to start up. This is the error output that I get when I tried running 'akonadictl start' from the console: I tried running 'akonadictl start' from the command line, and it fails to start -- apparently because I haven't installed MySql. Console output is below: Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] search paths: ("/home/cubranic/bin", "/home/cubranic/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin") [akonadiserver] Found mysql_install_db: "/usr/bin/mysql_install_db" [akonadiserver] Found mysql_upgrade: "/usr/bin/mysql_upgrade" "akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/cubranic/.local/share/akonadi/db_misc/mysql.socket' " [akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/cubranic/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect [akonadiserver] FATAL ERROR: Upgrade failed [akonadiserver] Database process exited unexpectedly during initial connection! [akonadiserver] executable: "/usr/sbin/mysqld-akonadi" [akonadiserver] arguments: ("--defaults-file=/home/cubranic/.local/share/akonadi//mysql.conf", "--datadir=/home/cubranic/.local/share/akonadi/db_data/", "--socket=/home/cubranic/.local/share/akonadi/db_misc/mysql.socket") [akonadiserver] stdout: "" [akonadiserver] stderr: "" [akonadiserver] exit code: 1 [akonadiserver] process error: "Unknown error" [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052265] [akonadiserver] 1: akonadiserver() [0x8052726] [akonadiserver] 2: [0xb5d400] [akonadiserver] 3: [0xb5d422] [akonadiserver] 4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0x4d1651] [akonadiserver] 5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x4d4a82] [akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x16d2dc] [akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x80537a4] [akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0x20546e] [akonadiserver] 9: /usr/lib/libQtCore.so.4(+0x10a275) [0x21a275] [akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0x21b78d] [akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804dea3] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x2071) [0xe50cb1] [akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x263) [0xe53da3] [akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x7d) [0xe5403d] [akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xe554f8] [akonadiserver] 16: akonadiserver(main+0x374) [0x804d204] [akonadiserver] 17: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0x4bdbd6] [akonadiserver] 18: akonadiserver() [0x804cdc1] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) [repeated three more times] To manage notifications about this bug go to: https://bugs.launchpad.net/akonadi/+bug/578357/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp