https://bugs.kde.org/show_bug.cgi?id=334420
--- Comment #1 from Peter Fodrek <[email protected]> --- I am to provide additiona informtaion when starting akonadi . It starts migration assistant and it returned 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-ea8_18`, CONSTRAINT `#sql-ea8_18_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(_Z11akBacktracev+0x37) [0x468267] 1: akonadiserver() [0x4684c2] 2: /lib64/libc.so.6(+0x358d0) [0x7f53c1e518d0] 3: /lib64/libc.so.6(gsignal+0x39) [0x7f53c1e51849] 4: /lib64/libc.so.6(abort+0x148) [0x7f53c1e52cd8] 5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f53c3656204] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x46a67d] 7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7f53c36f0830] 8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7f53c36fdc2d] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7f53c3706813] 10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x46e09a] 11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f53c377811e] 12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f53c37600ad] 13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7f53c37630ff] 14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7f53c378d493] 15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7f53c152c316] 16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7f53c152c668] 17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f53c152c70c] 18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7f53c378cd55] 19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f53c375ed0f] 20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f53c375f005] 21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7f53c376413b] 22: akonadiserver(main+0x1bf) [0x461c6f] 23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f53c1e3dbe5] 24: akonadiserver() [0x4623a9] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) "akonadiserver" crashed too often and will not be restarted! It may be solved via database update with akonadi related command, but I am no so familiar with SQL to determine which one is correct -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list [email protected] https://mail.kde.org/mailman/listinfo/kdepim-bugs
