none
sql server 2005数据库奇怪的问题 RRS feed

  • 常规讨论

  • 您好:

        我们的sql 2005标准版数据库最近突然发现一个奇怪的问题,前一段时间我发现数据库经常停止响应,无法停止服务,只能重启服务

    器硬件,启动后数据库恢复正常,我在数据库中日志中发现出dump,checktable后发现是一个表坏了(后面就叫A表),提示有两个一致性

    错误,我重新建了一遍这个表,并且重新导入数据,坏表改名后服务器正常运行了1个月,我感觉稳定后我将坏表数据trancate掉了,表仍

    然保留,奇怪的事情发生了一个小时以后,数据库日志再次出现dump,提示我另外一个表坏了(这个表叫B表),我对B表做checktable,

    发现也是有一致性错误,我又重新创建这个表并且改掉了坏表的表名,在网上我看到有人说这种情况删掉并重新建立索引会好,我就删掉

    了这个坏表的索引,重新checktable后发现这个表正常了,但是一个小时左右,又一个表出现了dump(这个叫C表),现象和A,B表损坏完

    全相同,这次我没有再做操作,因为前两次都是坏在非关键表,如果我在做操作坏在关键表上就会严重影响我的业务了,我想问问专家遇

    到过这种问题吗?我要怎么解决?下面是C表损坏后的一些日志片段。

    2014-01-09 17:05:21.92 spid1173    **Dump thread - spid = 1173, PSS = 0x000000079AB1E080, EC = 0x000000079AB1E090
    2014-01-09 17:05:21.92 spid1173    ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

    \SQLDump10000.txt
    2014-01-09 17:05:21.92 spid1173    * *******************************************************************************
    2014-01-09 17:05:21.92 spid1173    *
    2014-01-09 17:05:21.92 spid1173    * BEGIN STACK DUMP:
    2014-01-09 17:05:21.92 spid1173    *   01/09/14 17:05:21 spid 1173
    2014-01-09 17:05:21.92 spid1173    *
    2014-01-09 17:05:21.92 spid1173    * Location:  SpcAlloc.cpp:1061
    2014-01-09 17:05:21.92 spid1173    * Expression:  pPage->IsType (Page::TEXT_MIX_PAGE)
    2014-01-09 17:05:21.92 spid1173    * SPID:   1173
    2014-01-09 17:05:21.92 spid1173    * Process ID:  3064
    2014-01-09 17:05:21.92 spid1173    *
    2014-01-09 17:05:21.92 spid1173    * Input Buffer 255 bytes -
    2014-01-09 17:05:21.92 spid1173    *                •    16 00 00 00 12 00 00 00 02 00 01 00 00 00 95 04 00 00
    2014-01-09 17:05:21.92 spid1173    *        I n s e r t  01 00 00 00 0d 00 49 00 6e 00 73 00 65 00 72 00 74 00
    2014-01-09 17:05:21.92 spid1173    *  S y n c L o g    @ 53 00 79 00 6e 00 63 00 4c 00 6f 00 67 00 00 00 07 40
    2014-01-09 17:05:21.92 spid1173    *   u s e r I D  çþ   00 75 00 73 00 65 00 72 00 49 00 44 00 00 e7 fe 01 04
    2014-01-09 17:05:21.92 spid1173    *   Р   0 1 0 3 8 4  08 d0 00 00 10 00 30 00 31 00 30 00 33 00 38 00 34 00
    2014-01-09 17:05:21.92 spid1173    *  0 6  @ a c t i o n 30 00 36 00 0c 40 00 61 00 63 00 74 00 69 00 6f 00 6e
    2014-01-09 17:05:21.92 spid1173    *   _ t y p e  &      00 5f 00 74 00 79 00 70 00 65 00 00 26 02 02 01 00 09
    2014-01-09 17:05:21.92 spid1173    *  @ l o g _ d a t e  40 00 6c 00 6f 00 67 00 5f 00 64 00 61 00 74 00 65 00
    2014-01-09 17:05:21.92 spid1173    *   o  ®¢  à   @ t h 00 6f 08 08 ae a2 00 00 c3 9d 19 01 07 40 00 74 00 68
    2014-01-09 17:05:21.92 spid1173    *   r e a d  çþ   Р  00 72 00 65 00 61 00 64 00 00 e7 fe 01 04 08 d0 00 00
    2014-01-09 17:05:21.92 spid1173    *    3  @ l o g _ l e 02 00 33 00 0a 40 00 6c 00 6f 00 67 00 5f 00 6c 00 65
    2014-01-09 17:05:21.92 spid1173    *   v e l  çd   Р    00 76 00 65 00 6c 00 00 e7 64 00 04 08 d0 00 00 08 00
    2014-01-09 17:05:21.92 spid1173    *  I N F O  @ l o g g 49 00 4e 00 46 00 4f 00 07 40 00 6c 00 6f 00 67 00 67
    2014-01-09 17:05:21.92 spid1173    *   e r  çþ   Р   U  00 65 00 72 00 00 e7 fe 01 04 08 d0 00 00 0c 00 55 00
    2014-01-09 17:05:21.92 spid1173    *  p l o a d  @ m e s 70 00 6c 00 6f 00 61 00 64 00 08 40 00 6d 00 65 00 73
    2014-01-09 17:05:21.92 spid1173    *   s a g e  çÿÿ  Р  00 73 00 61 00 67 00 65 00 00 e7 ff ff 04 08 d0 00 00
    2014-01-09 17:05:21.92 spid1173    *  R       R   (u7b ÿ 52 00 00 00 00 00 00 00 52 00 00 00 28 75 37 62 1a ff
    2014-01-09 17:05:21.92 spid1173    *  0 1 0 3 8 4 0 6    30 00 31 00 30 00 33 00 38 00 34 00 30 00 36 00 20 00
    2014-01-09 17:05:21.92 spid1173    *   _ËY÷‹Bl N Openc,  00 5f cb 59 f7 8b 42 6c 0a 4e 20 4f 70 65 6e 63 2c 00
    2014-01-09 17:05:21.92 spid1173    *  Æ[ x ÿ4 2 5 0 6 9  c6 5b 01 78 1a ff 34 00 32 00 35 00 30 00 36 00 39 00
    2014-01-09 17:05:21.92 spid1173    *  0 0   , Hr,g÷S ÿV  30 00 30 00 20 00 2c 00 48 72 2c 67 f7 53 1a ff 56 00
    2014-01-09 17:05:21.92 spid1173    *  2        @ e x c e 32 00 20 00 00 00 00 00 0a 40 00 65 00 78 00 63 00 65
    2014-01-09 17:05:21.92 spid1173    *   p t i o n  ç    Ð 00 70 00 74 00 69 00 6f 00 6e 00 00 e7 a0 0f 04 08 d0
    2014-01-09 17:05:21.92 spid1173    *                     00 00 00 00
    2014-01-09 17:05:21.92 spid1173    * 
    2014-01-09 17:05:21.92 spid1173    *
    2014-01-09 17:05:21.92 spid1173    *  MODULE                          BASE      END       SIZE
    2014-01-09 17:05:21.92 spid1173    * sqlservr                       0000000001000000  0000000003651FFF  02652000
    2014-01-09 17:05:21.92 spid1173    * ntdll                          0000000077EC0000  0000000077FFBFFF  0013c000
    2014-01-09 17:05:21.92 spid1173    * kernel32                       0000000077D40000  0000000077EB2FFF  00173000
    2014-01-09 17:05:21.92 spid1173    * SYSFER                         0000000060B10000  0000000060BA5FFF  00096000
    2014-01-09 17:05:21.92 spid1173    * MSVCR80                        0000000078130000  00000000781F8FFF  000c9000
    2014-01-09 17:05:21.92 spid1173    * msvcrt                         000007FF7FC00000  000007FF7FC85FFF  00086000
    2014-01-09 17:05:21.92 spid1173    * MSVCP80                        000000007C420000  000000007C528FFF  00109000
    2014-01-09 17:05:21.92 spid1173    * ADVAPI32                       000007FF7FEE0000  000007FF7FFE5FFF  00106000
    2014-01-09 17:05:21.92 spid1173    * RPCRT4                         000007FF7FD30000  000007FF7FECFFFF  001a0000
    2014-01-09 17:05:21.92 spid1173    * Secur32                        000007FF7E9C0000  000007FF7E9E1FFF  00022000
    2014-01-09 17:05:21.92 spid1173    * sqlos                          00000000344D0000  00000000344D6FFF  00007000
    2014-01-09 17:05:21.92 spid1173    * USERENV                        000007FF7C680000  000007FF7C789FFF  0010a000
    2014-01-09 17:05:21.92 spid1173    * USER32                         0000000077C20000  0000000077D2BFFF  0010c000
    2014-01-09 17:05:21.92 spid1173    * GDI32                          000007FF7FC90000  000007FF7FD2AFFF  0009b000
    2014-01-09 17:05:21.92 spid1173    * WINMM                          000007FF7E240000  000007FF7E28FFFF  00050000
    2014-01-09 17:05:21.92 spid1173    * opends60                       00000000333E0000  00000000333E7FFF  00008000
    2014-01-09 17:05:21.92 spid1173    * NETAPI32                       000007FF77370000  000007FF77407FFF  00098000
    2014-01-09 17:05:21.92 spid1173    * IMM32                          000007FF7D500000  000007FF7D538FFF  00039000
    2014-01-09 17:05:21.92 spid1173    * LPK                            000007FF69300000  000007FF6930CFFF  0000d000
    2014-01-09 17:05:21.92 spid1173    * USP10                          000007FF78E80000  000007FF78F0DFFF  0008e000
    2014-01-09 17:05:21.92 spid1173    * psapi                          000007FF7E380000  000007FF7E38FFFF  00010000
    2014-01-09 17:05:21.92 spid1173    * instapi                        0000000048060000  000000004806CFFF  0000d000
    2014-01-09 17:05:21.92 spid1173    * sqlevn70                       000000004F610000  000000004F7B8FFF  001a9000
    2014-01-09 17:05:21.92 spid1173    * rsaenh                         0000000068000000  000000006804BFFF  0004c000
    2014-01-09 17:05:21.92 spid1173    * AUTHZ                          000007FF7E490000  000007FF7E4BDFFF  0002e000
    2014-01-09 17:05:21.92 spid1173    * MSCOREE                        000006427EE50000  000006427EEBEFFF  0006f000
    2014-01-09 17:05:21.92 spid1173    * ole32                          000007FF57140000  000007FF573C4FFF  00285000
    2014-01-09 17:05:21.92 spid1173    * msv1_0                         000007FF7E500000  000007FF7E544FFF  00045000
    2014-01-09 17:05:21.92 spid1173    * cryptdll                       000007FF7DC90000  000007FF7DC9EFFF  0000f000
    2014-01-09 17:05:21.92 spid1173    * WS2_32                         000007FF77310000  000007FF7733FFFF  00030000
    2014-01-09 17:05:21.92 spid1173    * WS2HELP                        000007FF77140000  000007FF7714BFFF  0000c000
    2014-01-09 17:05:21.92 spid1173    * iphlpapi                       000007FF57040000  000007FF57070FFF  00031000
    2014-01-09 17:05:21.92 spid1173    * kerberos                       000007FF77410000  000007FF774C4FFF  000b5000
    2014-01-09 17:05:21.92 spid1173    * MSASN1                         000007FF7D340000  000007FF7D36BFFF  0002c000
    2014-01-09 17:05:21.92 spid1173    * schannel                       000007FF7DD50000  000007FF7DD93FFF  00044000
    2014-01-09 17:05:21.92 spid1173    * CRYPT32                        000007FF7D370000  000007FF7D4CEFFF  0015f000
    2014-01-09 17:05:21.92 spid1173    * COMRES                         000007FF7EAF0000  000007FF7EBB5FFF  000c6000
    2014-01-09 17:05:21.92 spid1173    * XOLEHLP                        000007FF5C5B0000  000007FF5C5B6FFF  00007000
    2014-01-09 17:05:21.92 spid1173    * MSDTCPRX                       000007FF67140000  000007FF67213FFF  000d4000
    2014-01-09 17:05:21.92 spid1173    * OLEAUT32                       000007FF7EBC0000  000007FF7ECD5FFF  00116000
    2014-01-09 17:05:21.92 spid1173    * msvcp60                        0000000019430000  0000000019519FFF  000ea000
    2014-01-09 17:05:21.92 spid1173    * MTXCLU                         000007FF7B540000  000007FF7B569FFF  0002a000
    2014-01-09 17:05:21.92 spid1173    * VERSION                        000007FF7FBF0000  000007FF7FBFAFFF  0000b000
    2014-01-09 17:05:21.92 spid1173    * WSOCK32                        000007FF770F0000  000007FF770F9FFF  0000a000
    2014-01-09 17:05:21.92 spid1173    * CLUSAPI                        000007FF7B3A0000  000007FF7B3C3FFF  00024000
    2014-01-09 17:05:21.92 spid1173    * RESUTILS                       000007FF7B310000  000007FF7B32BFFF  0001c000
    2014-01-09 17:05:21.92 spid1173    * mswsock                        000007FF771B0000  000007FF7722CFFF  0007d000
    2014-01-09 17:05:21.92 spid1173    * DNSAPI                         000007FF7E8F0000  000007FF7E93EFFF  0004f000
    2014-01-09 17:05:21.92 spid1173    * winrnr                         000007FF7E9F0000  000007FF7E9FAFFF  0000b000
    2014-01-09 17:05:21.92 spid1173    * WLDAP32                        000007FF7E950000  000007FF7E9B5FFF  00066000
    2014-01-09 17:05:21.92 spid1173    * rasadhlp                       000007FF7EA00000  000007FF7EA06FFF  00007000
    2014-01-09 17:05:21.92 spid1173    * security                       000007FF77530000  000007FF77534FFF  00005000
    2014-01-09 17:05:21.92 spid1173    * dssenh                         0000000068100000  000000006813EFFF  0003f000
    2014-01-09 17:05:21.92 spid1173    * msfte                          0000000049980000  0000000049D30FFF  003b1000
    2014-01-09 17:05:21.92 spid1173    * dbghelp                        000000001B890000  000000001B9ECFFF  0015d000
    2014-01-09 17:05:21.92 spid1173    * WINTRUST                       000007FF7E3E0000  000007FF7E42FFFF  00050000
    2014-01-09 17:05:21.92 spid1173    * imagehlp                       000007FF7E470000  000007FF7E484FFF  00015000
    2014-01-09 17:05:21.92 spid1173    * SHELL32                        000007FF7F190000  000007FF7FB9BFFF  00a0c000
    2014-01-09 17:05:21.92 spid1173    * SHLWAPI                        000007FF7EF60000  000007FF7EFFAFFF  0009b000
    2014-01-09 17:05:21.92 spid1173    * comctl32                       000007FF7F000000  000007FF7F186FFF  00187000
    2014-01-09 17:05:21.92 spid1173    * hnetcfg                        000007FF6D200000  000007FF6D292FFF  00093000
    2014-01-09 17:05:21.92 spid1173    * wshtcpip                       000007FF77170000  000007FF7717AFFF  0000b000
    2014-01-09 17:05:21.92 spid1173    * NTMARTA                        000007FF7E4C0000  000007FF7E4FBFFF  0003c000
    2014-01-09 17:05:21.92 spid1173    * SAMLIB                         000007FF77150000  000007FF77165FFF  00016000
    2014-01-09 17:05:21.92 spid1173    * ntdsapi                        000007FF7DCB0000  000007FF7DCD3FFF  00024000
    2014-01-09 17:05:21.92 spid1173    * xpsp2res                       000000001EFC0000  000000001F286FFF  002c7000
    2014-01-09 17:05:21.92 spid1173    * CLBCatQ                        000007FF7EA10000  000007FF7EAEDFFF  000de000
    2014-01-09 17:05:21.92 spid1173    * sqlncli                        00000000337A0000  0000000033A63FFF  002c4000
    2014-01-09 17:05:21.92 spid1173    * COMCTL32                       000007FF76200000  000007FF762EEFFF  000ef000
    2014-01-09 17:05:21.92 spid1173    * comdlg32                       000007FF7D540000  000007FF7D5B6FFF  00077000
    2014-01-09 17:05:21.92 spid1173    * SQLNCLIR                       000000003EBB0000  000000003EBE2FFF  00033000
    2014-01-09 17:05:21.92 spid1173    * msftepxy                       000000001C640000  000000001C660FFF  00021000
    2014-01-09 17:05:21.92 spid1173    * xpsqlbot                       000000001FDF0000  000000001FDF7FFF  00008000
    2014-01-09 17:05:21.92 spid1173    * xpstar90                       000000001FE70000  000000001FEF7FFF  00088000
    2014-01-09 17:05:21.92 spid1173    * SQLSCM90                       000000001FF10000  000000001FF1BFFF  0000c000
    2014-01-09 17:05:21.92 spid1173    * ODBC32                         000007FF63F00000  000007FF63F68FFF  00069000
    2014-01-09 17:05:21.92 spid1173    * BatchParser90                  000000001FF50000  000000001FF7CFFF  0002d000
    2014-01-09 17:05:21.92 spid1173    * ATL80                          000000001FF80000  000000001FF9DFFF  0001e000
    2014-01-09 17:05:21.92 spid1173    * odbcint                        000007FF63DC0000  000007FF63DD7FFF  00018000
    2014-01-09 17:05:21.92 spid1173    * xpstar90                       0000000033700000  0000000033725FFF  00026000
    2014-01-09 17:05:21.92 spid1173    * xplog70                        00000000333C0000  00000000333CFFFF  00010000
    2014-01-09 17:05:21.92 spid1173    * xplog70                        0000000033730000  0000000033732FFF  00003000
    2014-01-09 17:05:21.92 spid1173    *
    2014-01-09 17:05:21.92 spid1173    *     P1Home: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *     P2Home: 0000000077EF3B18:  00000330249C8B48  0000032824B48B48  0000032024BC8B48 

    0000031824A48B4C  0000031024AC8B4C  0000030824B48B4C 
    2014-01-09 17:05:21.92 spid1173    *     P3Home: 00000000543AD7F0:  0000000000000001  0000000000000000  0000000000000010 

    00000000023ACCA2  0000000080ADC080  00000000543B0040 
    2014-01-09 17:05:21.92 spid1173    *     P4Home: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *     P5Home: 000000000000021A: 
    2014-01-09 17:05:21.92 spid1173    *     P6Home: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    * ContextFlags: 000000000010000F: 
    2014-01-09 17:05:21.92 spid1173    *      MxCsr: 0000000000001FA0: 
    2014-01-09 17:05:21.92 spid1173    *      SegCs: 0000000000000033: 
    2014-01-09 17:05:21.92 spid1173    *      SegDs: 000000000000002B: 
    2014-01-09 17:05:21.92 spid1173    *      SegEs: 000000000000002B: 
    2014-01-09 17:05:21.92 spid1173    *      SegFs: 0000000000000053: 
    2014-01-09 17:05:21.92 spid1173    *      SegGs: 000000000000002B: 
    2014-01-09 17:05:21.92 spid1173    *      SegSs: 000000000000002B: 
    2014-01-09 17:05:21.92 spid1173    *     EFlags: 0000000000000206: 
    2014-01-09 17:05:21.92 spid1173    *        Rax: 00000000543AD528:  0000000077D67DED  000000002004A6B0  0000000000000000 

    00000000543AD7E0  000000079AB1E080  00000000000042AC 
    2014-01-09 17:05:21.92 spid1173    *        Rcx: 00000000543AD050:  0000000000000000  0000000077EF3B18  00000000543AD7F0 

    0000000000000000  000000000000021A  0000000000000000 
    2014-01-09 17:05:21.92 spid1173    *        Rdx: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *        Rbx: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *        Rsp: 00000000543AD530:  000000002004A6B0  0000000000000000  00000000543AD7E0 

    000000079AB1E080  00000000000042AC  0000000000000000 
    2014-01-09 17:05:21.92 spid1173    *        Rbp: 00000000543AECB0:  0000000000000425  0000000000000000  000003E500000001 

    0000000000000001  0000000000000000  0000000000000000 
    2014-01-09 17:05:21.92 spid1173    *        Rsi: 00000000543AD7E0:  000000002004A6B0  0000000000000000  0000000000000001 

    0000000000000000  0000000000000010  00000000023ACCA2 
    2014-01-09 17:05:21.92 spid1173    *        Rdi: 000000079AB1E080:  00000007A2A90B00  0000000000000000  000000079AB1E080 

    0000000000000000  0000000000000000  000000079AB1E0A8 
    2014-01-09 17:05:21.92 spid1173    *         R8: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *         R9: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *        R10: 0000000000000000: 
    2014-01-09 17:05:21.92 spid1173    *        R11: 00000000543ADD20:  0000000000000000  0000000077EF3B18  00000000543AD7F0 

    0000000000000000  000000000000021A  0000000000000000 
    2014-01-09 17:05:21.92 spid1173    *        R12: 000000000000003F: 
    2014-01-09 17:05:21.92 spid1173    *        R13: 000000079AB1E090:  000000079AB1E080  0000000000000000  0000000000000000 

    000000079AB1E0A8  000000079AB1E0A8  000000079AB1E0B8 
    2014-01-09 17:05:21.92 spid1173    *        R14: 00000000543AEBD0:  00610063006F004C  006E006F00690074  005300200009003A 

    006C004100630070  002E0063006F006C  003A007000700063 
    2014-01-09 17:05:21.92 spid1173    *        R15: 0000000000000001: 
    2014-01-09 17:05:21.93 spid1173    *        Rip: 0000000077D67DED:  C3000000C8C48148  15FF984B8D49D233  8679E990FFFD967F 

    9090909090900000  834853C08B909090  0C0C7A158B4830EC 
    2014-01-09 17:05:21.93 spid1173    * *******************************************************************************
    2014-01-09 17:05:21.93 spid1173    * -------------------------------------------------------------------------------
    2014-01-09 17:05:21.93 spid1173    * Short Stack Dump

    2014-01-09 17:05:21.93 spid1173    0000000077D67DED Module(kernel32+0000000000027DED)
    2014-01-09 17:05:21.93 spid1173    0000000001F6CF6E Module(sqlservr+0000000000F6CF6E)
    2014-01-09 17:05:21.93 spid1173    0000000001F6F469 Module(sqlservr+0000000000F6F469)
    2014-01-09 17:05:21.93 spid1173    00000000027CE55B Module(sqlservr+00000000017CE55B)
    2014-01-09 17:05:21.93 spid1173    000000000280D707 Module(sqlservr+000000000180D707)
    2014-01-09 17:05:21.93 spid1173    000000000285E49D Module(sqlservr+000000000185E49D)
    2014-01-09 17:05:21.93 spid1173    000000000289C367 Module(sqlservr+000000000189C367)
    2014-01-09 17:05:21.93 spid1173    00000000023D2E1F Module(sqlservr+00000000013D2E1F)
    2014-01-09 17:05:21.93 spid1173    00000000023D3ED4 Module(sqlservr+00000000013D3ED4)
    2014-01-09 17:05:21.93 spid1173    00000000023D429C Module(sqlservr+00000000013D429C)
    2014-01-09 17:05:21.93 spid1173    00000000023D49DD Module(sqlservr+00000000013D49DD)
    2014-01-09 17:05:21.93 spid1173    00000000023DCC77 Module(sqlservr+00000000013DCC77)
    2014-01-09 17:05:21.93 spid1173    00000000023DCD7C Module(sqlservr+00000000013DCD7C)
    2014-01-09 17:05:21.93 spid1173    00000000019F92F9 Module(sqlservr+00000000009F92F9)
    2014-01-09 17:05:21.93 spid1173    0000000001862C0F Module(sqlservr+0000000000862C0F)
    2014-01-09 17:05:21.93 spid1173    00000000018626CE Module(sqlservr+00000000008626CE)
    2014-01-09 17:05:21.93 spid1173    00000000029F11D3 Module(sqlservr+00000000019F11D3)
    2014-01-09 17:05:21.93 spid1173    00000000015FC366 Module(sqlservr+00000000005FC366)
    2014-01-09 17:05:21.93 spid1173    00000000016022C4 Module(sqlservr+00000000006022C4)
    2014-01-09 17:05:21.93 spid1173    0000000001605959 Module(sqlservr+0000000000605959)
    2014-01-09 17:05:21.93 spid1173    0000000001605C11 Module(sqlservr+0000000000605C11)
    2014-01-09 17:05:21.93 spid1173    0000000001608116 Module(sqlservr+0000000000608116)
    2014-01-09 17:05:21.93 spid1173    00000000016100D3 Module(sqlservr+00000000006100D3)
    2014-01-09 17:05:21.93 spid1173    00000000015CE649 Module(sqlservr+00000000005CE649)
    2014-01-09 17:05:21.93 spid1173    00000000015CC59C Module(sqlservr+00000000005CC59C)
    2014-01-09 17:05:21.93 spid1173    00000000015CB332 Module(sqlservr+00000000005CB332)
    2014-01-09 17:05:21.93 spid1173    00000000015CBDF4 Module(sqlservr+00000000005CBDF4)
    2014-01-09 17:05:21.93 spid1173    00000000015C483E Module(sqlservr+00000000005C483E)
    2014-01-09 17:05:21.93 spid1173    00000000015C4AD9 Module(sqlservr+00000000005C4AD9)
    2014-01-09 17:05:21.93 spid1173    00000000015BB254 Module(sqlservr+00000000005BB254)
    2014-01-09 17:05:21.93 spid1173    00000000014D4687 Module(sqlservr+00000000004D4687)
    2014-01-09 17:05:21.93 spid1173    00000000017BE7B9 Module(sqlservr+00000000007BE7B9)
    2014-01-09 17:05:21.93 spid1173    00000000017BE585 Module(sqlservr+00000000007BE585)
    2014-01-09 17:05:21.94 spid1173    00000000017EADE8 Module(sqlservr+00000000007EADE8)
    2014-01-09 17:05:21.94 spid1173    00000000781337D7 Module(MSVCR80+00000000000037D7)
    2014-01-09 17:05:21.94 spid1173    0000000078133894 Module(MSVCR80+0000000000003894)
    2014-01-09 17:05:21.94 spid1173    0000000077D6B71A Module(kernel32+000000000002B71A)
    2014-01-09 17:05:21.94 spid1173    Stack Signature for the dump is 0x00000001527877C2

    2014-01-09 17:05:26.32 spid1173    External dump process return code 0x20000001.
    External dump process returned no errors.

    2014-01-09 17:05:26.32 spid1173    Error: 17066, Severity: 16, State: 1.
    2014-01-09 17:05:26.32 spid1173    SQL Server Assertion: File: <SpcAlloc.cpp>, line=1061 Failed Assertion = 'pPage-

    >IsType (Page::TEXT_MIX_PAGE)'. This error may be timing-related. If the error persists after rerunning the statement,

    use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data

    structures are not corrupted.
    2014-01-09 17:05:26.32 spid1173    Error: 3624, Severity: 20, State: 1.
    2014-01-09 17:05:26.32 spid1173    A system assertion check has failed. Check the SQL Server error log for details.

    Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption,

    consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to

    Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

     

    每次出基本都有以上类似的错误。

    奇怪的地方在于,如果我不动这张坏表,数据库就不会出dump,并且也没有其他的表损坏(我对其他表都做了checktable),但是我只要

    解决掉这张坏表的问题,就一定会有另外一个表报相同的错误。

     

     

    2014年1月10日 8:08

全部回复