SAP Knowledge Base Article - Preview

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


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



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


SAP Adaptive Server Enterprise 16.0


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 ONE Support launchpad (Login required).

Search for additional results

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