Symptom
- "admin who_is_down" in the standby SRS shows:
REP AGENT CI Down xxx_xxx_R2.master
- "sp_help_rep_agent master, 'process' in the primary ASE shows:
Replication Agent Coordinator Process Status dbname spid sleep_status state
--------------------------------------------------------------------------------------
(1 row affected)
- When we try to restart this RepAgent in the primary ASE, it fails because it was not completely down:
1> sp_start_rep_agent master 2> go Msg 9431, Level 16, State 0: Server 'xxx', Procedure 'sp_start_rep_agent', Line 281: A Rep Agent Thread for database 'master' (dbid=1) is being stopped. Msg 18421, Level 16, State 1: Server 'xxx', Procedure 'sp_start_rep_agent', Line 286: Failed to start the Replication Agent thread for database 'master'. (return status = 1)
- If the first sp_stop_rep_agent fails, then the subsequent attempt to stop RepAgent with nowait (force stop) causes a Signal 11 error and the ASE server crashes:
00:0049:00000:04282:2021/08/11 15:50:19.31 server Error: 9414, Severity: 20, State: 1
00:0049:00000:04282:2021/08/11 15:50:19.31 server RepAgent(1): Streaming replication stream CI Library error -1 with severity 2 and message 'Producer receiver 'master' failed to receive data, shutting down transport to 'nnnn:nn ssl=nnn"'.'. Rep Agent detected error 3 with message 'Unknown' at line 3653 in file ra_ci_scanner.c.
00:0000:00000:00000:2021/08/11 15:50:19.31 kernel (CI-Info) Message: 76050, Severity: 0 Producer of Stream 'master' is exiting.
00:0049:00000:00753:2021/08/11 15:50:19.31 server Rep Agent on database 'master' switched from mode 'sync' to mode 'async' because scanner reopened the stream after a retryable error.
……
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel Current process (0x0) infected with signal 11 (SIGSEGV)
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel Current Process is running on a Non-Engine Thread
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel Address 0x(nil) (), siginfo (code, address) = (1, 0x(nil))
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel **** Saved signal context (0x0x00007e8ec61a4ac0): ****
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel uc_flags: 0x7, uc_link: 0x(nil)
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel uc_sigmask: 0x7bfbf037 0xb 0x1 0x0
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel General Registers (uc_mcontext.gregs):
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel PC : (nil) ()
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel RAX : 0x0000000000000025 RBX : 0x00007e8ec61a57f0
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel RCX : (nil) RDX : (nil)
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel RBP : 0x00007e8ec61a5b40 RSP : 0x00007e8ec61a57a8
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel R8 : (nil) R9 : 0x00007e9839d50370
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel R10 : (nil) R11 : 0x0000000000000206
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel R12 : (nil) R13 : 0x00007e983a973d30
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel R14 : 0x00007e983a9714f0 R15 : 0x0000000000000001
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel RDI : 0x00007e983a9714f0 RSI : 0x00007e8ec61a57f0
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel RIP : (nil) CSGSFS : 0x002b000000000033
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel TRAPNO : 0x000000000000000e ERR : 0x0000000000000014
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel EFL : 0x0000000000010246
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel **** end of signal context ****
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel Spinlocks held by taskblock 0x7e8efb28aa08
00:0090:00000:00000:2021/08/13 11:37:38.50 kernel Spinlock Kernel->kpprocspin[i] at address 0x00007e8ef9525400 owned by 0x7e8efb28aa08
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel Spinlock DES Name Hash Bucket Spin at address 0x00007e8efa01d200 owned by 0x7e8efb28aa08
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel Spinlock DES Name Hash Bucket Spin at address 0x00007e8efa057400 owned by 0x7e8efb28aa08
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel Spinlock default data cache at address 0x00007e8efa3a9480 owned by 0x7e8efb28aa08
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel End of spinlock display.
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel Exception in blocking call execution
00:0040:00000:00000:2021/08/13 11:37:38.51 kernel ueshutdown: exiting
00:0000:00000:00000:2021/08/13 11:37:38.51 kernel Main thread performing final shutdown.
00:0000:00000:00000:2021/08/13 11:37:38.51 kernel Blocking call queue shutdown.
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x000000000153b8a1 nthrd_backtrace+0x3b()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000001563612 kbctException+0x44()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000001561575 krtctskException+0x57()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x000000000156999e kisignal+0xa22()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: (nil) ()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000f00c40 ra__ci_call_CloseStream_unblocking+0x3f()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x000000000224cd54 ubcExecute+0x54()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x00000000022591a3 kbctMain+0x73()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000002252f79 krtctskRun+0x39()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000001a8496c ktskRun+0x5c()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000002278daa kt__RTCMain+0xaa()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel end of stack trace
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel Blocking call executing on behalf of 440862010 failed with exception
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000001a7ce2b upsleepgeneric+0x5cb()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x000000000224ce6f ubcWaitForCompletion+0x5f()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x000000000224dccc undo_blockingcall_thread+0x3c()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000ef4a87 ra__ci_sleep_on_close_CI_stream+0x3d0()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000ef448b ra__ci_close_CI_stream+0x921()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000ef3835 ra_ci_close_CI_stream+0xfa()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000f1d31e ra__ci_scanner_close_stream+0xa7()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000f1e3a8 ra__ci_scanner_reopen_stream+0x55()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel [Handler pc: 0x0x0000000000f98589 ra_hdlr installed by the following function:-]
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000f11dad ra__ci_scanner_execute+0x18a()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel [Handler pc: 0x0x0000000000f98589 ra_hdlr installed by the following function:-]
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel [Handler pc: 0x0x0000000000f98589 ra_hdlr installed by the following function:-]
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel [Handler pc: 0x0x0000000000f98589 ra_hdlr installed by the following function:-]
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel pc: 0x0000000000f0ea74 ra_ci_scanner_thread+0x3ce()
00:0090:00000:00000:2021/08/13 11:37:38.51 kernel end of stack trace, spid 4282, kpid 440862010, suid 0
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
- SAP Replication Server (SRS) 16.0
Product
Keywords
sybase, 825379, CR825379, CR#825379, SEGV, segmentation, storage, access, violation, fault, segfault, stacktrace , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error
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.
SAP Knowledge Base Article - Preview