Oninit
Talk to an expert →

Informix Error -12123

-12123 Smart Large Object: Metadata is full.

The metadata area in the smart-large-object space has insufficient storage for a create or write request.

Delete some of the smart large objects or add a chunk with metadata space to the sbspace. Use the -Ms option of onspaces to add additional metadata space.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12123 fires when the metadata area in an sbspace has insufficient storage for a create or write request — per the official guidance.

  1. The sbspace's metadata area having insufficient free storage, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Delete some smart large objects, per the official guidance, or
  2. Add a chunk with metadata space to the sbspace, per the official guidance, using onspaces's -Ms option.
Examples
Adding metadata space to an sbspace
$ onspaces -a sbspace_name -p /path/to/chunk -o 0 -s 500000 -Ms
Diagnostic Checks
  1. Check the sbspace's metadata-area free space, and either delete objects or add metadata space via onspaces -Ms.
Related Errors / Related Topics
  • -12102 — "Smart Large Objects: A bad Meta Data Area was entered for the smart large object." A related metadata-area error, about an invalid size specified at sbspace creation rather than the area being full.

The sbspace's metadata area ran out of storage — delete objects or add metadata space via onspaces -Ms.