SAP Knowledge Base Article - Preview

2795213 - dbcc orphantable generate stack trace on d_orphantables - ASE

Symptom

  • Running a dbcc orphantable("drop")
  • The following stacktrace is generated:

server SQL Text: dbcc orphantables("drop")
kernel curdb = 4 tempdb = 43 pstat = 0x10000 p2stat = 0x101010
kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
kernel lasterror = 0 preverror = 0 transtate = 3
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

  • 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) 16.0

Product

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.