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