Symptom
- Both a user-defined threshold and a last chance threshold on the logsegment may not be fired
- ASE runs out of log free space with a 1105 error and a 3475 error on a mixed data and log database.
Msg 1105, Level 17, State 7:
Server 'ASETEST', Line 2:
Can't allocate space for object 'syslogs' in database 'databasename' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
Msg 3475, Level 21, State 7:
Server 'ASETEST', Line 2:
There is no space available in SYSLOGS to log a record for which space has been reserved in database 'databasename' (id x). This process will retry at intervals of one minute.
- This problem can occur on the master database if you register a user-defined threshold because the master database is a mixed data and log database.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.x
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
"user defined", CR671152, CR#671152, 671152, truncate_only, "truncate log", "trunc log on chkpt", free space, syslogs, log segment, LCT , 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.