Informix - Problem description
Problem IT03029 | Status: Closed |
BAD INDEX ON HDR SECONDARY IN A COMBINED ER PRIMARY TARGET SYSTEM WITH ATTACHED HDR | |
product: | |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 | |
Problem description: | |
In a combined ER primary target with an attached HDR secondary on the ER target occasionally assert fails with "Error during recovery left index inconsistent" messages. Afterward the indicated index is bad on the HDR secondary. On the HDR primary and the ER primary no errors occur. Message looks 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@coelho, 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 IDS-12.10.xC5 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.07.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |