[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
jajaX
jajaxor at gmail.com
Fri May 2 10:38:39 BST 2014
https://bugs.kde.org/show_bug.cgi?id=334014
--- Comment #6 from jajaX <jajaxor at gmail.com> ---
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 at portable:~$ mysqladmin --socket=/tmp/akonadi-jajax.lR117e/mysql.socket
shutdown
jajax at portable:~$ akonadictl start
Starting Akonadi Server...
done.
jajax at 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!
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list