You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Tellier Benoit (JIRA)" <ji...@apache.org> on 2017/09/19 02:03:00 UTC
[jira] [Resolved] (MAILBOX-306) [Cassandra] Populate the
attachmentId -> messageIds table
[ 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org