SAP Knowledge Base Article - Preview

2496030 - Error 834 when using in-memory tempdb - SAP ASE

Symptom

  • When using an in-memory tempdb (IMDB)
  • Log filled up and trying to kill or rollback the session will receive error 834:

Space available in the log segment has fallen critically low in database 'TEMPDBIM'.
All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.

Error: 834, Severity: 20, State: 3
Illegal attempt to clean buffer: BUF=0x0x00002ab50a8373d8, MASS=0x0x00002ab50a8373d8, Buf#=0, page=0x0x00002ab5774ee800, dbid=123, Mass vdevno=12, vpage=54184,
Buf lpage=54184, Mass stat=0x4011001, Buf stat=0x2, size=2048, cid=5 ('tempdbcache'), Pinned xdes=0x(nil), spid=0.

  • Error 834 is followed by a stack trace including modules :

buffree
bufunkeep_cache
ins_insert
insert_all
LeInsertOp
LeEmitNoSndOp
LePlanNext


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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