SAP Knowledge Base Article - Preview

2127258 - FP lookup table inconsistency & Memory corruption in IQ16 SP8.x

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

SAP Sybase IQ 15.4

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.