Symptom
IQ is running just fine and all the sudden all processes stop running.
When pstacks are take on the spid - you will find:
Threads (1): 766
unsigned short UnixTask::wait(unsigned short)
void RWLatch::get_exclusive(int)
load_proc_definition(df_SysCursor*)
DB_Load_procedure(unsigned*,char*,unsigned,an_errmap_index*)
lookup_procedure_ex2(an_expr_node*,an_errmap_index*)
dbi_call_result(a_statement*,a_call*,IDBHeap*)
DefineImplicitResultSet(a_statement*,a_statement_heap_ref*)
parse(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*,unsigned,unsigned,unsigned*,SQLFlagger*)
PrepareStringUsingHeap(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*,unsigned,unsigned,SQLFlagger*)
PrepareStringAgain(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*)
add_procedure_statments(a_proc_def*,const dfv_Value&,unsigned)
load_proc_statements(a_proc_def*)
DB_Load_procedure(unsigned*,char*,unsigned,an_errmap_index*)
dbi_find_procedure_ex2(an_expr_node*)
process_call(Connection*,a_context_ref*,a_statement*)
exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)
unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)
unsigned dbi_resume_procedure(a_context_ref*,unsigned)
a_cursor*handle_open(Connection*,a_stmt*,an_isolation_level,unsigned)
db__open(Connection*,an_sqlpres_receive*)
RequestProcedure::call()
Context::call(Procedure*,Context**)
Worker::call_on_stack(Procedure*)
TopProcedure::call()
Worker::spawn(Procedure*)
EngStream::execute()
RQBaseItem::do_work(Worker*)
DeferredCall::worker_body()
request_task(void*)
UnixTask::pre_body(void*)
This causes a deadlock with another spid:
Threads (1): 848
unsigned short UnixTask::wait(unsigned short)
Mutex::wait_for_mutex(Task*,int)
Mutex::get(Task*,int)
Worker::get_all_forbid_mutexes()
Worker::forbid(unsigned,unsigned,unsigned,unsigned)
DB_Commit_Chgs(Connection*)
ri_commit(Connection*)
Connection::commit_work()
DbCleaner::clean()
DbCleaner::do_request()
Worker::spawn(Procedure*)
RQInternalBaseItem::do_work(Worker*)
DeferredCall::worker_body()
request_task(void*)
UnixTask::pre_body(void*)
Read more...
Environment
SAP IQ 15.3x
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
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.