Symptom
After applying SP08 PL27, IQ got crashed many times when running sp_iqcheckdb() atainst the all FP indexes in the database.
Sometimes, a stacktrace was generated, but nothing logged.
[ 1st Crash ]
** srvlog
I. 03/24 11:19:37. <,10611,PREPARE,call "sp_iqcheckdb"('check index OWNER001.TAB001.ASIQ_IDX_T1005_C65_FP')
I. 03/24 11:19:37. >,10611,PREPARE,393269
I. 03/24 11:19:37. <,10611,OPEN,393269
** message log
I. 03/24 11:21:06. 0000166346 *** SAP IQ Abort:
I. 03/24 11:21:06. 0000166346 *** From: stcxtlib/st_server.cxx:1709
** stacktrace
---- Signal 11 (SIGSEGV) delivered ----
_ZN13v2s_bmcontext29PositionPartitionReadIteratorEy + .....
_ZN13v2s_bmcontext20TestBitAndRepositionEyi + .....
_ZN16s_bmFastROCursor7FindBitEy + .....
_ZN15s_bArrayLocater15DbccCheckRidMapEP9hs_xstatsPK4s_bmRPyisR12s_bmOrCursor + .....
_ZN15s_bArrayLocater9DbccCheckEP9hs_xstatsPK4s_bmRPyis + .....
_ZNK5hs_dp22GatherStatisticsFPVer4EP9hs_xstats + .....
_ZNK5hs_dp16GatherStatisticsEP9hs_xstats + .....
_ZN11db_IndexDef16GatherStatisticsEP9hs_xstats + .....
_ZN13db_StatisticsC1ER10hdb_catObjP9hs_xstatsP11db_dbccIteri + .....
_ZN11db_dbccIter8ExecWorkERij + .....
[ 2nd Crash ]
** srvlog
I. 03/24 13:50:31. <,5,PREPARE,call "sp_iqcheckdb"('check index OWNER001.TAB001.ASIQ_IDX_T1005_C65_FP')
I. 03/24 13:50:31. >,5,PREPARE,327703
I. 03/24 13:50:31. <,5,OPEN,327703
** message log
I. 03/24 13:52:09. 0000000024 *** SAP IQ Abort:
I. 03/24 13:52:09. 0000000024 *** From: stcxtlib/st_server.cxx:1709
I. 03/24 13:52:09. 0000000024 ** While handling one abort, caught signal 11, program abort on thread 1333 (TID 1324)
** stacktrace
---- Signal 11 (SIGSEGV) delivered ----
_ZN10s_blockmap20FindAndMakeDirtiableEysi + .....
_ZN16s_pageListCursor12PositionPageEy + .....
_ZNK16s_pageListCursor15LogicalBlockNumEv .....
_ZN13v2s_bmcontext14bmlfblkselfgetEv + .....
_ZN13v2s_bmcontext11bmselfunionEP4s_bmPKyii + .....
_ZN4s_bm12SetBitsIfOffEPKyjji + .....
_ZN16s_bmRWCursorBase11BulkSetBitsEi + .....
_ZN5hs_dp15InProbeRowRangeEPK7s_phashR12s_bmSBCursorR16s_bmFastROCursorP10hs_dpfetchPvyyP18s_indexFindContext.....
_ZN14vpp_PWUContext13DoOneWorkunitEv + .....
_ZN6vpp_In15ExecuteFindHashEv + .....
_ZN6vpp_In11ExecuteOpusEv + .....
_ZN3vpp7ExecuteEPP4s_bmPKS0_S4_10hos_boolop + .....
_ZN11vpp_Boolean11ExecuteOpusEv + .....
_ZN3vpp7ExecuteEPP4s_bmPKS0_S4_10hos_boolop + .....
_ZN12vpp_Combiner8ExecWorkERij + .....
Read more...
Environment
SAP IQ 16 SP08.27
Product
Keywords
SAP IQ, IQ, crash, sp_iqcheckdb, stcxtlib/st_server, _ZN13v2s_bmcontext29PositionPartitionReadIteratorEy, s_bmcontext, PositionPartitionReadIterator, _ZN10s_blockmap20FindAndMakeDirtiableEysi, FindAndMakeDirtiable , 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.