[Akonadi] [Bug 334420] Different behavior when starting mysqld via command line and crash/do not start after doing same via akonadi

Peter Fodrek peter.fodrek at stuba.sk
Fri May 9 12:45:49 BST 2014


https://bugs.kde.org/show_bug.cgi?id=334420

--- Comment #1 from Peter  Fodrek <peter.fodrek at stuba.sk> ---
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.



More information about the Kdepim-bugs mailing list