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

Drop of sharded system.buckets yields confusing error

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 6.0.9
    • Component/s: None
    • None
    • Storage Execution
    • ALL
    • Hide

      See script given in description.

      Show
      See script given in 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.

            Assignee:
            backlog-server-execution [DO NOT USE] Backlog - Storage Execution Team
            Reporter:
            felipe.gasper@mongodb.com Felipe Gasper
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: