Page (1:3321432), slot 6 for text, ntext, or image node does not exist.

Question

Page (1:3321432), slot 6 for text, ntext, or image node does not exist.

Christopher L Hanawalt

SSC Enthusiast

Points: 123
More actions
March 28, 2005 at 12:12 pm

#88450

Running a DBCC Checkdb resulted in the following error on a table:
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:3321432), slot 6 for text, ntext, or image node does not exist.
I have a client database that seemed to have corrupt data in a certain table. I was able to pinpoint (got REAL lucky in finding it!) the record which was causing the problem, so I created a new table (exact copy of the old...then recreated the constraints, and indexes and reassigned the dependencies) and DTS copied the all but this record to the new table. All was fine (no errors upon DBCC checkdb) for about 12-24 hours. The next day it resurfaced on more records in this same table. Problem seems to be on a specific column with data type of text, 16, nullable.
I found previous posting by Journeyman points to http://support.microsoft.com/default.aspx?scid=kb;en-us;320434, (and that's the closet thing I can find related to this) I'm not sure this is exactly the same issue, but this article suggests that SP2 fixes this...problem is my client is running SP3 (or SP3a) (confirmed this by SELECT @@VERSION, results: 2000.8.00.760), so my thoughts are this isn't fixed in SP2 or I'm experiencing a new bug in SQL Server.
I see there is a Service Pack 4 beta but can't really use my client's database as a beta test site, unless I pull the 40GB database to a different server but the thing is I don't know this will fix it either.
Any ideas, anyone?
Thanks,
Chris

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

"This problem occurs if you are running SQL Server 2000 with an affinity mask that is set to use a multiple of seven processors. "

from MS http://support.microsoft.com/?kbid=890755

Shamless self promotion - read my blog http://sirsql.net

Christopher L Hanawalt SSC Enthusiast Points: 123 More actions · Answer 2

Nicholas,

That's definitely good to know and I didn't (thanks) but problem with that is that the affinity mask is for this SQL Server is 2, there are only 2 CPUs on the server. I verified this in EM (Processors lists only 2) and sp_configure returns 0 for both run_value and config_value.

I was really hoping this was the problem. Thanks for your input. There must be something else causing this...Hmmm.

Thanks,

Chris

athurgar SSCrazy Points: 2816 More actions · Answer 3

What is the row size for this table? Are you using text in row or text pointers?

Christopher L Hanawalt SSC Enthusiast Points: 123 More actions · Answer 4

Not sure I understand. Do you mean, "How large is the table?" ? It has 339,518+ rows.

I don't know how to answer your next question. If you could tell me how to find this out I'd really appreciate it. I'll also see if my development group can answer this. Just so you know, I'm in Support at the "front-line" so my knowledge is limited. I hope to increase my knowledge with conversions like this.

Thanks.

Joshua Smith Grasshopper Points: 17 More actions · Answer 5

I am having the exact same problem, but tried to get the update from MS, but that is nearly impossible. I even tried getting the SP4 beta, but that program has expired.

What about reloading SQL?