sybase 11.92 NT 日志总是有问题 程序运行时快时慢

c001100c

Error: 691, Severity: 20, State: 6
00:00000:00035:2005/12/17 10:15:41.29 server  Encountered invalid logical page '0' while accessing object '-2293777' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00035:2005/12/17 10:15:41.29 kernel  ************************************
00:00000:00035:2005/12/17 10:15:41.29 kernel  SQL causing error : execute dbo.bq_lsby;1 @bq = '001', @flh = '03', @class = '5'
00:00000:00035:2005/12/17 10:15:41.29 kernel  ************************************
00:00000:00035:2005/12/17 10:15:41.29 server  SQL Text: execute dbo.bq_lsby;1 @bq = '001', @flh = '03', @class = '5'
00:00000:00035:2005/12/17 10:15:41.29 kernel  curdb = 5 pstat = 0x10000 lasterror = 691
00:00000:00035:2005/12/17 10:15:41.29 kernel  preverror = 0 transtate = 1
00:00000:00035:2005/12/17 10:15:41.29 kernel  curcmd = 193 program =                              
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x423ea34, 0x192004f, 0x423ea34, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x423ea34, 0x423ef88, 0x270f, 0x2)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x883514 pcstkwalk+ 0x224 (0x192004f, 0x2, 0x270f, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x14, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x423f34c, 0x4527a
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x405fe6 terminate_process+ 0x566 (0x423f3ac, 0x639a02, 0x6, 0x5b)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x4527ea close_network+ 0x1a (0x6, 0x5b, 0x14, 0x6)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x5b, 0x14, 0x6)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x639a02 s_handle+ 0x162 (0x6, 0x5b, 0x14, 0x6)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x452413 ex_raise+ 0x193 (0x3ea1222c, 0x202545ac, 0x6, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x543080 wrongpage+ 0x630 (0x423f4f4, 0x0, 0x202545ac, 0x1)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x57976d getrootpage+ 0x41d (0x423f860, 0x202545ac, 0x1, 0x1)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x5775c0 srchindex+ 0x190 (0x202545ac, 0x1, 0x20dd942c, 0x1)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x53141e apl__startscan+ 0x1ce (0x202545ac, 0x1, 0x1, 0x204a76a
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x530f4f startscan+ 0x21f (0x20da3378, 0x20e81bb8, 0x423fb28, 0x204a76a
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x6d6741 exec_eop+ 0x2d1 (0x20da3378, 0x20e818f4, 0x423fb28, 0x20da337
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x6d6837 exec_eop+ 0x3c7 (0x20da3378, 0x20d87b78, 0x423fb28, 0x204a76a
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x6d6f69 exec_eop+ 0xaf9 (0x20db2740, 0x20da316c, 0xc1, 0x423fb2
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x68fb50 sortmerr  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x635bb0 aritherr  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x6d573e execute+ 0x26e (0x204a76a8, 0x81a, 0x20dd7c18, 0xb)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x652ccb s_execute+ 0x78b (0x20db2000, 0x204a76a8, 0x20010080, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x6398a0 s_handle  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x63678f sequencer+ 0x15f (0x20dd7ba0, 0x20dd7c18, 0x0, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x659d8f execproc+ 0x28f (0x21, 0x204a76a8, 0x204a76a8, 0x203a5e80)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x65467a s_execute+ 0x213a (0x20d80800, 0x21, 0x1910025, 0x204a76a
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x6398a0 s_handle  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x63678f sequencer+ 0x15f (0x0, 0x20016c08, 0x1910025, 0x20013830)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x436d31 tdsrecv_language+ 0xc1 (0xe, 0x4000, 0x20016c08, 0x1910025)
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x452660 hdl_backout  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x40dc1c conn_hdlr+ 0xb5c (0x20016c08, 0x20013830, 0x1910025, 0x20016c0
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20016c08, 0x0, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x77ed4f05 KERNEL32.dll (0x0, 0x0, 0x20010080, 0x204a76a
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x77ed5449 KERNEL32.dll (0x0, 0x0, 0x0, 0x20dd7cbc)
00:00000:00035:2005/12/17 10:15:41.29 kernel  pc: 0x0 (suspect virtual address)(0x0, 0x0, 0x0, 0x0)
00:00000:00035:2005/12/17 10:15:41.29 kernel  end of stack trace, spid 35, kpid 26345551, suid 1
00:00000:00009:2005/12/18 13:25:53.75 kernel  Cannot send, host process disconnected:  -195087 spid: 9

冷月无声

做个dbcc 看看！

c001100c

那位高手能帮助一下，ERROR：691是怎么产生的

songwk80

建议备份数据库
重新安装

c001100c

谢谢，楼上的，数据库是刚刚新建的。

小无赖

把object '-2293777' 这个表的数据bcp或者select into出来,重建表结构,再把数据导进去.

第一次看到object id还有负数的!

RS9000

Error 691
Severity
20
Error Message
Encountered invalid logical page '%ld' while accessing
object '%ld' in database '%d'. This is an internal
system error. Please contact Sybase Technical Support.
Explanation
¨Note This message was introduced in Version 11.0.3 to improve the ability to
diagnose 605 object ID mismatch errors. Some errors that previously raised
the 605 error are now reported as 691 errors. These errors may be due to
hardware problems.
This error occurs when Adaptive Server tries to access an object but
requests an invalid page number. There are two possibilities:
• A negative page number is requested.
• Page number 0 is requested. To be more specific, a request is issued for
page 0, which is an allocation page, as if it was a data page. Data pages
do not use page ID 0. Corrupt page linkages or incorrect entries for the
object in sysindexes can cause the server to request page 0.
Error 691 results in a stack trace and breaks your connection to Adaptive
Server.
Action
Take the following steps:
1. Check the server error log for other errors that may have been raised
prior to the 691 error. Save the entire error log.
2. Identify the object named in the error message using the following
isql commands:
1> use <database name>
2> go
1> select name from sysobjects where id=<object id>
2> go

3. To determine the full extent of the corruption, run the dbcc checkdb and
dbcc checkalloc commands (or dbcc checktable and dbcc tablealloc) as soon as
possible. On version 11.5 and higher, you can also run dbcc checkstorage.
4. To check if this error is a result of hardware failure, examine your
operating system error log and correct hardware problems.
If the 691 error is not a soft error (one that exists only in memory), the
problem is severe. Sybase Technical Support may be able to help you
recover from the error. However this recovery procedure often results
in loss of data; if this is unacceptable, you will probably need to restore
from backups.
Additional Information
Refer to the writeup for Error 605 for a discussion of potential causes
of hardware error.
Have the following information ready before calling Sybase Technical
Support:
• Adaptive Server version and SWR version level
• Server error log
• Operating System error log
• Output of the dbcc checks from Step 3 above.
Version in Which This Error is Raised
11.0.3 and later

zhhui2000

原帖由 RS9000 于 2005-12-26 16:46 发表
Error 691
Severity
20
Error Message
Encountered invalid logical page '%ld' while accessing
object '%ld' in database '%d'. This is an internal
system error. Please contact Sybase Technical Sup ...

Professional!