SAP Knowledge Base Article - Preview

2452537 - Running sp_fixindex and create temporary table concurrently cause stacktrace in tempdb

Symptom

  • Running sp_fixindex in tempdb to reclaim space from system tables
  • When user creating temporay table at the same time, the user connection stacktrace and holding a lock.
  • The following messages reported in errorlog:

    server  dbcc dbrepair: Clustered index restored for tempdb..syscomments.
    Current process (0x319f8) infected with signal 11 (SIGSEGV)
    Address 0x0x0000003ea52838a7 (memmove+0xa7), siginfo (code, address) = (1, 0x0xfffffffffffffffa)
    kernel  **** Saved signal context (0x0x00002aac5acdc700): ****
    kernel  ************************************
    kernel  SQL causing error : <SQL>
    kernel  curdb = 2 tempdb = 2 pstat = 0x10000 p2stat = 0x40101000
    kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
    kernel  lasterror = 0 preverror = 0 transtate = 0
    kernel  curcmd = 0 program = shortcut_server_bss
    kernel  extended error information: hostname: blkcisl005 login: mylogin
    kernel  pc: 0x00000000014e927b pcstkwalk+0x3a3()
    kernel  pc: 0x00000000014e8d53 ucstkgentrace+0x263()
    kernel  pc: 0x00000000014e8d53 ucstkgentrace+0x263()
    kernel  pc: 0x00000000014e4cbe ucbacktrace+0x50()
    kernel  pc: 0x0000000000773b64 terminate_process+0x15e4()
    kernel  pc: 0x0000000001538438 kisignal+0x31f()
    kernel  end of stack trace, spid 6305, kpid 203256, suid 1305


Read more...

Environment

  • Adaptive Server Enterprise 16
  • Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

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