moveRange() not working

Fory_Horio1 · May 21, 2025, 9:17am

I have the following sharded database. I have tried the moveRange() command, but even the command returns “ok”, that sharded data is not moved.

sh.status()
…
database: {
_id: ‘METRIC_RAW_DATA’,
primary: ‘East’,
partitioned: true,
version: {
uuid: UUID(‘128add24-9a71-42ac-b980-d7f4df17b51f’),
lastMod: 1,
timestamp: Timestamp({ t: 1719866456, i: 8 })
}
},
collections: {
‘METRIC_RAW_DATA.OPERATIONAL_METRIC’: {
shardKey: { containerKey: 1, _id: 1 },
unique: false,
balancing: true,
chunkMetadata: [
{ shard: ‘East’, nChunks: 4 },
{ shard: ‘Ohio’, nChunks: 1 },
{ shard: ‘West’, nChunks: 5 }
],
chunks: [
{ min: { containerKey: MinKey(), _id: MinKey() }, max: { containerKey: ‘10000000’, _id: MinKey() }, ‘on shard’: ‘West’, ‘last modified’: Timestamp({ t: 8, i: 1 }) },
{ min: { containerKey: ‘10000000’, _id: MinKey() }, max: { containerKey: ‘11000000’, _id: MinKey() }, ‘on shard’: ‘Ohio’, ‘last modified’: Timestamp({ t: 8, i: 0 }) },
{ min: { containerKey: ‘11000000’, _id: MinKey() }, max: { containerKey: ‘8000000’, _id: MinKey() }, ‘on shard’: ‘West’, ‘last modified’: Timestamp({ t: 7, i: 3 }) },
{ min: { containerKey: ‘8000000’, _id: MinKey() }, max: { containerKey: ‘8000001’, _id: ObjectId(‘62498d5e7c0d6b5d3e7a19a9’) }, ‘on shard’: ‘West’, ‘last modified’: Timestamp({ t: 8, i: 2 }) },
{ min: { containerKey: ‘8000001’, _id: ObjectId(‘62498d5e7c0d6b5d3e7a19a9’) }, max: { containerKey: ‘8000002’, _id: ObjectId(‘62477d4d7c0d6b5d3e7a0b8b’) }, ‘on shard’: ‘West’, ‘last modified’: Timestamp({ t: 8, i: 3 }) },
{ min: { containerKey: ‘8000002’, _id: ObjectId(‘62477d4d7c0d6b5d3e7a0b8b’) }, max: { containerKey: ‘9000000’, _id: MinKey() }, ‘on shard’: ‘West’, ‘last modified’: Timestamp({ t: 8, i: 4 }) },
{ min: { containerKey: ‘9000000’, _id: MinKey() }, max: { containerKey: ‘9000001’, _id: ObjectId(‘624ab364da1b434b9d11e031’) }, ‘on shard’: ‘East’, ‘last modified’: Timestamp({ t: 8, i: 5 }) },
{ min: { containerKey: ‘9000001’, _id: ObjectId(‘624ab364da1b434b9d11e031’) }, max: { containerKey: ‘9000002’, _id: ObjectId(‘62435420da1b434b9d11aa72’) }, ‘on shard’: ‘East’, ‘last modified’: Timestamp({ t: 8, i: 6 }) },
{ min: { containerKey: ‘9000002’, _id: ObjectId(‘62435420da1b434b9d11aa72’) }, max: { containerKey: ‘9999999’, _id: MinKey() }, ‘on shard’: ‘East’, ‘last modified’: Timestamp({ t: 8, i: 7 }) },
{ min: { containerKey: ‘9999999’, _id: MinKey() }, max: { containerKey: MaxKey(), _id: MaxKey() }, ‘on shard’: ‘East’, ‘last modified’: Timestamp({ t: 7, i: 0 }) }
],
tags: [
{
tag: ‘Ohio’,
min: { containerKey: ‘10000000’, _id: MinKey() },
max: { containerKey: ‘11000000’, _id: MinKey() }
},
{
tag: ‘West’,
min: { containerKey: ‘8000000’ },
max: { containerKey: ‘9000000’ }
},
{
tag: ‘East’,
min: { containerKey: ‘9000000’, _id: MinKey() },
max: { containerKey: ‘9999999’, _id: MinKey() }
}
]
}
}
},
…

db.adminCommand( { moveRange: ‘METRIC_RAW_DATA.OPERATIONAL_METRIC’, toShard: ‘West’, min: { containerKey: 9000000, eventId: MinKey() }, max: { containerKey: 10000000, eventId: MinKey() } } )
{
ok: 1,
‘$clusterTime’: {
clusterTime: Timestamp({ t: 1747776845, i: 3 }),
signature: {
hash: Binary.createFromBase64(‘YuPPtu7HLEkdRI8bY7A0GcpZfas=’, 0),
keyId: Long(‘7469301375919194116’)
}
},
operationTime: Timestamp({ t: 1747776845, i: 3 })
}

Also tried:

db.adminCommand( { moveRange: ‘METRIC_RAW_DATA.OPERATIONAL_METRIC’, toShard: ‘West’, min: { containerKey: 9000000, eventId: MinKey() }, max: { containerKey: 10000000, eventId: MinKey() } } )
{
ok: 1,
‘$clusterTime’: {
clusterTime: Timestamp({ t: 1747776845, i: 3 }),
signature: {
hash: Binary.createFromBase64(‘YuPPtu7HLEkdRI8bY7A0GcpZfas=’, 0),
keyId: Long(‘7469301375919194116’)
}
},
operationTime: Timestamp({ t: 1747776845, i: 3 })
}

But the sh.status() still shows the chunks in the East shard that I wanted to move to the West shard.

Renato_Riccio · May 21, 2025, 10:01am

Hi @Fory_Horio1

From the extract of sh.status() you shared seems you have defined zones on the collection and you tagged

{ tag: 'East',
  min: { containerKey: '9000000', _id: MinKey() },
  max: { containerKey: '9999999', _id: MinKey() }
}

Is this tag associated to the Shard East, can you please share the full sh.status() output?

Fory_Horio1 · May 28, 2025, 8:34am

I am exercising from the smallest dataset collection first, METRIC_RAW_DATA.OPERATIONAL_METRIC

Fory_Horio1 · May 28, 2025, 8:34am

The goal is I’d like to move all the East shared collections to the West and change the West tag to includes the East tag range, and remove the East shard. At the end, I’d like to change West/East/Ohio sharded clusters to just West/Ohio sharded clusters.

Fory_Horio1 · May 28, 2025, 8:35am

 sh.status()
shardingVersion
{ _id: 1, clusterId: ObjectId('5901903fb27b7b308b8fec85') }
---
shards
[
  {
    _id: 'East',
    host: 'East/mone1.smk.env.akana.com:27017,mone2.smk.env.akana.com:27017,mone3.smk.env.akana.com:27017',
    tags: [ 'East' ],
    state: 1
  },
  {
    _id: 'Ohio',
    host: 'Ohio/mon1oh.smk.env.akana.com:27017,mon2oh.smk.env.akana.com:27017,mon3oh.smk.env.akana.com:27017',
    state: 1,
    tags: [ 'Ohio' ]
  },
  {
    _id: 'West',
    host: 'West/monw1.smk.env.akana.com:27017,monw2.smk.env.akana.com:27017,monw3.smk.env.akana.com:27017',
    tags: [ 'West' ],
    state: 1
  }
]
---
active mongoses
[ { '6.0.23': 4 } ]
---
autosplit
{ 'Currently enabled': 'yes' }
---
balancer
{
  'Currently running': 'no',
  'Currently enabled': 'yes',
  'Failed balancer rounds in last 5 attempts': 0,
  'Migration Results for the last 24 hours': 'No recent migrations'
}
---
databases
[
  {
    database: {
      _id: 'Akana',
      primary: 'West',
      partitioned: false,
      version: {
        uuid: UUID('a28c0e28-3b93-4484-bf55-c7b85d2ea686'),
        timestamp: Timestamp({ t: 1747772440, i: 17 }),
        lastMod: 2
      }
    },
    collections: {}
  },
  {
    database: { _id: 'config', primary: 'config', partitioned: true },
    collections: {
      'config.system.sessions': {
        shardKey: { _id: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 341 },
          { shard: 'Ohio', nChunks: 341 },
          { shard: 'West', nChunks: 342 }
        ],
        chunks: [
          { min: { _id: MinKey() }, max: { _id: { id: UUID('00400000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1538, i: 0 }) },
          { min: { _id: { id: UUID('00400000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('00800000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1541, i: 0 }) },
          { min: { _id: { id: UUID('00800000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('00c00000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1543, i: 0 }) },
          { min: { _id: { id: UUID('00c00000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('01000000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1544, i: 0 }) },
          { min: { _id: { id: UUID('01000000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('01400000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1546, i: 0 }) },
          { min: { _id: { id: UUID('01400000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('01800000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1548, i: 0 }) },
          { min: { _id: { id: UUID('01800000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('01c00000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1550, i: 0 }) },
          { min: { _id: { id: UUID('01c00000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('02000000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1553, i: 0 }) },
          { min: { _id: { id: UUID('02000000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('02400000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1554, i: 0 }) },
          { min: { _id: { id: UUID('02400000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('02800000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1557, i: 0 }) },
          { min: { _id: { id: UUID('02800000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('02c00000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1558, i: 0 }) },
          { min: { _id: { id: UUID('02c00000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('03000000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1560, i: 0 }) },
          { min: { _id: { id: UUID('03000000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('03400000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1563, i: 0 }) },
          { min: { _id: { id: UUID('03400000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('03800000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1565, i: 0 }) },
          { min: { _id: { id: UUID('03800000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('03c00000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1567, i: 0 }) },
          { min: { _id: { id: UUID('03c00000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('04000000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1568, i: 0 }) },
          { min: { _id: { id: UUID('04000000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('04400000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1571, i: 0 }) },
          { min: { _id: { id: UUID('04400000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('04800000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1572, i: 0 }) },
          { min: { _id: { id: UUID('04800000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('04c00000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1574, i: 0 }) },
          { min: { _id: { id: UUID('04c00000-0000-0000-0000-000000000000') } }, max: { _id: { id: UUID('05000000-0000-0000-0000-000000000000') } }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 1577, i: 0 }) },
          'too many chunks to print, use verbose if you want to force print'
        ],
        tags: []
      }
    }
  },
  {
    database: {
      _id: 'ENVISION',
      primary: 'West',
      partitioned: false,
      version: {
        uuid: UUID('7e050850-bb37-4593-8283-40c7af490758'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 10 })
      }
    },
    collections: {}
  },
  {
    database: {
      _id: 'METRIC_RAW_DATA',
      primary: 'East',
      partitioned: true,
      version: {
        uuid: UUID('128add24-9a71-42ac-b980-d7f4df17b51f'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 8 })
      }
    },
    collections: {
      'METRIC_RAW_DATA.OPERATIONAL_METRIC': {
        shardKey: { containerKey: 1, _id: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 4 },
          { shard: 'Ohio', nChunks: 1 },
          { shard: 'West', nChunks: 5 }
        ],
        chunks: [
          { min: { containerKey: MinKey(), _id: MinKey() }, max: { containerKey: '10000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 1 }) },
          { min: { containerKey: '10000000', _id: MinKey() }, max: { containerKey: '11000000', _id: MinKey() }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 8, i: 0 }) },
          { min: { containerKey: '11000000', _id: MinKey() }, max: { containerKey: '8000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 7, i: 3 }) },
          { min: { containerKey: '8000000', _id: MinKey() }, max: { containerKey: '8000001', _id: ObjectId('62498d5e7c0d6b5d3e7a19a9') }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 2 }) },
          { min: { containerKey: '8000001', _id: ObjectId('62498d5e7c0d6b5d3e7a19a9') }, max: { containerKey: '8000002', _id: ObjectId('62477d4d7c0d6b5d3e7a0b8b') }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 3 }) },
          { min: { containerKey: '8000002', _id: ObjectId('62477d4d7c0d6b5d3e7a0b8b') }, max: { containerKey: '9000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 4 }) },
          { min: { containerKey: '9000000', _id: MinKey() }, max: { containerKey: '9000001', _id: ObjectId('624ab364da1b434b9d11e031') }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 5 }) },
          { min: { containerKey: '9000001', _id: ObjectId('624ab364da1b434b9d11e031') }, max: { containerKey: '9000002', _id: ObjectId('62435420da1b434b9d11aa72') }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 6 }) },
          { min: { containerKey: '9000002', _id: ObjectId('62435420da1b434b9d11aa72') }, max: { containerKey: '9999999', _id: MinKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 7 }) },
          { min: { containerKey: '9999999', _id: MinKey() }, max: { containerKey: MaxKey(), _id: MaxKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 7, i: 0 }) }
        ],
        tags: [
          {
            tag: 'Ohio',
            min: { containerKey: '10000000', _id: MinKey() },
            max: { containerKey: '11000000', _id: MinKey() }
          },
          {
            tag: 'West',
            min: { containerKey: '8000000' },
            max: { containerKey: '9000000' }
          },
          {
            tag: 'East',
            min: { containerKey: '9000000', _id: MinKey() },
            max: { containerKey: '9999999', _id: MinKey() }
          }
        ]
      }
    }
  },
  {
    database: {
      _id: 'METRIC_ROLLUP_DATA',
      primary: 'West',
      partitioned: false,
      version: {
        uuid: UUID('2c6816ff-0412-4cd3-9a66-788715585330'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 11 })
      }
    },
    collections: {}
  },
  {
    database: {
      _id: 'PM',
      primary: 'West',
      partitioned: true,
      version: {
        uuid: UUID('01701b03-d109-4122-bcf5-bcf0bb2fc677'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 6 })
      }
    },
    collections: {
      'PM.ALERTS': {
        shardKey: { containerKey: 1, _id: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 55 },
          { shard: 'Ohio', nChunks: 31 },
          { shard: 'West', nChunks: 47 }
        ],
        chunks: [
          { min: { containerKey: MinKey(), _id: MinKey() }, max: { containerKey: '10000000', _id: MinKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 148, i: 1 }) },
          { min: { containerKey: '10000000', _id: MinKey() }, max: { containerKey: '10000011', _id: ObjectId('61e9dae7d993dd40af395ff4') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 8 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61e9dae7d993dd40af395ff4') }, max: { containerKey: '10000011', _id: ObjectId('61ec6e57d993dd40af39e280') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 11 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61ec6e57d993dd40af39e280') }, max: { containerKey: '10000011', _id: ObjectId('61ef01ced993dd40af3a650c') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 14 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61ef01ced993dd40af3a650c') }, max: { containerKey: '10000011', _id: ObjectId('61f1956dd993dd40af3ae798') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 20 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61f1956dd993dd40af3ae798') }, max: { containerKey: '10000011', _id: ObjectId('61f42919d993dd40af3b6a24') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 26 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61f42919d993dd40af3b6a24') }, max: { containerKey: '10000011', _id: ObjectId('61f6bcd3d993dd40af3becb0') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 29 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61f6bcd3d993dd40af3becb0') }, max: { containerKey: '10000011', _id: ObjectId('61f950a5d993dd40af3c6f3c') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 35 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61f950a5d993dd40af3c6f3c') }, max: { containerKey: '10000011', _id: ObjectId('61fbe47dd993dd40af3cf1c8') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 38 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61fbe47dd993dd40af3cf1c8') }, max: { containerKey: '10000011', _id: ObjectId('61fe78a8d993dd40af3d7454') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 44 }) },
          { min: { containerKey: '10000011', _id: ObjectId('61fe78a8d993dd40af3d7454') }, max: { containerKey: '10000011', _id: ObjectId('62010cd0d993dd40af3df6e0') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 47 }) },
          { min: { containerKey: '10000011', _id: ObjectId('62010cd0d993dd40af3df6e0') }, max: { containerKey: '10000012', _id: ObjectId('61e935703c5e4f50a69d0131') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 48 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e935703c5e4f50a69d0131') }, max: { containerKey: '10000012', _id: ObjectId('61e93a503c5e4f50a69d0228') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 49 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e93a503c5e4f50a69d0228') }, max: { containerKey: '10000012', _id: ObjectId('61e93f513c5e4f50a69d0325') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 46 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e93f513c5e4f50a69d0325') }, max: { containerKey: '10000012', _id: ObjectId('61e9444c3c5e4f50a69d0421') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 40 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e9444c3c5e4f50a69d0421') }, max: { containerKey: '10000012', _id: ObjectId('61e949843c5e4f50a69d0529') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 37 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e949843c5e4f50a69d0529') }, max: { containerKey: '10000012', _id: ObjectId('61e94ed03c5e4f50a69d0635') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 31 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e94ed03c5e4f50a69d0635') }, max: { containerKey: '10000012', _id: ObjectId('61e9ca8b3c5e4f50a69d1eae') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 28 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e9ca8b3c5e4f50a69d1eae') }, max: { containerKey: '10000012', _id: ObjectId('61e9cfe73c5e4f50a69d1fbd') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 22 }) },
          { min: { containerKey: '10000012', _id: ObjectId('61e9cfe73c5e4f50a69d1fbd') }, max: { containerKey: '10000012', _id: ObjectId('61e9d5403c5e4f50a69d20cc') }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 148, i: 16 }) },
          'too many chunks to print, use verbose if you want to force print'
        ],
        tags: [
          {
            tag: 'Ohio',
            min: { containerKey: '10000000', _id: MinKey() },
            max: { containerKey: '11000000', _id: MinKey() }
          },
          {
            tag: 'West',
            min: { containerKey: '8000000' },
            max: { containerKey: '9000000' }
          },
          {
            tag: 'East',
            min: { containerKey: '9000000', _id: MinKey() },
            max: { containerKey: '9999999', _id: MinKey() }
          }
        ]
      }
    }
  },
  {
    database: {
      _id: 'PM_AUDIT',
      primary: 'East',
      partitioned: true,
      version: {
        uuid: UUID('54e43a20-bceb-4dda-8f22-99d039fff1cc'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 9 })
      }
    },
    collections: {
      'PM_AUDIT.AUDIT': {
        shardKey: { containerKey: 1, eventId: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 7801 },
          { shard: 'Ohio', nChunks: 550 },
          { shard: 'West', nChunks: 5297 }
        ],
        chunks: [
          { min: { containerKey: MinKey(), eventId: MinKey() }, max: { containerKey: '10000000', eventId: MinKey() }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15815, i: 0 }) },
          { min: { containerKey: '10000000', eventId: MinKey() }, max: { containerKey: '11000000', eventId: MinKey() }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15600, i: 0 }) },
          { min: { containerKey: '11000000', eventId: MinKey() }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '00005e60-378d-11e7-9756-9b87acd39587' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15816, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '00005e60-378d-11e7-9756-9b87acd39587' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '037ae7ef-efb7-11e8-8682-e1bfab0f62bf' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15817, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '037ae7ef-efb7-11e8-8682-e1bfab0f62bf' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '06f62004-fc95-11e8-ab08-be95d11ec04a' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15818, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '06f62004-fc95-11e8-ab08-be95d11ec04a' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0a734ded-f918-11e8-ab08-be95d11ec04a' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15819, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0a734ded-f918-11e8-ab08-be95d11ec04a' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0bdd008d-d748-11e8-b931-c7c3af393e79' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15820, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0bdd008d-d748-11e8-b931-c7c3af393e79' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0cb7169d-5f4c-11ea-af81-bfbd8982b33e' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15821, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0cb7169d-5f4c-11ea-af81-bfbd8982b33e' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0d9e5e2d-4c92-11ea-836d-cabcfb31ed65' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15822, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0d9e5e2d-4c92-11ea-836d-cabcfb31ed65' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0e83cf8a-60f3-11ea-af81-bfbd8982b33e' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15823, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0e83cf8a-60f3-11ea-af81-bfbd8982b33e' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0f5debdc-f6bf-11e8-ab08-be95d11ec04a' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15824, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '0f5debdc-f6bf-11e8-ab08-be95d11ec04a' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '12ea44fa-effc-11e8-8682-e1bfab0f62bf' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15825, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '12ea44fa-effc-11e8-8682-e1bfab0f62bf' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '148ca5af-fca0-11ea-8611-c054af179794' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15826, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '148ca5af-fca0-11ea-8611-c054af179794' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '16254817-fe42-11ea-8611-c054af179794' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15827, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '16254817-fe42-11ea-8611-c054af179794' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '16650a3b-ebf7-11e8-9592-ffde24e6e343' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15828, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '16650a3b-ebf7-11e8-9592-ffde24e6e343' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '17986e8d-d6cf-11e8-b931-c7c3af393e79' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15829, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '17986e8d-d6cf-11e8-b931-c7c3af393e79' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '186f0708-4fac-11ea-836d-cabcfb31ed65' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15830, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '186f0708-4fac-11ea-836d-cabcfb31ed65' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '1941b9dc-61a4-11ea-af81-bfbd8982b33e' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15831, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '1941b9dc-61a4-11ea-af81-bfbd8982b33e' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '1a134e5a-60d3-11ea-af81-bfbd8982b33e' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15832, i: 0 }) },
          { min: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '1a134e5a-60d3-11ea-af81-bfbd8982b33e' }, max: { containerKey: '188e6907-901c-4aac-bd58-9cb0a017', eventId: '1ae730e1-5f07-11ea-af81-bfbd8982b33e' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 15833, i: 0 }) },
          'too many chunks to print, use verbose if you want to force print'
        ],
        tags: [
          {
            tag: 'Ohio',
            min: { containerKey: '10000000', eventId: MinKey() },
            max: { containerKey: '11000000', eventId: MinKey() }
          },
          {
            tag: 'West',
            min: { containerKey: '8000000' },
            max: { containerKey: '9000000' }
          },
          {
            tag: 'East',
            min: { containerKey: '9000000', eventId: MinKey() },
            max: { containerKey: '9999999', eventId: MinKey() }
          }
        ]
      },
      'PM_AUDIT.AUDIT_MSG': {
        shardKey: { containerKey: 1, eventId: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 461 },
          { shard: 'Ohio', nChunks: 460 },
          { shard: 'West', nChunks: 460 }
        ],
        chunks: [
          { min: { containerKey: MinKey(), eventId: MinKey() }, max: { containerKey: 8000000, eventId: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 296, i: 0 }) },
          { min: { containerKey: 8000000, eventId: MinKey() }, max: { containerKey: 9000000, eventId: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 294, i: 1 }) },
          { min: { containerKey: 9000000, eventId: MinKey() }, max: { containerKey: 10000000, eventId: MinKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 300, i: 1 }) },
          { min: { containerKey: 10000000, eventId: MinKey() }, max: { containerKey: 11000000, eventId: MinKey() }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 295, i: 1 }) },
          { min: { containerKey: 11000000, eventId: MinKey() }, max: { containerKey: '8000001', eventId: '00551f92-14b5-4718-9d9a-edf233d22eab' }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 297, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '00551f92-14b5-4718-9d9a-edf233d22eab' }, max: { containerKey: '8000001', eventId: '00ad8d01-82bc-47a7-ae60-5b2e07f76f1b' }, 'on shard': 'West', 'last modified': Timestamp({ t: 298, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '00ad8d01-82bc-47a7-ae60-5b2e07f76f1b' }, max: { containerKey: '8000001', eventId: '01083304-1639-443e-922e-ae30cc2e8001' }, 'on shard': 'West', 'last modified': Timestamp({ t: 299, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '01083304-1639-443e-922e-ae30cc2e8001' }, max: { containerKey: '8000001', eventId: '0164ce9f-8bda-4ecc-9bb8-f8bf1ad5345b' }, 'on shard': 'West', 'last modified': Timestamp({ t: 300, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '0164ce9f-8bda-4ecc-9bb8-f8bf1ad5345b' }, max: { containerKey: '8000001', eventId: '01c0d294-549f-4185-9346-8d4717d33b70' }, 'on shard': 'East', 'last modified': Timestamp({ t: 230, i: 2 }) },
          { min: { containerKey: '8000001', eventId: '01c0d294-549f-4185-9346-8d4717d33b70' }, max: { containerKey: '8000001', eventId: '021f7995-1dfd-44a8-a009-2d2f710be043' }, 'on shard': 'East', 'last modified': Timestamp({ t: 230, i: 3 }) },
          { min: { containerKey: '8000001', eventId: '021f7995-1dfd-44a8-a009-2d2f710be043' }, max: { containerKey: '8000001', eventId: '027a908e-9c12-487e-847c-33d37274420a' }, 'on shard': 'East', 'last modified': Timestamp({ t: 231, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '027a908e-9c12-487e-847c-33d37274420a' }, max: { containerKey: '8000001', eventId: '02d58d06-cdab-4b8c-b29c-3a28b4bdfaf5' }, 'on shard': 'East', 'last modified': Timestamp({ t: 233, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '02d58d06-cdab-4b8c-b29c-3a28b4bdfaf5' }, max: { containerKey: '8000001', eventId: '032e0480-c9a2-4bd1-8df5-1f0d4b19a3a6' }, 'on shard': 'East', 'last modified': Timestamp({ t: 232, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '032e0480-c9a2-4bd1-8df5-1f0d4b19a3a6' }, max: { containerKey: '8000001', eventId: '038a5918-b34c-4d14-a838-6910a2300817' }, 'on shard': 'East', 'last modified': Timestamp({ t: 239, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '038a5918-b34c-4d14-a838-6910a2300817' }, max: { containerKey: '8000001', eventId: '03e7ecdb-e2be-414b-8aff-c31d8830dded' }, 'on shard': 'East', 'last modified': Timestamp({ t: 240, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '03e7ecdb-e2be-414b-8aff-c31d8830dded' }, max: { containerKey: '8000001', eventId: '04418d54-559f-462b-8b97-e92f3ebf2faa' }, 'on shard': 'East', 'last modified': Timestamp({ t: 241, i: 0 }) },
          { min: { containerKey: '8000001', eventId: '04418d54-559f-462b-8b97-e92f3ebf2faa' }, max: { containerKey: '8000001', eventId: '049bbc7c-97d0-441e-8410-cb53c1c05640' }, 'on shard': 'East', 'last modified': Timestamp({ t: 235, i: 2 }) },
          { min: { containerKey: '8000001', eventId: '049bbc7c-97d0-441e-8410-cb53c1c05640' }, max: { containerKey: '8000001', eventId: '04f87b19-97d3-4525-8326-c29dda492f33' }, 'on shard': 'East', 'last modified': Timestamp({ t: 235, i: 3 }) },
          { min: { containerKey: '8000001', eventId: '04f87b19-97d3-4525-8326-c29dda492f33' }, max: { containerKey: '8000001', eventId: '0554e484-d8b1-4321-8363-bc5762658d64' }, 'on shard': 'East', 'last modified': Timestamp({ t: 236, i: 2 }) },
          { min: { containerKey: '8000001', eventId: '0554e484-d8b1-4321-8363-bc5762658d64' }, max: { containerKey: '8000001', eventId: '05b0e445-9c37-46ec-8aa8-1cb74544391f' }, 'on shard': 'East', 'last modified': Timestamp({ t: 236, i: 3 }) },
          'too many chunks to print, use verbose if you want to force print'
        ],
        tags: [
          {
            tag: 'West',
            min: { containerKey: 8000000, eventId: MinKey() },
            max: { containerKey: 9000000, eventId: MinKey() }
          },
          {
            tag: 'East',
            min: { containerKey: 9000000, eventId: MinKey() },
            max: { containerKey: 10000000, eventId: MinKey() }
          },
          {
            tag: 'Ohio',
            min: { containerKey: 10000000, eventId: MinKey() },
            max: { containerKey: 11000000, eventId: MinKey() }
          }
        ]
      }
    }
  }
]

Renato_Riccio · May 28, 2025, 9:23am

In order to update the zone you can use updateZoneKeyRange for each one of the collection.

The steps would be:

stop the balancer
remove the East zone for the collection.
Associate the former “East” zone to “West”
Enable the balancer

Here an example:

sh.stopBalancer()
sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: 9000000, eventId: MinKey() }, {containerKey: 10000000, eventId: MinKey() },null)
sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: 9000000, eventId: MinKey() }, {containerKey: 10000000, eventId: MinKey() },"West")
sh.startBalancer()

Please test these steps in your test environment before.

Additional note, I notice you are using 6.0. This version will be EOL in the end of July 2025.

We strongly reccomend to upgrade to a supported version before that date, ideally you should upgrade to 8.0 that comes with several new functionalities and performance improvements.

Fory_Horio1 · May 28, 2025, 4:25pm

What happens to the data when I remove the East zone in step #2? I’d like to keep the current data.

Renato_Riccio · May 28, 2025, 8:25pm

In step #2 updateZoneKeyRange will only remove the metadata information about Zone “East”, in step #3 you will associate the range to Zone “West” and the balancer will take care of moving the data accordingly when you enable the balancer back in step #4.

I strongly recommend you to try the procedure in a test environment to get familiar with it before applying it to your cluster.

Fory_Horio1 · May 28, 2025, 11:56pm

OK, the below worked. But I am still seeing the data in East.

[direct: mongos] METRIC_RAW_DATA> sh.stopBalancer()
{
  ok: 1,
  '$clusterTime': {
    clusterTime: Timestamp({ t: 1748476339, i: 1 }),
    signature: {
      hash: Binary.createFromBase64('/yqyUol1gpoLYnKmqBdnrLMpf5c=', 0),
      keyId: Long('7469301375919194116')
    }
  },
  operationTime: Timestamp({ t: 1748476339, i: 1 })
}
[direct: mongos] METRIC_RAW_DATA> sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: 9000000, _id: MinKey() }, {containerKey: 9999999, _id: MinKey() },null)
{
  ok: 1,
  '$clusterTime': {
    clusterTime: Timestamp({ t: 1748476342, i: 11 }),
    signature: {
      hash: Binary.createFromBase64('u11yiaOCc7O4VbLZX8FOBGJi4OA=', 0),
      keyId: Long('7469301375919194116')
    }
  },
  operationTime: Timestamp({ t: 1748476342, i: 11 })
}
[direct: mongos] METRIC_RAW_DATA> sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: 9000000, _id: MinKey() }, {containerKey: 10000000, _id: MinKey() },"West")
{
  ok: 1,
  '$clusterTime': {
    clusterTime: Timestamp({ t: 1748476354, i: 5 }),
    signature: {
      hash: Binary.createFromBase64('qGfCpd8DC4wuap6YeBreeCLCLyE=', 0),
      keyId: Long('7469301375919194116')
    }
  },
  operationTime: Timestamp({ t: 1748476354, i: 5 })
}
[direct: mongos] METRIC_RAW_DATA> sh.startBalancer()
{
  ok: 1,
  '$clusterTime': {
    clusterTime: Timestamp({ t: 1748476360, i: 4 }),
    signature: {
      hash: Binary.createFromBase64('ODwwQ9DWhnprci0Qvk23ytoCEwE=', 0),
      keyId: Long('7469301375919194116')
    }
  },
  operationTime: Timestamp({ t: 1748476360, i: 4 })
}
[direct: mongos] METRIC_RAW_DATA> db.OPERATIONAL_METRIC.getShardDistribution()
Shard East at East/mone1.smk.env.akana.com:27017,mone2.smk.env.akana.com:27017,mone3.smk.env.akana.com:27017
{
  data: '51KiB',
  docs: 34,
  chunks: 4,
  'estimated data per chunk': '12KiB',
  'estimated docs per chunk': 8
}
---
Shard West at West/monw1.smk.env.akana.com:27017,monw2.smk.env.akana.com:27017,monw3.smk.env.akana.com:27017
{
  data: '34KiB',
  docs: 23,
  chunks: 7,
  'estimated data per chunk': '4KiB',
  'estimated docs per chunk': 3
}
---
Shard Ohio at Ohio/mon1oh.smk.env.akana.com:27017,mon2oh.smk.env.akana.com:27017,mon3oh.smk.env.akana.com:27017
{
  data: '6KiB',
  docs: 4,
  chunks: 1,
  'estimated data per chunk': '6KiB',
  'estimated docs per chunk': 4
}
---
Totals
{
  data: '92KiB',
  docs: 61,
  chunks: 12,
  'Shard East': [
    '55.51 % data',
    '55.73 % docs in cluster',
    '1KiB avg obj size on shard'
  ],
  'Shard West': [
    '37.48 % data',
    '37.7 % docs in cluster',
    '1KiB avg obj size on shard'
  ],
  'Shard Ohio': [
    '6.99 % data',
    '6.55 % docs in cluster',
    '1KiB avg obj size on shard'
  ]
}
[direct: mongos] METRIC_RAW_DATA> db.OPERATIONAL_METRIC.getShardDistribution()
Shard East at East/mone1.smk.env.akana.com:27017,mone2.smk.env.akana.com:27017,mone3.smk.env.akana.com:27017
{
  data: '51KiB',
  docs: 34,
  chunks: 4,
  'estimated data per chunk': '12KiB',
  'estimated docs per chunk': 8
}
---
Shard West at West/monw1.smk.env.akana.com:27017,monw2.smk.env.akana.com:27017,monw3.smk.env.akana.com:27017
{
  data: '34KiB',
  docs: 23,
  chunks: 7,
  'estimated data per chunk': '4KiB',
  'estimated docs per chunk': 3
}
---
Shard Ohio at Ohio/mon1oh.smk.env.akana.com:27017,mon2oh.smk.env.akana.com:27017,mon3oh.smk.env.akana.com:27017
{
  data: '6KiB',
  docs: 4,
  chunks: 1,
  'estimated data per chunk': '6KiB',
  'estimated docs per chunk': 4
}
---
Totals
{
  data: '92KiB',
  docs: 61,
  chunks: 12,
  'Shard East': [
    '55.51 % data',
    '55.73 % docs in cluster',
    '1KiB avg obj size on shard'
  ],
  'Shard West': [
    '37.48 % data',
    '37.7 % docs in cluster',
    '1KiB avg obj size on shard'
  ],
  'Shard Ohio': [
    '6.99 % data',
    '6.55 % docs in cluster',
    '1KiB avg obj size on shard'
  ]
}

Fory_Horio1 · May 29, 2025, 3:06am

FYI, the sh.status() now shows

 {
    database: {
      _id: 'METRIC_RAW_DATA',
      primary: 'East',
      partitioned: true,
      version: {
        uuid: UUID('128add24-9a71-42ac-b980-d7f4df17b51f'),
        lastMod: 1,
        timestamp: Timestamp({ t: 1719866456, i: 8 })
      }
    },
    collections: {
      'METRIC_RAW_DATA.OPERATIONAL_METRIC': {
        shardKey: { containerKey: 1, _id: 1 },
        unique: false,
        balancing: true,
        chunkMetadata: [
          { shard: 'East', nChunks: 4 },
          { shard: 'Ohio', nChunks: 1 },
          { shard: 'West', nChunks: 7 }
        ],
        chunks: [
          { min: { containerKey: MinKey(), _id: MinKey() }, max: { containerKey: 9000000, _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 8 }) },
          { min: { containerKey: 9000000, _id: MinKey() }, max: { containerKey: 10000000, _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 9 }) },
          { min: { containerKey: 10000000, _id: MinKey() }, max: { containerKey: '10000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 10 }) },
          { min: { containerKey: '10000000', _id: MinKey() }, max: { containerKey: '11000000', _id: MinKey() }, 'on shard': 'Ohio', 'last modified': Timestamp({ t: 8, i: 0 }) },
          { min: { containerKey: '11000000', _id: MinKey() }, max: { containerKey: '8000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 7, i: 3 }) },
          { min: { containerKey: '8000000', _id: MinKey() }, max: { containerKey: '8000001', _id: ObjectId('62498d5e7c0d6b5d3e7a19a9') }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 2 }) },
          { min: { containerKey: '8000001', _id: ObjectId('62498d5e7c0d6b5d3e7a19a9') }, max: { containerKey: '8000002', _id: ObjectId('62477d4d7c0d6b5d3e7a0b8b') }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 3 }) },
          { min: { containerKey: '8000002', _id: ObjectId('62477d4d7c0d6b5d3e7a0b8b') }, max: { containerKey: '9000000', _id: MinKey() }, 'on shard': 'West', 'last modified': Timestamp({ t: 8, i: 4 }) },
          { min: { containerKey: '9000000', _id: MinKey() }, max: { containerKey: '9000001', _id: ObjectId('624ab364da1b434b9d11e031') }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 5 }) },
          { min: { containerKey: '9000001', _id: ObjectId('624ab364da1b434b9d11e031') }, max: { containerKey: '9000002', _id: ObjectId('62435420da1b434b9d11aa72') }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 6 }) },
          { min: { containerKey: '9000002', _id: ObjectId('62435420da1b434b9d11aa72') }, max: { containerKey: '9999999', _id: MinKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 8, i: 7 }) },
          { min: { containerKey: '9999999', _id: MinKey() }, max: { containerKey: MaxKey(), _id: MaxKey() }, 'on shard': 'East', 'last modified': Timestamp({ t: 7, i: 0 }) }
        ],
        tags: [
          {
            tag: 'West',
            min: { containerKey: 9000000, _id: MinKey() },
            max: { containerKey: 10000000, _id: MinKey() }
          },
          {
            tag: 'Ohio',
            min: { containerKey: '10000000', _id: MinKey() },
            max: { containerKey: '11000000', _id: MinKey() }
          },
          {
            tag: 'West',
            min: { containerKey: '8000000' },
            max: { containerKey: '9000000' }
          },
          {
            tag: 'East',
            min: { containerKey: '9000000', _id: MinKey() },
            max: { containerKey: '9999999', _id: MinKey() }
          }
        ]
      }
    }
  },

Renato_Riccio · May 29, 2025, 7:00am

In the sh.status shows that you still have a range on Est
You will need to do the same procedure for the range

         {
            tag: 'East',
            min: { containerKey: '9000000', _id: MinKey() },
            max: { containerKey: '9999999', _id: MinKey() }
          }

Fory_Horio1 · May 30, 2025, 11:43pm

I thought according to your post below command should remove the East???

sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: 9000000, _id: MinKey() }, {containerKey: 9999999, _id: MinKey() },null)

Do I need to execute this?

sh.removeRangeFromZone()

Fory_Horio1 · May 31, 2025, 12:31am

Also you indicated that stop and start balancer should move the data to new shard, but it didn’t.

Fory_Horio1 · June 2, 2025, 9:12pm

I didn’t realize that my containerKey was string ‘9999999’ not 9999999, I cut and pasted your post. Now I am ending up with

        tags: [
          {
            tag: 'West',
            min: { containerKey: 8000000, eventId: MinKey() },
            max: { containerKey: 9000000, eventId: MinKey() }
          },
          {
            tag: 'East',
            min: { containerKey: 9000000, eventId: MinKey() },
            max: { containerKey: 10000000, eventId: MinKey() }
          },
          {
            tag: 'Ohio',
            min: { containerKey: 10000000, eventId: MinKey() },
            max: { containerKey: 11000000, eventId: MinKey() }
          }
        ]

And can't merge the two West tags

sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: '8000000' }, {containerKey: '9000000' },null)
{
  ok: 1,
  '$clusterTime': {
    clusterTime: Timestamp({ t: 1748897099, i: 1 }),
    signature: {
      hash: Binary.createFromBase64('KEAbKzpJMTiPhFaVOGEyYROs4Ys=', 0),
      keyId: Long('7469301375919194116')
    }
  },
  operationTime: Timestamp({ t: 1748897099, i: 1 })
}
 
sh.updateZoneKeyRange("METRIC_RAW_DATA.OPERATIONAL_METRIC",{ containerKey: '8000000', _id: MinKey() }, {containerKey: '9999999', _id: MinKey() },"West")
MongoServerError[RangeOverlapConflict]: Zone range: { containerKey: "8000000", _id: MinKey } -->> { containerKey: "9999999", _id: MinKey }  on  West is overlapping with existing: { containerKey: "8000000", _id: MinKey } -->> { containerKey: "9000000", _id: MinKey }  on  West
 
Even though the first 'null' command shows "ok", when I check the sh.status() after the command was executed, the tag is still there and I can't remove it. 
 
 {
      tag: 'West',
         min: { containerKey: '8000000' },
         max: { containerKey: '9000000' }
 }