Symptom
IQ server is extremely slow after upgrading to IQ 16.1 sp05 even before running 'alter database upgrade'. After 'alter database upgrade' also there were few periods of unresponsiveness. When this happens only 1 CPU out of many appears at 100%. key thread in pstack looks like ;
Thread 2025 (Thread 0x7ffacd0ed700 (LWP 26814)):
#0 .. Counters::add(int, ..
#1 .. MainHeap::Free(void*) ..
#2 .. RoleInfo::~RoleInfo() ..
#3 .. RoleInfo::~RoleInfo() ..
#4 .. CheckManageRolesPrivs(Database*, ..
#5 .. checkRecurse(Database*, ..
#6 .. checkRecurse(Database*, ..
#7 .. checkRecurse(Database*, ..
#8 .. CheckRBAC(Database*, ..
#9 .. dbi_load_table_perms(Database*, ..
#10.. BuildUserDef(Database*, ..
#11.. Database::FindUserByID(unsigned, ..
#12.. dbi_load_table_perms(Database*, ..
#13.. BuildUserDef(Database*, ..
#14.. Database::FindUserByID(unsigned, ..
#15.. load_roles(Database*, ..
#16.. make_user_roleids(Database*, ..
#17.. dbi_user_groupids(UserDef*), ..
#18.. dbi_object_path(an_object_name const*, ..
#19.. dbi_call_result(a_statement*, ..
#20.. parse(a_statement_heap_ref*, ..
#21.. PrepareStringUsingHeap(a_statement_heap_ref*,..
#22.. PrepareStringAgain(a_statement_heap_ref*, ..
#23.. load_proc_definition(df_SysCursor*, ..
#24.. load_proc_by_name(char*) ,..
#25.. DB_Load_procedure(unsigned int*, ..
#26.. dbi_call_result(a_statement*, ..
#27.. parse(a_statement_heap_ref*, ..
#28.. PrepareStringUsingHeap(a_statement_heap_ref*, ..
#29.. PrepareStringAgain(a_statement_heap_ref*, ..
#30.. load_proc_definition(df_SysCursor*, ..
#31.. load_proc_by_name(char*) ..
#32.. DB_Load_procedure(unsigned int*, ..
#33.. dbi_find_procedure_ex2(a_base_expr*)..
#34.. dbi_callprocedure(Connection*, ..
#35.. DoExecuteBodyLocal(Connection*, ..
#36.. DoExecuteStmt(Connection*, ..
#37.. CallLoginEnvironment(Connection*)
#38.. db__connect(an_sqlpres_receive*) ,
#39.. RequestProcedure::call() ..
#40.. Worker::spawn(Procedure*) ..
#41.. EngStream::handle_ind(unsigned char, ..
#42.. EngStream::execute() ..
#43.. RQConnItem::do_request() ..
#44.. RQBaseItem::do_work(Worker*) ..
#45.. RequestQueue::worker_body() ..
#46.. request_task(void*) ..
#47.. run_task_body () ..
#48.. UnixTask::pre_body(void*) ..
#49.. start_thread ..
#50.. clone ..
Read more...
Environment
SAP IQ16.1 sp05
Product
Keywords
RBAC , role based access control , CheckManageRolesPrivs , CheckRBAC, , 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.