none
SQLDump EXCEPTION_ACCESS_VIOLATION RRS feed

  • 問題

  • Could anyone help about the following case? many many thanks in advance

     

    1.    This problem will be happended for different but similar storeprocedures. in transient manner. However, when we try to repeat the problem by running the procedure again, it probably work fines

     2.    However, the problem has happended again unexpectedly

     3.    The problem occurs in different server have similar environment (Window 2003 server and SQL Server 2000 SP4).

     

    Following is the dump:

    SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
    * *******************************************************************************
    *
    * BEGIN STACK DUMP:
    *   05/21/07 15:52:04 spid 57
    *
    *   Exception Address = 007EA027 (SQLExit + 00282530 Line 0+00000000)
    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
    *   Access Violation occurred reading address 76A6F2F3
    *    H p m s _ R p t  12 00 48 00 70 00 6d 00 73 00 5f 00 52 00 70 00 74 00
    *  M t n _ 0 0 0 1 1  4d 00 74 00 6e 00 5f 00 30 00 30 00 30 00 31 00 31 00
    *  2    @ P a r a m _ 32 00 00 00 0a 40 00 50 00 61 00 72 00 61 00 6d 00 5f
    *   I d x   H      H  00 49 00 64 00 78 00 00 e7 48 00 04 04 d0 00 00 48 00
    *  d 7 7 7 9 8 1 1 -  64 00 37 00 37 00 37 00 39 00 38 00 31 00 31 00 2d 00
    *  9 9 d e - 4 6 6 1  39 00 39 00 64 00 65 00 2d 00 34 00 36 00 36 00 31 00
    *  - 9 b 8 4 - 6 9 1  2d 00 39 00 62 00 38 00 34 00 2d 00 36 00 39 00 31 00
    *  d a f 8 8 3 f d 2  64 00 61 00 66 00 38 00 38 00 33 00 66 00 64 00 32 00

    *
    *  MODULE                          BASE      END       SIZE
    * sqlservr                       00400000  00CBAFFF  008bb000
    * ntdll                          7C800000  7C8BFFFF  000c0000
    * kernel32                       77E40000  77F41FFF  00102000
    * ADVAPI32                       77F50000  77FEBFFF  0009c000
    * RPCRT4                         77C50000  77CEEFFF  0009f000
    * MSVCP71                        7C3A0000  7C41AFFF  0007b000
    * MSVCR71                        7C340000  7C395FFF  00056000
    * opends60                       41060000  41065FFF  00006000
    * SHELL32                        7C8D0000  7D0D3FFF  00804000
    * msvcrt                         77BA0000  77BF9FFF  0005a000
    * GDI32                          77C00000  77C47FFF  00048000
    * USER32                         77380000  77411FFF  00092000
    * SHLWAPI                        77DA0000  77DF1FFF  00052000
    * sqlsort                        42AE0000  42B6FFFF  00090000
    * ums                            41070000  4107DFFF  0000e000
    * IMM32                          76290000  762ACFFF  0001d000
    * LPK                            62D80000  62D88FFF  00009000
    * USP10                          75490000  754F0FFF  00061000
    * comctl32                       77420000  77522FFF  00103000
    * sqlevn70                       41080000  4108AFFF  0000b000
    * NETAPI32                       71C40000  71C97FFF  00058000
    * AUTHZ                          76C40000  76C53FFF  00014000
    * COMRES                         77010000  770D5FFF  000c6000
    * ole32                          77670000  777A3FFF  00134000
    * XOLEHLP                        01600000  01605FFF  00006000
    * MSDTCPRX                       61150000  611C7FFF  00078000
    * msvcp60                        780C0000  78120FFF  00061000
    * MTXCLU                         74F40000  74F58FFF  00019000
    * VERSION                        77B90000  77B97FFF  00008000
    * WSOCK32                        71BB0000  71BB8FFF  00009000
    * WS2_32                         71C00000  71C16FFF  00017000
    * WS2HELP                        71BF0000  71BF7FFF  00008000
    * OLEAUT32                       77D00000  77D8BFFF  0008c000
    * CLUSAPI                        74DE0000  74DF1FFF  00012000
    * RESUTILS                       74EF0000  74F02FFF  00013000
    * USERENV                        76920000  769E3FFF  000c4000
    * secur32                        76F50000  76F62FFF  00013000
    * mswsock                        71B20000  71B60FFF  00041000
    * DNSAPI                         76ED0000  76EFEFFF  0002f000
    * winrnr                         76F70000  76F76FFF  00007000
    * WLDAP32                        76F10000  76F3DFFF  0002e000
    * rasadhlp                       76F80000  76F87FFF  00008000
    * NTMARTA                        77E00000  77E21FFF  00022000
    * SAMLIB                         5CCF0000  5CCFEFFF  0000f000
    * SSNETLIB                       00E80000  00E95FFF  00016000
    * security                       71F60000  71F63FFF  00004000
    * crypt32                        761B0000  76242FFF  00093000
    * MSASN1                         76190000  761A1FFF  00012000
    * schannel                       76750000  76776FFF  00027000
    * rsaenh                         68000000  6802EFFF  0002f000
    * PSAPI                          76B70000  76B7AFFF  0000b000
    * dssenh                         68100000  68123FFF  00024000
    * hnetcfg                        5F270000  5F2C8FFF  00059000
    * wshtcpip                       71AE0000  71AE7FFF  00008000
    * SSmsLPCn                       00EF0000  00EF7FFF  00008000
    * SSnmPN70                       410D0000  410D6FFF  00007000
    * ntdsapi                        766F0000  76704FFF  00015000
    * SQLFTQRY                       03410000  03435FFF  00026000
    * xpsp2res                       10000000  102C4FFF  002c5000
    * CLBCatQ                        777B0000  77832FFF  00083000
    * sqloledb                       03450000  034D0FFF  00081000
    * MSDART                         74A50000  74A69FFF  0001a000
    * MSDATL3                        61200000  61214FFF  00015000
    * oledb32                        03900000  03978FFF  00079000
    * OLEDB32R                       037E0000  037F0FFF  00011000
    * msv1_0                         76C90000  76CB6FFF  00027000
    * iphlpapi                       76CF0000  76D09FFF  0001a000
    * xpsqlbot                       03A00000  03A05FFF  00006000
    * xplog70                        03020000  0302EFFF  0000f000
    * xplog70                        03A10000  03A14FFF  00005000
    * xpstar                         410F0000  4113CFFF  0004d000
    * SQLRESLD                       42AC0000  42ACBFFF  0000c000
    * SQLSVC                         04900000  0491AFFF  0001b000
    * ODBC32                         04920000  0495CFFF  0003d000
    * COMCTL32                       77530000  775C6FFF  00097000
    * comdlg32                       762B0000  762F9FFF  0004a000
    * odbcbcp                        60950000  60955FFF  00006000
    * W95SCM                         41140000  4114CFFF  0000d000
    * SQLUNIRL                       5BB30000  5BB5CFFF  0002d000
    * WINSPOOL                       73070000  73096FFF  00027000
    * SHFOLDER                       766D0000  766D8FFF  00009000
    * odbcint                        04B20000  04B36FFF  00017000
    * NDDEAPI                        75810000  75816FFF  00007000
    * SQLSVC                         04C50000  04C55FFF  00006000
    * xpstar                         04C60000  04C68FFF  00009000
    * dbghelp                        04DB0000  04EAFFFF  00100000
    *
    *        Edi: 00000000:
    *        Esi: 4A517478: 4A516020  4A517FF0  92CDD908  9D63AD4C  CB0EB00C  00000029 
    *        Eax: 76A6F2F3:
    *        Ebx: 4A517358: 00240024  00000010  00000000  00000000  47000002  00000000 
    *        Ecx: 00000004:
    *        Edx: 00000004:
    *        Eip: 007EA027: CE8B108B  508B1189  04518904  8908508B  508B0851  0C51890C 
    *        Ebp: 032F84E8: 032F8540  0075AD60  44E195C0  44DF6038  4A517308  032F8560 
    *      SegCs: 0000001B:
    *     EFlags: 00010206: 00740073  00720065  0063005C  0075006C  00740073  00720065 
    *        Esp: 032F84C4: 44E195C0  4A517308  44DF6038  4A517478  4A517358  00000001 
    *      SegSs: 00000023:
    * *******************************************************************************
    * -------------------------------------------------------------------------------
    * Short Stack Dump
    * 007EA027 Module(sqlservr+003EA027) (SQLExit+00282530)
    * 0075AD60 Module(sqlservr+0035AD60) (SQLExit+001F3269)
    * 008C222B Module(sqlservr+004C222B) (GetIMallocForMsxml+000CD6AB)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004B817B Module(sqlservr+000B817B)
    * 005DAE2A Module(sqlservr+001DAE2A) (SQLExit+00073333)
    * 005DB09D Module(sqlservr+001DB09D) (SQLExit+000735A6)
    * 005DA3AB Module(sqlservr+001DA3AB) (SQLExit+000728B4)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004C680A Module(sqlservr+000C680A)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC024 Module(sqlservr+000FC024)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 00514181 Module(sqlservr+00114181)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 0048ED21 Module(sqlservr+0008ED21)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC024 Module(sqlservr+000FC024)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004C680A Module(sqlservr+000C680A)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004FC000 Module(sqlservr+000FC000)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004C680A Module(sqlservr+000C680A)
    * 00461C5A Module(sqlservr+00061C5A)
    * 0048ED21 Module(sqlservr+0008ED21)
    * 00461C5A Module(sqlservr+00061C5A)
    * 004885F1 Module(sqlservr+000885F1)
    * 00461C5A Module(sqlservr+00061C5A)
    * 00541A71 Module(sqlservr+00141A71)
    * 00461C5A Module(sqlservr+00061C5A)
    * 0048FCF1 Module(sqlservr+0008FCF1)
    * 00461C5A Module(sqlservr+00061C5A)
    * 00461D54 Module(sqlservr+00061D54)
    * 00466407 Module(sqlservr+00066407)
    * 004667DD Module(sqlservr+000667DD)
    * 00466893 Module(sqlservr+00066893)
    * 00464D29 Module(sqlservr+00064D29)
    * 00464E1F Module(sqlservr+00064E1F)
    * 00464FE7 Module(sqlservr+00064FE7)
    * 004709F2 Module(sqlservr+000709F2)
    * 00470A8F Module(sqlservr+00070A8F)
    * 004786CF Module(sqlservr+000786CF)
    * 0044DBE7 Module(sqlservr+0004DBE7)
    * 0044D85C Module(sqlservr+0004D85C)
    * 0043711A Module(sqlservr+0003711A)
    * 005CF4AF Module(sqlservr+001CF4AF) (SQLExit+000679B8)
    * 005CF7D1 Module(sqlservr+001CF7D1) (SQLExit+00067CDA)
    * 00415E57 Module(sqlservr+00015E57)
    * 0043CDDE Module(sqlservr+0003CDDE)
    * 0043D005 Module(sqlservr+0003D005)
    * 0042598D Module(sqlservr+0002598D)
    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
    * 77E6608B Module(kernel32+0002608B) (GetModuleFileNameA+000000EB)
    * -------------------------------------------------------------------------------

    2007年6月21日 上午 01:24

所有回覆

  • Does anyone share the same experience? Seems no-one meet such "odd" behaviour. Just a wild guess...is it due to AntiVirus software...we use "TrendMicro server protect"....

     

    Thanks for those who can provide information..I'm very frustrate about this error.....

    2007年6月27日 上午 06:39