On Monday, 25 September 2017 07:45:21 BST Wolfgang Bauer wrote:
Am Sonntag, 24. September 2017, 10:47:58 schrieb stakanov:
The combination of mariadb and kmail is (in my case, ymmv) totally non functional and a disaster. Data loss, crashes (up to system crashes), multiple merge candidates, blocked filters.....
I doubt that any of these problems are related to mariadb though, or that switching to mysql would help.
Your main problem seems to be the "Multiple Merge Candidates" problem, which will prevent Akonadi to sync the affected folder at all.
Dropping the cache will "fix" a "broken" folder as you know, but it will not prevent the problem from happening in the first place.
Upstream bug reports would suggest that the main reason for this problem is mail filtering, see e.g. https://bugs.kde.org/show_bug.cgi?id=376808. It is a long standing problem that moving mails via filters can cause duplicates (e.g. https://bugs.kde.org/show_bug.cgi?id=283682), and I suspect these may be the cause of this (duplicates in the database may lead to this "Multiple Merge Candidates" error I think, if the duplicates have the same RID).
So I'd say, try to disable automatic filering and see if it helps.
This definitely helps, populate the inbox first then applying the filters afterwards has saved me a lot of duplication issues. But i still get the odd days where the inbox already contains duplicates before i apply filters.
There have been a few fixes in this regard in 17.08 to make it less likely to happen (AFAIK it's still not fixed completely), so maybe you could try uprading to the latest version too. I might be able to create testing packages based on the Leap 42.3 version with some fixes added if you prefer that. E.g. this 17.08 commit should improve filtering: https://phabricator.kde.org/D5667 And this would apparently prevent one reason for "Muliple Merge Candidates" to appear: https://cgit.kde.org/akonadi.git/commit/?id=0c0c2824374c45785b3d3754fc0b2647... (although I'm not sure at the moment if the latter one would apply to 17.04 or fixed a problem with later changes)
The "data losses" you mentioned might be caused by deleting the caches, this will of course delete data that hasn't been synced back to the actual storage yet.
Complete system crashes should not be able to be triggered by a user space application anyway, and rather point to problems at a lower level (kernel, graphics driver).
Kind Regards, Wolfgang
-- opensuse:tumbleweed:20170913 Qt: 5.9.1 KDE Frameworks: 5.37.0 KDE Plasma: 5.10.5 kwin 5.10.5 kmail2 5.6.1 akonadiserver 5.6.1 Kernel: 4.13.1-1-default Nouveau: 1.0.15_1.2 -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org