Informix Error -25899: Same index already exists on given BSON columns.
Cause and resolution
Same index already exists on given BSON columns.
This CREATE INDEX statement cannot be executed because an index on the given BSON columns with the same key parts already exists.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25899 fires when CREATE INDEX on BSON columns duplicates an existing index's key
parts — per the official guidance.
- An index with the same key parts already existing on the given BSON columns, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use the existing index instead of creating a duplicate, per the official guidance, or drop it first if a genuinely different index is needed.
Examples
N/A
No specific triggering statement is documented beyond a duplicate BSON-column index.
Diagnostic Checks
- Check
sysindexesfor an existing index on the same BSON columns/key parts, and use it, or drop it first if replacing it.
Related Errors / Related Topics
- -25898 — "The total size of the index exceeds 32767 bytes." A related index-size restriction, unrelated to duplication.
An index on the given BSON columns already existed with the same key parts — use the existing index, or drop it first.