'akonadictl start' aborts with error after upgrade to 10.4 beta

[Ernst Kloppenburg]

after upgrading to 10.4beta today, akonadi does not start

I have looked at the similar resolved bugs and checked that I really have the package versions containing the latest fixes:

akonadi-server 1.3.1-0ubuntu2
mysql-server-core-5.1 5.1.41-3ubuntu11

I get the following error message from kmail: "MySQL-Serverprotokoll fehlerhaft"

The content of /home/$USER/.local/share/akonadi/db_data/mysql.err is

100403 16:44:00 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100403 16:44:00 [ERROR] Plugin 'InnoDB' init function returned error.
100403 16:44:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100403 16:44:00 [ERROR] Unknown/unsupported table type: innodb
100403 16:44:00 [ERROR] Aborting

100403 16:44:00 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete

[Harald Sitter (apachelogger)]

From what version did you upgrade and did you upgrade before that already (e.g. did you upgrade from 9.04 to 9.10 and then to 10.04)?

[Ernst Kloppenburg (ernst-kloppenburg)]

yes, I upgraded from 9.04 to 9.10 to 10.04

btw, I made the upgrade only on a copy so I could do tests starting from 9.10 again, if this helps

[Gareth (gmccumskey)]

I am having the same error after a clean install of 10.04 with the same /home partition as I had with 9.10. Are there perhaps configuration setting we need to get rid of to be re-initialised? FYI, I deleted all configs in /home/$USER/.config/akonadi directory and did an apt-get install --reinstall akonadi-server akonadi-kde to see if that fixed it and no go

[tlue (tlueber)]

This solved it for me:
http://userbase.kde.org/Akonadi_4.4/Troubleshooting#Environment_Setup
-> Titel "Kubuntu 10.4 Upgrade"

citation:

  Kubuntu 10.4 Upgrade

This is a summary of other entries here for those upgrading from Kubuntu 9.10 to 10.4 who may have been using a personal package archive (PPA) for KDE 4.3 for bug fixes.

Install missing prerequisites. Remove previous akonadi cache. Start the akonadi service. Install the database. Upgrade the database. Stop and restart the akonadi service.

sudo apt-get install virtuoso-server
sudo apt-get install mysql-server-5.1
rm -r $HOME/.local/share/akonadi
akonadictl start
--tlue: open a second terminal
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
akonadictl stop
--tlue: check if the first terminal is ready again/has stopped
akonadictl start

The mysql_install_db command above will report something like what follows, which you can safely ignore:

Installing MySQL system tables...
100501 18:04:30 [Warning] Can't create test file /home/[userid]/.local/share/akonadi/db_data/[hostname].lower-test

Reference: forum.kde.org Akonadi 1.2.1 - some issues

[Launchpad Janitor (janitor)]

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