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 for Me (Login required).

Search for additional results

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