Hi!
I use MongoDB Atlas three-node replica set v6.0.24. After deleting some of the data I’ve done an analysis showing that more than 80%, about 2TiB of the storage are free blocks. I’ve run “compact” command iterating through the collections on the secondaries, then performed a failover and ran the command again on the remaining node which became secondary.
This unfortunately only freed about 1TiB of storage on every node, I still see that the storage size is 1TiB larger than the logical data size. Running “compact” again doesn’t do the job. Why is that? What can I do to reclaim the rest of the storage? I know there’s option to perform an initial sync, but I don’t think I can do that myself on Atlas
Contact MonogDB Support they can assist with resyncing the members. Use the in-app help or if you have support https://support.mongodb.com
A compact is not guaranteed to release the free blocks in these cases resyncing the hosts is the next option.