远程链接的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)