Informix Error -12025: Smart Large Objects: Chunk not empty.
Cause and resolution
Smart Large Objects: Chunk not empty.
You attempted to drop a smart-large-object chunk that still contained data. The chunk was not dropped. To ensure that chunks you want to drop are empty, delete the rows that contain pointers to smart large objects in the chunk or remove the smart-large-object pointers in the rows.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12025 fires when a DROP targets a smart-large-object chunk that still contains data —
per the official guidance.
- A chunk targeted for drop that still contains data, per the official guidance — the direct, only cause; the chunk isn't dropped.
Solutions / Resolution
- Delete the rows that contain pointers to smart large objects in the chunk, per the official guidance, or
- Remove the smart-large-object pointers in those rows, per the official guidance, before retrying the drop.
Examples
N/A
No specific triggering statement is documented beyond dropping a chunk that still has data.
Diagnostic Checks
- Check for rows still holding smart-large-object pointers into this chunk, and clear them before retrying the drop.
Related Errors / Related Topics
- -12024 — "Smart Large Objects: Chunk dropped from sbspace." A related chunk-drop error, about referencing a chunk already mid-drop rather than one that's not yet empty.
A chunk targeted for drop still contains data — clear the smart-large-object pointers into it first.