Comment 2 for bug 587418

I share the author's bug after I upgraded my x86_64 Kubuntu 9.10 setup to 10.04. Just like him, test #4 contains the same set of errors:

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
(repeats)

I've attached self-test file for the full report.

However, to add to what the original author mentioned, I have stopped and started akonadi from the command line, which gives me more info. Where it first seems to die is this line:

[akonadiserver] /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

Why would this fail? The only thing I can think of is that I have an existing mysqld to do web development work and I wonder if it this akonadi startup process is accessing its data store? And maybe more importantly, what could I try to fix it so that it can log in as root?

Here's what I'm trying:

michael@core2duo:~$ akonadictl stop
michael@core2duo:~$ QProcess: Destroyed while process is still running.
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Process operation timed out)

michael@core2duo:~$ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (backend: Unknown)

michael@core2duo:~$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] search paths: ("/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/michael/.local/share/akonadi/db_misc/mysql.socket'
"
[akonadiserver] /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Access denied for user 'michael'@'localhost' (using password: NO)"
[akonadiserver] Unable to open database "Access denied for user 'michael'@'localhost' (using password: NO) QMYSQL: Unable to connect"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b739]
[akonadiserver] 1: akonadiserver() [0x40bc7a]
[akonadiserver] 2: /lib/libc.so.6(+0x33af0) [0x7f0fc1e9daf0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f0fc1e9da75]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f0fc1ea15c0]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f0fc3083da4]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40cd88]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7f0fc3112967]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10e1d9) [0x7f0fc31201d9]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f0fc31213d9]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x4071b9]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x55a) [0x7f0fc34f5eda]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f0fc34f6d1a]
[akonadiserver] 13: akonadiserver(main+0x429) [0x406539]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f0fc1e88c4d]
[akonadiserver] 15: akonadiserver() [0x406019]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)

(after this, it keeps looping, repeating the same block of text above over and over)