Can't allocate space for object 'syslogs' in database 'ge' because 'logsegment' segment is full/has no free extents. If you ran

 问题描述：
00:00000:00001:2007/09/15 10:56:14.76 server  Completed REDO pass for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.76 server  Recovery of database 'ge' will undo incomplete nested top actions.
00:00000:00001:2007/09/15 10:56:14.76 server  Started recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server  Completed recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server  Started filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.80 server  Completed filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.81 server  Started cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server  Completed cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server  Checking external objects.
00:00000:00001:2007/09/15 10:56:14.83 server  Space available in the log segment has fallen critically low in database 'ge'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00001:2007/09/15 10:56:14.83 server  Error: 1105, Severity: 17, State: 4
00:00000:00001:2007/09/15 10:56:14.83 server  Can't allocate space for object 'syslogs' in database 'ge' 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 to increase the size of the segment.
00:00000:00010:2007/09/15 10:56:14.84 server  Error: 950, Severity: 14, State: 1
00:00000:00010:2007/09/15 10:56:14.84 server  Database 'ge' is currently offline. Please wait and try your command again later.
00:00000:00010:2007/09/15 10:56:14.84 server  Threshold task could not use database 6, and so cannot execute the threshold procedure for segment 2, free space 153616.
00:00000:00010:2007/09/15 10:56:14.84 server  Failed to execute the threshold procedure for database 6, segment 2, free space 153616.
00:00000:00001:2007/09/15 10:56:14.84 server  SQL Server could not bring database 'ge' online.
00:00000:00001:2007/09/15 10:56:14.84 server  Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.84 server  Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.88 server  Recovery has restored the original size for '16K' pool and '2K' pool in 'default data cache'.

 

解决方法：

进入isql

1> use master
2> go
1> dump tran ge with no_log
2> go

1> shutdown
2> go

 

日志中信息如下：

00:00000:00011:2007/09/15 10:59:40.13 server  WARNING: ***************************
00:00000:00011:2007/09/15 10:59:40.13 server  Attempt by user 1 to dump xact on db ge with NO_LOG

sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:01:05.62 server  Attempt by user 1 to dump xact on db ge with NO_LOG was successful
00:00000:00011:2007/09/15 11:01:05.63 server  WARNING: ***************************

sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:02:30.00 server  SQL Server shutdown by request.
00:00000:00011:2007/09/15 11:02:30.00 kernel  ueshutdown: exiting

 

然后重新启动数据库即可

 

参考文章：http://hi.baidu.com/woshi123/blog/item/2328c31166b4c2c7a6ef3f37.html

系统提示Can"t allocate space for object "syslogs" in database 该如何处理？

2007-05-21 21:46

系统提示Can"t allocate space for object "syslogs" in database "cwbase?" because the "logsegment" segment is full……该如何处理？
　

上面的提示指数据库的日志已满，可用系统管理员按如下方法解决：
（1）如果是 master 库：
dump tran master with no_log
（2）如果是用户数据库（如：cwbase1）：
可以等待自动清理，过5分钟后，再重启SQLSERVER；否则：
用WISQL连接该帐套数据库后执行以下语句：
use master
go
sp_dboption cwbase1,"trunc. log on chkpt.",false
go
checkpoint
go
dump tran cwbase1 with no_log
go
sp_dboption cwbase1,"trunc. log on chkpt.",true
go
checkpoint
go

第二套帐依次类推，将1改成2、3、4、5……