Currently, the metadataConsistency command is always acquiring the database DDL lock in S mode.

However, when the metadataConsistency command is running on the collection level, it would be better to take the database collection lock in IS mode and the collection DDL lock in S mode. With that improvement, we avoid blocking any DDL operation running over a collection that shares the same database that the collection we are running the metadataConsistency command on.