Loading...

XML

Word

Printable

JSON

Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Steps To Reproduce:
Hide

> show collections ts [time-series] system.buckets.ts

Compacting a time series view shows the expected error:

> db.runCommand({compact:'ts', force:true}) MongoServerError: can't compact a view

But compacting the underlying collection also fails:

> db.runCommand({compact:'system.buckets.ts', force:true}) MongoServerError: can't compact a system namespace
Show
> show collections ts [time-series] system.buckets.ts Compacting a time series view shows the expected error: > db.runCommand({compact:'ts', force:true}) MongoServerError: can't compact a view But compacting the underlying collection also fails: > db.runCommand({compact:'system.buckets.ts', force:true}) MongoServerError: can't compact a system namespace
Sprint:
Execution Team 2022-12-12

I have over 100 GB of unused disk usage (and just 7GB used) in my time series collection that isn’t being reclaimed. I am unable to compact it.

Currently as far as I know we don't have a way to reclaim space in a time series collection other than dump and restore.

is related to

SERVER-81041 Fix time-series collection compact locking