Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 SQL error "Could not continue scan with NOLOCK due to data"  [new]
Вжик
Member

Откуда: Москва
Сообщений: 676
как решить проблему с этой ошибкой ???
если есть бекап можно ли используя его заменить ошибочные блоки ???
11 июл 03, 16:26    [259117]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
Вжик
Member

Откуда: Москва
Сообщений: 676
Вот такой набор ошибок:
DBCC results for 'SC5475'.

There are 5 rows in 1 pages for object 'SC5475'.
DBCC results for 'RG4833'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 543341000, index ID 4: Page (1:1629) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 543341000, index ID 4, page (1:1629). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 543341000, index ID 4. Page (1:1629) was not seen in the scan although its parent (1:616952) and previous (1:2195) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 543341000, index ID 4. Page (1:1963) is missing a reference from previous page (1:1629). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1890821798, index ID 0: Page (1:695545) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1890821798, index ID 0, page (1:695545). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1890821798, index ID 1. Page (1:695545) was not seen in the scan although its parent (1:695090) and previous (1:695544) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1890821798, index ID 1. Page (1:695546) is missing a reference from previous page (1:695545). Possible chain linkage problem.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table '_1SJOURN' (ID 1929773932). Missing or invalid key in index 'VIA5397' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:3320:46) identified by (RID = (1:3320:46) ROW_ID = 5650903) has index values (DS5397 = 150994944 and DATE_TIME_IDDOC = '200307113CTX80 LZBPD50' and ROW_ID = 5650903).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table '_1SJOURN' (ID 1929773932). Missing or invalid key in index 'VIA5397' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:3320:47) identified by (RID = (1:3320:47) ROW_ID = 5650904) has index values (DS5397 = 150994944 and DATE_TIME_IDDOC = '200307113G0T0W LZBQD50' and ROW_ID = 5650904).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table '_1SJOURN' (ID 1929773932). Missing or invalid key in index 'VIA5397' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:3320:48) identified by (RID = (1:3320:48) ROW_ID = 5650905) has index values (DS5397 = 150994944 and DATE_TIME_IDDOC = '200307113IPOOG LZBRD50' and ROW_ID = 5650905).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table '_1SJOURN' (ID 1929773932). Missing or invalid key in index 'VIA5397' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:3320:49) identified by (RID = (1:3320:49) ROW_ID = 5650906) has index values (DS5397 = 150994944 and DATE_TIME_IDDOC = '200307113LTKGG LZBSD50' and ROW_ID = 5650906).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table '_1SJOURN' (ID 1929773932). Missing or invalid key in index 'VIA5397' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:3320:50) identified by (RID = (1:3320:50) ROW_ID = 5650907) has index values (DS5397 = 150994944 and DATE_TIME_IDDOC = '200307113OKDK0 LZBTD50' and ROW_ID = 5650907).
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1961774046, index ID 1. Page (1:111056) is missing a reference from previous page (1:110997). Possible chain linkage problem.
There are 0 rows in 0 pages for object 'RG4833'.
DBCC results for 'DT4763'.
There are 0 rows in 0 pages for object 'DT4763'.
DBCC results for 'SC4810'.
There are 40 rows in 5 pages for object 'SC4810'.
DBCC results for 'RA4833'.
There are 0 rows in 0 pages for object 'RA4833'.
DBCC results for 'DH4698'.
There are 0 rows in 0 pages for object 'DH4698'.
DBCC results for 'SC5406'.
There are 5215 rows in 72 pages for object 'SC5406'.
DBCC results for 'RG4840'.
There are 2074451 rows in 12511 pages for object 'RG4840'.
DBCC results for 'DT4698'.
There are 0 rows in 0 pages for object 'DT4698'.
DBCC results for 'SC488'.
There are 325 rows in 21 pages for object 'SC488'.
DBCC results for 'RA4840'.
There are 12303998 rows in 136943 pages for object 'RA4840'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'RA4840' (object ID 543341000).
DBCC results for 'DH5154'.
There are 0 rows in 0 pages for object 'DH5154'.
DBCC results for 'SC5622'.
There are 25 rows in 1 pages for object 'SC5622'.
DBCC results for 'RG4844'.
There are 0 rows in 0 pages for object 'RG4844'.
DBCC results for 'DT5154'.
There are 0 rows in 0 pages for object 'DT5154'.
DBCC results for 'SC4612'.
There are 37 rows in 1 pages for object 'SC4612'.
DBCC results for 'RA4844'.
There are 0 rows in 0 pages for object 'RA4844'.
DBCC results for 'DH4826'.
There are 0 rows in 0 pages for object 'DH4826'.
DBCC results for 'SC430'.
There are 1 rows in 1 pages for object 'SC430'.
DBCC results for 'RG4870'.
There are 0 rows in 0 pages for object 'RG4870'.
DBCC results for 'DT4826'.
There are 0 rows in 0 pages for object 'DT4826'.
DBCC results for 'SC656'.
There are 73960 rows in 3231 pages for object 'SC656'.
DBCC results for 'RA4870'.
There are 0 rows in 0 pages for object 'RA4870'.
DBCC results for 'DH5042'.
There are 0 rows in 0 pages for object 'DH5042'.
DBCC results for 'SC5371'.
There are 0 rows in 0 pages for object 'SC5371'.
DBCC results for 'RG4881'.
There are 0 rows in 0 pages for object 'RG4881'.
DBCC results for 'DT5042'.
There are 0 rows in 0 pages for object 'DT5042'.
DBCC results for 'SC4638'.
There are 5 rows in 1 pages for object 'SC4638'.
DBCC results for 'RA4881'.
There are 0 rows in 0 pages for object 'RA4881'.
DBCC results for 'DH5389'.
There are 0 rows in 0 pages for object 'DH5389'.
DBCC results for 'SC4947'.
There are 127990 rows in 2979 pages for object 'SC4947'.
DBCC results for 'RG5094'.
There are 49254 rows in 530 pages for object 'RG5094'.
DBCC results for 'DT5389'.
There are 0 rows in 0 pages for object 'DT5389'.
DBCC results for 'SC5697'.
There are 2 rows in 1 pages for object 'SC5697'.
DBCC results for 'RA5094'.
There are 3337 rows in 47 pages for object 'RA5094'.
DBCC results for 'DH5142'.
There are 0 rows in 0 pages for object 'DH5142'.
DBCC results for 'SC4986'.
There are 3 rows in 1 pages for object 'SC4986'.
DBCC results for '_1SSTREAM'.
There are 1 rows in 1 pages for object '_1SSTREAM'.
DBCC results for 'DT5142'.
There are 0 rows in 0 pages for object 'DT5142'.
DBCC results for 'SC792'.
There are 3 rows in 1 pages for object 'SC792'.
DBCC results for 'DH4746'.
There are 16034 rows in 1018 pages for object 'DH4746'.
DBCC results for 'SC4614'.
There are 8 rows in 1 pages for object 'SC4614'.
DBCC results for 'DT4746'.
There are 155387 rows in 1697 pages for object 'DT4746'.
DBCC results for 'SC4616'.
There are 6 rows in 1 pages for object 'SC4616'.
DBCC results for '_1SCONST'.
There are 440798 rows in 4080 pages for object '_1SCONST'.
DBCC results for 'DH5213'.
There are 0 rows in 0 pages for object 'DH5213'.
DBCC results for 'SC4618'.
There are 7 rows in 1 pages for object 'SC4618'.
DBCC results for 'DT5213'.
There are 0 rows in 0 pages for object 'DT5213'.
DBCC results for 'SC4719'.
There are 150 rows in 3 pages for object 'SC4719'.
DBCC results for 'DH4799'.
There are 120604 rows in 8063 pages for object 'DH4799'.
DBCC results for 'SC5457'.
There are 1509 rows in 40 pages for object 'SC5457'.
DBCC results for 'DT4799'.
There are 1439305 rows in 11826 pages for object 'DT4799'.
DBCC results for 'SC5542'.
There are 2 rows in 1 pages for object 'SC5542'.
DBCC results for 'DH4917'.
There are 2 rows in 1 pages for object 'DH4917'.
DBCC results for 'SC4937'.
There are 27177 rows in 461 pages for object 'SC4937'.
DBCC results for 'DT4917'.
There are 1 rows in 1 pages for object 'DT4917'.
DBCC results for 'SC5471'.
There are 3 rows in 1 pages for object 'SC5471'.
DBCC results for '_1SUPDTS'.
There are 449355 rows in 2993 pages for object '_1SUPDTS'.
DBCC results for 'DH5230'.
There are 0 rows in 0 pages for object 'DH5230'.
DBCC results for 'SC5600'.
There are 122 rows in 2 pages for object 'SC5600'.
DBCC results for '_1SDBSET'.
There are 30 rows in 2 pages for object '_1SDBSET'.
DBCC results for 'DT5230'.
There are 0 rows in 0 pages for object 'DT5230'.
DBCC results for 'SC5517'.
There are 14143 rows in 360 pages for object 'SC5517'.
DBCC results for '_1SDWNLDS'.
There are 99 rows in 1 pages for object '_1SDWNLDS'.
DBCC results for 'DH5099'.
There are 0 rows in 0 pages for object 'DH5099'.
DBCC results for 'SC5447'.
There are 13256 rows in 271 pages for object 'SC5447'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'DT5099'.
There are 0 rows in 0 pages for object 'DT5099'.
DBCC results for '_1SCONNECT'.
There are 1 rows in 1 pages for object '_1SCONNECT'.
DBCC results for 'SC512'.
There are 3 rows in 1 pages for object 'SC512'.
DBCC results for 'DH5121'.
There are 0 rows in 0 pages for object 'DH5121'.
DBCC results for 'SC5779'.
There are 2245 rows in 22 pages for object 'SC5779'.
DBCC results for 'DT5121'.
There are 0 rows in 0 pages for object 'DT5121'.
DBCC results for 'SC4634'.
There are 373871 rows in 4156 pages for object 'SC4634'.
DBCC results for 'DH5166'.
There are 15 rows in 2 pages for object 'DH5166'.
DBCC results for 'SC5890'.
There are 35847 rows in 323 pages for object 'SC5890'.
DBCC results for 'DT5166'.
There are 3337 rows in 31 pages for object 'DT5166'.
DBCC results for 'SC4674'.
There are 13 rows in 1 pages for object 'SC4674'.
DBCC results for 'DH5180'.
There are 0 rows in 0 pages for object 'DH5180'.
DBCC results for 'SC4691'.
There are 365097 rows in 4743 pages for object 'SC4691'.
DBCC results for 'DT5180'.
There are 0 rows in 0 pages for object 'DT5180'.
DBCC results for 'SC3791'.
There are 2 rows in 1 pages for object 'SC3791'.
DBCC results for 'DH4776'.
There are 0 rows in 0 pages for object 'DH4776'.
DBCC results for 'SC3788'.
There are 4 rows in 1 pages for object 'SC3788'.
DBCC results for 'DT4776'.
There are 0 rows in 0 pages for object 'DT4776'.
DBCC results for 'SC3094'.
There are 2 rows in 1 pages for object 'SC3094'.
DBCC results for 'DH5205'.
There are 0 rows in 0 pages for object 'DH5205'.
DBCC results for 'SC4672'.
There are 11 rows in 1 pages for object 'SC4672'.
DBCC results for 'DT5205'.
There are 0 rows in 0 pages for object 'DT5205'.
DBCC results for 'SC4609'.
There are 2 rows in 1 pages for object 'SC4609'.
DBCC results for 'DH5498'.
There are 6527 rows in 466 pages for object 'DH5498'.
DBCC results for 'SC5574'.
There are 0 rows in 0 pages for object 'SC5574'.
DBCC results for 'DT5498'.
There are 614749 rows in 14654 pages for object 'DT5498'.
DBCC results for 'SC4620'.
There are 1 rows in 1 pages for object 'SC4620'.
DBCC results for 'DH4755'.
There are 1866 rows in 126 pages for object 'DH4755'.
DBCC results for 'SC5581'.
There are 1 rows in 1 pages for object 'SC5581'.
DBCC results for 'DT4755'.
There are 87560 rows in 1415 pages for object 'DT4755'.
DBCC results for 'SC5586'.
There are 0 rows in 0 pages for object 'SC5586'.
DBCC results for 'DH5259'.
There are 0 rows in 0 pages for object 'DH5259'.
DBCC results for 'SC5553'.
There are 0 rows in 0 pages for object 'SC5553'.
DBCC results for 'DT5259'.
There are 0 rows in 0 pages for object 'DT5259'.
DBCC results for 'SC1564'.
There are 1 rows in 1 pages for object 'SC1564'.
DBCC results for 'DH4786'.
There are 122487 rows in 8178 pages for object 'DH4786'.
DBCC results for 'SC2557'.
There are 3 rows in 1 pages for object 'SC2557'.
DBCC results for 'DT4786'.
There are 1585324 rows in 13231 pages for object 'DT4786'.
DBCC results for 'SC3813'.
There are 0 rows in 0 pages for object 'SC3813'.
DBCC results for 'DH5413'.
There are 0 rows in 0 pages for object 'DH5413'.
DBCC results for 'SC1889'.
There are 0 rows in 0 pages for object 'SC1889'.
DBCC results for 'DT5413'.
There are 0 rows in 0 pages for object 'DT5413'.
DBCC results for 'SC4109'.
There are 0 rows in 0 pages for object 'SC4109'.
DBCC results for '_1SUSERS'.
There are 1 rows in 1 pages for object '_1SUSERS'.
DBCC results for '_1SSYSTEM'.
There are 1 rows in 1 pages for object '_1SSYSTEM'.
DBCC results for 'DH4806'.
There are 4927499 rows in 329392 pages for object 'DH4806'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'DH4806' (object ID 1890821798).
DBCC results for 'SC4124'.
There are 0 rows in 0 pages for object 'SC4124'.
DBCC results for 'DT4806'.
There are 8941989 rows in 140120 pages for object 'DT4806'.
DBCC results for 'SC5682'.
There are 0 rows in 0 pages for object 'SC5682'.
DBCC results for '_1SJOURN'.
There are 5244368 rows in 70870 pages for object '_1SJOURN'.
CHECKDB found 0 allocation errors and 5 consistency errors in table '_1SJOURN' (object ID 1929773932).
DBCC results for 'DH5721'.
There are 0 rows in 0 pages for object 'DH5721'.
DBCC results for 'SC995'.
There are 0 rows in 0 pages for object 'SC995'.
DBCC results for '_1SCRDOC'.
There are 5417821 rows in 54182 pages for object '_1SCRDOC'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '_1SCRDOC' (object ID 1961774046).
DBCC results for 'DT5721'.
There are 0 rows in 0 pages for object 'DT5721'.
DBCC results for 'SC2283'.
There are 1 rows in 1 pages for object 'SC2283'.
DBCC results for '_1SDNLOCK'.
There are 29 rows in 1 pages for object '_1SDNLOCK'.
DBCC results for 'DH5726'.
There are 13 rows in 1 pages for object 'DH5726'.
DBCC results for 'SC983'.
There are 0 rows in 0 pages for object 'SC983'.
DBCC results for '_1SUIDCTL'.
There are 66 rows in 1 pages for object '_1SUIDCTL'.
DBCC results for 'DT5726'.
There are 51572 rows in 269 pages for object 'DT5726'.
DBCC results for 'SC5588'.
There are 0 rows in 0 pages for object 'SC5588'.
DBCC results for 'SC4979'.
There are 633 rows in 8 pages for object 'SC4979'.
DBCC results for 'DH5735'.
There are 0 rows in 0 pages for object 'DH5735'.
DBCC results for 'SC5593'.
There are 69895 rows in 909 pages for object 'SC5593'.
DBCC results for 'SC5291'.
There are 1 rows in 1 pages for object 'SC5291'.
DBCC results for 'DT5735'.
There are 0 rows in 0 pages for object 'DT5735'.
DBCC results for 'SC4604'.
There are 34 rows in 2 pages for object 'SC4604'.
DBCC results for 'SC5298'.
There are 0 rows in 0 pages for object 'SC5298'.
DBCC results for 'DH5742'.
There are 0 rows in 0 pages for object 'DH5742'.
CHECKDB found 0 allocation errors and 14 consistency errors in database 'centr_phouse'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (centr_phouse ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
11 июл 03, 16:27    [259122]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
pkarklin
Member

Откуда: Москва (Муром)
Сообщений: 74925
Что касается ошибки, то вот это думал подойдет. http://support.microsoft.com/default.aspx?scid=kb;en-us;815008

А пока думал ты еще и результат проверки запостил. Если есть бэкап, поднимай его.
11 июл 03, 16:32    [259133]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
Вжик
Member

Откуда: Москва
Сообщений: 676
А частями можно перезаписать плохие блоки ???
Бекап вчерашний, день не хочется терять...
11 июл 03, 16:34    [259138]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
Вжик
Member

Откуда: Москва
Сообщений: 676
Вот и вопрос: можно ли исправить ошибки в текущей побитой базе, имея бекап с нормальными данными ???
11 июл 03, 17:23    [259238]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
pkarklin
Member

Откуда: Москва (Муром)
Сообщений: 74925
Вот и вопрос: можно ли исправить ошибки в текущей побитой базе, имея бекап с нормальными данными ???

Ну если хочешь повозиться, то ради бога. Для начала запусти как тебе велели DBCC CHECKDB с параметром repair_allow_data_loss, чтоб исправить ошибки. Потом поднимай бэкап в другую базу. И запросами перетаскивай нужные тебе данные из одной базы в другую.
11 июл 03, 17:52    [259295]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
Вжик
Member

Откуда: Москва
Сообщений: 676
Хорошо, так и будем делать.
Есть ли еще комментарии ???
11 июл 03, 17:56    [259308]     Ответить | Цитировать Сообщить модератору
 Re: SQL error "Could not continue scan with NOLOCK due to data"  [new]
Crimean
Member

Откуда:
Сообщений: 13148
Надежнее поднять целый вчерашний бэкап и в него натаскать из битого свежие данные. Это может быть достаточно хлопотно, но в плате отсутствия граблей в будующем лучче.
12 июл 03, 13:26    [259682]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить