Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-80929

Drop of sharded system.buckets yields confusing error

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • 6.0.9
    • None
    • None
    • Storage Execution
    • ALL
    • Hide

      See script given in description.

      Show
      See script given in description.

    Description

      db = db.getSiblingDB("test");
      db.getSiblingDB("admin").runCommand({ shardCollection: "test.weather", timeseries: { timeField: "timestamp", metaField: "metadata" }, key: {timestamp: 1} });
      db.system.buckets.weather.drop()
      

      The above fails with this error in v6.0.9:

      MongoServerError: drop collection of a sharded time-series collection is not supported
      

      This error is misleading; it seems quite possible to drop a sharded time-series collection, but it has to be done on the logical collection (i.e., the view) rather than the buckets.

      Suggested revision:

      Drop on a sharded time-series system.buckets collection is unsupported; drop the view instead.

      Attachments

        Activity

          People

            backlog-server-execution Backlog - Storage Execution Team
            felipe.gasper@mongodb.com Felipe Gasper
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: