validateDBMetadata

Definition

validateDBMetadata

The validateDBMetadata command checks that the stored metadata of a database or a collection is valid within a particular API version.

validateDBMetadata reports errors, but does not have the capability to fix errors.

Syntax

The command has the following syntax:

db.runCommand(
   {
     validateDBMetadata: 1,
     apiParameters: {
       version: <string>,
       strict: <boolean>,
       deprecationErrors: <boolean>
      },
     db: <string>,
     collection: <string>,
   }
)

Command Fields

The command takes the following fields:

Behavior

• Validate all collections in all databases, reporting APIStrictError and APIVersionError error responses.

  db.runCommand( {
    validateDBMetadata: 1,
    apiParameters: {
      version: "1",
      strict: true,
      deprecationErrors: true
    },
  })

• Validate all collections in inventory:

  db.runCommand( {
    validateDBMetadata: 1,
    apiParameters: {
      version: "1",
      strict: true,
      deprecationErrors: true
    },
    db: "inventory",
  })

• Validate the sales collection in the inventory database:

  db.runCommand( {
    validateDBMetadata: 1,
    apiParameters: {
      version: "1",
      strict: true,
      deprecationErrors: true
    },
    db: "inventory",
    collection: "sales",
  })

• Validate any and all sales collections across all databases:

  db.runCommand( {
    validateDBMetadata: 1,
    apiParameters: {
      version: "1",
      strict: true,
      deprecationErrors: true
    },
    collection: "sales",
  })

Output

{
   apiVersionErrors: [
     {
       ns: <string>,
       code: <int>,
       codeName: <string>,
       errmsg: <string>
     }
   ],
   ok: <int>,
   hasMoreErrors: <boolean>,
}

validateDBMetadata.apiVersionErrors

Array of documents describing API Version errors.

validateDBMetadata.apiVersionErrors[n].ns

Namespace of the collection or view with error.

validateDBMetadata.apiVersionErrors[n].code

Numeric error code.

validateDBMetadata.apiVersionErrors[n].codeName

Name of the error code.

validateDBMetadata.apiVersionErrors[n].errmsg

String describing the error.

validateDBMetadata.ok

If the command fails, ok is set to 1. Otherwise, ok is set to 0. validateDBMetadata.ok may have a value of 0 and still report validation errors.

validateDBMetadata.hasMoreErrors

If true, there are additional errors.

Example

Use the sample Query API code to create a sales collection in mongosh:

db.sales.insertMany([
    { "_id" : 1, "item" : "shoes", "price" : 10, "quantity" : 2, "date" : ISODate("2021-01-01T08:00:00Z") },
    { "_id" : 2, "item" : "hat", "price" : 20, "quantity" : 1, "date" : ISODate("2021-02-03T09:00:00Z") },
    { "_id" : 3, "item" : "gloves", "price" : 5, "quantity" : 5, "date" : ISODate("2021-02-03T09:05:00Z") },
    { "_id" : 4, "item" : "pants", "price" : 10, "quantity" : 10, "date" : ISODate("2021-02-15T08:00:00Z") },
    { "_id" : 5, "item" : "socks", "price" : 5, "quantity" : 10, "date" : ISODate("2021-02-15T09:05:00Z") },
    { "_id" : 6, "item" : "shirt", "price" : 5, "quantity" : 5, "date" : ISODate("2021-02-15T12:05:10Z") },
    { "_id" : 7, "item" : "belt", "price" : 5, "quantity" : 10, "date" : ISODate("2021-02-15T14:12:12Z") },
    { "_id" : 8, "item" : "blouse", "price" : 10, "quantity" : 5, "date" : ISODate("2021-03-16T20:20:13Z") }
])

Add a text index on the item field.

db.sales.createIndex( { item: "text" } )

Validate the sales collection for strict compliance with API version 1 and include deprecationErrors in the output.

db.runCommand( {
  validateDBMetadata: 1,
  apiParameters: {
    version: "1",
    strict: true,
    deprecationErrors: true
  },
  collection: "sales",
})

validateDBMetadata reports an APIStrictError on the item_text index.

{
   apiVersionErrors: [
     {
       ns: 'test.sales',
       code: 323,
       codeName: 'APIStrictError',
       errmsg: 'The index with name item_text is not allowed in API version 1.'
     }
   ],
   ok: 1,
   hasMoreErrors: false,
}