报错信息如下
Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
The transaction log in database tempdb is almost full. Your transaction is being suspended until space is made available in the log.
因为临时库作为全局应用,涉及到排序、临时表等操作,所以临时库日志空间不足会导致所有进程挂起
解决办法1
1.登陆连个sa用户到sybase server
2.一个用shutdown进行停库操作,结果显示信息如下
1> shutdown
2> go
1 task(s) are sleeping waiting for space to become available in the log segment
for database tempdb.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.
3.在第二个窗口用shutdown with nowiat停掉库,再重启
1> shutdown with nowait
2> go
A SHUTDOWN command is already in progress. Please log off.
Server SHUTDOWN by request.
The SQL Server is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
解决办法2