January 21, 2010 at 8:36 pm
SQL Sever 2005 Enterprise Editon:
I Meet Below question In Transactional Replication :
The Database ID 5, Page (1:29848), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page
According To Transaction sequence number:0x0003601200019517001600000000, Command ID: 19 ,
After Run sp_browsereplcmds, Get Error Command Line:
{CALL [sp_MSupd_dbotbl_tableName] (,,,,,1,,,,0,,4378,0x2002)}
There is a nvarchar(max) Field in Table, Run dbcc checktable, No Errors.
Run dbcc page(εΊε,1,29848,3) with tableresults, Results:
----------------------------------------------------------
BUFFER:BUF @0x03CB6074bpage0x3351A000
BUFFER:BUF @0x03CB6074bhash0x00000000
BUFFER:BUF @0x03CB6074bpageno(1:14964)
BUFFER:BUF @0x03CB6074bdbid11
BUFFER:BUF @0x03CB6074breferences0
BUFFER:BUF @0x03CB6074bUse112872
BUFFER:BUF @0x03CB6074bstat0x7c00009
BUFFER:BUF @0x03CB6074blog0x12212159
BUFFER:BUF @0x03CB6074bnext0x00000000
PAGE HEADER:Page @0x3351A000m_pageId(1:14964)
PAGE HEADER:Page @0x3351A000m_headerVersion1
PAGE HEADER:Page @0x3351A000m_type3
PAGE HEADER:Page @0x3351A000m_typeFlagBits0x0
PAGE HEADER:Page @0x3351A000m_level0
PAGE HEADER:Page @0x3351A000m_flagBits0x2208
PAGE HEADER:Page @0x3351A000m_objId (AllocUnitId.idObj)685
PAGE HEADER:Page @0x3351A000m_indexId (AllocUnitId.idInd)256
PAGE HEADER:Page @0x3351A000Metadata: AllocUnitId72057594082820096
PAGE HEADER:Page @0x3351A000Metadata: PartitionId72057594087342080
PAGE HEADER:Page @0x3351A000Metadata: IndexId1
PAGE HEADER:Page @0x3351A000Metadata: ObjectId212911830
PAGE HEADER:Page @0x3351A000m_prevPage(0:0)
PAGE HEADER:Page @0x3351A000m_nextPage(0:0)
PAGE HEADER:Page @0x3351A000pminlen0
PAGE HEADER:Page @0x3351A000m_slotCnt1
PAGE HEADER:Page @0x3351A000m_freeCnt152
PAGE HEADER:Page @0x3351A000m_freeData8038
PAGE HEADER:Page @0x3351A000m_reservedCnt0
PAGE HEADER:Page @0x3351A000m_lsn(20075:694:23)
PAGE HEADER:Page @0x3351A000m_xactReserved0
PAGE HEADER:Page @0x3351A000m_xdesId(0:87137743)
PAGE HEADER:Page @0x3351A000m_ghostRecCnt0
PAGE HEADER:Page @0x3351A000m_tornBits-2069038748
PAGE HEADER:Allocation StatusGAM (1:2)ALLOCATED
PAGE HEADER:Allocation StatusSGAM (1:3)NOT ALLOCATED
PAGE HEADER:Allocation StatusPFS (1:8088)0x44 ALLOCATED 100_PCT_FULL
PAGE HEADER:Allocation StatusDIFF (1:6)CHANGED
PAGE HEADER:Allocation StatusML (1:7)NOT MIN_LOGGED
----------------------------------------------------------
Blob row at: Page (1:14964) Slot 0 Length: 7942 Type: 3 (DATA)
Blob Id:358547456
74AAC06E: 0050003c 0026003e 0062006e 00700073 <.P.>.&.n.b.s.p.
74AAC07E: 003c003b 0050002f 000d003e 003c000a ;.<./.P.>.....<.
74AAC08E: 003e0050 006e0026 00730062 003b0070 P.>.&.n.b.s.p.;.
74AAC09E: 006e0026 00730062 003b0070 006e0026 &.n.b.s.p.;.&.n.
74AAC0AE: 00730062 003b0070 006e0026 00730062 b.s.p.;.&.n.b.s.
74AAC0BE: 003b0070 006e0026 00730062 003b0070 p.;.&.n.b.s.p.;.
74AAC0CE: 006e0026 00730062 003b0070 006e0026 &.n.b.s.p.;.&.n.
74AAC0DE: 00730062 003b0070 006e0026 00730062 b.s.p.;.&.n.b.s.
74AAC0EE: 003b0070 006e0026 00730062 003b0070 p.;.&.n.b.s.p.;.
I could not Find problem cause, please Everyone Help Analysize, Thanks.
January 22, 2010 at 1:25 pm
Did you run the DBCC command the message asked you to do?
DBCC CHECKDB (Database Name) WITH NO_INFOMSGS, ALL_ERRORMSGS
Also I hope you have Backups of this database when this error was not showing.
-Roy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply