SAP Knowledge Base Article - Preview

2384481 - Reorg defrag when used with 'skip_compact_extents' may produce error 871 - SAP ASE

Symptom

  • Error: 871, Severity: 20, State: 2
  • Process 166 is trying to release a latch on buffer 0x1a83c870 (dbid: 5, pageno: 113225) without holding a latch on the buffer.
  • SQL causing error : REORG DEFRAG DBH_STG_TABLES WITH SKIP_COMPACT_EXTENTS = 90
  • An 871 error "Process <n> is trying to release a latch on buffer <0xabcd> (dbid: <n>, pageno: <n>) without holding a latch on the buffer"

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver
  • Solaris on Sparc 64 bit
  • Solaris on x86_64 64bit

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Error: 871, Severity: 20, State: 2, CR790456, CR#790456, 790456 , 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.