SAP Knowledge Base Article - Preview

2293345 - Executing an online parallel index may produce errors 871 and 804 - SAP ASE on Windows XP

Symptom

  • Executing an online parallel create index
  • ASE Server is a 2K page server
  • A 871 and 804 error is reported:

Error: 871, Severity: 20, State: 2 "Process %d is trying to release a latch on buffer 0x%x (dbid: %d, pageno: %u) without holding a latch on the buffer"
Error: 804, Severity: 20, State: 1 "Unable to find buffer '0x2fe4fb40' from cache 'default data cache' holding logical page '19987' in sdes '0x287eb8b0' kept buffer pool for object '<object>'.

  • ASE errorlog shows the following stack:

server  lava_psort_bldindex - got ATTEN 171.pattention=0, pstat=65538.
server  online utility rollback, trg_des 0x274ca280, keepcnt diff is  1 +1
server  SQL Text: [no text]
kernel  curdb = 4 tempdb = 2 pstat = 0x10400 p2stat = 0x101000
kernel  p3stat = 0x8800 p4stat = 0x0 p5stat = 0x80000 p6stat = 0x0 p7stat = 0x10000
kernel  lasterror = 804 preverror = 0 transtate = 1
kernel  curcmd = 294 program = <program>                        
kernel  extended error information: hostname: <hostname> login: user0
kernel  Symbolic stack trace information is successfully loaded
kernel  pc: 0x0000000001663479 NT_GetASEThreadType+ 0x596c9 (0x0000000009F7C010, 0x0000000009F7C010, 0x0000000009F7DFA0, 0x0000000000000000)
kernel  pc: 0x00000000015D5752 uboprop+ 0x247f2 (0x0000000000000001, 0x00000000006B0036, 0x000000000000270F, 0x0000000002F00000)
kernel  pc: 0x00000000015D50D4 uboprop+ 0x24174 (0x0000000000000001, 0x0000000000000001, 0x00000000FFFFFFFF, 0x0000000000000001)
kernel  pc: 0x00000000015D35CF uboprop+ 0x2266f (0x00000000287DB420, 0x00000000287DB6F0, 0x00000000287DB6F0, 0x0000000000000000)
kernel  end of stack trace, spid 76, kpid 7012406, suid 3


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Windows XP

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

error 871, severity:20, state: 2, buffer, index, error 804, severity: 20, state: 1, default data cache, CR#784606, CR784606, 784606 , 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.