suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download