Hello!

On Arch fully updated I get some problems with akonadi:
(akonadi 15.08.1-1, kmail 15.08.1-1)

The akonadi errors I always get (database driver Mysql):

DATABASE ERROR:
Error code: 1452
DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionpimitemrelation`, CONSTRAINT `collectionpimitemrelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Der Befehl konnte nicht ausgef\u00FChrt werden"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id) VALUES (:0, :1)"

This error also came up after completely rebuilding all mail accounts in akonadi.

Also the "search mail" function to create virtual search folders seems not to work at all.
It sometimes works one time but then always uses the same search pattern everytime no matter what search criteria I enter in subsequent searches. For some really obvious patterns like "somewhere in the mail header" "contains" "gmail.com" I do not get any search results at all though searching "all folders"...

BTW this behaviour is the same when I switch to an external Mariadb server.

Now I do not know if these two issues are related but I assume so.

Also the akonadi control module shows only one (!) single gmail resource though akonadi console shows about 10 mail resources, also calendar and contact resources and so forth.

On a fresh user account I run into the same problems....

Is there a way to clean up this situation without reconfiguring the complete akonadi setup (including all mail accounts)?

In the past I had about a dozen virtual virtual search folders running well within kmail.
Now I am lost here.

Any ideas someone?

thx, p.

As it seems the situation changed in many ways.

The error messages above do not show up anymore, search works (well not correctly but that is different...)
So I guess this post is obsolete.

p.

I installed Kmail (stand-alone) from the Mint repository recently. The search function gets no results when I can see there are messages with the positive search criteria. How can I get this working?

Ensure you have the email indexer set up and working. Check if your distribution ships a "baloo-pim" or similar package, or "akonadi-search".

I just checked and found baloo in the repository but not akonadi.

libbaloopim4 ---Pim functionality
This was already installed for some reason (might have done that before), and I just installed baloo. The following were not installed:

libbalooxapian4 ---Xapian functionality
libbaloofiles4 ---Files functionality
libbaloocore4 ---Core functionality

Would I install these and pare back later or wait and add "modules (?)" later? There are other packages (widgets, for example, and development), but I think those can wait.

Thanks for pointing me to the email indexer. I understand that kmail is integrated into a comprehensive suite, but I didn't know how modular the search facility would be.

You may want to check with "akonadiconsole" and see if you see if there's any "indexer" in the list it is presented you in the first tab.

I was mistaken: akonadi packages are in the Mint repository, and I have about 8-10 of them installed (not akonadiconsole).

With balloo installed, I was able to do a search and get the results. I have yet to look in more detail and still don't know if I will need those other packages. Likewise, I don't know what akonadi packages do. I may have installed some of them over a year ago in attempt to find a file-search/manager with different functionality than Nemo (from the Mint distro).

Thank you Einar for your suggestions.

einar wrote:Ensure you have the email indexer set up and working. Check if your distribution ships a "baloo-pim" or similar package, or "akonadi-search".

thanks !
installing the missing packages solved the problem for me.
why wouldn't they include them in the standard distribution of linuxmint KDE - strange.