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

ehxz 发表于 2005-5-26 13:27:14

01:00000:00130:2005/05/26 12:09:00.17 serverError: 692, Severity: 20, State: 1 01:00000:00130:2005/05/26 12:09:00.17 serverUninitialized 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 kernelSQL Server system exception (0xc0000005) generated by a storage access violation. 01:00000:00130:2005/05/26 12:09:00.42 kernelpc: 0x008CB630 dpdb_handle+ 0x78 (0x00000024, 0x00000002, 0x00000019, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.42 kernelpc: 0x008CB630 dpdb_handle+ 0x78 (0x00000024, 0x00000002, 0x00000019, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.43 kernelpc: 0x0046736B ex_raise+ 0x2b3 (0x00000006, 0x0000005C, 0x00000014, 0x00000001) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x0073AC47 s_handle+ 0x12a8 (0x00000006, 0x0000005C, 0x00000014, 0x00000001) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x0046736B ex_raise+ 0x2b3 (0x5E2FDBF8, 0x23AE2784, 0x00000001, 0x00000001) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x005D667B wrongpage+ 0x2ec (0x23AE2784, 0x00000004, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x005D46C8 getpage_with_validation+ 0x1358 (0x28EAD000, 0x000021A4, 0x00001C49, 0x00001C4A) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x008BF9F8 dmp_send_logchain+ 0x6a3 (0x00001C4A, 0x28EAD000, 0x0DC3E930, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x008B831B dmpx_scanlog+ 0x165 (0x0DC3F310, 0x00000006, 0x00000000, 0x01000001) 01:00000:00130:2005/05/26 12:09:00.45 kernel 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x008B703E dmpx__truncatemain+ 0x84d (0x2BFE25B0, 0x00000000, 0x00000000, 0x00000001) 01:00000:00130:2005/05/26 12:09:00.45 kernelpc: 0x008B67EB dmpxact+ 0x8b (0x00000000, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.48 kernelpc: 0x00707116 s_execute+ 0x4496 (0x28EAD000, 0x00449075, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.48 kernel 01:00000:00130:2005/05/26 12:09:00.48 kernelpc: 0x00736835 sequencer+ 0x17f5 (0x23AE2100, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.48 kernelpc: 0x00444314 tdsrecv_language+ 0x540 (0x0000004B, 0x00000000, 0x00000000, 0x24A554E4) 01:00000:00130:2005/05/26 12:09:00.48 kernel 01:00000:00130:2005/05/26 12:09:00.50 kernel 01:00000:00130:2005/05/26 12:09:00.51 kernel 01:00000:00130:2005/05/26 12:09:00.51 kernelpc: 0x00412202 conn_hdlr+ 0x3429 (0x24A554E4, 0x00000000, 0x00000000, 0x24A554E4) 01:00000:00130:2005/05/26 12:09:00.54 kernelpc: 0x00A1EF27 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.56 kernelpc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.56 kernelend 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 kernelSQL 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 serverSQL Text: dump tran master with truncate_only 01:00000:00130:2005/05/26 12:09:00.57 kernelcurdb = 1 pstat = 0x10000 lasterror = 692 01:00000:00130:2005/05/26 12:09:00.57 kernelpreverror = 0 transtate = 3 01:00000:00130:2005/05/26 12:09:00.57 kernelcurcmd = 235 program = isql 01:00000:00130:2005/05/26 12:09:00.60 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0DC3D0F0, 0x77E6E597, 0x77E64E58, 0xFFFFFFFF) 01:00000:00130:2005/05/26 12:09:00.60 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0DC3D0F0, 0x0DC3CEA8, 0x0000270F, 0x00000002) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00A6F8BA pcstkwalk+ 0x204 (0x0D1F0092, 0x00000002, 0x0000270F, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00A6F544 ucstkgentrace+ 0x224 (0x0D1F0092, 0x00000001, 0x00BEC888, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00A2969B ucbacktrace+ 0xab (0x0D1F0092, 0xFFFFFFFF, 0xC0000005, 0x23AE21FC) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00406FC1 terminate_process+ 0xb8f (0xC0000005, 0x7800BDB5, 0x0DC3D470, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00A1E47B kiexception+ 0x2e0 (0x24A554E4, 0x00000000, 0x00000000, 0x24A554E4) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x00A1EFA7 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.64 kernelpc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000) 01:00000:00130:2005/05/26 12:09:00.64 kernelend of stack trace, spid 130, kpid 220135570, suid 1 00:00000:00051:2005/05/26 12:20:56.07 serverBufunhash: 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 serverMass: 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 serverPage: 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 serverProcess id 51 killed by Hostname LEE, Host process id 1620. 00:00000:00137:2005/05/26 12:54:12.39 serverProcess id 145 killed by Hostname LEE, Host process id 1620.

flybean 发表于 2005-5-26 13:51:10

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

flybean 发表于 2005-5-26 14:06:48

flybean

use master 

go 
dbcc checktable(syslogs) 
go 

dbcc tablealloc(syslogs) 

go

c001100c 发表于 2005-12-2 18:06:10

有知道的请回个帖子

页: [1]

PowerBuilder(PB)BBS社区's Archiver

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

flybean