none
Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    Question

  • All,

    I am troubleshooting errors on SQL Server version 9.00.5000.00

    This comes with a number of clues that I'll try to be clear with.

    1)  Recently sp_SendMail has stopped working as expected.  Specifically, it will send an email unless we give it a query to append to the body.  The result is a hung session (query) that cannot be cancelled.  There also is a minidump occuring about the same time - I'll paste some the text below.

    2)  Cannot access Error logs in SSMS, both version 2005 and 2008R2 doesn't do anything except an hourglass for a little while.

    3) Cannot access SQL DBA Dashboard reports (runs some CLR routines)

    Aside from simply rebooting the server this evening, can anyone offer advise on what to look for?

    Memory                              
    MemoryLoad = 91%                    
    Total Physical = 4094 MB            
    Available Physical = 335 MB         
    Total Page File = 5973 MB           
    Available Page File = 2119 MB       
    Total Virtual = 2047 MB             
    Available Virtual = 47 MB           
    ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0004.txt             
    SqlDumpExceptionHandler: Process 222 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
     terminating this process.                                                                                      
    * *******************************************************************************                               
    *                                                                                                               
    * BEGIN STACK DUMP:                                                                                             
    *   11/28/11 08:30:36 spid 222                                                                                  
    *                                                                                                               
    *                                                                                                               
    *   Exception Address = 7C82C6E6 Module(ntdll+0002C6E6)                                                         
    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION                                                     
    *   Access Violation occurred reading address 00000004                                                          
    * Input Buffer 510 bytes -                                                                                      
    *             DECLARE @MSG VARCHAR(255)  DECLARE @mySubjectLine varChar(200                                     
    *  )  DECLARE @mySubject varChar(255)  DECLARE @myQuery varchar(max)    --D                                     
    *  ECLARE @MAILTO VARCHAR(500)  --SET @MAILTO = 'xxx@xxx.org;xxx@                                    
    *  xxx.org;xxx@xxx.org'    EXEC CLIENT_KS.DBO.sp_Lytec_BadSSN_view  IF @@R                                     
    *  OWCOUNT > 0      BEGIN              SET @MSG = 'Below are clients whose social secur                                     
    *  ity numbers do not match between the Lytec system and CMS as of '                                                        
    *      + CONVERT(VARCHAR(20),GETDATE(),101) + char(13) + char(13)          SET @mySu                                     
    *  bjectLine='xxx BEHAVIORAL HEALTHCARE: Mis-matched SSNs'          SET @mySubjec                                     
    *  t = @mySubjectLine          SET @myQuery = 'CLIENT_KS.DBO.sp_Lytec_BadSSN_view                                     
    *  '          EXEC appSecurity.SafeSend.sp_SendMail_Static                  @rptSubjectLine =                                     
    *   @mySubjectLine,                   @strSubject = @mySubject,                  @strBody = @MSG,                                       
    *                  @Qry = @myQuery          --EXEC msdb.dbo.sp_send_dbmail          --    @profile_nam                                     
    *  e = 'ASDMail',       --        @recipients = @MAILTO ,          --    @copy_recipients = '                                     
    *  xxx@xxx.org;xxx@xxx.org',            --    @query = 'CLIENT_KS.DBO.s                                     
    *  p_Lytec_BadSSN_view',          --    @subject = 'xxx BEHAVIORAL HEALTHCARE: Mis-m                                     
    *  atched SSNs',          --    @body = @MSG      END                                                                       
    *                                                                                                               
    *                                                                                                               
    *  MODULE                          BASE      END       SIZE                                                     
    * sqlservr                       01000000  02C26FFF  01c27000                                                   
    * ntdll                          7C800000  7C8C2FFF  000c3000                                                   

     

    Thanks in advance,

    Mac McCaskie

    Monday, November 28, 2011 8:08 PM

Answers

All replies

  • I would suggest you install the latest Cumulative Update and see if the problem is already resolved.

    Please see:

    http://support.microsoft.com/kb/2485757

    • Proposed as answer by Peja Tao Wednesday, November 30, 2011 3:37 AM
    • Marked as answer by Peja Tao Monday, December 05, 2011 3:21 AM
    Monday, November 28, 2011 8:35 PM
    Moderator
  • Problem signature:
    Problem Event Name: BEX
    Application Name: CivilizationV.exe
    Application Version: 1.0.0.17
    Application Timestamp: 4c9b9294
    Fault Module Name: StackHash_a940
    Fault Module Version: 0.0.0.0
    Fault Module Timestamp: 00000000
    Exception Offset: 00000000
    Exception Code: c0000005
    Exception Data: 00000008
    OS Version: 6.0.6002.2.2.0.768.3
    Locale ID: 1033
    Additional Information 1: a940
    Additional Information 2: dcf2f0e87615fe015374b77f51d2b897
    Additional Information 3: b9f6
    Additional Information 4: 07541c74c3b0b7da05ec73a24541e5b3
    I went threw alot of trouble shooting from some of the member here at 2K that keeps telling me it had to do with out of date drivers for a video card or sound card.These 2 driver would not affect the CPU and make it stake up shut down the program.They keep looking at the Exception Code: c0000005 and was not looking at the BEX. BEX was the key to causing my problem.
    Often BEX errors are caused by Toolbars such as Google, TrendMicro 
    and others. Are you using any 3rd party toolbars in IE? Cause and fix is same for Vista and Windows 7.
    What antivirus/antispyware/security product do you have on machine? 
    Include any you have EVER had on this machine including those you 
    uninstalled (they leave remnants behind which causes issues).
    Start - All Programs - Accessories - System Tools - IE with no Add-ons
    does this work better?
    IE - Tools - Internet Options - Advanced Tab - click Restore Advanced Settings and then click RESET - APPLY / OK
    IE - Tools - Internet Options - Security Tab - click Reset all zones -
    APPLY / OK
    Close and restart IE and/or IE with no addons
    Start - All Programs - Accessories - System Tools - IE with no Addons -
    does this work better?
    IE - Tools - Manage Addons (for sure disable SSV2 if it is there, this 
    is no longer needed but Java still installs it and it causes issues - you ever update Java go back in and disable it again.) Look for other possible problems.
    Windows Defender - Tools - Software Explorer - look for issues with programs that do not look right. Permitted are usually OK and "not permitted" are not always bad.
    I think these are some related issue which can cause of this problem.
    Tuesday, January 03, 2012 12:18 PM
  • Sorry I have been so tardy with the reply.  Your sugestion has great merit however the our IT dept avoids updates like the plague (let's not argue about it, I've been blue in the face enought about it).

    I can't remember what I did to fix otherwise I let you-all know.

    thanks

    Tuesday, March 06, 2012 3:42 PM
  • This crash was caused by a zero length detail section in a report. Increasing to anything over zero fixes it.

    Tuesday, September 23, 2014 8:34 PM