January 26, 2011 at 1:35 am
Hello,
Could you please help me. I've got the following problem during Rebuild Index Task:
01/24/2011 23:21:08,Bad_base_test_Osinkin.Subplan_1,Error,1,XDBS,Bad_base_test_Osinkin.Subplan_1,Subplan_1,,Executed as user: XDBS\root. ...:34.50 Source: Rebuild Index Task Executing query "USE [upp_new] ".: 0% complete End Progress Progress: 2011-01-24 23:33:34.51 Source: Rebuild Index Task Executing query "ALTER INDEX [_Acc14_ByParentCode_RSR] ON [dbo].[_A".: 0% complete End Progress Progress: 2011-01-24 23:33:34.51 Source: Rebuild Index Task Executing query "USE [upp_new] ".: 0% complete End Progress Progress: 2011-01-24 23:33:34.51 Source: Rebuild Index Task Executing query "ALTER INDEX [_Acc14_ByParentDescr_RSR] ON [dbo].[_".: 0% complete End Progress Progress: 2011-01-24 23:33:34.51 Source: Rebuild Index Task Executing query "USE [upp_new] ".: 0% complete End Progress Progress: 2011-01-24 23:33:34.53 Source: Rebuild Index Task Executing query "ALTER INDEX [_Acc14_ByParentField22415_RLR] ON [db".: 0% complete End Progress Progress: 2011-01-24 23:33:34.53 Source: Rebuild Index Task ... The package execution fa... The step failed.,01:37:09,0,0,,,,0
The Check Database Integrity gives the following diagnostics:
01/22/2011 12:23:07,Bad_base.Subplan_1,Error,0,XDBS,Bad_base.Subplan_1,(Job outcome),,The job failed. The Job was invoked by User GRAFICAM\apikalov. The last step to run was step 1 (Subplan_1).,01:55:49,0,0,,,,0
01/22/2011 12:23:08,Bad_base.Subplan_1,Error,1,XDBS,Bad_base.Subplan_1,Subplan_1,,Executed as user: XDBS\root. ... Version 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:23:08 Progress: 2011-01-22 12:23:40.21 Source: {A288D294-93F7-46BB-81C4-5F9F88116EF0} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2011-01-22 12:23:41.17 Source: Check Database Integrity Executing query "USE [upp] ".: 50% complete End Progress Error: 2011-01-22 14:18:55.78 Code: 0xC002F210 Source: Check Database Integrity Execute SQL Task Description: Executing the query "DBCC CHECKDB WITH NO_INFOMSGS " failed with the following error: "Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594239975424 (type LOB data). The off-row data node at page (1:6033311)<c/> slot 20<c/> text ID 1283014066176 is not referenced. Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 720576... The package execution fa... The step failed.,01:55:48,0,0,,,,0
The database is the very big - almost 300 GB. Unfortunetely, there are no backups done before the problem appears. Thank you in advance for any ideas!
Anton
January 26, 2011 at 1:48 am
The errors from the check integrity task are cut off. Please run the following and post the full and complete results
DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2011 at 5:19 am
The log is the following:
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
01/26/2011 12:01:22,Bad_base_test_Osinkin.Subplan_1,Error,0,XDBS,Bad_base_test_Osinkin.Subplan_1,(Job outcome),,The job failed. The Job was invoked by User GRAFICAM\aosinkin. The last step to run was step 1 (Subplan_1).,02:04:38,0,0,,,,0
01/26/2011 12:01:23,Bad_base_test_Osinkin.Subplan_1,Error,1,XDBS,Bad_base_test_Osinkin.Subplan_1,Subplan_1,,Executed as user: XDBS\root. ...<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594239975424 (type LOB data). The off-row data node at page (1:6033311)<c/> slot 36<c/> text ID 1283015114752 is not referenced. Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594239975424 (type LOB data). The off-row data node at page (1:6033311)<c/> slot 37<c/> text ID 1283015180288 is not referenced. Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594239975424 (type LOB data). The off-row data node at page (1:6033311)<c/> slot 38<c/> text ID 1283015245824 is not referenced. Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594239975424 (type LOB data). The off-row data node at page (1:6033311)<c/> slot 39<c/> text ID 1283015311360 is not referenced. Table error: Object ID 363200394<c/> index ID 1<c/> partition ID 72057618543476736<c/> alloc unit ID 72057594... The package execution fa... The step failed.,02:04:37,0,0,,,,0
January 26, 2011 at 5:24 am
That is still cut off at the end.
Please run the following and post the full and complete results
DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2011 at 7:00 am
I attach to this post all log's done by the task.
January 26, 2011 at 7:47 am
Looks like some pages were deallocated without cleaning up the surrounding structures. On SQL 2000 that could happen when running a checkDB with repair, not sure how it could happen on SQL 2005.
Fix is to repair it. Take the database into single user mode and run the following
DBCC CheckDB(<Database Name>) WITH REPAIR_ALLOW_DATA_LOSS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2011 at 8:09 am
Thank you. I'll try...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply