Displaying difference between revision 4 and 3 of Wiki page:Sybase error 1105 - logsegment is full
Please wait, loading revisions...
display as  
!!Symptom Sybase does not store data correctly, cannot add users, etc., the following type of errors appear in the [Sybase error log|WIKIPAGE:5378]: {{{Error: 1105, Severity: 17, State: 4 Can't allocate space for object 'syslogs' in database 'master' 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 or sp_extendsegment to increase size of the segment.}}} !!Solution This is primarily caused by a lack of (manual) maintenance on the Sybase Server. As Ameos Models grow, log segments of individual databases need to be increased. Also, for Sybase Servers which do not reboot regularly, running the Ameos desktop's __Admin -> Perform Manager Maintenance__ command is essential. See also "5 Repository Manager Maintenance" in the Online PDF documentation or [here|DOC:2366] The following steps will usually help to solve the problem: First, dump the transaction log: ([how to run isql|WIKIPAGE:2910]) {{{isql -Usa Password:<SA_PASSWORD> 1> use master 2> go 1> dump transaction master with no_log 2> go}}} Now, the errorlog should show something like: {{{server WARNING: *************************** server Attempt by user 1 to dump xact on db master with NO_LOG server Attempt by user 1 to dump xact on db master with NO_LOG was successful server WARNING: ***************************}}} It might also be a good idea to extend the log segment of the master database by some MBs. Check how much space there is left on the master device by using the sp_helpdevice command, then: {{{, i.e. by 8: {{{isql -Usa Password:<SA_PASSWORD> 1> alter database master 2> log on masterdefault = 8 3> with override 4> go}}} This extends the master log segment by 8MB (the threshold warbing can be ignored). If there's not enough space left on the master device, you can [resize the master device|WIKIPAGE:2840] before running the alter database command. If you have done this, restart the Sybase server and test it. If Sybase is still not working, you have to increase the size of the segment 'logsegment' as mentioned in the errorlog with: {{{isql -Usa Password:<SA_PASSWORD> 1> sp_extendsegment logsegment, master, master 2> go}}} The answer should be: {{{DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. Segment extended. (return status = 0)}}} In many cases this will help. (Further details can be found in the above mentioned manual in the chapter "Troubleshooting a Sybase Server") As last resort, see this [Sybase article|http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookView;lang=de?DwebQuery=1105&DwebSearchAll=1]