- 论坛徽章:
- 0
|
数据库运行期间发生错误,日志如下
00:00000:00001:2007/01/17 00:02:00.46 server End diagnostics for read failure:
00:00000:00001:2007/01/17 00:02:00.46 server Run the DBCC command 'dbcc tablealloc' for both the objects 832005995, 2126630619
00:00000:00001:2007/01/17 00:02:00.46 server Error: 605, Severity: 21, State: 7
00:00000:00001:2007/01/17 00:02:00.46 server An attempt was made to fetch logical page '8492712' in database 'ZD_JXC' from cache 'default data cache'. Page belongs to object with id '2126630619', not to object 'GZSP'.
00:00000:00001:2007/01/17 00:02:00.46 kernel ************************************
00:00000:00001:2007/01/17 00:02:00.46 kernel SQL causing error : select A.DEPTID, BM.DEPT_NAME,A.CUR_XSBM_FLAG from GZSP A, BM where A.DEPTID=BM.DEPTID and A.SP_ID=0
00:00000:00001:2007/01/17 00:02:00.46 kernel ************************************
00:00000:00001:2007/01/17 00:02:00.46 server SQL Text: select A.DEPTID, BM.DEPT_NAME,A.CUR_XSBM_FLAG from GZSP A, BM where A.DEPTID=BM.DEPTID and A.SP_ID=0 00:00000:00001:2007/01/17 00:02:00.48 kernel curdb = 6 pstat = 0x10000 lasterror = 605
00:00000:00001:2007/01/17 00:02:00.48 kernel preverror = 0 transtate = 1
00:00000:00001:2007/01/17 00:02:00.48 kernel curcmd = 193 program =
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x26fecc0, 0x1e001e, 0x26fecc0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x26fecc0, 0x26ff214, 0x270f, 0x2)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x1e001e, 0x2, 0x270f, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x26ff5d8, 0x4527a
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x405fe6 terminate_process+ 0x566 (0x26ff638, 0x639a02, 0x6, 0x5)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x4527ea close_network+ 0x1a (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x639a02 s_handle+ 0x162 (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x452413 ex_raise+ 0x193 (0x50c17970, 0x203d00f0, 0x7, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x542e0d wrongpage+ 0x3bd (0x26ff78c, 0x203d00f0, 0x2, 0x26ffaf
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x578fc9 getindexpage+ 0x1c9 (0x26ffaf8, 0x203d00f0, 0x1, 0x1)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x577813 srchindex+ 0x3e3 (0x203d00f0, 0x1, 0x21689df4, 0x1)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x53141e apl__startscan+ 0x1ce (0x203d00f0, 0x1, 0x1, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x530f4f startscan+ 0x21f (0x231fe43c, 0x231fe744, 0x26ffd34, 0x231fe43c)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x6d6741 exec_eop+ 0x2d1 (0x231fe43c, 0x231fe650, 0x26ffd34, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x6d6837 exec_eop+ 0x3c7 (0x231fe3a0, 0x231fe43c, 0xc1, 0x26ffd34)
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x6da130 execerr installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x68fb50 sortmerr installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x6da130 execerr installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x6da130 execerr installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x635bb0 aritherr installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x6d573e execute+ 0x26e (0x21, 0x20a514f0, 0x20a514f0, 0x20a29ce0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x652ccb s_execute+ 0x78b (0x231d8800, 0x21, 0x20a5872d, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x6398a0 s_handle installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x63678f sequencer+ 0x15f (0x0, 0x20014ccc, 0x1a001a, 0x2001391c)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x436d31 tdsrecv_language+ 0xc1 (0x4, 0x4000, 0x20014ccc, 0x1a001a)
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x40dc1c conn_hdlr+ 0xb5c (0x20014ccc, 0x2001391c, 0x1a001a, 0x20014ccc)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20014ccc, 0x0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel pc: 0x77e6b396 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel end of stack trace, spid 1, kpid 1966110, suid 7
00:00000:00007:2007/01/17 00:02:51.00 kernel shutdownproc: shutting down SQL Server!
00:00000:00007:2007/01/17 00:02:51.06 kernel ueshutdown: exiting
00:00000:00007:2007/01/17 00:02:51.06 kernel XP Server is not running.
发生错误后,我执行以下操作:
DUMP TRAN ZD_JXC WITH NO_LOG
go
dump database ZD_JXC TO 'E:\ZD_JXC.DAT'
GO
最后我执行了导入操作:
load database ZD_JXC FROM 'E:\zd_jxc.DAT'
GO
online database ZD_JXC
GO
操作完毕后,打开数据库,USER TABLE全部丢失,请大家帮忙找下原因,感激不尽
注:SYBASE版本11.9,操作系统为WINDOWS2000 SERVER |
|