Reply to topic

Akonadi MySQL errors

User avatar binro
Registered Member
Posts
11
Karma
0

Akonadi MySQL errors

Sun Apr 06, 2014 8:44 am
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
User avatar progdan
KDE Developer
Posts
54
Karma
0
OS

Re: Akonadi MySQL errors

Tue Apr 08, 2014 2:32 pm
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.
akolbasenko
Registered Member
Posts
1
Karma
0

Re: Akonadi MySQL errors

Wed Apr 09, 2014 9:40 am
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
User avatar binro
Registered Member
Posts
11
Karma
0

Re: Akonadi MySQL errors

Sun Apr 13, 2014 11:49 am
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>
PaddyMac
Registered Member
Posts
1
Karma
0

Re: Akonadi MySQL errors

Fri Apr 18, 2014 11:06 pm
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.
User avatar binro
Registered Member
Posts
11
Karma
0

Re: Akonadi MySQL errors

Sat Apr 19, 2014 9:56 am
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. :(
User avatar einar
Administrator
Posts
2788
Karma
5
OS

Re: Akonadi MySQL errors

Sat Apr 19, 2014 2:03 pm
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.


"Violence is the last refuge of the incompetent."
Image
Plasma FAQ maintainer - Plasma programming with Python

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], baroi, Bing [Bot], brochard, davidemme, dpagoto, Exabot [Bot], Google [Bot], google01103, Mamarok, metzman, myrjola, paviluf, Steve Guilford