2277335 - SAP IQ 16 - LOAD into tiered HG results in index corruption and s_blockmap aborts | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2277335 - SAP IQ 16 - LOAD into tiered HG results in index corruption and s_blockmap aborts

Symptom

  • SAP IQ 16 multiplex environment loading data into a table with a tiered HG index, under certain rare conditions can result in an inconsistent index.

 

  • Running a sp_iqcheckdb verify will start to report Inconsistent Index and or Non-Completed Index errors.

 

  • Trying to update the table with the corrupt index can result in various s_blockmap  buffer manager errors , for example...
I. 04/21 05:55:14. 0000873324   The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
I. 04/21 05:55:14. 0000873324   from GetBlockmapEntryInfo
...
I. 04/21 05:55:14. 0000873324 Exception Thrown from slib/s_blockmap.cxx:3355, Err# 0, tid 5 origtid 5
I. 04/21 05:55:14. 0000873324    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
I. 04/21 05:55:14. 0000873324 [20521]: Internal state violation, please contact SAP IQ support
-- (slib/s_blockmap.cxx 3355)
  • Trying to drop or rebuild the damaged index can result in an abort at s_bloackmap and a stack at call to s_blockmap::DestroyAllMappedPages()
I. 04/21 14:20:42. 0000021627 ***   SAP IQ Abort:
I. 04/21 14:20:42. 0000021627 ***      From:  slib/s_blockmap.cxx:4641
I. 04/21 14:20:42. 0000021627 ***      PID: 26040
I. 04/21 14:20:42. 0000021627 ***      Message: Internal Erro
r
...
***************** This is the STACKTRACE **************

I. 04/21 14:20:43. 0000021627
===== Thread Number  199  (IQ connID: 0000021627) =====
I. 04/21 14:20:43. 0000021627 pc: 0x0 (0x0, 0xfffffd7ffd705a89)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe4371187 void DumpAllThreads(const char*,unsigned,int)+0x29f(0xfffffd7fe6b42e40, 0xfffffd7fe69eff50)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe4056cca void hos_ABORT(const char*,unsigned,const char*,char*,char*)+0x1a2(0x13e, 0x0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe443a9a4 void s_blockmap::DestroyAllMappedPages()+0x344(0xfffffd7fe43559a8, 0x13f50eacc8)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe4c06709 void hs_ohc::Destroy(s_CKInfo*,int)+0xf5(0xfffffd7fe9e79a20, 0xfffffd7fe432bfd4)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe404aee9 void opt_RebuildIndex::GenerateDFEs(df_Heap*,opt_QueryExp*)+0xd9(0x0, 0x0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe3f0aac2 dfo_Root*opt_Driver::GenerateTree(QueryNode*,st_cursor*,const a_statement*,UITable*,UIIndex*,s_bm*,unsigned*,db_RebuildIndexInfo**,int,a_table*,hos_vector_noerror*,hs_store*,int,db_IQParallelIndexInfo*,rv_MergeCmdState*)+0xeca(0x0, 0x13f54f78e8)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe51f6711 void db_RebuildIndex::Execute()+0xa9(0xfffffd7ff3b02a00, 0xfffffd7ffd7751c0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe4fd28b6 void st_command::DoCmdThroughResourceGate()+0x1c2(0xfffffd7fe6bc4d70, 0xc00000003)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe519095c unsigned db_iqddl::InternalFunction(UIConnection*,int,char*,char*)+0x48(0xfffffd7fe9e7cc20, 0xfffffd7fe9e7d290)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe3a0186b UIQDDL_InternalFunction+0x27(0xfffffd7fe9e7c068, 0xfffffd7fe9e7d290)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe502fa54 void st_SAIQInterfaceInfo::callFunction()+0x1c(0xfffffd7fe9e7c318, 0x13f8630fb8)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe50b4325 void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x28d(0x0, 0x0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe5030069 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)+0x259(0xfffffd7fe9e7d8e0, 0xfffffd7ffe118254)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7fe439497a void saint_iqthresholdddl::IQInternalFunction(IConnection*,int,char*,char*)+0xda(0xfffffd7ea0919060, 0xfffffd7ea8840420)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe04fa32 int iq_internalfunction(InternalProcCall&)+0x1fa(0xfffffd7fe9e7dc60, 0xfffffd7ffe0430e8)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe04317a void call_function(int(*)(InternalProcCall&),InternalProcCall&)+0x6a(0xfffffd7ea8740060, 0xfffffd7ea91208e0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe0434de void RunInternalProcedure(Connection*,a_context_ref*)+0x6a(0xfffffd7ea87a17f0, 0xfffffd7fe9e7dcf0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe0ecbbe void process_ext_int_remote_call(Connection*,a_context_ref*,unsigned,dfm_CallInfo*)+0x11e(0x0, 0xfffffd7fe9e7df80)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe0f4151 unsigned exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)+0x929(0xfffffd7fe9e7e630, 0xfffffd7ea2806ae0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe0f87e0 unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)+0xbcc(0xfffffd7ea91208e0, 0x1)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe0f9f70 unsigned dbi_resume_procedure(a_context_ref*,unsigned)+0xc8(0x0, 0x0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe19ba6b void do_cursor_execute(Connection*,a_stmt*)+0x667(0xfffffd7fe9e7ea10, 0xfffffd7ea2b6fc20)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe19c483 void db__execute_any_imm(Connection*,an_sqlpres_receive*)+0x19b(0x5e9e7eab0, 0x1ffe202418)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe1abd69 void RequestProcedure::call()+0x799(0x8000e9e700c0, 0x4bcbd8)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffdf493f1 void Context::call(Procedure*,Context**)+0xc5(0x5a5d351b0, 0xfffffd7fff1f99b0)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffdf4a195 void Worker::call_on_stack(Procedure*)+0x49(0xfffffd7fff22e680, 0xfffffd7fe9e7ed4c)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe1aca53 void TopProcedure::call()+0x43(0xfffffd7fe9e7ed50, 0x4bc800)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffdf4a0a3 int Worker::spawn(Procedure*)+0xc3(0x4bc, 0xfffffd01fe905f9c)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe1acd21 void EngStream::handle_ind(unsigned char,unsigned)+0x189(0x0, 0x4bc798)
I. 04/21 14:20:43. 0000021627 pc: 0xfffffd7ffe1ae1d2 void EngStream::execute()+0x52a(0xfffffd7fff365e98, 0x4bc800)
 

Read more...

Environment

SAP IQ 16 SP08.x any platform , multiplex environment , with tables having tiered HG indexes

Product

SAP IQ 16.0

Keywords

IQ16, Sybase, crash, checkdb, High Group, validate, insert , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.