I solved it this way:
1. Stop akonadi (from akonaditray)
2. Delete (or rename, or move) .local/share/akonadi/
3. Start akonadi

I also had to recreate Google Calendar and Google Contacts for it to work properly. Akonadi took a few minutes to synchronize everything but after all I'm finally free of akonadi_google_resource everywhere. It was kinda overkill, but works.

DISCLAIMER:
I am not responsible for anything you do using what worked for me. I am not liable for damages. Use my advice with a grain of salt.

The way I did it is as follows:

I opened the console and went to "DB Console". I then ran the query

Code: Select all

SELECT * FROM resourcetable;


I then looked at the name column and found the items I wanted to delete and took a careful note of the ID. I then ran the following:

Code: Select all

DELETE * FROM resourcetable
WHERE id = THEIDYOUGOTFROMSTEP1;


This should take care of it, but be careful not to type the wrong ID in. If you do, it will delete a resource you might not want deleted.

I think that was an old bug, you removed the resource but it didn't remove the collection.


I heard you can now run:
$ akonadictl fsck

But I've no idea if it fixes your problem.