Informix Error -12131
-12131 Smart Large Objects: Metadata area in the chunk contains data.
During a chunk drop, the metadata area in the chunk was not empty. The metadata area must be empty for the chunk to be dropped without dropping the sbspace.
Try to empty the metadata area by deleting all the smart large objects in the chunk. If you do not want the smart large objects, you can also "force" drop the sbspace.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12131 fires when a chunk drop finds a non-empty metadata area — per the official guidance.
- The chunk's metadata area still holding data, per the official guidance — the direct, only cause; the metadata area must be empty for the chunk to drop without also dropping the sbspace.
Solutions / Resolution
- Delete all the smart large objects in the chunk to empty the metadata area, per the official guidance, or
- "Force" drop the sbspace instead, per the official guidance, if the objects aren't needed.
Examples
N/A
No specific triggering statement is documented beyond dropping a chunk with data still in its metadata area.
Diagnostic Checks
- Check for smart large objects still stored in the chunk's metadata area, and delete them or force-drop the sbspace.
Related Errors / Related Topics
- -12123 — "Smart Large Object: Metadata is full." A related metadata-area error, on running out of space rather than blocking a chunk drop.
A chunk drop found a non-empty metadata area — delete the objects in it, or force-drop the sbspace.