Informix Error -12122: Smart Large Objects: drop of the sbspace chunk is already occurring.
Cause and resolution
Smart Large Objects: drop of the sbspace chunk is already occurring.
You are probably attempting an operation that might be in conflict with a chunk drop operation that is already occurring (for example, trying to drop a chunk when sbspace is being dropped). Retry the operation later.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12122 fires when an operation conflicts with a chunk-drop already in progress — per the official guidance.
- A concurrent chunk-drop operation (for example, dropping a chunk while its sbspace is also being dropped), per the official guidance — the direct, only cause.
Solutions / Resolution
- Retry the operation later, per the official guidance, once the concurrent drop completes.
Examples
N/A
No specific triggering statement is documented beyond a conflict with an in-progress chunk drop.
Diagnostic Checks
- Check for a concurrent chunk-drop or sbspace-drop operation, and retry once it completes.
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 conflicting drop.
- -12121 — "Smart Large Objects: The sbspace is flagged as dropped." A related sbspace-lifecycle error, about the sbspace as a whole being dropped rather than specifically its chunk.
The operation conflicted with a chunk-drop already in progress — retry once it completes.