Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Could not continue scan with NOLOCK due to data movement. Expand / Collapse
Author
Message
Posted Monday, March 24, 2008 11:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
This is crazy ... I'm getting this error on a database that has zero activity to it, when attempting to do an updatestats with fullscan. Thus far everything I've read about relating to this error is due to using a NOLOCK hint, which I am not ...

Do I simply need add a read uncommitted into my procedure?

Any thoughts?


---
SQLSlayer
Making SQL do what we want it to do.

Post #473623
Posted Monday, March 24, 2008 12:29 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
Is your SQL Server running on VMWare?
Post #473635
Posted Monday, March 24, 2008 12:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
No, I'm testing locally against my own machine ...

---
SQLSlayer
Making SQL do what we want it to do.

Post #473637
Posted Monday, March 24, 2008 12:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
just stick to only rebuilding indexes as part of maintenance and no need to run update statistics

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #473644
Posted Monday, March 24, 2008 12:40 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Could you enter the error text in a post? The title is getting cut-off halfway through for me.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #473645
Posted Monday, March 24, 2008 12:52 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
rbarryyoung (3/24/2008)
Could you enter the error text in a post? The title is getting cut-off halfway through for me.


Msg 601, Level 12, State 3, Line 1
Could not continue scan with NOLOCK due to data movement.


---
SQLSlayer
Making SQL do what we want it to do.

Post #473652
Posted Monday, March 24, 2008 12:52 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
SQL Noob (3/24/2008)
just stick to only rebuilding indexes as part of maintenance and no need to run update statistics


And just forget about any non-index statistics? No thanks.


---
SQLSlayer
Making SQL do what we want it to do.

Post #473653
Posted Monday, March 24, 2008 1:02 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
check for corruption?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #473661
Posted Monday, March 24, 2008 1:04 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
ah ha, that was it ... good call.

Msg 8928, Level 16, State 1, Line 1
Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data): Page (1:17819) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data), page (1:17819). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8928, Level 16, State 1, Line 1
Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data): Page (1:17851) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1419152101, index ID 5, partition ID 72057594157858816, alloc unit ID 72057594172669952 (type In-row data), page (1:17851). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.

Rebuilt my indexes and all is well.

Thanks


---
SQLSlayer
Making SQL do what we want it to do.

Post #473665
Posted Thursday, June 25, 2009 2:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 11:54 AM
Points: 13, Visits: 424
Why do you ask if the server is VMWare? I am asking because we experienced the same error on a SQL 2005 box on an ESX server. Please let me know and thanks!
Post #742170
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse