| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2005-09-26 : 21:13:20
|
Hi guys,
have an issue here, got an 625 error when I try to run a script, I already follows the MS method via putting the option (hash join), but its still failing, (sql 2k + sp4) and it said it was fixed in sp4, oh well....any ideas?
no error return from dbcc checkdb, and dbcc page return the following:
PAGE: (6:45330)
---------------
BUFFER:
-------
BUF @0x01395580
---------------
bpage = 0x5DE1C000 bhash = 0x00000000 bpageno = (6:45330)
bdbid = 6 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x5DE1C000
----------------
m_pageId = (6:45330) m_headerVersion = 1 m_type = 2
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x4
m_objId = 274100017 m_indexId = 3 m_prevPage = (8:58136)
m_nextPage = (6:45331) pminlen = 13 m_slotCnt = 538
m_freeCnt = 26 m_freeData = 7103 m_reservedCnt = 0
m_lsn = (14672:2528:5) m_xactReserved = 0 m_xdesId = (0:34723148)
m_ghostRecCnt = 538 m_tornBits = 0
Allocation Status
-----------------
GAM (6:2) = NOT ALLOCATED SGAM (6:3) = NOT ALLOCATED
PFS (6:40440) = 0x8 0_PCT_FULL DIFF (6:6) = NOT CHANGED
ML (6:7) = NOT MIN_LOGGED
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
any ideas?
Thanks
|
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-09-27 : 13:21:13
|
What's the exact contents of the error message, along with the state? It's critical to know that information so that we can interpret the point where the error was raised, and the slot number that the 625 is complaining about. Which bug are you referring to that was supposedly fixed by SP4?
----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
|
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-09-29 : 04:30:20
|
I found out what actually happened, it was linking to another DB table and that have some issue with the index, once I did a dbreindex, everything is fine. I guess my next question is how to really read from that dbcc page output? as that object id it referring to is not the object I had corruption, is there a way to read it?
|
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-09-29 : 16:38:52
|
What are you info are you trying to get from the DBCC PAGE output? I'm confused why you're confused - the output looks perfectly normal to me.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-10-02 : 21:55:10
|
Hi,
I'm just confused, as i read this line:
m_objId = 274100017 m_indexId = 3 m_prevPage = (8:58136)
I though that the object using that page is 274100017, and that is the object that have issue, but looks like its not, where the object having issue was on the other database, I though that the page info will show me the error object id in that page so I can go to that object and see the error, is that true?
|
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-10-03 : 14:18:08
|
Can you post the 625 error please? I suspect you're issuing DBCC PAGE in the wrong database but I don't have enough data to go on.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
625 Error