2081276 - Error: 832, Severity: 20, State: 1 - SAP ASE

• 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)

• SAP Adaptive Server Enterprise (ASE) 15.7

"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