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
Keywords
KBA , last chance threshold , lct , syslogs , blocked spid , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.