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

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

SAP Sybase IQ 15.1

s_dpThreeByteFetch::GetCardinality , KBA , BC-SYB-IQ , Sybase IQ , Problem