跪求 解决错误691 无法连接数据库

xztok

我用空库 BCP导入也中途报错，用户表可以访问，一写入数据 就进程锁死，但是找锁死进程。也好不到对应的号。下面是出错信息
00:00000:00009:2015/03/01 22:00:31.15 server  Error: 691, Severity: 20, State: 1
00:00000:00009:2015/03/01 22:00:31.15 server  Encountered invalid logical page '0' while accessing object '14' in database '5'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00009:2015/03/01 22:00:31.15 kernel  ************************************
00:00000:00009:2015/03/01 22:00:31.15 kernel  SQL causing error :    BZHL=1,

    0:31.17 kernel  curdb = 5 pstat = 0x10108 lasterror = 691
00:00000:00009:2015/03/01 22:00:31.18 kernel  preverror = 0 transtate = 0
00:00000:00009:2015/03/01 22:00:31.18 kernel  curcmd = 197 program =                              
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x8a2977 (Symbol not found)(0x180ec18, 0x1a001a, 0x180ec18, 0x0)
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x8a2977 (Symbol not found)(0x180ec18, 0x180f16c, 0x270f, 0x2)
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x883514 (Symbol not found)(0x1a001a, 0x2, 0x270f, 0x0)
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x8830ae (Symbol not found)(0x0, 0x1, 0x14, 0x0)
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x862864 (Symbol not found)(0x0, 0xffffffff, 0x180f530, 0x4527a
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x405fe6 (Symbol not found)(0x180f590, 0x639a02, 0x6, 0x5b)
00:00000:00009:2015/03/01 22:00:31.18 kernel  pc: 0x4527ea (Symbol not found)(0x6, 0x5b, 0x14, 0x1)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x4527a8 (Symbol not found)(0x6, 0x5b, 0x14, 0x1)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x639a02 (Symbol not found)(0x6, 0x5b, 0x14, 0x1)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x452413 (Symbol not found)(0x6bf939d8, 0x2062d5a0, 0x1, 0x0)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x543080 (Symbol not found)(0x2062d5a0, 0x4, 0x0, 0x0)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x540482 (Symbol not found)(0x2062d5a0, 0x21698b40, 0x180f744, 0x0)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x5079d9 (Symbol not found)(0x2062cdc8, 0x180f7c0, 0x2, 0x1f80000)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x507db1 (Symbol not found)(0x2062cdc8, 0x1f7ffff, 0x180f830, 0xa)
00:00000:00009:2015/03/01 22:00:31.20 kernel  pc: 0x4e8de7 (Symbol not found)(0x21de6d8c, 0x6bf57e34, 0x1, 0x21e1fb70)
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x549917 (Symbol not found)(0x21e1fb70, 0x0, 0x0, 0x201e61d4)
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x54e78c (Symbol not found)(0x201e61d4, 0x28, 0x0, 0x201e61d4)
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x54393c (Symbol not found)(0x201e61d4, 0xc, 0x2062d248, 0x
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x55c380 (Symbol not found)(0x2062d1b4, 0x6bf5abf8, 0x2062c500, 0x20977a70)
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x55a9d2 (Symbol not found)(0x201e61d4, 0x18227982, 0x5, 0x0)
00:00000:00009:2015/03/01 22:00:31.21 kernel  [Handler pc: 0x619bc0 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.21 kernel  pc: 0x61905c (Symbol not found)(0x20977a70, 0x21edd000, 0x2062c500, 0x20632fec)
00:00000:00009:2015/03/01 22:00:31.21 kernel  [Handler pc: 0x452660 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.23 kernel  [Handler pc: 0x452660 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x639652 (Symbol not found)(0x21edd000, 0x21f02800, 0x4, 0x2062c500)
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x639334 (Symbol not found)(0x4, 0x2062c500, 0x20977a70, 0x20632fec)
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x6391aa (Symbol not found)(0x21edd000, 0x2062c500, 0x20010040, 0x0)
00:00000:00009:2015/03/01 22:00:31.23 kernel  [Handler pc: 0x6398a0 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x637665 (Symbol not found)(0x21f2ccf4, 0x21f2cd90, 0x201e6110, 0x20276ad0)
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x65a99e (Symbol not found)(0x21, 0x2062c500, 0x2062c500, 0x205dcde0)
00:00000:00009:2015/03/01 22:00:31.23 kernel  pc: 0x655504 (Symbol not found)(0x21ee8800, 0x21, 0x2063373d, 0x2062c500)
00:00000:00009:2015/03/01 22:00:31.25 kernel  [Handler pc: 0x6398a0 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.25 kernel  pc: 0x63678f (Symbol not found)(0x0, 0x200149f8, 0x0, 0x0)
00:00000:00009:2015/03/01 22:00:31.25 kernel  pc: 0x436d31 (Symbol not found)(0x3, 0x4000, 0x200149f8, 0x0)
00:00000:00009:2015/03/01 22:00:31.25 kernel  [Handler pc: 0x452660 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.25 kernel  [Handler pc: 0x5c0c40 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.25 kernel  [Handler pc: 0x5c0c40 (Symbol not found) installed by the following function:-]
00:00000:00009:2015/03/01 22:00:31.25 kernel  pc: 0x40dc1c (Symbol not found)(0x200149f8, 0x0, 0x0, 0x200149f
00:00000:00009:2015/03/01 22:00:31.26 kernel  pc: 0x89c1c6 (Symbol not found)(0x0, 0x0, 0x0, 0x0)
00:00000:00009:2015/03/01 22:00:31.26 kernel  end of stack trace, spid 9, kpid 1703962, suid 1
00:00000:00009:2015/03/01 22:00:31.26 server  Error: 21, Severity: 26, State: 1
00:00000:00009:2015/03/01 22:00:31.26 server  WARNING - Fatal Error 1251 occurred at Mar  1 2015 10:00PM.  Please note the error and time, and contact a user with System Administrator (SA) authorization.
00:00000:00009:2015/03/01 22:00:31.28 server  Error: 1251, Severity: 26, State: 1
00:00000:00009:2015/03/01 22:00:31.28 server  An in-use preallocated semaphore cursor was encountered.
00:00000:00009:2015/03/01 22:00:31.28 server  Error while undoing log row in database 'ZD_JXC'.  Rid pageid = 0x0; row num = 0x0.
00:00000:00009:2015/03/01 22:00:31.28 server  WARNING: Pss found with open sdes.  pspid 9, psuid 1, pcurdb 5, system table entry 0, sdesp 0x2169ada0, objid 8
00:00000:00009:2015/03/01 22:00:31.28 server  WARNING: Pss found with open sdes.  pspid 9, psuid 1, pcurdb 5, system table entry 1, sdesp 0x21244340, objid 404912514
00:00000:00009:2015/03/01 22:00:31.28 server  WARNING: Pss found with open sdes.  pspid 9, psuid 1, pcurdb 5, system table entry 2, sdesp 0x2169ada0, objid 8
00:00000:00009:2015/03/01 22:00:31.29 server  WARNING: Pss found with open sdes.  pspid 9, psuid 1, pcurdb 5, system table entry 3, sdesp 0x2169a440, objid 5
00:00000:00009:2015/03/01 22:00:31.29 server  WARNING: Pss found with open sdes.  pspid 9, psuid 1, pcurdb 5, system table entry 4, sdesp 0x2169c060, objid 14
00:00000:00009:2015/03/01 22:00:31.29 server  Error: 6103, Severity: 17, State: 1
00:00000:00009:2015/03/01 22:00:31.29 server  Unable to do cleanup for the killed process; received Msg 3300.
00:00000:00009:2015/03/01 22:00:31.29 server  WARNING: spid 9, with suid 1 and curdbid 5 has active XDES #1 with xactid (33030136, 1).

andkylee

检查数据库设备所在磁盘是否有故障。

ceozenliu

1.先查出DB-NAME
2.再查出object-name
3.執行dbcc tablealloc去修復

wfcjz

http://infocenter.sybase.com/arc ... AdvRes/BACHGFJI.htm

good luck!

wq4113

收藏一下了

wfcjz

回复 2# andkylee


http://bbs.chinaunix.net/thread-4191019-1-1.html

推荐你了，

   

andkylee

非常感谢。。。

Anxiang1129

回复 8# andkylee