SAP Knowledge Base Article - Preview

3316620 - Coordinator is hanging post start after upgrade from 16.0 sp11.25 to 16.1 sp05.07 - SAP IQ

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

SAP IQ all versions

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.