MongoDB Atlas online archive getting stuck

Varun_Sumesh · 2023-05-03T07:33:25.553Z

Created a custom query online archiving rule.But the archiving gets stuck once it reaches 500MB.Even after pausing and resuming the process multiple times its showing no progress.Trying to archive about 4GB of data

Satyam · 2023-05-05T05:11:22.925Z

Hey @Varun_Sumesh,

Welcome to the MongoDB Community Forums!

Please contact the Atlas in-app chat support regarding this. They will be better able to help you out in this case.

Regards,
Satyam

Prem_PK_Krishna · 2023-05-22T07:11:50.103Z

Hi @Varun_Sumesh ,

Can you please let us know if this issue is still existing. If so, can you please clarify by “archiving gets stuck”, does the archive display an “error” status or does it show the “archiving” status.

Thanks !

Varun_Sumesh · 2023-05-23T07:17:34.028Z

The issue is still existing.The status is shown as archiving and the cpu utilisation goes up but there is no decrease in documents count in the collection we are archiving.Its stuck at 2.03 GB.

Prem_PK_Krishna · 2023-05-23T16:02:19.944Z

We’d like to help you further, but have a few clarifying questions to help diagnose:

Can you clarify how much time it takes for it to archive 2.03GB of data
Are there high cardinality string fields in the partitioned fields
What are the data types of the partition fields

Varun_Sumesh · 2023-05-24T10:54:50.692Z

The time taken to archive 2.03GB is approximately 45 minutes.
We have two partition fields in the archive.One is a timestamp value in seconds which is an integer.It has high cardinality.The other is a random number user id which is stored as string,it also has high cardinality

Prem_PK_Krishna · 2023-05-25T04:18:56.968Z

Thanks for your response. We do not recommend providing high cardinality string fields as partition keys for Online Archive. This is mentioned in the documentation and we also request you to refer this blog: Optimizing your Online Archive for Query Performance | MongoDB

As part of our roadmap, we are changing the backend storage service of Online Archive in our next version and as part of this new release, we will allow the option to choose high cardinality string fields.

Details about the Private Preview program are here: https://www.mongodb.com/community/forums/t/invitation-to-participate-in-the-early-access-program-of-online-archives-query-performance-improvements/204188
If you’d like to participate in the program, please contact me at : prem.krishna@mongodb.com

If you’d like to test out without the Private Preview mode in your non-production environment, then you can delete the archive and create a new archive without high cardinality string field. Also you can “schedule” the archive to run during non-peak hours, so that way you are ensuring the CPU utilization doesn’t peak.

Josef_noah · 2023-12-07T11:26:23.267Z

The issue is still existing.The status is shown as archiving and the cpu utilisation goes up but there is no decrease in documents count in the collection we are archiving
I’m unable to create clickable links directly in the text, but you can copy and paste the URL into your browser’s address bar to access the site. Here’s the paragraph with the URL included:

「Twitterの動画をダウンロードする方法」はいくつかあります。まず、特定のツイートにある動画のURLをコピーします。次に、信頼できるオンラインの動画ダウンローダーにそのURLを貼り付けます。ダウンローダーは通常、ビデオの品質や形式を選択できる機能を提供しています。また、一部のブラウザ拡張機能やアプリケーションは、そのURLにアクセスするとTwitterの動画を直接ダウンロードすることができます。ダウンロードする際は、セキュリティリスクや著作権侵害の問題を避けるために、使用するウェブサイトやツールが信頼できるかを確認することを忘れないでください。

Prem_PK_Krishna · 2023-12-07T15:29:56.671Z

Hi @Josef_noah ,

We might need additional details about your environment before guiding you towards the correct solution approach,

Please contact the Atlas in-app chat support regarding this. They will be better able to help you out in this case.

Thanks !