SAP Knowledge Base Article - Preview

3134569 - SAP IQ server hang when calling a sproc with ALTER TABLE having dependent views - SAP IQ

Symptom

  • SAP IQ unresponsive
  • Messages stop being logged in IQMSG 
  • A particular sproc is executed by several connections simultaneously.
  • This sproc executes "ALTER TABLE". 
  • The "ALTER TABLE" statement automatically triggers a recompile of dependent views.

The stack traces taken by DumpAllthreads or pstack contains these functions calls: 

UnixTask::wait
CondVar::wait
Worker::do_wait
WorkerMutex::get
WorkerRecursiveMutex::get
DB_Check_if_reusable_right_away
a_db_cursor*MakeVolcanoOptimizerCursor
a_db_cursor*MakeCursorForView
RecompileView
dbi_alter
a_cursor*DoExecuteBodyLocal
DoExecuteStmt
process_exec_immediate
exec_procedure_stmt
run_procedure
dbi_resume_procedure


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

 825919,  CR825919,  CR#825919, WorkerRecursiveMutex, DB_Check_if_reusable_right_away, RecompileView, dbi_alter, exec_procedure_stmt, run_procedure, dbi_alter,  , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , 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.