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

mongodump fails because it can’t query system.sharding_ddl_coordinators collection

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 100.7.1
    • Affects Version/s: 100.5.2
    • Component/s: mongodump
    • Labels:
    • Environment:
      mongodb-database-tools-100.5.2.x86_64.rpm

      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.

       

       

            Assignee:
            felipe.gasper@mongodb.com Felipe Gasper
            Reporter:
            x22t33c81@gmail.com Hidemi Ta
            Rohan Sharan, Tim Fogarty
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: