[
https://issues.apache.org/jira/browse/MAILBOX-306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tellier Benoit resolved MAILBOX-306.
------------------------------------
Resolution: Fixed
https://github.com/linagora/james-project/pull/974 is merged
> [Cassandra] Populate the attachmentId -> messageIds table
> ---------------------------------------------------------
>
> Key: MAILBOX-306
> URL: https://issues.apache.org/jira/browse/MAILBOX-306
> Project: James Mailbox
> Issue Type: Improvement
> Reporter: Raphaël Ouazana
>
> MAILBOX-305 introduced an attachmentId -> messageIds table. We now need to
> migrate data to it.
> The plan :
> - (Migration optimisation) compact messageV2 table.
> - SELECT * on messageV2 with high timeout value (several hours?) to get the
> msgId -> attIds relation. Reducing the page size can also help avoid errors
> (maybe ~ 100)
> - For each entry, write to the new table.
> - Compact new table once finished.
> Tips: ensure no concurrency on writes (sequential). It's fast enough and
> reduce drasticly the risk to overwhelm the cluster.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
