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

[email protected]:/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: ***************************

[email protected]:/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……