SAP Knowledge Base Article - Preview

2006074 - Signal 11 at LeSubst+0xdc during REORG REBUILD when using the 'with online' parameter - ASE

Symptom

  • Client process executing "REORG REBUILD ... WITH ONLINE" disconnected unexpectedly
  • ASE errorlog contains an "infected with signal 11" error in function LeSubst():

Example:
server Beginning REORG REBUILD of table 'UserTable'.
server Beginning REORG REBUILD of table 'UserTable'.
kernel Current process (0x5cd02e7) infected with signal 11 (SIGSEGV)
kernel Address 0x00000000803f5ebc (LeSubst+0xdc), siginfo (code, address) =  (1,0x0000000000000048)
kernel **** Saved signal context (0x000001003f698640): ****
kernel uc_flags: 0x2f, uc_link: 0x0
kernel uc_sigmask: 0xefbe7877 0xfff7 0x0 0x0
kernel uc_stack: ss_sp: 0xffffffff78700000, ss_size: 0x2080768, ss_flags: 0x0
kernel General Registers (uc_mcontext.gregs):
kernel PC :00000000803f5ebc (LeSubst+0xdc)
kernel Next PC :00000000803f5ec0 (LeSubst+0xe0)
kernel CCR :0000000000000044 Y : 0000000000000000
kernel ASI :0000000000000082 FPRS : 0000000000000005
kernel g0 :0000000000000000 g1 : 0000000000000200 g2 : 000000005a87a89a
kernel g3 :0000010001510f38 g4 : 0000000000000020 g5 : ffffffffffffffff
kernel g6 :0000000000000000 g7 : ffffffff78900a40
kernel o0 :0000000000000001 o1 : 0000000000000000 o2 : 00000102dc5b5c10
kernel o3 :000001003f698ab8 o4 : 000000000000d000 o5 : 000001012fa37548
kernel o6 :000001003f698221 o7 : 00000100e8704050
kernel Windowed Registers (from stack frame 000001003f698a20):
kernel l0 :0000000000000000 l1 : 0000000000000000 l2 : 000001012fa37548
kernel l3 :000000000000004c l4 : 0000010d3c2fd000 l5 : 0000010447929000
kernel l6 :00000000000e0000 l7 : 000000000000000c
kernel i0 :000000000000000a i1 : 00000101d4325d30 i2 : 0000000000000002
kernel i3 :0000000000000000 i4 : 00000101d4325d30 i5 : 00000102a20c5768
kernel i6 :000001003f698461 i7 : 00000000803fd41c
kernel previous stackframe : 000001003f698c60
kernel **** end of signal context ****

kernel ************************************
kernel SQL causing error :
kernel ************************************
server SQL Text: alter table UserTable partition by roundrobin 3 --Internal SQL:<sql>()
kernel curdb = 5 tempdb = 12 pstat = 0x10100 p2stat = 0x44101000
kernel p3stat = 0x10800 p4stat = 0x10000 p5stat = 0x8 p6stat = 0x11 p7stat = 0x110000
kernel lasterror = 0preverror = 0 transtate = 0
kernel curcmd = 339 program = UserApp
kernel extended error information: hostname: testhost login: testlogin
kernel pc:0x0000000081554d9c pcstkwalk+0x18
kernel pc:0x0000000081554be4 ucstkgentrace+0x23c
kernel pc:0x0000000081550fc4 ucbacktrace+0xd0
kernel pc:0x00000000807f86c8 terminate_process+0x172c
kernel pc:0x000000008159d778 kisignal+0x438
kernel pc:0x00000000803f5ebc LeSubst+0xdc
kernel pc:0x00000000803fd41c getnext+0x1fc
kernel pc: 0x00000000804026b8 LeRetnCode LeScanOp::_LeOpNext(ExeCtxt&)+0xd8
kernel pc: 0x000000008050dbe0 LeRetnCode LeAPScanOp::_LeOpNext(ExeCtxt&)+0x60
kernel pc: 0x0000000081aa4ffc LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel pc: 0x000000008042b37c LeRetnCode LeInsertOp::_LeOpNext(ExeCtxt&)+0xdc
kernel pc:0x0000000081aa4ffc LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel pc:0x00000000803f64c8 LeRetnCode LeEmitNoSndOp::_LeOpNext(ExeCtxt&)+0x188
kernel pc:0x0000000081aa4ffc LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel pc:0x0000000080410478 LePlanNext+0xb8
kernel pc:0x000000008040fe3c exec_lava+0x29c
kernel pc:0x000000008040d094 s_execute+0x1db4
kernel pc:0x0000000080529e94 sequencer+0x414
kernel pc:0x00000000813adc20internal_sql+0x4e4
kernel pc:0x000000008142dc50 rbld__table_via_amc+0x24c
kernel pc:0x000000008141a124 reorg_main+0x3ac
kernel pc:0x0000000080468564 _$o1cexjJ0.s_execute+0x24e4
kernel pc:0x0000000080529e94 sequencer+0x414
kernel pc:0x0000000080841980 tdsrecv_language+0x2b4
kernel pc:0x000000008054d078 _$o1ceyaO0.conn_hdlr+0x178
kernel pc:0x00000000815838b8 _coldstart
kernel end of stack trace, spid 35, kpid 97321703, suid 8


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.