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

原创 2007年09月15日 11:14:00

 问题描述:
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……

 

 

Sybase ASE:Can't allocate space for object in database 'tempdb' because 'default' segment is full

Sybase ASE:Can't allocate space for object in database 'tempdb' because 'default' segment is full

Can't allocate space for object 'syslogs' in database:Sybase

使用Sybase时候,遇到下面的错误: Can't allocate space for object 'syslogs' in database 'master' because 'logsegm...

Could not allocate space for object because the PRIMARY filegroup is full

SQL Server DBA Diaries   Could not allocate space for object because the PRIMARY filegroup...

win10 升级10041:Windows can't be installed because this PC has an unsupported disk layout for UEFI

如果你在安装或使用Windows 10 Build 10041时遇到了问题,那么你可能需要查看一下微软公布的Build 10041变通方案 一些用户的PC在尝试安装Windows 10 Build...

32.Your database instance is running with full workload after database creation. You have decided to

32.Your database instance is running with full workload after database creation. You have decided to...

Dbflow:Model object: xxxx is not registered with a Database. Did you forge an annotation?

错误代码: 错误描述,在三星、小米手机上运行没问题,在华为手机上抛出这个异常。 网上查询没有找到原因。 官网上提示说没有在application初始化的情况会抛出这个异常,但是初始化以...

SQL0964C The transaction log for the database is full (DB2 事务 日志满 清理 )

SQL0964C The transaction log for the database is full.  这个错误说明事务日志已满,查到一些解决方法: 方法一:命令行方式 把日志文件的...

Msg 9002 The transaction log for database '' is full

今天有个朋友说他的数据库报错,错误信息如下:   Msg 9002, Level 17, State 2, Line 4 The transaction log for database '' ...

移动文章分类的sql语句,查询并更新同一个表的方法 You can't specify target table 'news_articles' for update in FROM clause

移动文章分类的sql语句,很简单的一个 要把公司新闻的一些文章移动到公司新闻分类去。手动改麻烦,写个SQL直接改。 行业新闻分类的ID是19 公司新闻分类的ID是20 SQL代码如下: ...

'NoneType' object has no attribute '__getitem__'和argument of type 'NoneType' is not iterable 异常的解决办法

python多线程采集新浪微博GPS数据,存入Mongodb。Mongodb要求经纬度的严格顺序为[longtitude, latitude],而微薄返回的顺序正好相反。所以在转换时,报出如上图所示异...
  • era_misa
  • era_misa
  • 2014年04月03日 11:03
  • 24429
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Can't allocate space for object 'syslogs' in database 'ge' because 'logsegment' segment is full/has no free extents. If you ran
举报原因:
原因补充:

(最多只允许输入30个字)