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 became unresponsive.
  • Messages stop being logged in IQMSG.
  • A particular stored procedure is executed by several connections simultaneously.
  • This stored procedure 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 , Known Error

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.