SAP Knowledge Base Article - Preview

2067211 - Database crashes with error in function s_dpThreeByteFetch::GetCardinality - SAP IQ

Symptom

Database crashes with stacktrace after sp_iqcheckdb 'check database'

I. 08/25 13:31:08. 0000004059 Connect:  SA connHandle: 835  SA connID: 17  IQ connID: 0000004059  User: xxxx
I. 08/25 13:31:09. 0000004059 Cmt 31307614
I. 08/25 13:31:09. 0000004059 PostCmt 0
I. 08/25 13:31:09. 0000004059 Txn 31307615 0 31307615
I. 08/25 13:31:09. 0000004059 Cmt 31307616
I. 08/25 13:31:09. 0000004059 PostCmt 0
I. 08/25 13:31:09. 0000004059 Txn 31307617 0 31307617
I. 08/25 13:31:10. 0000004059
I. 08/25 13:31:10. 0000004059 **************************************************
I. 08/25 13:31:10. 0000004059 ***   Sybase IQ Abort:
I. 08/25 13:31:10. 0000004059 ***      From:  st_server.cxx:1378
I. 08/25 13:31:10. 0000004059 ***      PID: 8441
I. 08/25 13:31:10. 0000004059 ***      Message: caught signal 11, program abort
I. 08/25 13:31:10. 0000004059 ***      Thread: 984  (TID: 913)
I. 08/25 13:31:10. 0000004059 **************************************************
I. 08/25 13:31:10. 0000004059
I. 08/25 13:31:10. 0000004059     **  Error from IQ connection:  SA connHandle: 835  SA connID: 17  IQ connID: 0000004059  User: xxxx
I. 08/25 13:31:10. 0000004059     **  Time of error:  2014-08-25 13:31:10
I. 08/25 13:31:10. 0000004059     **  IQ Version:  Sybase IQ/15.1.0/100427/P/ESD 3
I. 08/25 13:31:10. 0000004059     **  OS info:  IQ built on: Sun_Sparc/OS 5.10,  Executed on: SunOS/GPU00529/5.10/Generic_148888-01/sun4u
I. 08/25 13:31:10. 0000004059     **  Command status when error occured:  COMMAND ACTIVE
I. 08/25 13:31:10. 0000004059     **  Command text:
? = call if4_exec_p_TableDim (?,?)

I. 08/25 13:31:10. 0000004059 Dump all thread stacks at st_server.cxx:1378 for PID: 8441

I. 08/25 13:31:10. 0000004059
    ***************** This is the STACKTRACE ***************


I. 08/25 13:31:10. 0000004059

===== Thread Number  984  (IQ connID: 0000004059) =====

I. 08/25 13:31:10. 0000004059 pc: 0x0 (0x11cfe5198, 0x0, 0x0, 0x0, 0xffffffff5d74bb9f)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5ce023fc int pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x3c(0x29, 0xffffffff5d98e6dd, 0x11cfe3e58, 0x11cfe40bc, 0x11cfe5198)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5ce00df4 void DumpAllThreads(const char*,unsigned,int)+0x274(0xffffffff5d98cfc8, 0x46c800, 0x1, 0x0, 0x1)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5caa7b4c void hos_ABORT(const char*,unsigned,const char*,char*,char*)+0x26c(0xffffffff5da887b0, 0x562, 0x391, 0x390800, 0x11cfe5754)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d325808 SigHndlr+0x48(0xb, 0x391800, 0x391828, 0xffffffff5d6f6f68, 0x3d17a4)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff7d3d8c28 _fini+0x1fe8cf60(0xb, 0x11cfe6210, 0x11cfe5f30, 0xffffffff5d3257c0, 0x0)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff7d3cc79c _fini+0x1fe80ad4(0xffffffff5aafb200, 0xffffffff5aafb200, 0x11cfe5f30, 0x8, 0x0)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff7d3cc9a8 _fini+0x1fe80ce0(0x0, 0x11cfe6210, 0x11cfe5f30, 0xffffffff5aafb200, 0x0)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d1fc4ac int s_phash::InsertKeyIfUnique()+0x26c(0x7ff8, 0x17fe8, 0x3b40233b0, 0x3b4024338, 0xc)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d12a118 unsigned long long s_dpThreeByteFetch::GetDistinctCount(const void*,int,const void*,int,unsigned long long,int&)+0x638(0x17fe8, 0x1, 0x3b44862b8, 0x3b40233b0, 0x1)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d129888 unsigned long long s_dpThreeByteFetch::GetCardinality()+0x308(0x3b44865a0, 0x3b40232e8, 0x3b44865a0, 0x11cfe6c28, 0xffffffff5da1deae)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d0d5508 unsigned long long hs_dp::GetCardinality() const+0xa8(0x3b4485c88, 0x390800, 0xffffffff5d887270, 0x1, 0x69e164)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5c8266c0 void dfe_BaseColumn::GatherMetaData()+0xd80(0x1, 0x3b4485c88, 0x3bf90dca8, 0xffffffff5d6f6f68, 0xffffffff5d79fa50)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5c827adc int dfe_BaseColumn::NeedOldValueForUpdate() const+0x1c(0x3bf90dca8, 0x1007392b8, 0x1, 0x0, 0x3b4023228)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5cf3b850 void opt_SelectList::GenerateDFEs(df_Heap*,opt_QueryExp*)+0x2950(0x110, 0x277ef1378, 0xffffffff5d7a04d0, 0xffffffff5d6f6f68, 0x3b48380b8)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5cf3150c void opt_Select::InitializeNestedQueries(opt_QueryExp*)+0x52c(0x6, 0x0, 0x3b4837798, 0xffffffff5d9c8628, 0x45)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5ce9f464 dfo_Root*opt_Driver::GenerateTree(QueryNode*,st_cursor*)+0x1d24(0xffffffff5d9aef5c, 0x1, 0x3b4837798, 0x0, 0xffffffff5d6f6f68)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5c5b6174 void db_cursorIQUpdate::Parse()+0x34(0x2780c31d8, 0x1268, 0x29800, 0x1140e24, 0x1000)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5c77cdb0 void db_sqlinsert::UpdateParse()+0x330(0x11cfee2e0, 0x1371dd960, 0x2780c31d8, 0x1e5, 0xffffffff6603d6e0)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5c7164f0 void db_sqlinsert::Parse()+0xd0(0x11cfee2e0, 0x0, 0x8, 0x391, 0x1)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d2cb448 void st_command::DoCmdThroughResourceGate()+0x488(0x11cfee2e0, 0xffffffff5d7699f0, 0x1007392f0, 0x11cfedd64, 0x244800)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d320e9c unsigned st_iqdml::Update(a_statement*,UIConnection*,UICursor*)+0x3c(0xffffffff7e3b7290, 0xffffffff6603d620, 0xffffffff657df460, 0xffffffff65da43a0, 0x0)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5ce58af8 UIQDML_Update+0x18(0x100738e38, 0xffffffff76401f28, 0xffffffff7d54a300, 0xffffffff5d320e60, 0xffffffff5aafb200)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d3263e4 void st_thrInterfaceInfo::callFunction()+0x24(0xffffffff76401d68, 0x0, 0x3d0ba4, 0xffffffff5d6f6f68, 0xffffffff76401d68)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d32ac7c void st_threadInterface::IQwaitForFunc()+0x2bc(0x3b3c03b28, 0x1007392b8, 0x1371269f0, 0x391, 0x390)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5d329458 IQLeaderThread+0xb8(0x3b3c03b28, 0xffffffff5d992ab0, 0x3cdbc4, 0x29b800, 0x391)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5ce28930 int hos_thread::Main()+0x4b0(0x1371e18a0, 0x1, 0x3b3c06cd8, 0x1c8b8820, 0xffffffff5d992a40)

I. 08/25 13:31:10. 0000004059 pc: 0xffffffff5cda8684 int hos_lwtask::Start(hos_lwtask*)+0x264(0x1371e16b8, 0x1c839008, 0x1007392f0, 0xffffffff5d93bbf4, 0xffffffff5ce28480)

I. 08/25 13:31:10. 0000000000


Read more...

Environment

SAP Sybase IQ 15.1

Product

SAP Sybase IQ 15.2

Keywords

s_dpThreeByteFetch::GetCardinality , 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.