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.
SAP Knowledge Base Article - Preview