sybaseASE日志溢出解決方式探究

--創建設備
disk init name='dat1',physname='/opt/sybase/data/dat1',size='1M'
disk init name='log1',physname='/opt/sybase/data/log1',size='1M'
--設備太小,擴充
disk resize name='dat1',size='1M'
--創建數據庫
create database test on dat1='2M' log on log1='1M'

use test
go
create table person(name varchar(64)) 
insert into person values('name')
insert into person select * from person
--truncate table person
dbcc checktable('syslogs')

1.free為7%,進程出現logsuspend狀態，數據庫日志中出現 xtasks are sleeping .for space to become available in the log segment for database test
2.進程狀態為LOGSUSPEND

‘DUMP TRANSACTION for database 'test' could not truncate the log. Either extend the log using ALTER DATABASE ... LOG ON command or eliminate the oldest active transaction in database 'test' shown in syslogshold table.’

[root@sybasehost ~]# isql -Usa -P -S ASE12_5_4 
1> shutdown 
2> go
2 task(s) are sleeping waiting for space to become available in the log segment
for database test.

SHUTDOWN is waiting for 1 process(es) to complete.
SHUTDOWN is waiting for 1 process(es) to complete.

 SQL Server could not bring database 'test' online.

disk init name='log2',physname='/opt/sybase/data/log2',size='1M'
alter database test log on log2 ='1M'

Extending database by 512 pages (1.0 megabytes) on disk log2
Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of the last chance threshold to be disabled.
執行時間: 1.471 秒

已插入 8192 行
Space available in the log segment has fallen critically low in database 'test'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
The transaction log in database test is almost full. Your transaction is being suspended until space is made available in the log.
執行時間: 158.9 秒