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 for Me (Login required).

Search for additional results

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