After the latest KDE upgrade to 4.12.4 I logged on and Akonadi won't start. It is still at 4.4.11.1 and normally runs faultlessly. Now I get
[code]
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths: (".", "/usr/local/sbin", "/usr/local/bin", "/sbin", "/usr/sbin", ".", "/sbin", "/usr/sbin", ".", "/usr/local/sbin", "/usr/local/bin", "/sbin", "/usr/sbin", "/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/games/bin", "/var/spool/fax/bin", "/home/robin/bin", "/usr/local/bin", "/usr/local/sbin", "/usr/games/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
"
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"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x464017]
1: akonadiserver() [0x464272]
/
[code]
So it looks like an SQL problem. I have run myisamchk on the /var/lib/mysql/akonadi and found no problems. How do I reinitialise the the various databases from scratch?

Incidentally, I upgraded a similar system at the same time and its akonadi still runs fine.

TIA

Hi,

this looks like a problem with partial migration. Can you please connect to the MySQL server and run these queries:

USE akonadi;
SHOW TABLES;
SELECT * FROM schemaversiontable;

and paste their output here? Then we can figure out what you have to do so that the DB is consistent and you don't have to wipe the entire database.

mysql> show tables
-> ;
+----------------------------+
| Tables_in_akonadi |
+----------------------------+
| CollectionAttributeTable |
| CollectionMimeTypeRelation |
| CollectionPimItemRelation |
| CollectionTable |
| FlagTable |
| MimeTypeTable |
| PartTable |
| PartTypeTable |
| PimItemFlagRelation |
| PimItemTable |
| ResourceTable |
| SchemaVersionTable |
| TagAttributeTable |
| TagTable |
+----------------------------+
14 rows in set (0.00 sec)
------------------------------------------------------------------------------

akonadictl start:

search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTypeTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking table "TagTable"
checking table "TagAttributeTable"
checking table "TagRemoteIdResourceRelationTable"
"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"
"
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"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x464fd7]
1: akonadiserver() [0x465232]
2: /lib64/libc.so.6(+0x352e0) [0x7fc1c0b8e2e0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fc1c0b8e269]
4: /lib64/libc.so.6(abort+0x148) [0x7fc1c0b8f5c8]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fc1c26637d4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x4670ad]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7fc1c26fc934]
8: /usr/lib64/qt4/libQtCore.so.4(+0x11b5df) [0x7fc1c27075df]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fc1c270fb6b]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5eb) [0x46aa1b]
11: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x26e) [0x7fc1c278294e]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8e) [0x7fc1c276905e]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x361) [0x7fc1c276c671]
14: /usr/lib64/qt4/libQtCore.so.4(+0x1ab313) [0x7fc1c2797313]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fc1c066dbc6]
16: /usr/lib64/libglib-2.0.so.0(+0x47f18) [0x7fc1c066df18]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc1c066dfbc]
18: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x66) [0x7fc1c27974a6]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fc1c2767d0f]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x138) [0x7fc1c2767f98]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x88) [0x7fc1c276d1d8]
22: akonadiserver(main+0x1bf) [0x45f7ef]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fc1c0b7aa65]
24: akonadiserver() [0x45ff68]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTypeTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking table "TagTable"
checking table "TagAttributeTable"
checking table "TagRemoteIdResourceRelationTable"
"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"
"
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"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x464fd7]
1: akonadiserver() [0x465232]
2: /lib64/libc.so.6(+0x352e0) [0x7fc60dd972e0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fc60dd97269]
4: /lib64/libc.so.6(abort+0x148) [0x7fc60dd985c8]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fc60f86c7d4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x4670ad]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7fc60f905934]
8: /usr/lib64/qt4/libQtCore.so.4(+0x11b5df) [0x7fc60f9105df]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fc60f918b6b]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5eb) [0x46aa1b]
11: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x26e) [0x7fc60f98b94e]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8e) [0x7fc60f97205e]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x361) [0x7fc60f975671]
14: /usr/lib64/qt4/libQtCore.so.4(+0x1ab313) [0x7fc60f9a0313]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fc60d876bc6]
16: /usr/lib64/libglib-2.0.so.0(+0x47f18) [0x7fc60d876f18]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc60d876fbc]
18: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x66) [0x7fc60f9a04a6]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fc60f970d0f]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x138) [0x7fc60f970f98]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x88) [0x7fc60f9761d8]
22: akonadiserver(main+0x1bf) [0x45f7ef]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fc60dd83a65]
24: akonadiserver() [0x45ff68]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTypeTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking table "TagTable"
checking table "TagAttributeTable"
checking table "TagRemoteIdResourceRelationTable"
"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"
"
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"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x464fd7]
1: akonadiserver() [0x465232]
2: /lib64/libc.so.6(+0x352e0) [0x7f10c9de92e0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f10c9de9269]
4: /lib64/libc.so.6(abort+0x148) [0x7f10c9dea5c8]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f10cb8be7d4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x4670ad]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f10cb957934]
8: /usr/lib64/qt4/libQtCore.so.4(+0x11b5df) [0x7f10cb9625df]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f10cb96ab6b]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5eb) [0x46aa1b]
11: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x26e) [0x7f10cb9dd94e]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8e) [0x7f10cb9c405e]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x361) [0x7f10cb9c7671]
14: /usr/lib64/qt4/libQtCore.so.4(+0x1ab313) [0x7f10cb9f2313]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7f10c98c8bc6]
16: /usr/lib64/libglib-2.0.so.0(+0x47f18) [0x7f10c98c8f18]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f10c98c8fbc]
18: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x66) [0x7f10cb9f24a6]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f10cb9c2d0f]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x138) [0x7f10cb9c2f98]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x88) [0x7f10cb9c81d8]
22: akonadiserver(main+0x1bf) [0x45f7ef]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f10c9dd5a65]
24: akonadiserver() [0x45ff68]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.2", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table "SchemaVersionTable"
checking table "ResourceTable"
checking table "CollectionTable"
checking table "MimeTypeTable"
checking table "PimItemTable"
checking table "FlagTable"
checking table "PartTypeTable"
checking table "PartTable"
checking table "CollectionAttributeTable"
checking table "TagTable"
checking table "TagAttributeTable"
checking table "TagRemoteIdResourceRelationTable"
"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"
"
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"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x464fd7]
1: akonadiserver() [0x465232]
2: /lib64/libc.so.6(+0x352e0) [0x7fda487f02e0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fda487f0269]
4: /lib64/libc.so.6(abort+0x148) [0x7fda487f15c8]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7fda4a2c57d4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x4670ad]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7fda4a35e934]
8: /usr/lib64/qt4/libQtCore.so.4(+0x11b5df) [0x7fda4a3695df]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fda4a371b6b]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5eb) [0x46aa1b]
11: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x26e) [0x7fda4a3e494e]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8e) [0x7fda4a3cb05e]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x361) [0x7fda4a3ce671]
14: /usr/lib64/qt4/libQtCore.so.4(+0x1ab313) [0x7fda4a3f9313]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fda482cfbc6]
16: /usr/lib64/libglib-2.0.so.0(+0x47f18) [0x7fda482cff18]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fda482cffbc]
18: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x66) [0x7fda4a3f94a6]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fda4a3c9d0f]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x138) [0x7fda4a3c9f98]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x88) [0x7fda4a3cf1d8]
22: akonadiserver(main+0x1bf) [0x45f7ef]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fda487dca65]
24: akonadiserver() [0x45ff68]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
c^C

Sorry for the delay, I was travelling. From MySQL

Code: Select all

mysql> SHOW TABLES;
+----------------------------+
| Tables_in_akonadi          |
+----------------------------+
| CollectionAttributeTable   |
| CollectionMimeTypeRelation |
| CollectionPimItemRelation  |
| CollectionTable            |
| FlagTable                  |
| MimeTypeTable              |
| PartTable                  |
| PartTypeTable              |
| PimItemFlagRelation        |
| PimItemTable               |
| ResourceTable              |
| SchemaVersionTable         |
| TagAttributeTable          |
| TagTable                   |                                                                                   
+----------------------------+                                                                                   
14 rows in set (0.00 sec)                                                                                         
                                                                                                                 
mysql> SELECT * FROM schemaversiontable;                                                                         
ERROR 1146 (42S02): Table 'akonadi.schemaversiontable' doesn't exist                                             
mysql>


I don't believe this is an isue with migration. I am getting the exact same error. However, in my case I am setting up an external MySQL database for the first time. Akonadi will start if I check the box to use the internal server, but it refuses to start when trying to use an external MySQL database. I'm using MariaDB 5.5.36 and KDE 4.12.4.

I "solved" the problem by dropping the akonadi database in MySQL. Then Akonadi rebuilt it and starts OK; I didn't lose any data. But now there is a new problem after installing KDE 4.13.0, KMail segfaults on start-up. It is hard on two systems. I think KDEPIM 4.4 is at the end of its life.

Please open a new thread on your issue: I would also suggest to post a bug with full backtrace on bugs.kde.org.

Nevermind, I see that you already did so.