Bug 215536 - Akonadi is 100% useless after updating to 1.2
Summary: Akonadi is 100% useless after updating to 1.2
Status: RESOLVED UNMAINTAINED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: general (other bugs)
Version First Reported In: unspecified
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Volker Krause
URL:
Keywords: investigated, triaged
Depends on:
Blocks:
 
Reported: 2009-11-21 11:40 UTC by Anders Lund
Modified: 2018-09-21 05:37 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Anders Lund 2009-11-21 11:40:52 UTC
Version:           ukendt (using 4.3.3 (KDE 4.3.3), Chakra KDE)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.31-ARCH

After updating to akonadi 1.2, it is completely useless. I can add resources, but they are not populated with data.

I can add one addressbook. more akonadi addressbooks are not displayed in the kaddressbook resource selector.

Adding calenders does not work at all. they simply do not become available in korganizer.

I had installed a eventlist plasmoid that has a events plasmaengine, that is also empty.

So, I switched back to traditional resources again. Good thing that we do have something that works!
Comment 1 Brad Hards 2009-11-21 11:57:58 UTC
Being offensive doesn't help to encourage developers to fix problems.

So lets try to avoid the emotive nonsense and try for something that might help to get the issues fixed.

Which version of KAddressBook are you using?

Which version of KOrganizer are you using?

Which "events" plasmoid are you referring to?
Comment 2 Anders Lund 2009-11-21 13:08:34 UTC
Brad, sorry that i become angry, but i find this higly frustrating. I was about to try writing some patches for a plasmoid (listed below) showing events from plasma, but i have to give up on that for now, including using that very nice applet.

My kde version is 4.3.3.
Korganizer is 4.3.3
Mysql is 5.1.39 or 5.1.41 (both have these problems after updating akonadi: [2009-11-20 23:43] upgraded akonadi (1.2.1-1 -> 1.2.1-2)

However, the feeling that akonadi actually worked lasted only part of one kde session, in which i had to remove all the automatically added resources and add them manually.

I have two applets displaying data from akonadi:
http://www.kde-look.org/content/show.php/Eventlist?content=107779
TODO applet v. 0.1  (kdemod-extragear-plasmoid-todo 0.2.1-4 - the 0.1 is in the information dialog in the plasma add widgets function)

The eventlist applet which provides a plasma data engine for events. It worked fine as long as my akonadi resources was populated, so i doubt the problem is there.

The TODO applet worked probably as well as expected, while the akonadi resources was populated.

During akonadi server startup i see various errors, qfilewatcher fails with /usr/bin/akonadi* and sometimes some mysql errors about duplicate primary key entries, which is odd given the akonadiconsole db browser shows that those tables are empty.

Please request any other information that could be helpful.
Comment 3 Anders Lund 2009-11-22 12:21:30 UTC
After grepping KDEDIR/share for "akonadi" and removing all infected files and keys (except for kapptemplate files) in addition to akonadis own files (in .local and .config), i tried restarting my session again. I believe that a key file herer is kres-migrationrc.

Nice dialog telling that each of my resources was migrated.

Akonadiconsole contains all my resources.

There are NO data.

Korganizer and kaddressbook appears unaffected, still using the old style resources.

My .xsession-errors contains the following relevant 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/anders/.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 0 REFERENCES Collection(id), resourceId BIGINT NOT NULL REFERENCES Resource(id), 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 Collection(id), mimeTypeId BIGINT REFERENCES MimeType(id), 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), 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 REFERENCES Collection(id), type LONGBLOB NOT NULL, value LONGBLOB );"
[akonadiserver] adding index "CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId);"
kdeinit4: preparing to launch /usr/lib/libkdeinit4_kwalletd.so
[akonadiserver] checking relation  "PimItemFlagRelation"
[akonadiserver] "CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItem(id), Flag_id INTEGER REFERENCES Flag(id), PRIMARY KEY (PimItem_id, Flag_id));"
[akonadiserver] checking relation  "CollectionMimeTypeRelation"
[akonadiserver] "CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES Collection(id), MimeType_id INTEGER REFERENCES MimeType(id), PRIMARY KEY (Collection_id, MimeType_id));"
[akonadiserver] checking relation  "CollectionPimItemRelation"
[akonadiserver] "CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES Collection(id), PimItem_id INTEGER REFERENCES PimItem
(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
Calling appendChild() on a null node does nothing.
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
<unknown program name>(12182)/: Communication problem with  "kwalletmanager" , it probably crashed.
Error message was:  "org.freedesktop.DBus.Error.NoReply" : " "Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken." "

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
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")
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")
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
<unknown program name>(12234)/ main: Migrator instance already running for type  "contact"
Calling appendChild() on a null node does nothing.
<unknown program name>(12235)/ main: Migrator instance already running for type  "contact"
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.
Calling appendChild() on a null node does nothing.

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

<unknown program name>(12299)/ main: Migrator instance already running for type  "calendar"
<unknown program name>(12295)/ main: Migrator instance already running for type  "contact"
[akonadiserver] Attribute "AccessRights" already exists for collection 2

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Attribute "AccessRights" already exists for collection 3

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

[akonadiserver] Error during adding a record to table "CollectionMimeTypeRelation" "Duplicate entry '4-0' for key 'PRIMARY' QMYSQL3: Unable to execute statement"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Attribute "AccessRights" already exists for collection 5

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during adding a record to table "CollectionMimeTypeRelation" "Duplicate entry '6-0' for key 'PRIMARY' QMYSQL3: Unable to execute statement"

---

This continues with many more similar sections
Comment 4 Anders Lund 2009-11-22 12:52:21 UTC
Trying with a completely new user yelds similar results as the above.

I noticed that while in kontact i had one calendar and one addressbook, i had two of each in akonadiconsole.

I tried adding a few events, but the data browser does not show any data at all.
Comment 5 Tobias Koenig 2010-03-16 12:14:36 UTC
Hej Anders,

do you still face these problems with 4.4.1?

Ciao,
Tobias
Comment 6 Anders Lund 2010-03-16 14:07:14 UTC
I haven't tried adding korganizer resources, but i can.

Akonadi often fails starting at all, showing a dialog that i really do not think is useful for end users. what it says is most often that there were errors in the logs. Sometimes this prevents akonadi from starting, sometimes not.

Sometimes my addressbook is populated, sometimes not (no evident connection to weather akonadi is loaded, except no adressees if not). Restarting akonadi sometimes helps sometimes restarting kontact is required too.

Korganizer decided to show the selection dialog for which instances of repeated events to edit again, which is very, very good as i use repeated events a lot <3 <3 <3 But that may be a result of my resources in korganizer not being akonadified, they do not look like they are when i edit them. And afaik korganizer is not officially switched to akonadi anyways?

I dropped the plasmoid, because it would make my desktop take 1938329323 to load, and often not even worked.

I think many problems is related to dbus?

I believe that logging out and then back in sometimes causes problems.
Comment 7 Andrew Crouthamel 2018-09-20 22:07:31 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days, the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information.

For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please set the bug status as REPORTED so that the KDE team knows that the bug is ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 8 Anders Lund 2018-09-21 05:37:13 UTC
This bug is from 2009/10, and probably not relevant any longer. I'm nor really using kaddressbook any longer, but the parts of akonadi I do use mostly works.