sybase,insert时报的一个严重错误,请各位大虾帮忙看下
insert 的时候出错信息为:
WARNING - Fatal Error 1127 occurred at Apr 7 2010 12:05PM. Please note
the error and time, and contact a user with System Administrator (SA) authoriza
tion.
奇怪的是,用下面的第一个insert语句报这个错,用第二个语句不报错,而这两个语句就差了一个alm_id的数值
语句如下:
第一个:insert into Tfi_actnminfo(alm_id,TL1,TL2,TL3,host_id,alm_time,alm_level,alm_detail,object_id,last_time,old_alm_id,alm_count)
values(253624448,1,4,35,454,'2010-4-7 12:21:20',1,'网元端口故障:NE=1257;PORTID=758;TIME=2010-04-07 12:21:20',1257,'2010-4-7 12:21:20',253624448,1)
第二个:
insert into Tfi_actnminfo(alm_id,TL1,TL2,TL3,host_id,alm_time,alm_level,alm_detail,object_id,last_time,old_alm_id,alm_count)
values(274135248,1,4,35,454,'2010-4-7 12:21:20',1,'网元端口故障:NE=1257;PORTID=758;TIME=2010-04-07 12:21:20',1257,'2010-4-7 12:21:20' ,274135248,1)
[解决办法]
这张表的行数是否超过了200多万?
The OAM has no room for new inserts.
-----------------------------------------------------
这个异常比较罕见。看看这个库还有可用空间吗?
[解决办法]
执行
select name from OAM..sysobjects where id=1913057851
go
看看是哪个表或者索引
然后确认这个表没有页链错误(dbcc checktable ,还有 dbcc tablealloc都正常)
再执行:
use OAM
go
sp_helpdb OAM
go
看一下数据空间和日志空间是否够用
[解决办法]