SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.