akonadi crashes on mysql problem

[Nico den Boer]

Migrated from last to current stable Kubuntu version.
Kmail crashes when starting, or freezes.
I did some testing to isolate the problem and found some info which might be useful.

1) Kmail crashes because akonadi crashes during init. Attached the log. It seems to be a mysql problem, dragging akonadi down with it.
2) Mysql works fine for other applications.
3) For akonadi the bin /usr/sbin/mysqld-akonadi is used. If I try starting akonadi, I see multiple processes trying to start this mysql bin. One prevents the other to start succesfully, as you can see in the attached log, test 4. Each bin adds a repeated block of error lines to mysql.err, in the attachment I cut away most of the the repeated blocks.
4) I logged in as another Linux user. Kmail was not used in this account yet. Akonadi starts normally in this account. Then I copied the whole dir /home/nico/.kde/share/apps/kmail and the files
/home/nico/.kde/share/config/kmail*
/home/nico/.kde/share/config/mail*
/home/nico/.kde/share/config/email*
Then restarted Akonadi and started kmail without any problem.

So, for this new user account all remains working fine, it seems files or
settings in /home/nico are causing this error.

Deleting the dir /home/nico/.local/share/akonadi has no effect, the dir is recreated and I still have the error.
Did a search on all akonadi files in my home dir:
./.local/share/akonadi/akonadiserver.socket
./.local/share/akonadi/akonadiserver.error.old
./.kde/share/config/akonadi-firstrunrc
./.config/akonadi/ <some files here, but they are recreated and therefore fresh>

I cannot find the difference, why in one account kmail / akonadi works fine, while in the other / my account I get crashes.
What can I do to assist in finding the cause of this problem?

[Ⅿⅰⅽhaeⅼ Ⅼutỵnskⅰ (eternal-cheesecake)]

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

[Maarten Bezemer (veger)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. We are sorry that we do not always have the capacity to look at all reported bugs in a timely manner. There have been many changes in Ubuntu since that time you reported the bug and your problem may have been fixed with some of the updates. It would help us a lot if you could test it on a currently supported Ubuntu version. When you test it and it is still an issue, kindly upload the updated logs by running apport-collect 587418 and any other logs that are relevant for this particular issue.

[Launchpad Janitor (janitor)]

[Expired for akonadi (Ubuntu) because there has been no activity for 60 days.]