| Summary: | Akonadi server doesn't start (internal Mysql backend) | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Hatl <hatl> |
| Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | dvratil |
| Priority: | NOR | ||
| Version: | 1.12.1 | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: |
mysqld.conf
akonadiserverrc |
||
|
Description
Hatl
2014-04-22 18:56:01 UTC
Created attachment 86216 [details]
mysqld.conf
Created attachment 86217 [details]
akonadiserverrc
I already tried killing all mysqld processes and restarting akonadi. Also tried to remove the mysqld.conf. Looks like a MySQL issue. Please check that you haven't run out of disk space, make sure that file ~/.local/share/akonadi/db_data/ibdata1 (and all other files in that directory) are owned by your user and group and have at least -rw-rw--- rights and that the directory itself is writeable.
Finally, try the following:
cp ~/.local/share/akonadi/db_data/ibdata1{,.backup}
mv ~/.local/share/akonadi/db_data/ibdata1{,.mv}
cp -a ~/.local/share/akonadi/db_data/ibdata1{.mv,}
(Found on the internet, reported by users to solve the "can't get ibdata1 lock" problem.
Thanks for your reply! There is plenty of disk space left (13GB) The file premissions are: -rw-rw--- The mv/cp didn't help. I also ruled out AppArmor: 3 processes are in complain mode. /usr/sbin/mysqld (1596) /usr/sbin/mysqld (5612) /usr/sbin/mysqld (5638) Ubuntu just got an update from mysql 5.5.35 to 5.5.37. Didn't change anything. Others got the same problem: https://forum.kde.org/viewtopic.php?f=215&t=120510 http://www.gossamer-threads.com/lists/gentoo/user/286323?page=last https://bugzilla.altlinux.org/show_bug.cgi?id=29926 I don't think that this is a mysql problem. Sql error: Can't create table 'akonadi.tagremoteidresourcerelationtable' (errno: 150) QMYSQL: Unable to execute query Query: CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, resourceId BIGINT NOT NULL, remoteId VARBINARY(255) NOT NULL, FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" The query works when I remove FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE ResourceTable exists (show create table ResourceTable;) CREATE TABLE `resourcetable` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varbinary(255) DEFAULT NULL, `isVirtual` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `name_2` (`name`), UNIQUE KEY `name_3` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 myisamchk can't find any errors. Hmm, there's the problem. You are running on MyISAM, which is not a supported configuration (I'm not sure if it was in the past, but I doubt it). I'm not sure how that could happened. Anyway, Akonadi requires InnoDB, because it depends on FOREIGN KEYS to function properly. I recommend converting all tables to InnoDB manually, then restarting Akonadi. It should automatically create all missing indexes and foreign keys. Thank you very much! That worked! I'm using akonadi since the very beginning. Maybe the default was changed at some point... |