Post reply

How to analyze stack dumps

  • October 16, 2006 at 4:02 pm

    #61967

    Given the following statements

    * BEGIN STACK DUMP:

    *   10/06/06 09:15:58 spid 82

    *

    *   Exception Address = 00402453 (RecBase::Resize(void) + 00000004 Line 0+00000000)

    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

    *   Access Violation occurred reading address 00000000

    * Input Buffer 68 bytes -

    *  exec sp_MSdbuseraccess N'db', N'%'

    Does it means that the accesss violation was caused because of the instruction on the input buffer? In this case because the spid 82 didn't have the right privileges to run the instruction showed after the input buffer line above?

    Is there any to find out which login account/windows account had the spid82 assigned at the time of the dump, after the fact, menaing hours or day(s) later?

    Is there any parameter in SQL server to have more detail information of the spid within the dump?  

    Dumps files have being removed from the server, but will like to be prepared in case this happen again.

     

  • October 19, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 26, 2012 at 10:54 pm

    #1439134

    An access violation means that SQL Server tried to access an area of memory that it was not allowed to access (hence, "access violation"). This is typically due to a bug in SQL Server's code, unless you're using an extended stored procedure. It has nothing to do with SQL Server permissions.

    You see that there was an attempt to read memory address 0 - this is an invalid address, and means there's a bug involved.

  • January 26, 2012 at 11:43 pm

    #1439143

    -- returns 1925

    SELECT

    [Days Since Previous Post] =

    DATEDIFF(DAY, 'October 20, 2006', GETDATE());

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply