Symptom
- When configuration parameter 'max buffers per lava operator' is set to maximum of 65535 or a value close to the maximum
- User session terminates unexpectedly with error 832 reported to the client:
Error: 832, Severity: 20, State: 1
Unable to place buffer <hex#> holding logical page 24 in sdes for object 'temp worktable' - there is no room in sdes aux keep pool.
- ASE errorlog also reports error 832, with (many) additional log messages and followed by a stacktrace which includes ASE functions bufkeep , buf__unhash_and_keep_grabbed_mass , bufreserve , sort_bufreserve. Sample log entries are:
- server Diagnostics related to error 832 state 1 for spid 47 follow, curcmd=193 (SELECT), xactid=(0,0), plasterror=0, pattention=0, pstat=0x10000, p2stat=0x1000, p3stat=0x800.
- server [0] spid=47, dbid=2, objid=-3080197, indid=0, ptnid=-1, pageno=24, ts=0000 00000000, cacheid=0, buf=0x0x5eec36680, mbuf=0x0x5eec36680, msize=2048 (2K), mstat=80c
- Error: 832, Severity: 20, State: 1
Unable to place buffer <hex#> holding logical page 24 in sdes for object 'temp worktable' - there is no room in sdes aux keep pool. -
bufkeep+0x1a8()
buf__unhash_and_keep_grabbed_mass+0x4d0()
bufreserve+0xc8()
sort_bufreserve+0xc9()
(offsets will vary by platform)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
Product
SAP Adaptive Server Enterprise 15.7
Keywords
"error 832", "message 832", "max buffer", "lava operator", bufkeep , buf__unhash_and_keep_grabbed_mass , bufreserve , sort_bufreserve , 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.