| Summary: | Different behavior when starting mysqld via command line and crash/do not start after doing same via akonadi | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Peter Fodrek <peter.fodrek> |
| Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED UNMAINTAINED | ||
| Severity: | critical | CC: | kdenis |
| Priority: | NOR | ||
| Version: | 4.13 | ||
| Target Milestone: | --- | ||
| Platform: | openSUSE | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Peter Fodrek
2014-05-06 14:58:19 UTC
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 /usr/bin/mysqlcheck --defaults-file=/home/peto/.local/share/akonadi/mysql.conf --socket=/tmp/akonadi-petoMOJ/mysql.socket -vc -A Processing databases information_schema akonadi 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 mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func 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.proxies_priv OK mysql.servers 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 performance_schema test but usr/bin/mysqlcheck --defaults-file=/home/peto/.local/share/akonadi/mysql.conf --socket=/tmp/akonadi-petoMOJ/mysql.socket -vr -A Processing databases information_schema akonadi akonadi.collectionattributetable note : The storage engine for the table doesn't support repair akonadi.collectionmimetyperelation note : The storage engine for the table doesn't support repair akonadi.collectionpimitemrelation note : The storage engine for the table doesn't support repair akonadi.collectiontable note : The storage engine for the table doesn't support repair akonadi.flagtable note : The storage engine for the table doesn't support repair akonadi.mimetypetable note : The storage engine for the table doesn't support repair akonadi.parttable note : The storage engine for the table doesn't support repair akonadi.parttypetable note : The storage engine for the table doesn't support repair akonadi.pimitemflagrelation note : The storage engine for the table doesn't support repair akonadi.pimitemtable note : The storage engine for the table doesn't support repair akonadi.pimitemtagrelation note : The storage engine for the table doesn't support repair akonadi.resourcetable note : The storage engine for the table doesn't support repair akonadi.schemaversiontable note : The storage engine for the table doesn't support repair akonadi.tagattributetable note : The storage engine for the table doesn't support repair akonadi.tagremoteidresourcerelationtable note : The storage engine for the table doesn't support repair akonadi.tagtable note : The storage engine for the table doesn't support repair mysql mysql.columns_priv OK This bug has only been reported for versions older than KDEPIM 4.14 (at most akonadi-1.3). Can anyone tell if this bug still present? If noone confirms this bug for a recent version of akonadi (part of KDE Applications 15.08 or later), it gets closed in about three months. Just as announced in my last comment, I close this bug. If you encounter it again in a recent version (at least 5.0 aka 15.08), please open a new one unless it already exists. Thank you for all your input. |