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 , Business Suite on Adaptive Server Enterprise , 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.