[JAMES-3109] Investigate the use of MessageSearch index for First UNSEEN Uid

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: cassandra, elasticsearch, mailbox
• Assignee: Unassigned
• Reporter: Benoit Tellier
• Created: 10/Mar/20 08:41
• Updated: 04/Sep/21 05:33

Description

After an expunge, or once all emails are read, Cassandra issues tubstone range warnings when trying to find first unseen UID of a mailbox reading `firstUnseen` table.

Maybe using the MessageSearch index to get this information is better suited. (Directly reused in the Message mapper)

Scenario:

• inset 2000 messages in a mailbox
• Mark them all as Read
• Insert 10 messages
• SELECT all unseen

Regarding mailboxRecent, we also encounter threshold warnings, but I'm wondering if this can be treated using the search index as the full list of values is expected (but we can try)

Furthermore relying on the search index will eventually solve coherence issue for these tables