3261480 - ASE hanging issue at udr_expand_role_optimized() due to undetected deadlock post fix 826760

 ASE server is hung at udr_expand_role_optimized()

dump> stack 1908
pc: 0x0000000001aa273b upsleepgeneric+0x5cb()
pc: 0x0000000001119d64 udr_expand_role_optimized+0x514()
pc: 0x00000000020febe6 get_role_bits+0x36()
pc: 0x00000000020fd612 set_role+0x182()
pc: 0x00000000020fe882 set_loginauth+0x3c2()
pc: 0x0000000001ad4d2c login+0x62c()
pc: 0x000000000182a80a conn_hdlr+0x65a()

dump> stack 251
pc: 0x0000000001aa273b upsleepgeneric+0x5cb()
pc: 0x0000000001119d64 udr_expand_role_optimized+0x514()
pc: 0x0000000002111fc2 get_srids_or_lrids+0x3f2()
pc: 0x0000000001fbbfb3 prot_verify_active_roles+0x63()
pc: 0x0000000001a82a4b sequencer+0x1dab()
pc: 0x0000000001ae41ba tdsrecv_language+0x23a()
pc: 0x000000000182b541 conn_hdlr+0x1391()

dump> stack 2145
pc: 0x0000000001aa273b upsleepgeneric+0x5cb()
pc: 0x0000000001119d64 udr_expand_role_optimized+0x514()
pc: 0x00000000010bae07 lookup__process_role+0x1c4()
pc: 0x00000000010ba00b get_logins_with_role_or_perm+0x1f3()
pc: 0x0000000001277ea8 udr_role_revoke_role+0x512()
pc: 0x000000000127454a udr_grantrev_role+0x3da()
pc: 0x0000000001a6e2a6 s_execute+0xdbd6()
pc: 0x0000000001a819b3 sequencer+0xd13()
pc: 0x0000000001a77736 execproc+0xcf6()
pc: 0x0000000001a65242 s_execute+0x4b72()
pc: 0x0000000001a819b3 sequencer+0xd13()
pc: 0x0000000001a77736 execproc+0xcf6()
pc: 0x0000000001a65242 s_execute+0x4b72()
pc: 0x0000000001a819b3 sequencer+0xd13()
pc: 0x0000000001ae41ba tdsrecv_language+0x23a()
pc: 0x000000000182b541 conn_hdlr+0x1391()

• SAP ASE 16.0 SP03 PL12 /EBF 30441 SMP CONTROLLED/P/x86_64/SLES 11.4/ase160sp03pl12x/4105/64-bit/FBO/Thu Jul 14 08:19:49 2022
• SAP ASE 16.0 SP03 PL13

CR827306, CR#827306, 827306 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem