Informix - Problem description
Problem IT09007 | Status: Closed |
BAD INDEX ON HDR SECONDARY IN A COMBINED ER PRIMARY TARGET SYSTEM WITH ATTACHED HDR | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
In a combined ER primary target with an attached HDR secondary on the ER target occasionally Af files with "Error during recovery left index inconsistent" Messages occur. Afterward the indicated index is bad on the HDR secondary. On the HDR primary and the ER primary no errors occur. Message look like this : 03:17:30 Assert Warning: Error during recovery left index inconsistent. 03:17:30 IBM Informix Dynamic Server Version 12.10.FC1 03:17:30 Who: Session(19, informix@server, 0, 0x4b90e268) Thread(37, xchg_1.1, 4b8d1da8, 12) File: rskey.c Line: 1647 03:17:30 Results: Index 'test:"informix".ta_kmo_zu_ne#ux_kmozune_une' is now unusable 03:17:30 Action: Run 'oncheck -cI test:"informix".ta_kmo_zu_ne#ux_kmozune_une' 03:17:30 stack trace for pid 25333 written to /work/1210/tmp/af.40d46aa 03:17:30 See Also: /work/1210/tmp/af.40d46aa 03:17:31 Error during recovery left index inconsistent. 03:17:31 Rollforward of log record failed. iserrno = 100 03:17:31 Log Record: log = 18, pos = 0x9d9684, type = OLDRSAM:ADDITEM(28), trans = 3691395284195082276 03:17:31 Rollforward of log record failed. iserrno = 100 03:17:31 Log Record: log = 18, pos = 0x9d9684, type = OLDRSAM:ADDITEM(28), trans = 36 03:17:30 doadditem: Node 0x1, match 3 03:17:30 Could not add item, rowid 0x104, key: KEY:4961:"NE5": 03:17:30 Node Node 1 Root+Leaf Prev 0 Next 0 page 1:69227 sz 2048 flags b0 nslots 3 frcnt 1969 frptr 401 next 0 prev 0 Slot 1 sl_ptr 388 sl_len 13 sl_flags 0 :4961:"NE3": 10028d 103 Slot 2 sl_ptr 375 sl_len 13 sl_flags 0 :4961:"NE4": 10028d 102 Slot 3 sl_ptr 362 sl_len 13 sl_flags 0 :4961:"NE5": 10028d 101 ---------------------------------------------------------------- ------ 03:17:30 03:17:30 IBM Informix Dynamic Server Version 12.10.FC1 Software Serial Number AAA#B000000 03:17:30 Assert Warning: Error during recovery left index inconsistent. 03:17:30 Who: Session(19, informix@server, 0, 0x4b90e268) Thread(37, xchg_1.1, 4b8d1da8, 12) File: rskey.c Line: 1647 03:17:30 Results: Index 'test:"informix".ta_kmo_zu_ne#ux_kmozune_une' is now unusable 03:17:30 Action: Run 'oncheck -cI test:"informix".ta_kmo_zu_ne#ux_kmozune_une' 03:17:30 Raw hex dump of stack located in /work/1210/tmp/af.40d46aa.rawstk 03:17:30 Stack for thread: 37 xchg_1.1 (oninit) afstack (oninit) afhandler (oninit) afwarn_interface (oninit) kybad (oninit) plogredo (oninit) rlogm_redo (oninit) next_recvr (oninit) producer_thread (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 11.70.xC9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.05.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |