| 1 |
After the latest KDE upgrade to 4.12.4 I logged on and Akonadi won't |
| 2 |
start. It is still at 4.4.11.1 and normally runs faultlessly. Now I get |
| 3 |
|
| 4 |
$ akonadictl start |
| 5 |
Starting Akonadi Server... |
| 6 |
done. |
| 7 |
Connecting to deprecated signal |
| 8 |
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) |
| 9 |
search paths: (".", "/usr/local/sbin", |
| 10 |
"/usr/local/bin", "/sbin", "/usr/sbin", ".", "/sbin", "/usr/sbin", ".", |
| 11 |
"/usr/local/sbin", "/usr/local/bin", "/sbin", "/usr/sbin", |
| 12 |
"/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", |
| 13 |
"/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/games/bin", |
| 14 |
"/var/spool/fax/bin", "/home/robin/bin", "/usr/local/bin", |
| 15 |
"/usr/local/sbin", "/usr/games/bin", "/usr/sbin", "/usr/local/sbin", |
| 16 |
"/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", |
| 17 |
"/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") |
| 18 |
Found mysql_install_db: "" |
| 19 |
Found mysqlcheck: "/usr/bin/mysqlcheck" |
| 20 |
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is |
| 21 |
still in use, all queries will cease to work. |
| 22 |
Database "akonadi" opened |
| 23 |
using driver "QMYSQL" |
| 24 |
DbInitializer::run() |
| 25 |
checking table |
| 26 |
"SchemaVersionTable" checking table "ResourceTable" checking table |
| 27 |
"CollectionTable" checking table "MimeTypeTable" checking table |
| 28 |
"PimItemTable" checking table "FlagTable" checking table |
| 29 |
"PartTypeTable" checking table "PartTable" checking table |
| 30 |
"CollectionAttributeTable" checking table "TagTable" checking table |
| 31 |
"TagAttributeTable" checking table "TagRemoteIdResourceRelationTable" |
| 32 |
|
| 33 |
"CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, |
| 34 |
resourceId BIGINT NOT NULL, remoteId VARBINARY(255) NOT NULL, FOREIGN |
| 35 |
KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE |
| 36 |
CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON |
| 37 |
UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT |
| 38 |
CHARSET=utf8" " |
| 39 |
|
| 40 |
Sql error: Can't create table |
| 41 |
'akonadi.TagRemoteIdResourceRelationTable' (errno: 150) QMYSQL: Unable |
| 42 |
to execute query Query: CREATE TABLE TagRemoteIdResourceRelationTable |
| 43 |
(tagId BIGINT NOT NULL, resourceId BIGINT NOT NULL, remoteId |
| 44 |
VARBINARY(255) NOT NULL, FOREIGN KEY (tagId) REFERENCES TagTable(id) ON |
| 45 |
UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (resourceId) REFERENCES |
| 46 |
ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE) |
| 47 |
COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" Unable to initialize |
| 48 |
database. |
| 49 |
|
| 50 |
|
| 51 |
|
| 52 |
So it looks like an SQL problem. I have run myisamchk on |
| 53 |
the /var/lib/mysql/akonadi and found no problems. How do I reinitialise |
| 54 |
the various databases from scratch? |
| 55 |
|
| 56 |
Incidentally, I upgraded a similar system at the same time and its |
| 57 |
akonadi still runs fine. |
| 58 |
|
| 59 |
TIA |
| 60 |
Robin |
Archives