SAP Knowledge Base Article - Preview

2795213 - Signal 11 in d_orphantables() caused by DBCC ORPHANTABLE - SAP ASE

Symptom

  • Running DBCC ORPHANTABLE ("drop").
  • The ASE errorlog contains an "infected with signal 11" error in the module d_orphantables() together with a stack trace:

Current process (0x450f04fe) infected with signal 11 (SIGSEGV)
Address 0x0x0000000000b4fd9e (d_orphantables+0xc47), siginfo (code, address) = (1, 0x0x000000000000027e)

  • The stack trace is generated as:

server SQL Text: dbcc orphantables("drop")
...
kernel curcmd = 317 program = isql
kernel extended error information: hostname: <hostname> login: sa
kernel pc: 0x00000000015240c0 pcstkwalk+0x482()
kernel pc: 0x0000000001523a7f ucstkgentrace+0x20f()
kernel pc: 0x00000000015202b2 ucbacktrace+0x54()
kernel pc: 0x00000000017ed8f7 terminate_process+0xb17()
kernel pc: 0x000000000155078c kisignal+0x706()
kernel pc: 0x0000000000b4fd9e d_orphantables+0xc47()
kernel pc: 0x0000000001cc2b2e exec_dbcc+0x108e()
kernel pc: 0x00000000020193e5 s_execute+0x4ab5()
kernel pc: 0x0000000002044a4d sequencer+0xd1d()
kernel pc: 0x000000000180c8ca tdsrecv_language+0x1ea()
kernel pc: 0x0000000001823479 conn_hdlr+0xf79()
kernel end of stack trace, spid 4191, kpid 1158612222, suid 1

  • And a 14127 error is reported:

Error: 14127, Severity: 16, State: 2
Cannot drop or modify partition descriptor database 'tempdb1' (4), object '#above0103382221d863357' (1345680121), index '#above0103382221d863357' (0), partition '#above0103382221d863357_1345680121' (1345680121) as it is in use. Please retry your command later. Total reference count '4'. Task reference count '2'.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR819329, CR#819329, 819329, orphan, temporary , 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.