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

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        ..

SAP IQ16.1 sp05

RBAC , role based access control , CheckManageRolesPrivs , CheckRBAC,  , KBA , BC-SYB-IQ , Sybase IQ , Problem