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
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.
SAP Knowledge Base Article - Preview