Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| 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 = 0x9bspin = 0 bnext = 0x00000000 PAGE HEADER:------------ Page @0x5DE1C000----------------m_pageId = (6:45330) m_headerVersion = 1 m_type = 2m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x4m_objId = 274100017 m_indexId = 3 m_prevPage = (8:58136)m_nextPage = (6:45331) pminlen = 13 m_slotCnt = 538m_freeCnt = 26 m_freeData = 7103 m_reservedCnt = 0m_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 ALLOCATEDPFS (6:40440) = 0x8 0_PCT_FULL DIFF (6:6) = NOT CHANGEDML (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 StonecipherDeveloper, 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 RandalDev 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 RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
|
|
625 Error