Bug 497648 - mail search and quick filters are mostly dysfunctional after upgrade to kmail2 6.3.0/akonadi 24.12.0
Summary: mail search and quick filters are mostly dysfunctional after upgrade to kmail...
Status: REPORTED
Alias: None
Product: kmail2
Classification: Applications
Component: search (show other bugs)
Version: 6.3.0
Platform: openSUSE Linux
: NOR major
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-18 16:04 UTC by Hans-Peter Jansen
Modified: 2025-04-18 18:28 UTC (History)
5 users (show)

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


Attachments
quick search (33.09 KB, image/png)
2024-12-18 16:04 UTC, Hans-Peter Jansen
Details
vs. search dialog (82.48 KB, image/png)
2024-12-18 16:05 UTC, Hans-Peter Jansen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hans-Peter Jansen 2024-12-18 16:04:27 UTC
Created attachment 176747 [details]
quick search

SUMMARY

After upgrade to kmail2 6.3.0/akonadi 24.12.0, mail search as well as quick filter via search line doesn't work as expected.
Either the result set is empty or a subset is found, only. This fails for inboxes on a local cyrus imap server, gmail accounts, remote imap servers (ionos.de) and local folders. 

DETAILED DESCRIPTION

In order to avoid interferences with fetching, I waited until kmail2 finished synchronizing mails from all servers.
Then I opened my primary mailbox, and entered some quick search text without any further search restrictions. 
Got no results. Then I tried the mail search dialog, but no matter, what I entered, I got no results, where I knew, there are mails, that match. At this point, I started akonadiconsole, removed the akonadi cache on my INBOX, restarted akonadi, and then kmail. Still no results. 

After that, I was quite puzzled. After further tests, I can conclude, that apart from searching, everything else is working as expected. Digging deeper into the issue, I discovered this:

On the maintenance tab of the folder properties of my INBOX, there's a checkbox for fulltext indexing, which is checked of course, but the indexed count differs significantly from the number of items in the folder: 4873 vs. 58275. Consequently, some mails are found now, if I enter a search, that is covered by the indexed subset. Pushing the <Index folder again> button, the indexed count displays the same number of indexed items again after reopening the properties dialog box.

Well, that is explainable, then. If only a subset of items is indexed, the result set is a subset as well. 

But things get stranger in other folders. Here INBOX/Sent. Here the item numbers match after deleting the akonadi cache and pushing the <Index folder again> button. But still, the quick search finds a subset only. Will attach screenshots. 
Here, the "find messages" dialog finds all expected messages. Just displaying them in the "Last search" folder fails (empty).

OTOH, the "find messages" dialog in INBOX without recursion finds all items, that are displayed in the quick search list.
Again, a subset of all possible matches. I searched for a certain sender address, and checked by sorting the list by sender.

BTW: a notable fact from my setup: the akonadi db is hosted on a local postgres 17 database.

The question is: why aren't all messages indexed, and why does the quick search displays a subset only at times...

SOFTWARE/OS VERSIONS

Operating System: openSUSE Tumbleweed 20241216
KDE Plasma Version: 6.2.4
KDE Frameworks Version: 6.9.0
Qt Version: 6.8.1
Kernel Version: 6.11.7-6-preempt (64-bit)
Graphics Platform: X11
Processors: 24 × AMD Ryzen 9 3900X 12-Core Processor
Memory: 62.3 GiB of RAM
Graphics Processor: NVIDIA GeForce RTX 3060/PCIe/SSE2
Manufacturer: ASUS
Comment 1 Hans-Peter Jansen 2024-12-18 16:05:09 UTC
Created attachment 176748 [details]
vs. search dialog
Comment 2 piedro 2025-01-28 07:40:30 UTC
This hasn't changed in version 6.3.1 (24.12.1). 

All those bells and whistles in Kmail are worth nothing if searching is not reliable. 

Reliable search is the most important function in a mail client (apart from getting mail in the first place)! 

Please help someone...
Comment 3 Sander van Grieken 2025-03-10 16:09:59 UTC
Same issue with a dovecot IMAP server.
Comment 4 Ricardo J. Barberis 2025-04-18 18:28:17 UTC
Adding a me too: this happens with several POP3 accounts (so, local emails), akonadi on sqlite.

I see a lot of errors like "org.kde.pim.akonadi_indexer_agent: Xapian error in indexer 0x7fba90010280 : Expected block 1932 to be level 0, not 2" after restarting akonadi, even after I emptied its databases trying to reindex my emails, which fails or doesn't index all of them.

Versions:

kmail2 6.3.3 (24.12.3)

Operating System: Fedora Linux 42
KDE Plasma Version: 6.3.4
KDE Frameworks Version: 6.13.0
Qt Version: 6.8.2
Kernel Version: 6.14.2-300.fc42.x86_64 (64-bit)
Graphics Platform: Wayland
Processors: 8 × Intel® Core™ i5-1035G1 CPU @ 1.00GHz
Memory: 15.2 GiB of RAM
Graphics Processor: Intel® UHD Graphics