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
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.