Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Exception_access_violation

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    Exception_access_violation

    after one database with 'suspect' and run the sp_resetstatus to remove the suspect, other errors showed after restart SQL2k MSDE sp3.
    ------------------------------------
    12/10/03 10:10:09 spid 79 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00403AF0

    2003-12-10 13:12:59.35 spid79 SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
    Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
    2003-12-10 13:12:59.35 spid79 Error: 3624, Severity: 20, State: 1.

    language_exec: Process 79 generated an access violation. SQL Server is terminating this process..
    2003-12-10 10:10:45.70 spid79 Using 'dbghelp.dll' version '4.0.5'
    *Dump thread - spid = 79, PSS = 0x1fd2f238, EC = 0x1fd2f560
    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump1043.txt

    Any Idea?
    -D

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Did you run a dbcc on that database to see the consistency?

    Do you have a backup of the database just in case everything goes wrong?

  3. #3
    Join Date
    Mar 2003
    Posts
    383
    How Dam to forget Daring DBCC?
    I was confused with SQL error.log. It is actually related on the DBCC check result! Hope in the future, the error.log could be closer to the real cause instead of dumping all the text file and code.....

    thanks MAK for your tip which I should have noticed especially after yesterday's experiences.

    It works now. You are really the <<Expert>>!
    -D

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  5. #5
    Join Date
    Mar 2003
    Posts
    383
    MAX:
    on the same MSDE sql2k sp3 server, another application database dbcc checkdb with consistency error, but this time the points to sysobjects (ID 1). missing or invalid key in index 'ncsysobjects' (ID 2) for the row:
    Server: Msg 8955 Data Row (1:8:18) indentified by (RID=(1:8:18) id = 96) has index values (name = sysfilegroup and uid=1 and id=96).

    This time it relates master's sys tables. Though, at this moment, all the previous "Exception_access_violation" and "SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>" are gone from the error.log.

    Why an application data/index pages might mixed with Master sys table? Since each database has its own data and log files both logically and physically? If any error appear again, need prepare to move all the appl db to another server....
    thanks
    -D

  6. #6
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    how often you do database maintenance and dbcc on your server?

    apply latest service pack on the machine.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    You mean you ran 'dbcc checkdb' on user db and reported error in master db? How is it possible?

  8. #8
    Join Date
    Mar 2003
    Posts
    383
    That is exactly what happened: Run 'dbcc checkdb' on user db and reported error in master db? I run DBCC for every user db every midnight after a full backup (7days a week). And I don't believe it.

    Server: Msg 8951, Level 16, State 1, Line 1
    Table error: Table 'sysobjects' (ID 1). Missing or invalid key in index 'ncsysobjects' (ID 2) for the row:
    Server: Msg 8955, Level 16, State 1, Line 1
    Data row (1:8:18) identified by (RID = (1:8:18) id = 96) has index values (name = 'sysfilegroups' and uid = 1 and id = 96).
    Server: Msg 8952, Level 16, State 1, Line 1
    Table error: Database 'DB_ABC', index 'sysobjects.ncsysobjects' (ID 1) (index ID 2). Extra or invalid key for the keys:
    Server: Msg 8956, Level 16, State 1, Line 1
    Index row (1:92:74) with values (name = 'sysfile⁧roups' and uid = 1 and id = 96) points to the data row identified by ().
    DBCC results for 'DB_ABC'.
    DBCC results for 'sysobjects'.
    There are 473 rows in 9 pages for object 'sysobjects'.
    CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysobjects' (object ID 1).
    DBCC results for 'sysindexes'.
    There are 178 rows in 8 pages for object 'sysindexes'.
    DBCC results for 'syscolumns'.
    There are 913 rows in 15 pages for object 'syscolumns'.
    DBCC results for 'systypes'.
    There are 26 rows in 1 pages for object 'systypes'.
    DBCC results for 'syscomments'.
    There are 447 rows in 110 pages for object 'syscomments'.
    DBCC results for 'sysfiles1'.
    There are 2 rows in 1 pages for object 'sysfiles1'.
    DBCC results for 'syspermissions'.
    There are 87 rows in 1 pages for object 'syspermissions'.
    DBCC results for 'sysusers'.
    There are 18 rows in 1 pages for object 'sysusers'.
    DBCC results for 'sysproperties'.
    There are 0 rows in 0 pages for object 'sysproperties'.
    DBCC results for 'sysdepends'.
    There are 524 rows in 3 pages for object 'sysdepends'.
    DBCC results for 'sysreferences'.
    There are 35 rows in 1 pages for object 'sysreferences'.
    DBCC results for 'sysfulltextcatalogs'.
    There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
    DBCC results for 'sysfulltextnotify'.
    There are 0 rows in 0 pages for object 'sysfulltextnotify'.
    DBCC results for 'sysfilegroups'.
    There are 1 rows in 1 pages for object 'sysfilegroups'.
    DBCC results for 'OutQueue'.
    There are 0 rows in 0 pages for object 'OutQueue'.
    --the rest check user tables ok...
    CHECKDB found 0 allocation errors and 2 consistency errors in database 'DB_ABC'.
    repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (DB_ABC ).
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    It looks need to prepare to go to "ER" very soon. At this time, all the transactions of 20 databases in this MSDE SP3 server are ok.
    thanks
    -D

  9. #9
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I dont see anything related to master database here.

  10. #10
    Join Date
    Mar 2003
    Posts
    383
    sysobjects only exists in Master.
    And it is pointing to "DBCC results for 'sysobjects'.
    "There are 473 rows in 9 pages for object 'sysobjects'.
    CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysobjects' (object ID 1)."
    then sysindexes, syscolumns... all system tables...
    -D

  11. #11
    Join Date
    Sep 2002
    Posts
    5,938
    Each db has set of system tables, they are not from master db.

  12. #12
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    dbo.syscolumns
    dbo.syscomments
    dbo.sysdepends
    dbo.sysfilegroups
    dbo.sysfiles
    dbo.sysfiles1
    dbo.sysforeignkeys
    dbo.sysfulltextcatalogs
    dbo.sysfulltextnotify
    dbo.sysindexes
    dbo.sysindexkeys
    dbo.sysmembers
    dbo.sysobjects
    dbo.syspermissions
    dbo.sysproperties
    dbo.sysprotects
    dbo.sysreferences
    dbo.systypes
    dbo.sysusers

    will be there in all the user databases.

  13. #13
    Join Date
    Mar 2003
    Posts
    383
    MAK and Rmiao:
    sorry about the confusion I brought to, only sysdatabases, syslogins are from Master. I guess a little fatigue about dbcc error from 'sysXYZ...'
    thanks for the 101 basic reminding. Just need to do some dbcc repair to the sys tables.
    -D

  14. #14
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    we all go through (went through) that phase. No big deal.

    Good luck.

  15. #15
    Join Date
    Mar 2003
    Posts
    383
    1. I made a backup for the user DB.
    2. after a dbcc allow data loss with the sysobjects table, the checktable(sysobjects) and the checkDB with no errors.

    question:
    1. Why out of 25 user dbs on a MSDE 2k sp3 server of this Tuesday, 10 user DBs report concurrency errors while the HD side is ok with 11GB space and the server has not been down since 11/15/2003?
    2. Though the dbcc check give me the screen tools to examine DBs everynight, how the syptom of index and/or data pages are being messed up, by what reasons?
    3. Why the dbcc allow data loss on sysobjects did not ask for a sp_configure allow updates true?

    thanks
    -D

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •