December 11, 2009 at 7:59 am
I am seeing following message in the sql error log
An inconsistency was detected during an internal operation in database 'humbo'(ID:16) on page (1:237604). Please contact technical support. Reference number 6.
here are the results for dbcc checkdb
DBCC results for 'humbo'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1299 rows in 15 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 196 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 270 rows in 9 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1299 rows in 15 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 196 rows in 2 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 270 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 25 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 173 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 977 rows in 21 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2305 rows in 43 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 11 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 593 rows in 11 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 933 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 1212 rows in 496 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 19 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 459 rows in 11 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 5096 rows in 54 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'ArchivedIS_ProcessCharacteristics'.
There are 0 rows in 0 pages for object "ArchivedIS_ProcessCharacteristics".
DBCC results for 'DecisionTable'.
There are 223 rows in 3 pages for object "DecisionTable".
DBCC results for 'VC_ProcessCharacteristics'.
There are 999 rows in 106 pages for object "VC_ProcessCharacteristics".
DBCC results for 'ArchivedVC_ProcessCharacteristics'.
There are 354 rows in 39 pages for object "ArchivedVC_ProcessCharacteristics".
DBCC results for 'TaskAssignmentAndConditions'.
There are 408 rows in 2 pages for object "TaskAssignmentAndConditions".
DBCC results for 'Processes'.
There are 151720 rows in 14866 pages for object "Processes".
DBCC results for 'OBEForms'.
There are 333 rows in 72 pages for object "OBEForms".
DBCC results for 'DraftProcesses'.
There are 16650 rows in 7264 pages for object "DraftProcesses".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
DBCC results for 'DummyItemTable'.
There are 67 rows in 1 pages for object "DummyItemTable".
DBCC results for 'ESDeadlines'.
There are 147 rows in 1 pages for object "ESDeadlines".
DBCC results for 'ArchivedProcesses'.
There are 278995 rows in 27001 pages for object "ArchivedProcesses".
DBCC results for 'ModelsNextProcesses'.
There are 19 rows in 1 pages for object "ModelsNextProcesses".
DBCC results for 'ProcessStatuses'.
There are 6 rows in 1 pages for object "ProcessStatuses".
DBCC results for 'TaskStatuses'.
There are 9 rows in 1 pages for object "TaskStatuses".
DBCC results for 'TaskTypes'.
There are 6 rows in 1 pages for object "TaskTypes".
DBCC results for 'ArchivedProcessesTasks'.
There are 1272616 rows in 19834 pages for object "ArchivedProcessesTasks".
DBCC results for 'UserPreferences'.
There are 690 rows in 2 pages for object "UserPreferences".
DBCC results for 'Groups'.
There are 86 rows in 1 pages for object "Groups".
DBCC results for 'CD_ProcessCharacteristics'.
There are 3230 rows in 386 pages for object "CD_ProcessCharacteristics".
DBCC results for 'RoutingTasksTasksGroups'.
There are 15 rows in 1 pages for object "RoutingTasksTasksGroups".
DBCC results for 'ArchivedAdjustedProcesses'.
There are 33169 rows in 16363 pages for object "ArchivedAdjustedProcesses".
DBCC results for 'AdjustedProcesses'.
There are 23948 rows in 13086 pages for object "AdjustedProcesses".
DBCC results for 'ArchivedAdjustedProcessesTasks'.
There are 189778 rows in 2656 pages for object "ArchivedAdjustedProcessesTasks".
DBCC results for 'AdjustedProcessesTasks'.
There are 154781 rows in 2167 pages for object "AdjustedProcessesTasks".
DBCC results for 'ModelsTasks'.
There are 197 rows in 2 pages for object "ModelsTasks".
DBCC results for 'ArchivedProcessesFiles'.
There are 260497 rows in 7261 pages for object "ArchivedProcessesFiles".
DBCC results for 'ModelTaskFlow'.
There are 205 rows in 1 pages for object "ModelTaskFlow".
DBCC results for 'ProcessesFiles'.
There are 197098 rows in 5453 pages for object "ProcessesFiles".
DBCC results for 'ModelsOwners'.
There are 19 rows in 1 pages for object "ModelsOwners".
DBCC results for 'ProcessesTasks'.
There are 863060 rows in 13702 pages for object "ProcessesTasks".
DBCC results for 'ArchivedTA_ProcessCharacteristics'.
There are 89928 rows in 28111 pages for object "ArchivedTA_ProcessCharacteristics".
DBCC results for 'ProcessTaskFlow'.
There are 1066030 rows in 10637 pages for object "ProcessTaskFlow".
DBCC results for 'GroupsUsers'.
There are 603 rows in 6 pages for object "GroupsUsers".
DBCC results for 'PC_ProcessCharacteristics'.
There are 1349 rows in 348 pages for object "PC_ProcessCharacteristics".
DBCC results for 'ArchivedSA_ProcessCharacteristics'.
There are 25740 rows in 7633 pages for object "ArchivedSA_ProcessCharacteristics".
DBCC results for 'Models'.
There are 19 rows in 1 pages for object "Models".
DBCC results for 'CollectionOwners'.
There are 1 rows in 1 pages for object "CollectionOwners".
DBCC results for 'Collections'.
There are 1 rows in 1 pages for object "Collections".
DBCC results for 'humboFeedback'.
There are 53 rows in 5 pages for object "humboFeedback".
DBCC results for 'CollectionsNextEnvelopes'.
There are 1 rows in 1 pages for object "CollectionsNextEnvelopes".
DBCC results for 'ArchivedRT_ProcessCharacteristics'.
There are 6860 rows in 417 pages for object "ArchivedRT_ProcessCharacteristics".
DBCC results for 'DraftProcessFiles'.
There are 2928 rows in 88 pages for object "DraftProcessFiles".
DBCC results for 'EnvelopeStatuses'.
There are 3 rows in 1 pages for object "EnvelopeStatuses".
DBCC results for 'OBSInfo'.
There are 109 rows in 3 pages for object "OBSInfo".
DBCC results for 'Envelopes'.
There are 4356 rows in 111 pages for object "Envelopes".
DBCC results for 'ArchivedPR_ProcessCharacteristics'.
There are 65124 rows in 31006 pages for object "ArchivedPR_ProcessCharacteristics".
DBCC results for 'OB_EnvelopeCharacteristics'.
There are 4356 rows in 844 pages for object "OB_EnvelopeCharacteristics".
DBCC results for 'OnBoardingStatuses'.
There are 6 rows in 1 pages for object "OnBoardingStatuses".
DBCC results for 'AT_ProcessCharacteristics'.
There are 3714 rows in 542 pages for object "AT_ProcessCharacteristics".
DBCC results for 'NewHireInfo'.
There are 1031 rows in 1031 pages for object "NewHireInfo".
DBCC results for 'sys.queue_messages_1134679140'.
There are 0 rows in 0 pages for object "sys.queue_messages_1134679140".
DBCC results for 'ArchivedPC_ProcessCharacteristics'.
There are 3053 rows in 768 pages for object "ArchivedPC_ProcessCharacteristics".
DBCC results for 'EC_ProcessCharacteristics'.
There are 1858 rows in 461 pages for object "EC_ProcessCharacteristics".
DBCC results for 'sys.queue_messages_1166679254'.
There are 0 rows in 0 pages for object "sys.queue_messages_1166679254".
DBCC results for 'ArchivedPA_ProcessCharacteristics'.
There are 9438 rows in 1109 pages for object "ArchivedPA_ProcessCharacteristics".
DBCC results for 'sys.queue_messages_1198679368'.
There are 0 rows in 0 pages for object "sys.queue_messages_1198679368".
DBCC results for 'ArchivedOB_EnvelopeCharacteristics'.
There are 6951 rows in 1177 pages for object "ArchivedOB_EnvelopeCharacteristics".
DBCC results for 'ArchivedNH_ProcessCharacteristics'.
There are 7055 rows in 2392 pages for object "ArchivedNH_ProcessCharacteristics".
DBCC results for 'GroupControllers'.
There are 246 rows in 3 pages for object "GroupControllers".
DBCC results for 'NewHireProfile'.
There are 868 rows in 22 pages for object "NewHireProfile".
DBCC results for 'ArchivedNB_ProcessCharacteristics'.
There are 6080 rows in 869 pages for object "ArchivedNB_ProcessCharacteristics".
DBCC results for 'GroupHistory'.
There are 470 rows in 12 pages for object "GroupHistory".
DBCC results for 'NewHireFiles'.
There are 2387 rows in 83 pages for object "NewHireFiles".
DBCC results for 'ArchivedNA_ProcessCharacteristics'.
There are 6592 rows in 1303 pages for object "ArchivedNA_ProcessCharacteristics".
DBCC results for 'NC_ProcessCharacteristics'.
There are 127 rows in 13 pages for object "NC_ProcessCharacteristics".
DBCC results for 'EEOC'.
There are 574 rows in 10 pages for object "EEOC".
DBCC results for 'NH_ProcessCharacteristics'.
There are 4433 rows in 1517 pages for object "NH_ProcessCharacteristics".
DBCC results for 'ArchivedEC_ProcessCharacteristics'.
There are 1774 rows in 456 pages for object "ArchivedEC_ProcessCharacteristics".
DBCC results for 'ArchivedNC_ProcessCharacteristics'.
There are 14 rows in 2 pages for object "ArchivedNC_ProcessCharacteristics".
DBCC results for 'CommentTypes'.
There are 3 rows in 1 pages for object "CommentTypes".
DBCC results for 'NA_ProcessCharacteristics'.
There are 4039 rows in 801 pages for object "NA_ProcessCharacteristics".
DBCC results for 'ArchivedCR_ProcessCharacteristics'.
There are 9307 rows in 1699 pages for object "ArchivedCR_ProcessCharacteristics".
DBCC results for 'Comments'.
There are 83623 rows in 2272 pages for object "Comments".
DBCC results for 'NB_ProcessCharacteristics'.
There are 3643 rows in 556 pages for object "NB_ProcessCharacteristics".
DBCC results for 'ArchivedAT_ProcessCharacteristics'.
There are 8538 rows in 1247 pages for object "ArchivedAT_ProcessCharacteristics".
DBCC results for 'CR_ProcessCharacteristics'.
There are 5012 rows in 889 pages for object "CR_ProcessCharacteristics".
DBCC results for 'ArchivedEnvelopes'.
There are 6951 rows in 184 pages for object "ArchivedEnvelopes".
DBCC results for 'ModelsSearchableTasks'.
There are 86 rows in 1 pages for object "ModelsSearchableTasks".
DBCC results for 'NR_ProcessCharacteristics'.
There are 912 rows in 253 pages for object "NR_ProcessCharacteristics".
DBCC results for 'RT_ProcessCharacteristics'.
There are 5054 rows in 328 pages for object "RT_ProcessCharacteristics".
DBCC results for 'Tasks'.
There are 162 rows in 3 pages for object "Tasks".
DBCC results for 'ArchivedAdjustedEnvelopes'.
There are 1766 rows in 356 pages for object "ArchivedAdjustedEnvelopes".
DBCC results for 'ArchivedNR_ProcessCharacteristics'.
There are 0 rows in 0 pages for object "ArchivedNR_ProcessCharacteristics".
DBCC results for 'ArchivedComments'.
There are 34202 rows in 959 pages for object "ArchivedComments".
DBCC results for 'AdjustedEnvelopes'.
There are 1027 rows in 212 pages for object "AdjustedEnvelopes".
DBCC results for 'Notifications'.
There are 1677 rows in 16 pages for object "Notifications".
DBCC results for 'IT_ProcessCharacteristics'.
There are 0 rows in 0 pages for object "IT_ProcessCharacteristics".
DBCC results for 'AssociatedProcesses'.
There are 28244 rows in 126 pages for object "AssociatedProcesses".
DBCC results for 'PA_ProcessCharacteristics'.
There are 5154 rows in 542 pages for object "PA_ProcessCharacteristics".
DBCC results for 'PR_ProcessCharacteristics'.
There are 20193 rows in 15839 pages for object "PR_ProcessCharacteristics".
DBCC results for 'ArchivedAssociatedProcesses'.
There are 16603 rows in 63 pages for object "ArchivedAssociatedProcesses".
DBCC results for 'SA_ProcessCharacteristics'.
There are 8550 rows in 2437 pages for object "SA_ProcessCharacteristics".
DBCC results for 'TA_ProcessCharacteristics'.
There are 28872 rows in 8868 pages for object "TA_ProcessCharacteristics".
DBCC results for 'TR_ProcessCharacteristics'.
There are 29248 rows in 11119 pages for object "TR_ProcessCharacteristics".
DBCC results for 'ArchivedCD_ProcessCharacteristics'.
There are 5429 rows in 590 pages for object "ArchivedCD_ProcessCharacteristics".
DBCC results for 'VT_ProcessCharacteristics'.
There are 0 rows in 0 pages for object "VT_ProcessCharacteristics".
DBCC results for 'ArchivedNewHireInfo'.
There are 26 rows in 26 pages for object "ArchivedNewHireInfo".
DBCC results for 'humboEntryPoints'.
There are 610 rows in 4 pages for object "humboEntryPoints".
DBCC results for 'ArchivedTR_ProcessCharacteristics'.
There are 17359 rows in 11348 pages for object "ArchivedTR_ProcessCharacteristics".
DBCC results for 'Positions'.
There are 12376 rows in 478 pages for object "Positions".
DBCC results for 'MR_ProcessCharacteristics'.
There are 22087 rows in 15206 pages for object "MR_ProcessCharacteristics".
DBCC results for 'ArchivedMR_ProcessCharacteristics'.
There are 10964 rows in 6249 pages for object "ArchivedMR_ProcessCharacteristics".
DBCC results for 'IS_ProcessCharacteristics'.
There are 2910 rows in 1026 pages for object "IS_ProcessCharacteristics".
DBCC results for 'ArchivedNewHireFiles'.
There are 0 rows in 0 pages for object "ArchivedNewHireFiles".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'humbo'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I don't see any errors here. I also ran dbcc updateusage(0) . but the error is still showing up.
December 11, 2009 at 8:13 am
DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS
comes back with nothing. and all it says is
Command(s) completed successfully.
December 11, 2009 at 11:24 am
What is your PAGE_VERIFY set to currently? If you are on SQL Server 2005, CHECKSUM is the recommended best practice setting for this, which stamps each page with a checksum value when it is written to disk. If the CHECKSUM value stored on the page doesn't match the calculated checksum value when it is read from disk, it will throw a 824 error, with the incorrect checksum, which is a pointer that something is awry with your disk subsystem. If it is set to NONE, you will get a 5242 when you would otherwise get a 824 if it were set to CHECKSUM or TORN_PAGE_DETECTION while performing SELECT operations from a table with corruption in it.
With PAGE_VERIFY set to NONE, you would get:
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database 'CheckDBPractice'(ID:24) on page (1:114). Please contact technical support. Reference number 6.
With PAGE_VERIFY set to TORN_PAGE_DETECTION, you would get:
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x12c048d5). It occurred during a read of page (1:114) in database ID 24 at offset 0x000000000e4000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\TestCorruption.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
and with PAGE_VERIFY set to CHECKSUM, you would get:
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xe5582473; actual: 0x1a5f4505). It occurred during a read of page (1:114) in database ID 24 at offset 0x000000000e4000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\TestCorruption.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Try and use DBCC PAGE to read the page header information from the page listed in the error and then get the associated object metadata:
DBCC TRACEON(3604)
CREATE TABLE #DBCC (
ParentObject VARCHAR(255)
, [Object] VARCHAR(255)
, Field VARCHAR(255)
, [Value] VARCHAR(255)
)
INSERT INTO #DBCC
EXECUTE('DBCC PAGE(humbo, 1, 237604, 3) WITH TABLERESULTS')
SELECT
[ObjectId],
[IndexId],
[PartitionId],
[AllocUnitId]
FROM
(
SELECT REPLACE(Field, 'Metadata: ', '') AS Field, Value
FROM #DBCC
WHERE Field LIKE 'Metadata:%'
) AS sub
PIVOT
(
MAX(Value) FOR Field IN ([ObjectId], [IndexId], [PartitionId], [AllocUnitId])
)
AS pvt
DROP TABLE #DBCC
DBCC TRACEOFF(3604)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply