SAP Knowledge Base Article - Preview

3586459 - Signal 11 in OdbcRemoteAccess::prepareResultSet() - SAP ASE

Symptom

  • ASE errorlog contains an infected with signal 11 error
  • Stack trace shows kisignal followed by (null) followed by OdbcRemoteAccess::prepareResultSet
  • Client process unexpectedly disconnected

     
  • Sample stack trace:
    520|0 0 00120258 1 440 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  Address 0x0x00007ffff603e91b ((null)+0xf603e91b), siginfo (code, address) =
    520|0 0 00120258 1 441 21:04:56| (1, 0x(nil))
    520|0 0 00120258 1 442 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  **** Saved signal context (0x0x000000014b958540): ****
    520|0 0 00120258 1 443 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  uc_flags: 0x1, uc_link: 0x(nil)
    520|0 0 00120258 1 444 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  uc_sigmask: 0x7bfbf037 0xb 0x1 0x0
    520|0 0 00120258 1 445 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
    520|0 0 00120258 1 446 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  General Registers (uc_mcontext.gregs):
    520|0 0 00120258 1 447 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       PC : 0x00007ffff603e91b ((null)+0xf603e91b)
    520|0 0 00120258 1 448 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel          RAX : (nil)  RBX : 0xffffffff80000000
    520|0 0 00120258 1 449 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel          RCX : (nil)  RDX : (nil)
    520|0 0 00120258 1 450 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       RBP : 0x000000014b958c20  RSP : 0x000000014b958ad8
    520|0 0 00120258 1 451 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       R8  : 0xffffffff7fffff80  R9  : 0x0000000000140000
    520|0 0 00120258 1 452 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       R10 : (nil)  R11 : 0x00007ffff603e3aa
    520|0 0 00120258 1 453 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       R12 : (nil)  R13 : 0x0000000156a6e800
    520|0 0 00120258 1 454 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       R14 : 0x00007fffe4084d60  R15 : 0x0000000000000001
    520|0 0 00120258 1 455 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       RDI : (nil)  RSI : (nil)
    520|0 0 00120258 1 456 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       RIP : 0x00007ffff603e91b  CSGSFS : 0x0000000000000033
    520|0 0 00120258 1 457 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       TRAPNO : 0x000000000000000e  ERR : 0x0000000000000006
    520|0 0 00120258 1 458 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel       EFL : 0x0000000000010286
    520|0 0 00120258 1 459 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  **** end of signal context ****
    520|0 0 00120258 1 460 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  ************************************
    520|0 0 00120258 1 461 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  SQL causing error : select textptr(c2)  from tblobp where c1 = 1
    520|0 0 00120258 1 462 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  ************************************
    0 0 00120258 1 462 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  ************************************
    520|0 0 00120258 1 463 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 server  SQL Text: select textptr(c2)  from tblobp where c1 = 1
    520|0 0 00120258 1 464 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  curdb = 1 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
    520|0 0 00120258 1 465 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
    520|0 0 00120258 1 466 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  lasterror = 0 preverror = 11227 transtate = 1
    520|0 0 00120258 1 467 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  curcmd = 193 program = qasql
    520|0 0 00120258 1 468 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  extended error information: hostname: lnxbarr07 login: user0
    520|0 0 00120258 1 469 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000021ca5a5 pcstkwalk+0x495()
    520|0 0 00120258 1 470 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000021c9eb3 ucstkgentrace+0x233()
    520|0 0 00120258 1 471 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000021c429d ucbacktrace+0x5d()
    520|0 0 00120258 1 472 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000008cffcd terminate_process+0x1ddd()
    520|0 0 00120258 1 473 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x0000000002236c47 kisignal+0x767()
    520|0 0 00120258 1 474 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00007ffff603e91b (null)+0xf603e91b()
    520|0 0 00120258 1 475 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x000000000242b999 OdbcRemoteAccess::prepareResultSet()+0x59()
    520|0 0 00120258 1 476 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x000000000242c5e5 OdbcRemoteAccess::startRemScan(OmniSQL*, bool)+0x455()
    520|0 0 00120258 1 477 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000023f20d6 RemoteAccess::prepareRemoteSQL(LeRemScanContext*,
    520|0 0 00120258 1 478 21:04:56| OmniSQL*)+0x156()
    520|0 0 00120258 1 479 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000025bdd73 LeRemScanOp::_LeOpOpen(ExeCtxt&)+0x173()
    520|0 0 00120258 1 480 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000025c0c45 LeRestrictOp::_LeOpOpen(ExeCtxt&)+0x125()
    520|0 0 00120258 1 481 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x0000000000991178 LeEmittOp::_LeOpOpen(ExeCtxt&)+0x58()
    520|0 0 00120258 1 482 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000009a31df LeEmitSndOp::_LeOpOpen(ExeCtxt&)+0x1f()
    520|0 0 00120258 1 483 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x0000000000968e54 LePlanOpen+0x284()
    520|0 0 00120258 1 484 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  [Handler pc: 0x0x000000000173b560 le_execerr installed by the following
    520|0 0 00120258 1 485 21:04:56| function:-]
    520|0 0 00120258 1 486 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x000000000173a690 exec_lava+0x1170()
    520|0 0 00120258 1 487 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000019c8540 s_execute+0x33b0()
    520|0 0 00120258 1 488 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  [Handler pc: 0x0x0000000001ab64a0 hdl_stack installed by the following
    520|0 0 00120258 1 489 21:04:56| function:-]
    520|0 0 00120258 1 490 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  [Handler pc: 0x0x0000000001a2a1a0 s_handle installed by the following
    520|0 0 00120258 1 491 21:04:56| function:-]
    520|0 0 00120258 1 492 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x0000000001a207b0 sequencer+0x12c0()
    520|0 0 00120258 1 493 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x00000000009285b5 tdsrecv_language+0x3d5()
    520|0 0 00120258 1 494 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  [Handler pc: 0x0x0000000001f41d20 ut_handle installed by the following
    520|0 0 00120258 1 495 21:04:56| function:-]
    520|0 0 00120258 1 496 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  pc: 0x000000000094ec22 conn_hdlr+0x3052()
    520|0 0 00120258 1 497 21:04:56|00:0002:00000:00035:2020/01/01 21:04:56.57 kernel  end of stack trace, spid 35, kpid 2818070, suid 3


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.x
  • ODBC

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.