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 |
|