Hi ! (sorry for my bad english) it'sn't solved forum after upgrade 4.12 to 4.13. these is the konsole result : jajax@portable:~$ akonadictl start Starting Akonadi Server... done. Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) jajax@portable:~$ search paths: ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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: "/usr/bin/mysql_install_db" Found mysqlcheck: "/usr/bin/mysqlcheck" akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK MySQL version OK (required "5.1" , available "5.5" ) 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" checking table "PimItemFlagRelation" checking table "PimItemTagRelation" checking table "CollectionMimeTypeRelation" checking table "CollectionPimItemRelation" DbInitializer::run() done skipping update 2 skipping update 3 skipping update 4 skipping update 8 skipping update 10 skipping update 12 skipping update 13 skipping update 14 skipping update 15 skipping update 16 skipping update 17 skipping update 18 skipping update 19 skipping update 20 skipping update 21 skipping update 22 skipping update 23 skipping update 24 skipping update 25 skipping update 26 Adding new foreign key constraints "ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" Updating index failed: Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_1b`, CONSTRAINT `#sql-a49_1b_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE "" Unable to initialize database. "[ 0: akonadiserver() [0x805d455] 1: akonadiserver() [0x805d6e1] 2: [0xb76fc400] 3: [0xb76fc424] 4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6d99aff] 5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6d9d083] 6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb7448d53] 7: akonadiserver() [0x805f524] 8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb74ed488] 9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb74fd84e] 10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7506f45] 11: akonadiserver() [0x8062da2] 12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb757789a] 13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb757f6eb] 14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb7566030] 15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7566094] 16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7565e3a] 17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75696fd] 18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb7569c0c] 19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb75961de] 20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6c7283e] 21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6c72be8] 22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6c72ca8] 23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75959cf] 24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7564813] 25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7564b39] 26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb756a8ee] 27: akonadiserver() [0x8057849] 28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6d84905] 29: akonadiserver() [0x8058372] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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: "/usr/bin/mysql_install_db" Found mysqlcheck: "/usr/bin/mysqlcheck" akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK MySQL version OK (required "5.1" , available "5.5" ) 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" checking table "PimItemFlagRelation" checking table "PimItemTagRelation" checking table "CollectionMimeTypeRelation" checking table "CollectionPimItemRelation" DbInitializer::run() done skipping update 2 skipping update 3 skipping update 4 skipping update 8 skipping update 10 skipping update 12 skipping update 13 skipping update 14 skipping update 15 skipping update 16 skipping update 17 skipping update 18 skipping update 19 skipping update 20 skipping update 21 skipping update 22 skipping update 23 skipping update 24 skipping update 25 skipping update 26 Adding new foreign key constraints "ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" Updating index failed: Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_1e`, CONSTRAINT `#sql-a49_1e_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE "" Unable to initialize database. "[ 0: akonadiserver() [0x805d455] 1: akonadiserver() [0x805d6e1] 2: [0xb777d400] 3: [0xb777d424] 4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e1aaff] 5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e1e083] 6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74c9d53] 7: akonadiserver() [0x805f524] 8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb756e488] 9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb757e84e] 10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7587f45] 11: akonadiserver() [0x8062da2] 12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75f889a] 13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb76006eb] 14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75e7030] 15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75e7094] 16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75e6e3a] 17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75ea6fd] 18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75eac0c] 19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76171de] 20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cf383e] 21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6cf3be8] 22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cf3ca8] 23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76169cf] 24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75e5813] 25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75e5b39] 26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75eb8ee] 27: akonadiserver() [0x8057849] 28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e05905] 29: akonadiserver() [0x8058372] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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: "/usr/bin/mysql_install_db" Found mysqlcheck: "/usr/bin/mysqlcheck" akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK MySQL version OK (required "5.1" , available "5.5" ) 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" checking table "PimItemFlagRelation" checking table "PimItemTagRelation" checking table "CollectionMimeTypeRelation" checking table "CollectionPimItemRelation" DbInitializer::run() done skipping update 2 skipping update 3 skipping update 4 skipping update 8 skipping update 10 skipping update 12 skipping update 13 skipping update 14 skipping update 15 skipping update 16 skipping update 17 skipping update 18 skipping update 19 skipping update 20 skipping update 21 skipping update 22 skipping update 23 skipping update 24 skipping update 25 skipping update 26 Adding new foreign key constraints "ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" Updating index failed: Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_21`, CONSTRAINT `#sql-a49_21_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE "" Unable to initialize database. "[ 0: akonadiserver() [0x805d455] 1: akonadiserver() [0x805d6e1] 2: [0xb779f400] 3: [0xb779f424] 4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e3caff] 5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e40083] 6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74ebd53] 7: akonadiserver() [0x805f524] 8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7590488] 9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb75a084e] 10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb75a9f45] 11: akonadiserver() [0x8062da2] 12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb761a89a] 13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb76226eb] 14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb7609030] 15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7609094] 16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7608e3a] 17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb760c6fd] 18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb760cc0c] 19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76391de] 20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6d1583e] 21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6d15be8] 22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6d15ca8] 23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76389cf] 24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7607813] 25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7607b39] 26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb760d8ee] 27: akonadiserver() [0x8057849] 28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e27905] 29: akonadiserver() [0x8058372] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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: "/usr/bin/mysql_install_db" Found mysqlcheck: "/usr/bin/mysqlcheck" akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK MySQL version OK (required "5.1" , available "5.5" ) 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" checking table "PimItemFlagRelation" checking table "PimItemTagRelation" checking table "CollectionMimeTypeRelation" checking table "CollectionPimItemRelation" DbInitializer::run() done skipping update 2 skipping update 3 skipping update 4 skipping update 8 skipping update 10 skipping update 12 skipping update 13 skipping update 14 skipping update 15 skipping update 16 skipping update 17 skipping update 18 skipping update 19 skipping update 20 skipping update 21 skipping update 22 skipping update 23 skipping update 24 skipping update 25 skipping update 26 Adding new foreign key constraints "ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" Updating index failed: Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_24`, CONSTRAINT `#sql-a49_24_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE "" Unable to initialize database. "[ 0: akonadiserver() [0x805d455] 1: akonadiserver() [0x805d6e1] 2: [0xb7785400] 3: [0xb7785424] 4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e22aff] 5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e26083] 6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74d1d53] 7: akonadiserver() [0x805f524] 8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7576488] 9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb758684e] 10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb758ff45] 11: akonadiserver() [0x8062da2] 12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb760089a] 13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb76086eb] 14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75ef030] 15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75ef094] 16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75eee3a] 17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75f26fd] 18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75f2c0c] 19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb761f1de] 20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cfb83e] 21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6cfbbe8] 22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cfbca8] 23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb761e9cf] 24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75ed813] 25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75edb39] 26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75f38ee] 27: akonadiserver() [0x8057849] 28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e0d905] 29: akonadiserver() [0x8058372] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) "akonadiserver" crashed too often and will not be restarted! help please ! note : If I must create a new bug report, say me ;)