-
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
-
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?
-
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
-
I am glad.
-
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
-
how often you do database maintenance and dbcc on your server?
apply latest service pack on the machine.
-
You mean you ran 'dbcc checkdb' on user db and reported error in master db? How is it possible?
-
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 = 'sysfileroups' 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
-
I dont see anything related to master database here.
-
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
-
Each db has set of system tables, they are not from master db.
-
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.
-
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
-
we all go through (went through) that phase. No big deal.
Good luck.
-
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
-
Forum Rules
|
|