Informix Error -25845: An online operation is already in progress on this table.
Cause and resolution
An online operation is already in progress on this table.
The following online operations are possible on a table: - online create index - online drop index - online alter fragment Only one of the above online operations can be performed on a table at a time. Wait until the first online operation is complete before reissuing another online command.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25845 fires when a second online operation (CREATE INDEX ONLINE, DROP INDEX ONLINE,
or ALTER FRAGMENT ONLINE) is issued against a table that already has one in
progress — per the official guidance, only one of these three can run on a table at a
time.
- A second online operation issued while one is already running on the same table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Wait until the first online operation completes, per the official guidance, before reissuing another online command.
Examples
N/A
No specific triggering statement is documented beyond overlapping online operations on the same table.
Diagnostic Checks
- Check whether an online create-index, drop-index, or alter-fragment operation is already running on the table, and wait for it to finish.
Related Errors / Related Topics
- -25834 — "The specified alter fragment operation cannot be performed online." A related online-operation error, on operation support/preconditions rather than concurrency.
An online operation was already in progress on the table — wait for it to finish before issuing another.