home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 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 IT10790 Status: Closed

INDEX REPACK WRITES ASSERT FAILURE EVEN IF IT SUCCEEDS

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
The index repack on a fragmented table succeeds but writes 
assert failure files: 
 
Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns 
blocked 1, Plog used 18432, Llog used 42859 
 
Assert Warning: Repack has attempted 1000 times to repack index 
ak_46989:"informix".miscari#ix_cont_fisa 
IBM Informix Dynamic Server Version 12.10.FC5W1 
Who: Session(36, informix@, 0, 0x44c3f0e0) 
                Thread(150, repack.2, 44bfb1e8, 1) 
                File: rsidxreorg.c Line: 1578 
 Results: Unable to complete repack of index because its too 
volatile. 
Action: Try running the repack operation when index is being 
updated less frequently. 
stack trace for pid 23044 written to 
/opt/informix/12.10.FC5W1/tmp/af.47e5ee2 
See Also: /opt/informix/12.10.FC5W1/tmp/af.47e5ee2 
Repack has attempted 1000 times to repack index 
ak_46989:"informix".miscari#ix_cont_fisa 
SCHAPI Repack succeeded for index 
'ak_46989:informix.ix_cont_fisa' partnum 400003. 
SCHAPI Shrink for ak_46989:informix.ix_cont_fisa started 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
200003 succeeded. 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
300003 succeeded. 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
400003 succeeded. 
SCHAPI index repack shrink  ak_46989:informix.ix_cont_fisa 
succeeded 
 
 (oninit) afstack 
 (oninit) afhandler 
 (oninit) afwarn_interface 
 (oninit) rsidxrepack 
 (oninit) fmrepack_idxfrag 
 (oninit) startup
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* users of IDS 12.10                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************
Local Fix:


Solution


Problem Fixed In IBM Informix Server 12.10.xC6


Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.08.2015
30.12.2015
30.12.2015


Problem solved at the following versions (IBM BugInfos)


12.10.xC6



Problem solved according to the fixlist(s) of the following version(s)


12.10.xC6

FixList