Informix - Problem description
Problem IT17540 | Status: Closed |
CREATE A FORIEGN KEY INDEX ON FOT PRIMARY KEY INDEXES CAUSES ERROR -245/105 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When a database has 2 tables with a primary key based on a FOT index an attempt to create an FK constraint between the 2 tables will fail with alter table uno add constraint (foreign key (kk) references dos constraint ix0_uno); 245: Could not position within a file via an index. 102: ISAM error: illegal argument to ISAM function. Error in line 2 Near character position 37 10:51:14 Assert Failed: item_to_hashval called with improper item 10:51:14 IBM Informix Dynamic Server Version 12.10.FC6 10:51:14 Who: Session(79, informix@server, 7641, 0x4a9bc340) Thread(114, sqlexec, 4a97ac28, 1) File: rsshash.c Line: 74 10:51:14 stack trace for pid 5286 written to /opt/informix/12.10.FC6/tmp/af.45a9c81 10:51:14 See Also: /opt/informix/12.10.FC6/tmp/af.45a9c81 10:51:16 item_to_hashval called with improper item 10:51:16 Assert Failed: Page Check Error in btposition:bad btree node 10:51:16 IBM Informix Dynamic Server Version 12.10.FC6 10:51:16 Who: Session(79, informix@server, 7641, 0x4a9bc340) Thread(114, sqlexec, 4a97ac28, 1) File: rsdebug.c Line: 1142 10:51:16 Results: Possible inconsistencies in index 'a:"holgerk".uno#ix0_uno' 10:51:16 Action: Run 'oncheck -cI a:"holgerk".uno#ix0_uno' 10:51:16 stack trace for pid 5286 written to /opt/informix/12.10.FC6/tmp/af.45a9c81 10:51:16 See Also: /opt/informix/12.10.FC6/tmp/af.45a9c81 10:51:18 Page Check Error in btposition:bad btree node 10:53:16 Checkpoint Completed: duration was 0 seconds. (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) item_to_hashval (oninit) btrootnode (oninit) btposition (oninit) kposition (oninit) rsstart (oninit) fmstart (oninit) chkintegrity (oninit) perform_alter (oninit) ddalter (oninit) aud_ddalter (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users creating Foreign Keys based on Forest of Trees Index * * in the referenced table. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS 12.10.FC9 when available * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.10.2016 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.FC9 | |
Problem solved according to the fixlist(s) of the following version(s) |