2962061 - Infected with signal 11 during planned failover, primary is stuck in deactivating state - SRS

• Planned failover failed,  RMA log shows:
  
  [INFO ] [Failover:66447][RMA] - [HADRStatus] - Executing 'select @@hadr_mode, @@hadr_state' on the ASE at hostname.domain.com:portnumber.
  [INFO ] [Failover:66447][RMA] - [HADRStatus] - HADR status for ASE 'SID_Site1' on host 'Site1' is '[Primary : Deactivating]'.

• Primary in deactivating state even after issuing sp_hadr_admin cancel
  
  
• During deactivation, ASE encountered stacktrace:
  
  Current process (0x5ad3011e) infected with signal 11 (SIGSEGV)
  Current Process is running on Engine 8
  Address 0x0x0000000000d97c19 (xact_check_active+0x88), siginfo (code, address) = (1, 0x0x0000000000000010)
  **** Saved signal context (0x0x00002aaabdd83100): ****
  uc_flags: 0x1, uc_link: 0x(nil)
  uc_sigmask: 0x7bfbf037 0xb 0x1 0x10
  uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
  General Registers (uc_mcontext.gregs):
  PC: 0x0000000000d97c19 (xact_check_active+0x88)
        RAX : (nil)  RBX : 0x000000000418b020
        RCX : 0x00002aaaaac223d8  RDX : (nil)
  RBP : 0x00002aaabdd836f0  RSP : 0x00002aaabdd836c0
  R8  : 0x00002aab637531c0  R9  : (nil)
  R10 : 0x0000000000000119  R11 : (nil)
  R12 : (nil)  R13 : (nil)
  R14 : (nil)  R15 : 0x0000000000000001
  RDI : (nil)  RSI : 0x00002aabb43535f8
  RIP : 0x0000000000d97c19  CSGSFS : 0x0000000000000033
  TRAPNO : 0x000000000000000e  ERR : 0x0000000000000004
  EFL : 0x0000000000010297
  **** end of signal context ****
  SQL causing error : sp_hadr_admin deactivate, '600', 'DR_Agent_925020267', NULL, 'drain', '600'
  Current statement number: 458 Current line number: 1165
  ***********************************
  SQL Text: sp_hadr_admin deactivate, '600', 'DR_Agent_925020267', NULL, 'drain', '600'
  SQL Text: dbcc hadr_admin(@cmd, @arg1, @arg2, @arg3, @arg4, @arg5, @arg6)
  curdb = 1 tempdb = 2 pstat = 0x10000 p2stat = 0x40101000
  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x1 p7stat = 0x10000
  lasterror = 0 preverror = 0 transtate = 1
  curcmd = 317 program = java.lang.Thread              
  extended error information: hostname: hostname login: DR_admin
  pc: 0x000000000154dc90 pcstkwalk+0x482()
  pc: 0x000000000154d64f ucstkgentrace+0x20f()
  pc: 0x0000000001549dd2 ucbacktrace+0x54()
  pc: 0x00000000018198be terminate_process+0xb1e()
  pc: 0x000000000157b304 kisignal+0x868()
  pc: 0x0000000000d97c19 xact_check_active+0x88()
  pc: 0x00000000012863fe hadr__deactivate_begin+0x5a()
  pc: 0x0000000001284914 hadr__deactivate+0x2fc()
  pc: 0x0000000001283d0d hadr_request+0x7aa()
  pc: 0x0000000000b3dd0e hadr_admin+0x1df()
  pc: 0x0000000001cf26d5 exec_dbcc+0xbd5()
  pc: 0x0000000002055dc4 s_execute+0x4a44()
  pc: 0x000000000208316c sequencer+0x1bdc()
  pc: 0x0000000002067a26 execproc+0xcf6()
  pc: 0x0000000002055996 s_execute+0x4616()
  pc: 0x00000000020822a3 sequencer+0xd13()
  pc: 0x000000000184fe79 conn_hdlr+0x12e9()
  end of stack trace, spid 798, kpid 1523777822, suid 4

 Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Replication Server (SRS) 16.0 SP03 PL08
• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 with Always-on Option (HADR)

 
CR822613, CR#822613, 822613, Signal 11, stacktrace, RepServer, RS, repagent, deactivating, HADR, failover , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed