Symptom
Suddenly IQ became crash during a delete operation. After the problem was detected, customer checked the consistency of the table which was to be deleted
via sp_iqcheckdb with check mode and found inconsistency in the table. Customer tried to rebuild these 2 inconsistent FP indexes by running sp_iqrebuildindex and succeeded.
After rebuilding these problematic FP indexes, no more errors reported by rerunning sp_iqcheckdb.
Customer succeeded to execute the delete operation which had made IQ server to crash.
[ Imqsg & stack ]
I. 02/02 13:16:36. 0001073510 IQ Internal Error Detected: Memory Corruption
...
I. 02/02 13:16:36. 0001073510 *** SAP IQ Abort:
I. 02/02 13:16:36. 0001073510 *** From: oslib/hos_mem.cxx:259
...
I. 02/02 13:39:23. 0000000014 DBCC: ERROR - Byte FP lookup table inconsistency, lookupCount[0]=832441110 <> barrayCount=832359189.
...
I. 02/02 13:39:23. 0000000014 DBCC: Statistics check detected exception from INDEX { sta_admin.TWJHC201.ASIQ_IDX_T1005_C3_FP }
I. 02/02 13:26:55. 0001073510 ***************** This is the STACKTRACE ***************
===== Thread Number 1299 (IQ connID: 0001073510) =====
... hos_ABORTPKcjRK13hos_exceptionPcS4_ + 0x520 at oslib/hos_abrt.cxx:284 ...
... ThrowRK13hos_exception + 0x140 at oslib/hos_throw.cxx:131 ...
... hos_mem10TestFencesEv at oslib/hos_mem.cxx:251
... hos_mem19CheckFencesAndThrowEv + 0x110 at oslib/hos_mem.cxx:256 ...
... hos_memmgr10FreeHosMemEPv + 0x80 at oslib/hos_mem.cxx:391 ...
... Pv at oslib/hos_mem.cxx:639
... aPv + 0x50 at oslib/hos_mem.cxx:627 ...
... s_lookupContextD1Ev + 0x50 at slib/s_dpidxfetch.cxx:2493 ...
... hs_dp10DeleteNBitEPK4s_bmi + 0x380 at slib/s_dpidx.cxx:1840 ...
...
Read more...
Environment
SAP IQ 16.0 SP08.x
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview