SAP Knowledge Base Article - Preview

1912247 - Stuck spid causes log to fill up even if 'abort tran on log full' is set - ASE

Symptom

  • Spid is stuck
  • Tempdb is filled up
  • 'abort tran on log full' is set
  • The following warning is reported


Attempt by user 1 to dump xact on db tempdb with NO_LOG was successful
WARNING: ***************************
background task message: 1401 THRESHOLD WARNING: transaction log for database 'tempdb' is dumped with the NO_LOG option because 'trunc log on chkpt' option is set for the database
background task message: 1401 LOG DUMP PAGES: Before: '0' After '0'
background task message: 1401 LOG DUMP TIME: 'Sep 4 2013 3:15PM', 'Sep 4 2013 3:16PM'
Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
background task message: 1401 LOG FULL: Last chance threshold in log segment of database 'tempdb'


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , lct , last chance threshold , blocked spid , syslogs , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.