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 ONE Support launchpad (Login required).

Search for additional results

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