I'm trying to clean up my config in the face of continued performance issues with Kontact (there's got to be a reason why this thing isn't performing as it should).

I've an old (empty) Google address book resource which I'm trying to delete from my address books list in Kontact. The resource does not appear in akonadi resources but when I try and delete it nothing happens. Akonadi seems to know about the address book because the server reports:

"Cannot connect to agent instance with identifier 'akonadi_googledata_resource_0', error message: 'Could not get owner of name 'org.freedesktop.Akonadi.Resource.akonadi_googledata_resource_0': no such name'"

Any idea how I can remove this address book (and associated data files) from my system?

Thanks

Nick

Until someone with better-detailed solution comes, I suggest to use akonadiconsole application (you may have to install separate package, depending on your distro). Maybe it will be capable of removing that resource.

Thanks for the suggestion, I installed and ran the console.

My mystery resource 'googledata_0' does not appear under the Agents tab but does appear under the Browser tab - unfortunately it still won't let me delete it.

There must be a config file somewhere in which I can remove this thing. The search continues!

Akonadi data is stored in:
~/.config/akonadi/
~/.local/share/akonadi/
There are bunch of config, index, cache and mysql files. I wouldn't dare to touch them (akonadictl stop before you do!), but you may try.

Depending on you situation, it may be easier to just remove these directories (better yet: rename them, so you can always switch back) and configure Akonadi from scratch.

I would definitely recommend a fresh configuration (after exporting a backup of your data, especially Calendars and Contacts). The resource not showing up as a resource but still showing up elsewhere is troubling.

Nevertheless, it should be possible to remove this remnant and I would consider this as a bug, that should appear in the kde bug tracker.
I had the same problem with a facebook ressource.
When the agent is removed using the package manager or not available for other reasons, the resource should not be shown or at least should be removable.

I experience the same issue with a google-contact resource.

It broke by upgrading to KDESC 4.9. Because the google code was moved into kdepimlibs I removed the obsolete separate akonadi-google package and upgraded to 4.9. Unfortunately I forgot to compile kdepimlibs with akonadi-google support. So the first boot into 4.9 was without google support (but a google resource already existed with 4.8). Perhaps this is the reason for the resource-"orphaning".

Did you already file a bug?

There are two solutions to this. Either you can install the package again, remove the resource and uninstall it, or you can do it manually by removing the resource from the Akonadi database:

In Akonadi Console, open "DB Browser" tab, select "resourcetable" and find the Akonadi resource that is causing the havoc and write down it's ID. Then go to "DB Console" tab and write following query:

Code: Select all

DELETE FROM resourcetable WHERE id=XX;

Replace XX by ID of the resource you found in resourcetable and hit the "Execute" button. The constraints should automatically remove all related collections and items from other tables as well. You might also want to remove configuration file (will be called something like akonadi_googledata_resource_XXrc) from $HOME/.kde/share/config/.

Remember to make backup of Akonadi data and configuration before doing this and be veeeery careful not to remove anything else.

Thanks to you, progdan! That worked out very well.

progdan wrote:There are two solutions to this. Either you can install the package again, remove the resource and uninstall it, or you can do it manually by removing the resource from the Akonadi database:

In Akonadi Console, open "DB Browser" tab, select "resourcetable" and find the Akonadi resource that is causing the havoc and write down it's ID. Then go to "DB Console" tab and write following query:

Code: Select all

DELETE FROM resourcetable WHERE id=XX;

Replace XX by ID of the resource you found in resourcetable and hit the "Execute" button. The constraints should automatically remove all related collections and items from other tables as well. You might also want to remove configuration file (will be called something like akonadi_googledata_resource_XXrc) from $HOME/.kde/share/config/.

Remember to make backup of Akonadi data and configuration before doing this and be veeeery careful not to remove anything else.

Thank you, this solution worked for me!

I have used this command in the pas but now it looks like it is not working and I have a load of old akonadi stuff that I would like to clean.

Code: Select all

* OK Akonadi Almost IMAP Server [PROTOCOL 28]
DELETE FROM resourcetable WHERE id=3;
DELETE BAD Unrecognized command: FROM


You have to enter the queries to the "DB Console" tab, not "Raw Socket".

Allright thanks, it works

Apprently there is a big mess up in my config:
I have accidently removed a ressource with akonadiconsole (akonadi_ical_0)
When I look in the agent however it is still there.... (Although it does not show in Korganizer )

I got some other reminiscences of old akonadi_google_resources (see image : the three at the top of the list)
http://imageshack.us/photo/my-images/23/myakonadiconsole.png
I can only see in those in the "Browser tab" and nowhere else.
Does anyone knows how to delete it ?