SAP Knowledge Base Article - Preview

2713796 - Blocking "reorg rebuild index" process cannot be killed - SAP ASE

Symptom

  • A single "reorg rebuild index" process is blocking other ASE processes. The status of the ASE spid in sysprocesses is: "latch sleep".
  • The "reorg rebuild index" process cannot be killed via "kill" command.
  • There may or may not be concurrent reorg processes running on the same table/index.
  • "Error: 872, Severity: 20, State: 1" may also reported.
  • dbcc stacktrace on the "reorg" spid includes the following functions: buf_get_latch(), bt__rebld_leafs(), bt__rebldpgs(), bt_rebuildtree(), rbld__index_partition(), rbld__index_main(), reorg_main()

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 16.0

Keywords

self-deadlock, "latch sleep", reorg, "reorg rebuild index", CR817271, 817271 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.