Informix Error -12233: Alter in progress on partition.
Cause and resolution
Alter in progress on partition.
The partition is being altered. The session could not obtain access to the requested table or index because it has been opened exclusively by another user. This condition is normally transient, retry operation after some delay.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12233 fires when a session can't access a table/index because another user has it open exclusively for an alter — per the official guidance.
- The partition being altered, with the session unable to obtain access because another user has opened it exclusively, per the official guidance — the direct, only cause; normally transient.
Solutions / Resolution
- Retry the operation after some delay, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond accessing a table/index mid-alter.
Diagnostic Checks
- Retry the operation after a short delay; if it persists, check for a long-running alter operation on the target partition.
Related Errors / Related Topics
- -12234 — "Partition has been altered." A related partition-alter condition, about a DML operation referencing a stale data-dictionary copy after an alter completed, rather than one still in progress.
A partition is being altered by another session — retry the operation after a short delay.