| Summary: | akonadiserver start problem after 4.12 to 4.13 update | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | jajaX <jajaxor> |
| Component: | server | Assignee: | kdepim bugs <pim-bugs-null> |
| Status: | RESOLVED NOT A BUG | ||
| Severity: | normal | CC: | dvratil, hir.i.mogul |
| Priority: | NOR | ||
| Version First Reported In: | 4.13 | ||
| Target Milestone: | --- | ||
| Platform: | Kubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
Your problem is that you are missing some constraints in the database, which caused the database to contain invalid data. Akonadi depends on those constraints to keep all data valid. Not sure how you came to not having them, but we need to first clean up the invalid data manually before Akonadi can create those foreign key constraints. 1) Start the MySQL database manually (on your distribution mysqld might be located elsewhere): /usr/libexec/mysqld --defaults-file=$HOME/.local/share/akonadi/mysql.conf --datadir=$HOME/.local/share/akonadi/db_data/ --socket=/tmp/akonadimysql.socket 2) Connect to it (from another terminal): mysql --socket=/tmp/akonadimysql.socket 3) Check whether you are using the correct database engine: SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA='akonadi'; This should return ~15 records, in format "table name | engine " where "engine" should always be "InnoDB". If "engine" is "MyISAM", run the query in step 4) for each such table, otherwise skip to step 5). 4) Convert table to InnoDB (replace "tableName" in the query with actual table name): ALTER TABLE akonadi.tableName ENGINE = InnoDB; 5) Select the database USE akonadi; 6) Remove invalid data DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT id FROM CollectionTable) AND parentId IS NOT NULL; This should print something like "X Rows affected", check whether X > 0. 7) Stop the MySQL server mysqladmin --socket=/tmp/akonadimysql.socket shutdown (or just send SIGTERM the mysqld) 8) Start Akonadi akonadictl start Akonadi will now be able to create the foreign key constraint. If you were missing the key constraints in more places, it's possible that there will be more invalid data in other tables that need to be cleaned up in similar way, so the startup might fail again. In such case please paste the full output again and we will continue :-) I'll close this as invalid, since it's not really a bug in Akonadi, but feel free to paste the Akonadi output here if there's a problem again. Hi (sorry for my bad english) big thanks for your help and answer ;) step 6 don't work => mysql> SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA='akonadi'; +----------------------------------+--------+ | TABLE_NAME | ENGINE | +----------------------------------+--------+ | collectionattributetable | InnoDB | | collectionmimetyperelation | InnoDB | | collectionpimitemrelation | InnoDB | | collectiontable | InnoDB | | flagtable | InnoDB | | mimetypetable | InnoDB | | parttable | InnoDB | | parttypetable | InnoDB | | pimitemflagrelation | InnoDB | | pimitemtable | InnoDB | | pimitemtagrelation | InnoDB | | resourcetable | InnoDB | | schemaversiontable | InnoDB | | tagattributetable | InnoDB | | tagremoteidresourcerelationtable | InnoDB | | tagtable | InnoDB | +----------------------------------+--------+ 16 rows in set (0.00 sec) mysql> USE akonadi; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT id FROM CollectionTable) AND parentId IS NOT NULL; ERROR 1093 (HY000): You can't specify target table 'CollectionTable' for update in FROM clause one idea ? Oh, stupid MySQL :-) This hack should work: DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable)) AND parentId IS NOT NULL; Sorry, I tested only with PostgreSQL, where DELETE FROM..SELECT FROM on the same table works. Hi ! new error message : mysql> USE akonadi; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable)) AND parentId IS NOT NULL; ERROR 1248 (42000): Every derived table must have its own alias Try this please (sorry, I don't have MySQL DB with Akonadi database in it to test the queries at the moment) DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable) AS tableA) AND parentId IS NOT NULL; Hi !
it's better but akonadi dont start again :
mysql> USE akonadi;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable) AS tableA) AND parentId IS NOT NULL;
Query OK, 1 row affected (0.05 sec)
mysql> quit
Bye
jajax@portable:~$ mysqladmin --socket=/tmp/akonadi-jajax.lR117e/mysql.socket shutdown
jajax@portable:~$ akonadictl start
Starting Akonadi Server...
done.
jajax@portable:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
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-112a_3`, CONSTRAINT `#sql-112a_3_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: [0xb76ee400]
3: [0xb76ee424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6d8baff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6d8f083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb743ad53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb74df488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb74ef84e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb74f8f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb756989a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75716eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb7558030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7558094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7557e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb755b6fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb755bc0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb75881de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6c6483e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6c64be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6c64ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75879cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7556813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7556b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb755c8ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6d76905]
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-112a_6`, CONSTRAINT `#sql-112a_6_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: [0xb777c400]
3: [0xb777c424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e19aff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e1d083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74c8d53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb756d488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb757d84e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7586f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75f789a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75ff6eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75e6030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75e6094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75e5e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75e96fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75e9c0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76161de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cf283e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6cf2be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cf2ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76159cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75e4813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75e4b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75ea8ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e04905]
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-112a_9`, CONSTRAINT `#sql-112a_9_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: [0xb778b400]
3: [0xb778b424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e28aff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e2c083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74d7d53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb757c488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb758c84e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7595f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb760689a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb760e6eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75f5030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75f5094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75f4e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75f86fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75f8c0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76251de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6d0183e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6d01be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6d01ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76249cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75f3813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75f3b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75f98ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e13905]
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-112a_c`, CONSTRAINT `#sql-112a_c_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: [0xb772c400]
3: [0xb772c424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6dc9aff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6dcd083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb7478d53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb751d488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb752d84e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7536f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75a789a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75af6eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb7596030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7596094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7595e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75996fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb7599c0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb75c61de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6ca283e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6ca2be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6ca2ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75c59cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7594813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7594b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb759a8ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6db4905]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
Same problem after upgrading from KDE 4.12.3 to 4.13.0 witch enabled backports in Kubuntu 12.04.4.
***@***-mobile:~$ akonadictl start
Starting Akonadi Server...
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
done.
***@***-mobile:~$ search paths: ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/home/***/android-sdk-linux/tools", "/home/***/android-sdk-linux/platform-tools", "/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.parttable_new 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.proxies_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.*** 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
DbUpdater: update to version: 25 mandatory: true
Starting database update to version 25
Creating a PartTable_new
Migrating part types
Moved part type "ATR:AddressAttribute" to PartTypeTable
Moved part type "ATR:DispatchModeAttribute" to PartTypeTable
Moved part type "ATR:MDNStateAttribute" to PartTypeTable
Moved part type "ATR:ScamAttribute" to PartTypeTable
Moved part type "ATR:SentActionAttribute" to PartTypeTable
Moved part type "ATR:SentBehaviourAttribute" to PartTypeTable
Moved part type "ATR:TransportAttribute" to PartTypeTable
Moved part type "ATR:contactmetadata" to PartTypeTable
DATABASE ERROR:
Error code: 1048
DB error: "Column 'name' cannot be null"
Error text: "Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Query: "INSERT INTO PartTypeTable (ns, name) VALUES (:0, :1)"
"Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver() [0x419d55]
1: akonadiserver() [0x41a00c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x364a0) [0x7f5f66f244a0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f5f66f24425]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f5f66f27b8b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f5f68a085db]
6: akonadiserver() [0x41c142]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f5f68aa4e4f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x119412) [0x7f5f68ab0412]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f5f68ab92a9]
10: akonadiserver() [0x41ec66]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x366) [0x7f5f68b2b946]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8c) [0x7f5f68b1232c]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x46a) [0x7f5f68b1610a]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aa493) [0x7f5f68b41493]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x133) [0x7f5f66400d13]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x48060) [0x7f5f66401060]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x34) [0x7f5f66401124]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6f) [0x7f5f68b418bf]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x32) [0x7f5f68b10e62]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0xf7) [0x7f5f68b110b7]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x87) [0x7f5f68b16407]
22: akonadiserver() [0x414295]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f5f66f0f76d]
24: akonadiserver() [0x414c11]
]
"
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", "/home/***/android-sdk-linux/tools", "/home/***/android-sdk-linux/platform-tools", "/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.parttable_new 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.proxies_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.*** 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
DbUpdater: update to version: 25 mandatory: true
Starting database update to version 25
Creating a PartTable_new
Migrating part types
Moved part type "ATR:AddressAttribute" to PartTypeTable
Moved part type "ATR:DispatchModeAttribute" to PartTypeTable
Moved part type "ATR:MDNStateAttribute" to PartTypeTable
Moved part type "ATR:ScamAttribute" to PartTypeTable
Moved part type "ATR:SentActionAttribute" to PartTypeTable
Moved part type "ATR:SentBehaviourAttribute" to PartTypeTable
Moved part type "ATR:TransportAttribute" to PartTypeTable
Moved part type "ATR:contactmetadata" to PartTypeTable
DATABASE ERROR:
Error code: 1048
DB error: "Column 'name' cannot be null"
Error text: "Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Query: "INSERT INTO PartTypeTable (ns, name) VALUES (:0, :1)"
"Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver() [0x419d55]
1: akonadiserver() [0x41a00c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x364a0) [0x7f573108e4a0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f573108e425]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f5731091b8b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f5732b725db]
6: akonadiserver() [0x41c142]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f5732c0ee4f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x119412) [0x7f5732c1a412]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f5732c232a9]
10: akonadiserver() [0x41ec66]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x366) [0x7f5732c95946]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8c) [0x7f5732c7c32c]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x46a) [0x7f5732c8010a]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aa493) [0x7f5732cab493]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x133) [0x7f573056ad13]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x48060) [0x7f573056b060]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x34) [0x7f573056b124]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6f) [0x7f5732cab8bf]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x32) [0x7f5732c7ae62]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0xf7) [0x7f5732c7b0b7]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x87) [0x7f5732c80407]
22: akonadiserver() [0x414295]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f573107976d]
24: akonadiserver() [0x414c11]
]
"
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", "/home/***/android-sdk-linux/tools", "/home/***/android-sdk-linux/platform-tools", "/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.parttable_new 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.proxies_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.*** 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
DbUpdater: update to version: 25 mandatory: true
Starting database update to version 25
Creating a PartTable_new
Migrating part types
Moved part type "ATR:AddressAttribute" to PartTypeTable
Moved part type "ATR:DispatchModeAttribute" to PartTypeTable
Moved part type "ATR:MDNStateAttribute" to PartTypeTable
Moved part type "ATR:ScamAttribute" to PartTypeTable
Moved part type "ATR:SentActionAttribute" to PartTypeTable
Moved part type "ATR:SentBehaviourAttribute" to PartTypeTable
Moved part type "ATR:TransportAttribute" to PartTypeTable
Moved part type "ATR:contactmetadata" to PartTypeTable
DATABASE ERROR:
Error code: 1048
DB error: "Column 'name' cannot be null"
Error text: "Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Query: "INSERT INTO PartTypeTable (ns, name) VALUES (:0, :1)"
"Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver() [0x419d55]
1: akonadiserver() [0x41a00c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x364a0) [0x7f5c233104a0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f5c23310425]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f5c23313b8b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f5c24df45db]
6: akonadiserver() [0x41c142]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f5c24e90e4f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x119412) [0x7f5c24e9c412]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f5c24ea52a9]
10: akonadiserver() [0x41ec66]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x366) [0x7f5c24f17946]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8c) [0x7f5c24efe32c]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x46a) [0x7f5c24f0210a]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aa493) [0x7f5c24f2d493]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x133) [0x7f5c227ecd13]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x48060) [0x7f5c227ed060]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x34) [0x7f5c227ed124]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6f) [0x7f5c24f2d8bf]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x32) [0x7f5c24efce62]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0xf7) [0x7f5c24efd0b7]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x87) [0x7f5c24f02407]
22: akonadiserver() [0x414295]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f5c232fb76d]
24: akonadiserver() [0x414c11]
]
"
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", "/home/***/android-sdk-linux/tools", "/home/***/android-sdk-linux/platform-tools", "/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.parttable_new 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.proxies_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.*** 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
DbUpdater: update to version: 25 mandatory: true
Starting database update to version 25
Creating a PartTable_new
Migrating part types
Moved part type "ATR:AddressAttribute" to PartTypeTable
Moved part type "ATR:DispatchModeAttribute" to PartTypeTable
Moved part type "ATR:MDNStateAttribute" to PartTypeTable
Moved part type "ATR:ScamAttribute" to PartTypeTable
Moved part type "ATR:SentActionAttribute" to PartTypeTable
Moved part type "ATR:SentBehaviourAttribute" to PartTypeTable
Moved part type "ATR:TransportAttribute" to PartTypeTable
Moved part type "ATR:contactmetadata" to PartTypeTable
DATABASE ERROR:
Error code: 1048
DB error: "Column 'name' cannot be null"
Error text: "Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Query: "INSERT INTO PartTypeTable (ns, name) VALUES (:0, :1)"
"Column 'name' cannot be null QMYSQL3: Unable to execute statement"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver() [0x419d55]
1: akonadiserver() [0x41a00c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x364a0) [0x7f5bfee0a4a0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f5bfee0a425]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f5bfee0db8b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f5c008ee5db]
6: akonadiserver() [0x41c142]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f5c0098ae4f]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x119412) [0x7f5c00996412]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f5c0099f2a9]
10: akonadiserver() [0x41ec66]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x366) [0x7f5c00a11946]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8c) [0x7f5c009f832c]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x46a) [0x7f5c009fc10a]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aa493) [0x7f5c00a27493]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x133) [0x7f5bfe2e6d13]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x48060) [0x7f5bfe2e7060]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x34) [0x7f5bfe2e7124]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6f) [0x7f5c00a278bf]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x32) [0x7f5c009f6e62]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0xf7) [0x7f5c009f70b7]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x87) [0x7f5c009fc407]
22: akonadiserver() [0x414295]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f5bfedf576d]
24: akonadiserver() [0x414c11]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
(In reply to comment #7) My bug might be different from this one. Sry for posting. Is it related to: Bug 331867 ? > DATABASE ERROR: > Error code: 1048 > DB error: "Column 'name' cannot be null" > Error text: "Column 'name' cannot be null QMYSQL3: Unable to execute > statement" > Query: "INSERT INTO PartTypeTable (ns, name) VALUES (:0, :1)" > "Column 'name' cannot be null QMYSQL3: Unable to execute statement" > Update failed > Failed to commit transaction for database update > Unable to initialize database. Hi ! (sorry for my bad english !)
always same problem after upgrade to kubuntu 14.04 :
jajax@portable:~/.local/share/akonadi/db_data$ mysql --socket=/tmp/akonadi-jajax.BSQudX/mysql.socket
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.5.35-1ubuntu1 (Ubuntu)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA='akonadi';
+----------------------------------+--------+
| TABLE_NAME | ENGINE |
+----------------------------------+--------+
| collectionattributetable | InnoDB |
| collectionmimetyperelation | InnoDB |
| collectionpimitemrelation | InnoDB |
| collectiontable | InnoDB |
| flagtable | InnoDB |
| mimetypetable | InnoDB |
| parttable | InnoDB |
| parttypetable | InnoDB |
| pimitemflagrelation | InnoDB |
| pimitemtable | InnoDB |
| pimitemtagrelation | InnoDB |
| resourcetable | InnoDB |
| schemaversiontable | InnoDB |
| tagattributetable | InnoDB |
| tagremoteidresourcerelationtable | InnoDB |
| tagtable | InnoDB |
+----------------------------------+--------+
16 rows in set (0.00 sec)
mysql> ALTER TABLE akonadi.tableName ENGINE = InnoDB;
ERROR 1146 (42S02): Table 'akonadi.tablename' doesn't exist
mysql> USE akonadi;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT id FROM CollectionTable) AND parentId IS NOT NULL;
ERROR 1093 (HY000): You can't specify target table 'CollectionTable' for update in FROM clause
mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable)) AND parentId IS NOT NULL;
ERROR 1248 (42000): Every derived table must have its own alias
mysql> DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable) AS tableA) AND parentId IS NOT NULL;
Query OK, 6 rows affected (0.17 sec)
mysql> mysqladmin --socket=/tmp/akonadi-jajax.BSQudX/mysql.socket shutdown
-> quit
->
->
->
->
-> quit
-> exit
-> ^CCtrl-C -- exit!
Aborted
jajax@portable:~/.local/share/akonadi/db_data$ mysqladmin --socket=/tmp/akonadi-jajax.BSQudX/mysql.socket shutdown
jajax@portable:~/.local/share/akonadi/db_data$ akonadictl start
Starting Akonadi Server...
done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
jajax@portable:~/.local/share/akonadi/db_data$ search paths: ("/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"
"ALTER TABLE CollectionTable ADD FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE"
"ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(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-436d_3`, CONSTRAINT `#sql-436d_3_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d445]
1: akonadiserver() [0x805d6ce]
2: [0xb777a400]
3: [0xb777a424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x47) [0xb6e19827]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e1cc53]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74c3d73]
7: akonadiserver() [0x805f514]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7568488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11083e) [0xb757883e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7581f35]
11: akonadiserver() [0x8062d92]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75f28aa]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75fa6fb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75e1040]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75e10a4]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75e0e4a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75e470d]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75e4c1c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a923e) [0xb761123e]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x273) [0xb6cea1e3]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x47468) [0xb6cea468]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cea528]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6b) [0xb761093b]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75df823]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75dfb49]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75e58fe]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6e04a83]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/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 PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(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-436d_6`, CONSTRAINT `#sql-436d_6_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d445]
1: akonadiserver() [0x805d6ce]
2: [0xb7773400]
3: [0xb7773424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x47) [0xb6e12827]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e15c53]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74bcd73]
7: akonadiserver() [0x805f514]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7561488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11083e) [0xb757183e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb757af35]
11: akonadiserver() [0x8062d92]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75eb8aa]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75f36fb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75da040]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75da0a4]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75d9e4a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75dd70d]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75ddc1c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a923e) [0xb760a23e]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x273) [0xb6ce31e3]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x47468) [0xb6ce3468]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6ce3528]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6b) [0xb760993b]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75d8823]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75d8b49]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75de8fe]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6dfda83]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/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 PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(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-436d_9`, CONSTRAINT `#sql-436d_9_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d445]
1: akonadiserver() [0x805d6ce]
2: [0xb7743400]
3: [0xb7743424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x47) [0xb6de2827]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6de5c53]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb748cd73]
7: akonadiserver() [0x805f514]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7531488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11083e) [0xb754183e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb754af35]
11: akonadiserver() [0x8062d92]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75bb8aa]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75c36fb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75aa040]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75aa0a4]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75a9e4a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75ad70d]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75adc1c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a923e) [0xb75da23e]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x273) [0xb6cb31e3]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x47468) [0xb6cb3468]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cb3528]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6b) [0xb75d993b]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75a8823]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75a8b49]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75ae8fe]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6dcda83]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/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 PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(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-436d_c`, CONSTRAINT `#sql-436d_c_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d445]
1: akonadiserver() [0x805d6ce]
2: [0xb76ec400]
3: [0xb76ec424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x47) [0xb6d8b827]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6d8ec53]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb7435d73]
7: akonadiserver() [0x805f514]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb74da488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11083e) [0xb74ea83e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb74f3f35]
11: akonadiserver() [0x8062d92]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75648aa]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb756c6fb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb7553040]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75530a4]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7552e4a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb755670d]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb7556c1c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a923e) [0xb758323e]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x273) [0xb6c5c1e3]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x47468) [0xb6c5c468]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6c5c528]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x6b) [0xb758293b]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7551823]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7551b49]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75578fe]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xb6d76a83]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
Hi ! (sorry for my bad english !) after I rename folder .local/share/akonadi and start akonadi, it's works !!!! tranks for your help ;) |
Hi ! (sorry for my bad english) after 4.12 to 4.13 upgrade, I have got a problem with akonadi server start : 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 ! Reproducible: Always Steps to Reproduce: 1.upgrade to 4.12.3 2.start akonadi server 3.problem for start, so I try solution here : https://bugs.kde.org/show_bug.cgi?id=331867 4.akonadi don't start again Actual Results: my akonadi server don't start. Kdepim don't start too. I can't do nothing for this time. I don't want make the method in this post => http://forum.kde.org/viewtopic.php?f=215&t=120673 I don't want loss any data ! thanks ;)