Version: akonadi-server 1.2.60 (svn/trunk r1007251), mysql 5.0.83 (using Devel) Compiler: gcc 4.4.1 Gentoo 4.4.1 p1.0 OS: Linux Installed from: Compiled sources Steps to reproduce: akonadictl stop # confirm that akonadi is stoped (ps aux | grep akonadi) rm -fr .kde4/share/config/akonadi* rm -fr .config/akonadi/ rm -fr .local/share/akonadi/ akonadictl start akonadiconsole Error message boxes: std.ics: "Unknown error. (Unable to append mimetype for collection.)" std.vcf: "Unknown error. (Unable to add collection attribute.)" Terminal output: [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/dschridde/.local/share/akonadi/db_misc/mysql.socket' (2) QMYSQL: Unable to connect" [akonadiserver] Trying to create database now... [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DbInitializer::run() [akonadiserver] checking table "SchemaVersionTable" [akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);" [akonadiserver] checking table "ResourceTable" [akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) BINARY NOT NULL UNIQUE);" [akonadiserver] checking table "CollectionTable" [akonadiserver] "CREATE TABLE CollectionTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, resourceId BIGINT NOT NULL REFERENCES ResourceTable(id) ON DELETE CASCADE ON UPDATE CASCADE, subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts TEXT );" [akonadiserver] adding index "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name);" [akonadiserver] checking table "MimeTypeTable" [akonadiserver] "CREATE TABLE MimeTypeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);" [akonadiserver] checking table "PimItemTable" [akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);" [akonadiserver] adding index "CREATE INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId);" [akonadiserver] checking table "FlagTable" [akonadiserver] "CREATE TABLE FlagTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);" [akonadiserver] checking table "PartTable" [akonadiserver] "CREATE TABLE PartTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, pimItemId BIGINT NOT NULL REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE, name VARCHAR(255) NOT NULL, data LONGBLOB , datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL , FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE);" [akonadiserver] adding index "CREATE UNIQUE INDEX PartTable_pimItemIdNameIndex ON PartTable (pimItemId,name);" [akonadiserver] checking table "CollectionAttributeTable" [akonadiserver] "CREATE TABLE CollectionAttributeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, collectionId BIGINT NOT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, type LONGBLOB NOT NULL, value LONGBLOB );" [akonadiserver] adding index "CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId);" [akonadiserver] checking relation "PimItemFlagRelation" [akonadiserver] "CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItemTable(id) , Flag_id INTEGER REFERENCES FlagTable(id) , PRIMARY KEY (PimItem_id, Flag_id));" [akonadiserver] checking relation "CollectionMimeTypeRelation" [akonadiserver] "CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , MimeType_id INTEGER REFERENCES MimeTypeTable(id) , PRIMARY KEY (Collection_id, MimeType_id));" [akonadiserver] checking relation "CollectionPimItemRelation" [akonadiserver] "CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , PimItem_id INTEGER REFERENCES PimItemTable(id) , PRIMARY KEY (Collection_id, PimItem_id));" [akonadiserver] DbInitializer::run() done [akonadiserver] skipping update 2 [akonadiserver] skipping update 3 [akonadiserver] skipping update 4 [akonadiserver] skipping update 8 [akonadiserver] skipping update 10 [akonadiserver] skipping update 12 [akonadiserver] skipping update 13 [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Nepomuk QueryServer interface not available! [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DataStore::unhideAllPimItems() PLUGINS: "/usr/share/akonadi/agents" PLUGINS: ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop") PLUGINS inserting: "akonadi_birthdays_resource" 0 ("Resource", "Unique") PLUGINS inserting: "akonadi_distlist_resource" 0 ("Resource") PLUGINS inserting: "akonadi_ical_resource" 0 ("Resource") PLUGINS inserting: "akonadi_imap_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kabc_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kcal_resource" 0 ("Resource") PLUGINS inserting: "akonadi_knut_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig") PLUGINS inserting: "akonadi_localbookmarks_resource" 0 ("Resource") PLUGINS inserting: "akonadi_maildir_resource" 0 ("Resource") PLUGINS inserting: "akonadi_microblog_resource" 0 ("Resource") PLUGINS inserting: "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig") PLUGINS inserting: "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig") PLUGINS inserting: "akonadi_nepomuktag_resource" 0 ("Resource") PLUGINS inserting: "akonadi_nntp_resource" 0 ("Resource") PLUGINS inserting: "akonadi_notes_resource" 0 ("Resource") QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource PLUGINS inserting: "akonadi_strigi_feeder" 0 ("Unique") PLUGINS inserting: "akonadi_vcarddir_resource" 0 ("Resource") PLUGINS inserting: "akonadi_vcard_resource" 0 ("Resource") PLUGINS: "/usr/share/akonadi/agents" PLUGINS: ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop") [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Attribute "AccessRights" already exists for collection 2 [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Error during adding a record to table "CollectionMimeTypeRelation" "Duplicate entry '3-0' for key 1 QMYSQL3: Unable to execute statement"
I would like to add that I have similar problems after rebuilding all my binaries with GCC 4.4.1 yesterday, too. "Unknown error. (Unable to append mimetype for collection.)" is what akonadi reports to me whenever a resource appears to be updated/synced. I'd be happy to provide additional info if needed. This is very annoying, since all my akonadi resources stopped working (my LDAP address book for example, which is really important to me).
(In reply to comment #1) > I would like to add that I have similar problems after rebuilding all my > binaries with GCC 4.4.1 yesterday, too. "Unknown error. (Unable to append > mimetype for collection.)" is what akonadi reports to me whenever a resource > appears to be updated/synced. > did you try to rebuild mysql with -O1 ?
Thanks for the hint, that actually made the problem disappear. Is it already known which one of -O2's optimizations causes this?
(In reply to comment #3) > Thanks for the hint, that actually made the problem disappear. Is it already > known which one of -O2's optimizations causes this? no, i just test it this afternoon and since it worked for me. (also i don't have enough knowledge to find it too :p)
*** Bug 202582 has been marked as a duplicate of this bug. ***
*** Bug 199808 has been marked as a duplicate of this bug. ***
Now known as the "Gentoo Assert", it's apparently a downstream issue so closing as such. More information there: http://userbase.kde.org/Akonadi#The_so-called_.22Gentoo-Assert.22