home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT10790 Status: Geschlossen

INDEX REPACK WRITES ASSERT FAILURE EVEN IF IT SUCCEEDS

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* users of IDS 12.10                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.08.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList