September 17, 2014 at 10:07 am
I got an error that says to run DBCC CHECKTABLE, but I can't find what table it is. It gives the db id and page Id. I ran DBCC PAGE but I could not figure out what object is using that page. I posted the error and dbcc page results below. Also, Slot 74 is not missing. I could not find m_objId or AllocUnitId in any system tables . Also, I got the same error for this db several other times. When I ran dbcc checkdb I did not get any errors. This is a SQL 2012 db created by SharePoint.
Why is m_nextPage and m_prevPage = (0:0) ?
Does the m_type=3 change how a page is linked?
I found Type 3 – text mix page. A text page that holds small chunks of LOB values plus internal parts of text tree. These can be shared between LOB values in the same partition of an index or heap.
Error2 from log--
Message
The Database ID 7, Page (1:14002), slot 74 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
Message
Error: 7105, Severity: 22, State: 6.
/*------------------------
DBCC PAGE (7, 1,14002,3)
------------------------*/
PAGE: (1:14002)
BUFFER:
BUF @0x000000070AFBD680
bpage = 0x00000004C1DC6000 bhash = 0x0000000000000000 bpageno = (1:14002)
bdbid = 7 breferences = 3 bcputicks = 0
bsampleCount = 0 bUse1 = 32014 bstat = 0x9
blog = 0x15ab215a bnext = 0x0000000000000000
PAGE HEADER:
Page @0x00000004C1DC6000
m_pageId = (1:14002) m_headerVersion = 1 m_type = 3
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2208
m_objId (AllocUnitId.idObj) = 3388
m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594259963904
Metadata: PartitionId = 0
Metadata: IndexId = -1 Metadata: ObjectId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 85
m_freeCnt = 510 m_freeData = 7890 m_reservedCnt = 0
m_lsn = (583:4565:26) m_xactReserved = 0 m_xdesId = (0:1552046)
m_ghostRecCnt = 0 m_tornBits = 1247984281 DB Frag ID = 1
Allocation Status
GAM (1:2) = NOT ALLOCATED SGAM (1:3) = NOT ALLOCATED PFS (1:8088) = 0xb 95_PCT_FULL
DIFF (1:6) = NOT CHANGED ML (1:7) = NOT MIN_LOGGED
September 17, 2014 at 11:28 am
I think this post might help you find the table it belongs to, http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-how-are-allocation-unit-ids-calculated/
One issue is that the page type (m_type = 3) is a "text mix page", which I learned about from this post, http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-page/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2014 at 12:16 pm
I'd suggest you run a full CheckDB. Also review the success/failure of your regular CheckDB jobs, see when they started failing.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply