Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-3203

mongodump failed no authorization to execute find on system.sharding_ddl_coordinators colleciton

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Waiting (Blocked)
    • Major - P3
    • Resolution: Unresolved
    • 100.5.2
    • 100.7.1
    • mongodump
    • mongodb-database-tools-100.5.2.x86_64.rpm

    Description

      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:

      { hash: BinData(0, B20AB0F10B84A79601AA1567D7B76F8296D9A1F3), keyId: 7073770222653538305 }

      }, $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.

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              x22t33c81@gmail.com Hidemi Ta
              Tim Fogarty
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: