sybase 报错!!!急~~~~

casilin 2009-10-28 11:56:05

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

...全文

133 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

casilin 2009-10-29

打赏
举报

我修改了sybase的配置，优化了一下tempdb数据库，好了

cqhweb 2009-10-28

打赏
举报

当客户端由于某种原因（宕机、断线等）长时间未与服务器联系，ASE将自动删除该客户端连接，

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

文件名是contest.jsp ; try{ Context ctx = new InitialContext(); if(ctx == null) { throw new Exception("访问数据库失败，初始化环境失败");... 请教高手指点，哪里出错了，很急～～～谢谢了！！！！

从Sybase IQ到Oracle 最近工作有个项目需要每天从Sybase IQ取数到Oracle数据库，因此研究了许多方法，目前仍未成功过。记录下这坎坷的过程。一、在本地搭建Oracle环境分别安装oracle11gR2、SQL Developer两个软件...

SYBASE常见问题 1．在运行安装程序时提示碰到找不到JAVA 虚拟机，在安装客户端时我碰到过解决方法：由于SETUP.EXE 可以带参数，所以可以在当前目录建一个Setup.bat 批处理文件，内容如下：setup -is:javahome C...

SYBASE数据库技术,数据库恢复前言：ASE 15.7 新增了命令可以将数据库对象的所有权从一个所有者移交给另一个所有者。比如将表customer的所有权从dbo移交给bill，使用命令： alter table dbo.customer modify ...

SQL 指结构化查询语言 SQL 使我们有能力访问数据库 SQL 是一种 ANSI 的标准计算机语言 SQL 可与数据库程序协同工作，比如 MS Access、DB2、Informix、MS SQL Server、Oracle、Sybase 以及其他数据库系统。...