日志错误server Error: 692，应该如何解决

ehxz

免费乐捐，感谢支持

01:00000:00130:2005/05/26 12:09:00.17 server Error: 692, Severity: 20, State: 1
01:00000:00130:2005/05/26 12:09:00.17 server Uninitialized logical page '8623' was read while accessing object '8' in database '1'. Please contact Sybase Technical Support.
01:00000:00130:2005/05/26 12:09:00.23 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
01:00000:00130:2005/05/26 12:09:00.42 kernel pc: 0x008CB630 dpdb_handle+ 0x78 (0x00000024, 0x00000002, 0x00000019, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.42 kernel pc: 0x008CB630 dpdb_handle+ 0x78 (0x00000024, 0x00000002, 0x00000019, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.43 kernel pc: 0x0046736B ex_raise+ 0x2b3 (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x0073AC47 s_handle+ 0x12a8 (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x0046736B ex_raise+ 0x2b3 (0x5E2FDBF8, 0x23AE2784, 0x00000001, 0x00000001)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x005D667B wrongpage+ 0x2ec (0x23AE2784, 0x00000004, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x005D46C8 getpage_with_validation+ 0x1358 (0x28EAD000, 0x000021A4, 0x00001C49, 0x00001C4A)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x008BF9F8 dmp_send_logchain+ 0x6a3 (0x00001C4A, 0x28EAD000, 0x0DC3E930, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x008B831B dmpx_scanlog+ 0x165 (0x0DC3F310, 0x00000006, 0x00000000, 0x01000001)
01:00000:00130:2005/05/26 12:09:00.45 kernel [Handler pc: 0x008CB5B8 dpdb_handle installed by the following function:-]
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x008B703E dmpx__truncatemain+ 0x84d (0x2BFE25B0, 0x00000000, 0x00000000, 0x00000001)
01:00000:00130:2005/05/26 12:09:00.45 kernel pc: 0x008B67EB dmpxact+ 0x8b (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.48 kernel pc: 0x00707116 s_execute+ 0x4496 (0x28EAD000, 0x00449075, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.48 kernel [Handler pc: 0x0073999F s_handle installed by the following function:-]
01:00000:00130:2005/05/26 12:09:00.48 kernel pc: 0x00736835 sequencer+ 0x17f5 (0x23AE2100, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.48 kernel pc: 0x00444314 tdsrecv_language+ 0x540 (0x0000004B, 0x00000000, 0x00000000, 0x24A554E4)
01:00000:00130:2005/05/26 12:09:00.48 kernel [Handler pc: 0x004673D7 hdl_backout installed by the following function:-]
01:00000:00130:2005/05/26 12:09:00.50 kernel [Handler pc: 0x00690BD0 ut_handle installed by the following function:-]
01:00000:00130:2005/05/26 12:09:00.51 kernel [Handler pc: 0x00690BD0 ut_handle installed by the following function:-]
01:00000:00130:2005/05/26 12:09:00.51 kernel pc: 0x00412202 conn_hdlr+ 0x3429 (0x24A554E4, 0x00000000, 0x00000000, 0x24A554E4)
01:00000:00130:2005/05/26 12:09:00.54 kernel pc: 0x00A1EF27 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.56 kernel pc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.56 kernel end of stack trace, spid 130, kpid 220135570, suid 1
01:00000:00130:2005/05/26 12:09:00.56 kernel ************************************
01:00000:00130:2005/05/26 12:09:00.56 kernel SQL causing error : dump tran master with truncate_only

01:00000:00130:2005/05/26 12:09:00.56 kernel ************************************
01:00000:00130:2005/05/26 12:09:00.57 server SQL Text: dump tran master with truncate_only
01:00000:00130:2005/05/26 12:09:00.57 kernel curdb = 1 pstat = 0x10000 lasterror = 692
01:00000:00130:2005/05/26 12:09:00.57 kernel preverror = 0 transtate = 3
01:00000:00130:2005/05/26 12:09:00.57 kernel curcmd = 235 program = isql
01:00000:00130:2005/05/26 12:09:00.60 kernel pc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0DC3D0F0, 0x77E6E597, 0x77E64E58, 0xFFFFFFFF)
01:00000:00130:2005/05/26 12:09:00.60 kernel pc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0DC3D0F0, 0x0DC3CEA8, 0x0000270F, 0x00000002)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00A6F8BA pcstkwalk+ 0x204 (0x0D1F0092, 0x00000002, 0x0000270F, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00A6F544 ucstkgentrace+ 0x224 (0x0D1F0092, 0x00000001, 0x00BEC888, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00A2969B ucbacktrace+ 0xab (0x0D1F0092, 0xFFFFFFFF, 0xC0000005, 0x23AE21FC)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00406FC1 terminate_process+ 0xb8f (0xC0000005, 0x7800BDB5, 0x0DC3D470, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00A1E47B kiexception+ 0x2e0 (0x24A554E4, 0x00000000, 0x00000000, 0x24A554E4)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x00A1EFA7 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.64 kernel pc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00130:2005/05/26 12:09:00.64 kernel end of stack trace, spid 130, kpid 220135570, suid 1
00:00000:00051:2005/05/26 12:20:56.07 server Bufunhash: Buffer 0x5e2fdbf8 from database id 1 has page number 0
in the page header and page number 8623 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
00:00000:00051:2005/05/26 12:20:56.07 server Mass: 0x5e2fdbf8 Buffer: 0x5e2fdbf8 Mass pagen 8623
-Mass virtpg: 12211 dbid: 1 Mass stat: 0x4001010
-Buffer pagen 8623 Buffer virtpg: 12211 Buf stat: 0x1 keep: 0 awaited: 0 tripsleft: 0
-bpage: 0x4cf2c000 flushseq: 0 dirty seq: 0 filthyseq: 0 linked: ( hash lru)
00:00000:00051:2005/05/26 12:20:56.09 server Page: 0x4cf2c000 pagen 0 objid: 0 indid: 0
- nextpg: 0 prevpg: 0 pstat: 0x0 ts: (0, 0) nextrn 0
- freeoff: 0 minlen: 0 level: 0
00:00000:00137:2005/05/26 12:24:44.23 server Process id 51 killed by Hostname LEE, Host process id 1620.
00:00000:00137:2005/05/26 12:54:12.39 server Process id 145 killed by Hostname LEE, Host process id 1620.

flybean

master库的syslogs表8623页面未能正确初始化。SYSLOGS是个烦人的东东，特殊表。[em06]
完整备份master和所有业务数据库。
运行 dbcc checktable and dbcc tablealloc，看能否解决问题。

flybean

use master
go
dbcc checktable(syslogs)
go
dbcc tablealloc(syslogs)
go

c001100c

有知道的请回个帖子