Mail sender display error - Question Mark

[keomabrun]

Steps to reproduce

1. Configure the mail app
2. Open the inbox

Expected behavior

The email sender should be displayed correctly.

Actual behavior

The message sender is not displayed correctly. Instead a question mark is displayed.

Mail app version

2.2.7

Mailserver or service

OVH Mail

Operating system

Debian Bookworm

PHP engine version

None

Web server

Nginx

Database

None

Additional info

I have two users configured with the same mailbox. Only one of them has this display error.

Here is the error I found in the log file:

[mail] Erreur: OCA\Mail\Exception\ServiceException: Could not load message at <<closure>>

0. /var/www/<redacted.domain.tld>/apps/mail/lib/Controller/MessagesController.php line 205
   OCA\Mail\Service\MailManager->getImapMessage()
1. /var/www/<redacted.domain.tld>/lib/private/AppFramework/Http/Dispatcher.php line 225
   OCA\Mail\Controller\MessagesController->getBody()
2. /var/www/<redacted.domain.tld>/lib/private/AppFramework/Http/Dispatcher.php line 133
   OC\AppFramework\Http\Dispatcher->executeController()
3. /var/www/<redacted.domain.tld>/lib/private/AppFramework/App.php line 172
   OC\AppFramework\Http\Dispatcher->dispatch()
4. /var/www/<redacted.domain.tld>/lib/private/Route/Router.php line 298
   OC\AppFramework\App::main()
5. /var/www/<redacted.domain.tld>/lib/base.php line 1053
   OC\Route\Router->match()
6. /var/www/<redacted.domain.tld>/index.php line 36
   OC::handleRequest()

GET /apps/mail/api/messages/386/body
from <IP> by e at 2023-09-06T08:09:35+00:00

Caused by OCP\AppFramework\Db\DoesNotExistException: Message does not exist
    /var/www/<redacted.domain.tld>/apps/mail/lib/Service/MailManager.php - line 180:
    OCA\Mail\IMAP\MessageMapper->find()
    /var/www/<redacted.domain.tld>/apps/mail/lib/Controller/MessagesController.php - line 205:
    OCA\Mail\Service\MailManager->getImapMessage()
    /var/www/<redacted.domain.tld>/lib/private/AppFramework/Http/Dispatcher.php - line 225:
    OCA\Mail\Controller\MessagesController->getBody()
    /var/www/<redacted.domain.tld>/lib/private/AppFramework/Http/Dispatcher.php - line 133:
    OC\AppFramework\Http\Dispatcher->executeController()
    /var/www/<redacted.domain.tld>/lib/private/AppFramework/App.php - line 172:
    OC\AppFramework\Http\Dispatcher->dispatch()
    /var/www/<redacted.domain.tld>/lib/private/Route/Router.php - line 298:
    OC\AppFramework\App::main()
    /var/www/<redacted.domain.tld>/lib/base.php - line 1053:
    OC\Route\Router->match()
    /var/www/<redacted.domain.tld>/index.php - line 36:
    OC::handleRequest()

[ChristophWurst]

The question marks mean the recipients (and sender) info is missing in the database.

[keomabrun]

Hey @ChristophWurst, thank you for your answer 🙏

So I guess the issue comes from the process that stores data into the database, as only a part of the emails are correctly store.
Could you tell me where to look for more information on that ?

[ChristophWurst]

I know the symptoms but don't know how you might have ended here unless you manually wiped data from oc_mail_recipients.

[keomabrun]

Unfortunately I did not mess around with the database :)
I will keep an eye on the logs and keep you updated if I have some news.

Thanks for the support !

[ChristophWurst]

I'm now seeing this on a testing instance of Nextcloud 28 and Mail 3.5. The messages seem to still exist on IMAP, their body shows. But Mail has lost the recipients info.

[ChristophWurst]

Symptoms are that a user account has four IMAP accounts. They all worked fine for a long time. Now suddenly this issue paired with #8223 shows up. For some accounts there are messages that have no recipient, for others the message is not found on imap and the recipients are missing.

The recipients are missing for messages before November 6th or older. Newer messages are not affected by this issue, I think.