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 for Me (Login required).

Search for additional results

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