[kmail2] [Bug 497648] New: mail search as well as quick filters are mostly dysfunctional after upgrade to kmail2 6.3.0/akonadi 24.12.0

[Hans-Peter Jansen]

https://bugs.kde.org/show_bug.cgi?id=497648

            Bug ID: 497648
           Summary: mail search as well as quick filters are mostly
                    dysfunctional after upgrade to kmail2 6.3.0/akonadi
                    24.12.0
    Classification: Applications
           Product: kmail2
           Version: 6.3.0
          Platform: openSUSE
                OS: Linux
            Status: REPORTED
          Severity: major
          Priority: NOR
         Component: search
          Assignee: kdepim-bugs at kde.org
          Reporter: hpj at urpla.net
  Target Milestone: ---

Created attachment 176747
  --> https://bugs.kde.org/attachment.cgi?id=176747&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.