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 |
