一、问题
Space available in segment 'logsegment' has fallen critically low in database
'tempdb'. All future modifications to this database will be suspended until the
transaction 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. 找环境
到安装log目录下(或安装Home 目录,source ase/SYBASE.sh, 这样就可以跳过步骤1了)
//找找isql的的位置
sh-3.2$grep isql xxx.log
//找用的是哪个 server
sh-3.2$
grep NAME xxxx.log
2. 改log
sh-3.2$ xxxxx/OCS-16_0/bin/isql64 -Usa -P -S linuxserver3
1> alter database tempdb on default=50
2> go
Msg 5029, Level 16, State 1:
Line 1:
ALTER DATABASE failed. Log space in master database has reached the last chance
threshold. Please free-up log space in master database and try again.
1> dump tran master with truncate_only
2> go
1> alter database tempdb on default=50
2> go
Extending database by 2304 pages (9.0 megabytes) on disk master
1>