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

Search for additional results

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