Bug#990115: Kmail message display hangs after letting Akonadi idling for several hours

[Julien AUBIN <julien.aubin@gmail.com>]

Package: akonadi-server
Version: 4:20.08.3-3
Severity: normal

Hi,

I'm using Akonadi with Postgres as a backend (but the very same issue occured
with Postgres). It turns out that after some time Kmail email client display
hangs when clicking on an e-mail with "getting the folder content" and not
displaying the e-mail. Sometimes after waiting several minutes the email ends
up displaying. I have disabled email content indexing, but I have several
dozens of thousands of emails.

This happens especially when Kmail has been idling for several hours.

Workarounds :
- Restarting Akonadi server fixes the issue.
- Otherwise wait several minutes.

The issue did not appear with Bullseye, same configuration (A POP3 mail
account, several IMAP account including one connected to Protonmail)


-- System Information:
Debian Release: 11.0
  APT prefers testing-security
  APT policy: (500, 'testing-security'), (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.10.0-7-amd64 (SMP w/8 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE,
TAINT_UNSIGNED_MODULE
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE not
set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages akonadi-server depends on:
ii  akonadi-backend-mysql                                    4:20.08.3-3
ii  akonadi-backend-postgresql                               4:20.08.3-3
ii  libaccounts-qt5-1                                        1.16-2
ii  libc6                                                    2.31-12
ii  libgcc-s1                                                10.2.1-6
ii  libkf5akonadiprivate5abi2 [libkf5akonadiprivate5-20.08]  4:20.08.3-3
ii  libkf5akonadiwidgets5abi1 [libkf5akonadiwidgets5-20.08]  4:20.08.3-3
ii  libkf5configcore5                                        5.78.0-4
ii  libkf5coreaddons5                                        5.78.0-4
ii  libkf5crash5                                             5.78.0-3
ii  libkf5i18n5                                              5.78.0-2
ii  libqt5core5a                                             5.15.2+dfsg-7
ii  libqt5dbus5                                              5.15.2+dfsg-7
ii  libqt5gui5                                               5.15.2+dfsg-7
ii  libqt5network5                                           5.15.2+dfsg-7
ii  libqt5sql5                                               5.15.2+dfsg-7
ii  libqt5widgets5                                           5.15.2+dfsg-7
ii  libqt5xml5                                               5.15.2+dfsg-7
ii  libstdc++6                                               10.2.1-6

akonadi-server recommends no packages.

Versions of packages akonadi-server suggests:
ii  akonadi-backend-mysql       4:20.08.3-3
ii  akonadi-backend-postgresql  4:20.08.3-3
pn  akonadi-backend-sqlite      <none>