Informix Error -12121: Smart Large Objects: The sbspace is flagged as dropped.
Cause and resolution
Smart Large Objects: The sbspace is flagged as dropped.
You are attempting an operation on an sbspace that someone else is trying to drop. Perhaps they are using a forced drop command. Do not use sbspaces that are being dropped. The force drop allows you to drop an sbspace that contains data.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12121 fires when an operation targets an sbspace someone else is dropping — per the official guidance.
- A concurrent forced drop command on the same sbspace, per the official guidance — the direct, likely cause.
Solutions / Resolution
- Don't use sbspaces that are being dropped, per the official guidance — a force drop allows dropping an sbspace that still contains data, so this can happen without warning to other sessions.
Examples
N/A
No specific triggering statement is documented beyond acting on an sbspace mid-force-drop.
Diagnostic Checks
- Check whether the target sbspace is currently being dropped (possibly via a forced drop) before retrying the operation.
Related Errors / Related Topics
- -12120 — "Smart Large Objects: Duplicate key encountered in sbspace create." A related sbspace-lifecycle error, about a stale create-attempt entry rather than a drop in progress.
- -12122 — "Smart Large Objects: drop of the sbspace chunk is already occurring." A related sbspace-lifecycle error, specific to a concurrent chunk-drop operation.
The target sbspace is flagged as dropped (likely via a forced drop elsewhere) — don't use sbspaces being dropped.