SAP Knowledge Base Article - Preview

2185333 - SAP IQ 16: ALTER TABLE ADD column cause IQ crash in s_dictionary::GetStrKey


This SQL: ALTER TABLE "T" ADD  "col" varchar(15) null
causes IQ crash in NBit dictionary with the stack trace below.

DBCC on the table returns no error.

    **  Error from IQ connection:  SA connHandle: 24  SA connID: 7  IQ connID: 0000009131  User: DBA   
    **  Time of error:  2015-05-25 20:37:19   
    **  IQ Version:  SAP IQ/16.0.0/150416/P/sp08.29   
    **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/hostname/2.6.32-358.el6.x86_64/#1 SMP Tue Jan 29 11:47:41 EST 2013/x86_64   
    **  Command status when error occured:  CURSOR ACTIVE   
    **  Command text: 
alter table "T" add  "col" varchar(15) null
Dump all thread stacks at stcxtlib/st_server.cxx:1707 for PID: 13140

    ***************** This is the STACKTRACE ***************

 ===== Thread Number  140059009853184  (IQ connID: 0000009131) =====
pc: 0x7f61fd7a03d2 hos_map<unsigned int, hos_oidEntry*, hos_less<unsigned int> >::hos_mapKTVTCompareTerminator(hos_map<unsigned int, hos_oidEntry*, hos_less<unsigned int> >*)+0x42
pc: 0x7f61fd7a0a41 __static_initialization_and_destruction_0(int, int)+0x25
pc: 0x7f61fd7a1c8e hos_dispatcher::hos_dispatcher(void (*)+0x50
pc: 0x7f61fd52e7ee opt_RebuildIndex::InitializeNestedQueries(opt_QueryExp*)+0xfe
pc: 0x7f61fe284d0f SigHndlr+0x4f
pc: 0x3f7aa0f500
pc: 0x7f61fe21eba2 s_dictionary::GetStrKey(unsigned int, unsigned char*&, short&)+0x12
pc: 0x7f61fe22ab31 s_dictionary::InsertKeyToHash(s_llhtable*, s_TokenCountTable*)+0x731
pc: 0x7f61fe22c30e s_dpNBit::Initialize(s_openmode, unsigned long, unsigned long, int)+0xf1e
pc: 0x7f61fd9c78a4 hs_dp::CreateDictionary(hs_vdo*)+0x64
pc: 0x7f61fd9ca160 hs_dp::hs_dp(db_IndexDef*, s_openmode, char const*, int, unsigned int, unsigned int, int)+0xdc0
pc: 0x7f61fe3350f7 db_IndexDef::OpenSIndexWithLock(unsigned int)+0x217
pc: 0x7f61fe493a56 db_IndexDef::OpenSIndex(unsigned int)+0x38e
pc: 0x7f61fe32f0e7 db_ColumnDef::FindIndexByType(an_indextype, s_index**)+0x87
pc: 0x7f61fd51fa16 opt_LoadTable::GenerateDFEs(df_Heap*, opt_QueryExp*)+0xe16
pc: 0x7f61fd77898a hos_sumAgg::hos_sumAgg(int)+0x4a
pc: 0x7f61fd79d754 hos_Deserializer::hos_Deserializer(unsigned char const*, int)+0x2f4
pc: 0x7f61fd773b41 hos_strcaseDBcmp(char const*, char const*, hos_dmcontext*)+0x11
pc: 0x7f61fd522f4f opt_InsertCreateFN()+0x3ff
pc: 0x7f61fd451a99 opt_BaseTableLeaf::IsDFPVertical(dfp*, double, int)+0x3f9
pc: 0x7f61fe33fd26 db_altertabledml::~db_altertabledml()+0x6
pc: 0x7f61fe236d72 st_command::DoCmdThroughResourceGate()+0x82
pc: 0x7f61fe3a82c3 db_iqddl::AlterIndex(a_statement const*, UIConnection*, UITable*, UIIndex*)+0x13
pc: 0x7f61fd063700
pc: 0x7f61fe289526 st_SAIQInterfaceInfo::callFunction()+0x26
pc: 0x7f61fe2f40cf st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x199
pc: 0x7f61fe289e9a st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20a
pc: 0x7f61fd7bee99 saint_iqthresholdddl::saint_CheckForDuplicateIndex(IConnection*, ITable*, IIndex*)+0x299
pc: 0x7f61fd7c1454 saint_iqthresholdddl::IQUtility(a_statement const*, IConnection*, ITable*)+0x9c4
pc: 0x7f639129dbd3 dbi_alter(a_statement*)+0x2213
pc: 0x7f63913bd803 DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int)+0x1383
pc: 0x7f63913c048a db__execute(Connection*, an_sqlpres_receive*)+0x12a
pc: 0x7f63913cccf4 RequestProcedure::call()+0xcd4
pc: 0x7f639122004e Context::call(Procedure*, Context**)+0x4e
pc: 0x7f6391220136 Worker::call_on_stack(Procedure*)+0x56
pc: 0x7f63913c978d TopProcedure::call()+0x3d
pc: 0x7f6391222539 Worker::spawn(Procedure*)+0x49
pc: 0x7f63913ca43c EngStream::handle_ind(unsigned char, unsigned int)+0x13c
pc: 0x7f63913cf6d6 EngStream::execute()+0xce6
pc: 0x7f63913c92b5 RQBaseItem::do_work(Worker*)+0x25
pc: 0x7f639140fe96 RequestQueue::worker_body()+0x66
pc: 0x7f63913ca185 request_task(void*)+0x65
pc: 0x7f63918d922d run_task_body+0x2d
pc: 0x7f6391410b77 UnixTask::pre_body(void*)+0x77



This issue was uncovered on IQ 16 SP 8 PL 29.


SAP IQ 16.0


784476 ,  Nbit , dictionary s_dictionary::GetStrKey s_dictionary::InsertKeyToHash s_dpNBit::Initialize hs_dp::CreateDictionary   , 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.