ASE :Space available in segment 'logsegment' has fallen critically low in database

一、问题


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>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值