[SERVER-38868] Db.mycoll.drop() cannot release table spaces Created: 07/Jan/19  Updated: 15/Jan/19  Resolved: 15/Jan/19

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 3.2.11
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: hiller1 Assignee: Danny Hatcher (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Participants:

 Description   

Db.mycoll.drop() cannot release table spaces

And when I restart the mongod service, the space is released.



 Comments   
Comment by hiller1 [ 15/Jan/19 ]

3.4 is OK.  thanks!

Comment by Danny Hatcher (Inactive) [ 10/Jan/19 ]

You may be experiencing SERVER-31101 or SERVER-26870. If you upgrade to 3.4.18 do you still have this problem?

Thank you,

Danny

Comment by Danny Hatcher (Inactive) [ 10/Jan/19 ]

Hello,

MongoDB will not release disk space except in a few special circumstances. If you are using WiredTiger as your storage engine, you can use the compact command or perform an initial sync from another member of the replica set. If you are using MMAPv1 as your storage engine, the only option is to perform an initial sync from another member of the replica set.

If you believe the situation you are encountering is a true bug, please provide the version of MongoDB, the storage engine, the replica set configuration, and the full reproduction steps.

Thank you,

Danny

Comment by hiller1 [ 10/Jan/19 ]

I executed my.coll.drop(), After I recreated an empty collection and insert new data.

I Can be accessed with the mongo shell, and synchronous replication is OK.

However, this drop collection on the secondary, disk space is not released.

Comment by Danny Hatcher (Inactive) [ 09/Jan/19 ]

Hello,

Can you please describe in further detail what you mean when you say "release table spaces"? When you drop a collection, can you still access that collection through the mongo shell until you restart? If you have reproduction steps please provide them.

Thank you,

Danny

Comment by hiller1 [ 07/Jan/19 ]

Primary can release table spaces, but secondary can't release table spaces.

Generated at Thu Feb 08 04:50:17 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.