[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
jajaX
jajaxor at gmail.com
Wed May 14 20:20:45 BST 2014
https://bugs.kde.org/show_bug.cgi?id=334014
--- Comment #9 from jajaX <jajaxor at gmail.com> ---
Hi ! (sorry for my bad english !)
always same problem after upgrade to kubuntu 14.04 :
jajax at 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 at portable:~/.local/share/akonadi/db_data$ mysqladmin
--socket=/tmp/akonadi-jajax.BSQudX/mysql.socket shutdown
jajax at portable:~/.local/share/akonadi/db_data$ akonadictl start
Starting Akonadi Server...
done.
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
jajax at 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!
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list