SAP Knowledge Base Article - Preview

2713796 - Reorg rebuild comand blocking other processes and cannot be killed - SAP ASE

Symptom

  • A reorg rebuild command is blocking other processes and in "latch sleep".
  • The reorg rebuild process cannot be killed.
  • There maybe other reorg rebuild commands running at the same time.
  • "Error: 872, Severity: 20, State: 1" may also reported.
  • When running dbcc stacktrace on the reorg command spid, the following stacktrace can be seen:
    upsleepgeneric
    buf_get_latch
    bt__rebld_leafs
    bt__rebldpgs
    bt_rebuildtree
    rbld__index_partition
    rbld__index_main
    reorg_main
    s_execute
     

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

self-deadlock,latch sleep, , 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.