Symptom
-
How to recover a user database when error 1105 followed by error 3475 was reported in the ASE errorlog?
- From ASE errorlog you can see some messages like:
Space available in the log segment has fallen critically low in database 'database_name'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
...
Error: 1105, Severity: 17, State: 4
Can't allocate space for object 'syslogs' in database 'database_name' 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.
...
Error: 3475, Severity: 21, State: 7
There is no space available in SYSLOGS to log a record for which space has been reserved in database 'database_name' (id x). This process will retry at intervals of one minute.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
replicate, replication, RepAgent, usedextents, -32768, sysdatabases, status, bypass, by-pass, recovery, secondary, truncation, point, truncate, truncate_only, sp_stop_rep_agent, sp_start_rep_agent, settrunc, ltm, ignore, valid, log, space, syslogs, GA1105, "Guided Answers" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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