Trying to dump whole database with mongodump using built-in backup role failed with following messages show no authorization to execute find on system.sharding_ddl_coordinators colleciton.
```
2022-06-22T13:41:37.990+0900 writing ea7a7132-6587-448c-839d-e4855bb1841e.bucket to /data/mongodb/backup/mongodb/ea7a7132-6587-448c-839d-e4855bb1841e/bucket.bson
2022-06-22T13:41:37.991+0900 done dumping 05da735c-dc40-43f5-b8d5-79eb8e18510c.customcode (0 documents)
2022-06-22T13:41:37.991+0900 done dumping ea7a7132-6587-448c-839d-e4855bb1841e.bucket (0 documents)
2022-06-22T13:41:37.992+0900 Failed: (Unauthorized) not authorized on config to execute command { find: "system.sharding_ddl_coordinators", filter: {}, lsid: { id: UUID("9e2cc5cb-e0e2-450b-97f5-8e0f06ddab53") }, $clusterTime: { clusterTime: Timestamp(1655872896, 1), signature:
}, $db: "config", $readPreference: { mode: "primaryPreferred" } }
```
According to TOOLS-2952, system.sharding_ddl_coordinators is not a collection should be skipped.
Workaround:
create a user-defined backup user has find privilege to system.sharding_ddl_coordinators.
- is related to
-
TOOLS-3210 mongorestore throws error for config db upon full backup restore
- Closed
- related to
-
TOOLS-3324 Fix failure to dump needed sharded collections from config database
- Closed
- links to