SAP Knowledge Base Article - Preview

3052519 - SAP IQ 16.1 aborts with "db_Catalog::GetPhysicalBlocksForTemporaryTable" stacktrace

Symptom

IQ 16.1 aborts during running regular jobs from time to time.

--.iqmsg during IQ abort

**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:2452
*** PID: 22334
*** Message: caught signal 11, program abort
*** Thread: 194 (TID: 24)
**************************************************

0000000194 Stacktrace requested from stcxtlib/st_server.cxx:2452 on thread 194 (TID 24) start stacktrace
** Error from IQ connection: SA connHandle: 59444 SA connID: 92 IQ connID: 0000156042 User: user001
** Time of error: 2021-04-12 02:46:27
** IQ Version: SAP IQ/16.1.040/14235/P/SP04.06
** OS info: IQ built on: Sun_x64/OS 5.11, Executed on: SunOS/host001/5.11/11.4.15.5.0/i86pc
** Command status when error occurred: COMMAND ACTIVE
** Command text:
call user_procedure001;

** Dump all thread stacks at stcxtlib/st_server.cxx:2452 for PID: 22334

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

===== Thread Number 194 (IQ connID: 0000156042) =====
pc: 0 <unknown>(5365b8c8, 0)
pc: 7ffb174f5376 void DumpAllThreads(const char*,unsigned,int)+0x4a6(7ffb19e0f610, 7fffbf03e28f)
pc: 7ffb17157a1b void hos_ABORT(const char*,unsigned,const char*,char*,char*,sigcontext*)+0x48b(7320746867756163, 3131206c616e6769)
pc: 7ffb18432717 SigHndlr+0x47(7ffb375fa000, 7fffbf0396f1)
pc: 7fffbf047d56 <unknown>(7ffb375f9f90, 580)
pc: 7fffbf0396f1 <unknown>(156cdccd8, 0)
pc: 7fffbf039b0e <unknown>(b, 7ffb375fae40)
pc: ffffffffffffffff <unknown>(0, 19dac2928)
pc: 7ffb184ea233 void db_Catalog::GetPhysicalBlocksForTemporaryTable(db_TxnInfo*,db_TxnInfo*,st_connection*)+0x1e3(375fb0e0, 21663bc38)
pc: 7ffb184d645f void db_Catalog::DropTable(UITable*,unsigned)+0x23f(7fffbf197c90, 19dac2a58)
pc: 7ffb186057ff void db_droptable::Execute()+0x28f(5257b6f58, 4a3c13e48)
pc: 7ffb183a6e9e void st_command::DoCmdThroughResourceGate()+0x1be(7ffb19f6e2b0, fee1900d)
pc: 7ffb18607be5 unsigned db_iqddl::DropTable(const a_statement*,UIConnection*,UITable*)+0x45(7ffb375fc590, 7ffb375fe7b0)
pc: 7ffb169fb291 UIQDDL_DropTable+0x21(7ffb375fc588, 7ffb375fe7b0)


Read more...

Environment

  • SAP IQ 16.1 SP04.06
  • Simplex

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed

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.