Unable to online database after syslog full, followed by an Instance crash

[Ray]

The transaction log on one of the ASE 12.5 databases was full. It was
followed by an unexpected Instance crash.

When I tried to restart the ASE Server, the user databases could not
online with the following messages :

server Error: 1105, Severity: 17, State:3
server Can't allocate space for object 'syslogs' in database 'dbuser'
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.
server Error: 3475, Severity: 21, State:7
server There is no space available in SYSLOGS for process 1 to log a
record for which space has been reserved. This process will retry at
intervals of one minute. The internal error number is -4.

Anyone who can kindly help on this ?

[Ray]

This post might be inappropriate. Click to display it.

[A.M.]

Post by Ray
The transaction log on one of the ASE 12.5 databases was full. It was
followed by an unexpected Instance crash.

What messages showed up in the server's errorlog?

Post by Ray
When I tried to restart the ASE Server, the user databases could not
server Error: 1105, Severity: 17, State:3
server Can't allocate space for object 'syslogs' in database 'dbuser'
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.
server Error: 3475, Severity: 21, State:7
server There is no space available in SYSLOGS for process 1 to log a
record for which space has been reserved. This process will retry at
intervals of one minute. The internal error number is -4.
Anyone who can kindly help on this ?

You can try doing a dump tran using the no_log option.
If that doesn't work, see if you can do an alter database
to add some log space. If neither of those work, update
master..sysusages for one of the database's non-log
segments and change it to add a log segment to it (look
up the bit meanings for sysusages if you don't understand
what I mean). Bounce the server after this and see what
happens. I don't think you'll need to update the master..
database status bits for that database - unless it says
it was marked suspect.

You'll need to clean up that extra log segment later.
Post back for advice once you've got it up and running
again.

-am © MMVI

[unknown]

once you try with dump tran with no_log you might get some
free space. Commands will work even when database is
offline, Not sure if this command work when database is yet
to recover.

Second option if DB is not recovered, update bit status in
sysdatabases for bypass recovery and try altering the log

Thanks

Post by Ray
The transaction log on one of the ASE 12.5 databases was
full. It was followed by an unexpected Instance crash.
When I tried to restart the ASE Server, the user databases
server Error: 1105, Severity: 17, State:3
server Can't allocate space for object 'syslogs' in
database 'dbuser' 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. server
Error: 3475, Severity: 21, State:7 server There is no
space available in SYSLOGS for process 1 to log a record
for which space has been reserved. This process will retry
at intervals of one minute. The internal error number is
-4.
Anyone who can kindly help on this ?

[Ray]

I tried to use dump tran with no_log, it failed with error messages
"Database not online ...."

Would you show me how to update the bits status in the
sysdatabases table.

Thank you for your help in advance.

See the link

http://www.faqs.org/faqs/databases/sybase-faq/part7/

also see

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/38808;pt=38273

thanks

Post by Ray
I tried to use dump tran with no_log, it failed with error messages
"Database not online ...."
Would you show me how to update the bits status in the
sysdatabases table.
Thank you for your help in advance.