Symptom
- A dump transaction command is not clearing space in a database
- A "dump transaction <SID>" command completes but does not free log space
- Which can result in the database running out of log space with error 1105 messages in ASE errorlog:
Error: 1105, Severity: 17, State: 7
Can't allocate space for object 'syslogs' in database '<DBSID>' 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 - Command "select * from master..syslogshold" shows a long running process with name $replication_truncation_point:
dbid reserved spid page xactid masterxactid starttime name
------ ------------- ------ ------ --------- ----------------- ----------------------------- ------------------------------------------
4 0 0 1234 0x000 0x000 May 7 2018 11:33AM $replication_truncation_point
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- SAP Replication Server (SRS)
Product
SAP Adaptive Server Enterprise all versions ; SAP Replication Server all versions
Keywords
1105, syslogs, syslogshold, replication_truncation_point, STP, dbcc settrunc, out of space, truncation point, transaction log, truncate, GA1105, "Guided Answers" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.
SAP Knowledge Base Article - Preview