[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #10 from jajaX jaja...@gmail.com --- Hi ! (sorry for my bad english !) after I rename folder .local/share/akonadi and start akonadi, it's works tranks for your help ;) -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #9 from jajaX jaja...@gmail.com --- 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.collectiontableOK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelationOK 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.eventOK mysql.func OK mysql.general_log OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 Elias hir.i.mo...@googlemail.com changed: What|Removed |Added CC||hir.i.mo...@googlemail.com --- Comment #7 from Elias hir.i.mo...@googlemail.com --- 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.collectiontableOK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttable_new OK akonadi.parttypetable OK akonadi.pimitemflagrelationOK 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.eventOK mysql.func OK mysql.general_log OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK 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_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK 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
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #8 from Elias hir.i.mo...@googlemail.com --- (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. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #5 from Daniel Vrátil dvra...@redhat.com --- 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; -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #6 from jajaX jaja...@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@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.collectiontableOK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelationOK 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.eventOK mysql.func OK mysql.general_log OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK 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_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK 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:
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #4 from jajaX jaja...@gmail.com --- 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #3 from Daniel Vrátil dvra...@redhat.com --- 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 Daniel Vrátil dvra...@redhat.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||dvra...@redhat.com Resolution|--- |INVALID --- Comment #1 from Daniel Vrátil dvra...@redhat.com --- 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 334014] akonadiserver start problem after 4.12 to 4.13 update
https://bugs.kde.org/show_bug.cgi?id=334014 --- Comment #2 from jajaX jaja...@gmail.com --- 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 ? -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs