Informix Error -12120: Smart Large Objects: Duplicate key encountered in sbspace create.
Cause and resolution
Smart Large Objects: Duplicate key encountered in sbspace create.
During the creation of an sbspace, it was noticed that the sbspace number was the same as some other sbspace number. The most common cause of the problem is failure to create an sbspace in an earlier attempt.
Rebooting the database server will remove the entry from the internal table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12120 fires when an sbspace create notices its sbspace number matches an existing one — per the official guidance.
- A failed earlier attempt to create an sbspace leaving a stale internal-table entry, per the official guidance — the most common named cause.
Solutions / Resolution
- Reboot the database server to remove the stale entry from the internal table, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a duplicate sbspace number from a failed prior attempt.
Diagnostic Checks
- Check for a prior failed sbspace-create attempt, and reboot the database server to clear the stale internal-table entry.
Related Errors / Related Topics
- -12121 — "Smart Large Objects: The sbspace is flagged as dropped." A related sbspace-lifecycle error, about acting on an sbspace being dropped rather than a duplicate create.
- -12122 — "Smart Large Objects: drop of the sbspace chunk is already occurring." A related sbspace-lifecycle error, about a conflicting concurrent drop rather than a duplicate create.
An sbspace create found a duplicate sbspace number, likely from a failed earlier attempt — reboot the server to clear the stale entry.