首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Sybase >

sybase 报错!解决方法

2012-03-16 
sybase 报错!!!急~~~~远程链接的sybase,内有三张10万条数据的表,访问开始时报tempdb空间不够,我就将tempdb

sybase 报错!!!急~~~~
远程链接的sybase,内有三张10万条数据的表,访问开始时报tempdb空间不够,我就将tempdb的日志文件挪至新的设备上,给了50M(不知道给多少比较合适),然后又把其在master设备上的空间扩大至32M,觉得这下应该没有问题了,可是,访问时发现cpu占了100%,随后链接就中断了,发现sybase日志中报如下错误,实在不知道该怎么解决了
00:00000:00018:2009/10/28 11:36:09.43 server Error: 1143, Severity: 22, State: 3
00:00000:00018:2009/10/28 11:36:09.43 server Invalid OAM Page 28161. Expected object=-1179699. Found object=-1179698, database=2, pstat=0x8000, indid=0.
00:00000:00018:2009/10/28 11:36:09.43 kernel ************************************
00:00000:00018:2009/10/28 11:36:09.43 kernel SQL causing error : select * from dbo.ytsjA,dbo.ytsjB,dbo.ytsjStrategy_GN_33 where dbo.ytsjA.nmId=dbo.ytsjB.nmId and dbo.ytsjA.nmId=dbo.ytsjStrategy_GN_33.nmId
00:00000:00018:2009/10/28 11:36:09.43 kernel ************************************
00:00000:00018:2009/10/28 11:36:09.43 server SQL Text: select * from dbo.ytsjA,dbo.ytsjB,dbo.ytsjStrategy_GN_33 where dbo.ytsjA.nmId=dbo.ytsjB.nmId and dbo.ytsjA.nmId=dbo.ytsjStrategy_GN_33.nmId
00:00000:00018:2009/10/28 11:36:09.43 kernel curdb = 4 tempdb = 2 pstat = 0x10000
00:00000:00018:2009/10/28 11:36:09.43 kernel lasterror = 1143 preverror = 0 transtate = 3
00:00000:00018:2009/10/28 11:36:09.43 kernel curcmd = 193 program =  
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00BA686D AseHTTPURLInputStream::readBytes+ 0xe8b57 (0x01F8D248, 0x7C821A60, 0x7C824598, 0xFFFFFFFF)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00BA686D AseHTTPURLInputStream::readBytes+ 0xe8b57 (0x01F8D248, 0x01F8D000, 0x0000270F, 0x00000002)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00B7EF7A AseHTTPURLInputStream::readBytes+ 0xc1264 (0x00140014, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00B7EC04 AseHTTPURLInputStream::readBytes+ 0xc0eee (0x00140014, 0x00000001, 0x01F8D8A0, 0x012726D4)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00B34B3B AseHTTPURLInputStream::readBytes+ 0x76e25 (0x00000000, 0xFFFFFFFF, 0x01F8D798, 0x00471B64)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x0040736E (Symbol not found)(0x01F8D8A0, 0x007993E6, 0x0000000B, 0x0000002B)
...都是symbol not found
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00837EDC (Symbol not found)(0x216C9528, 0x215C1800, 0x000000C1, 0x01F8F868)
00:00000:00018:2009/10/28 11:36:09.57 kernel [Handler pc: 0x0083DE78 (Symbol not found) installed by the following function:-]
...
00:00000:00018:2009/10/28 11:36:09.57 kernel [Handler pc: 0x007912E8 (Symbol not found) installed by the following function:-]
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00837029 (Symbol not found)(0x00000000, 0x20EB3E78, 0x00000000, 0x00000000)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00759BFB (Symbol not found)(0x215B7000, 0x0044A755, 0x01F8FF48, 0x012726D4)
00:00000:00018:2009/10/28 11:36:09.57 kernel [Handler pc: 0x00797C32 (Symbol not found) installed by the following function:-]
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00793E83 (Symbol not found)(0x20EA5100, 0x00000000, 0x00000000, 0x00000000)
00:00000:00018:2009/10/28 11:36:09.57 kernel pc: 0x00452A6E (Symbol not found)(0x00000006, 0x00000000, 0x00000000, 0x212C0E38)
00:00000:00018:2009/10/28 11:36:09.59 kernel [Handler pc: 0x004717D4 (Symbol not found) installed by the following function:-]
00:00000:00018:2009/10/28 11:36:09.59 kernel [Handler pc: 0x006D4FC0 (Symbol not found) installed by the following function:-]
00:00000:00018:2009/10/28 11:36:09.59 kernel [Handler pc: 0x006D4FC0 (Symbol not found) installed by the following function:-]
00:00000:00018:2009/10/28 11:36:09.59 kernel pc: 0x0041ABA8 (Symbol not found)(0x212C0E38, 0x00000000, 0x00000000, 0x212C0E38)
00:00000:00018:2009/10/28 11:36:09.59 kernel pc: 0x00B2A187 AseHTTPURLInputStream::readBytes+ 0x6c471 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00018:2009/10/28 11:36:09.62 kernel pc: 0x7C824829 kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)


00:00000:00018:2009/10/28 11:36:09.62 kernel end of stack trace, spid 18, kpid 1310740, suid 1



[解决办法]
当客户端由于某种原因(宕机、断线等)长时间未与服务器联系,ASE将自动删除该客户端连接,

有两个主要原因:1、网络故障,硬件、或病毒等,2、服务器自身错误(可能是ASE也可能是操作系统)导致无法与客户端连接
错误不会导致宕机,从你的LOG上看,宕机是由于存储设备问题造成的,检查一下你的数据库设备,当然也包括你的操作系统

热点排行