Error: 7105 issue - SQL Server Forums

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.

All Forums

General SQL Server Forums

Data Corruption Issues

Error: 7105 issue

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-21 : 09:34:17

Andy Chau writes "Dear All,

I have found the below error in my sql log. What is the root cause of this issue and what should I do to prevent it?

2006-07-02 06:27:20.05 spid95 Error: 7105, Severity: 22, State: 6
2006-07-02 06:27:20.05 spid95 Page (1:1180115), slot 1 for text, ntext, or image node does not exist..

Regards,

Andy"

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-23 : 11:28:06

Columns with text, ntext and image data are typically stored 'off-row' - i.e. in different data pages than the rest of the data row. This means that to read the text column, the data row must be read, the pointer to the 'off-row' text data extracted, and then the text data page read to find the text column.

The error you're seeing is because the pointer is not pointing to a valid text column. This can be caused by corruption in the database or, more commonly, using the NOLOCK hint or read-uncommitted isolation level. Are either of the latter the case, to your knowledge? Do you know whether your databases are clean of corruptions?

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Kevin3NF
Starting Member

1 Post

Posted - 2007-04-27 : 16:04:16

For those that found this post via Googling for error 7105 (like I did), removing the NOLOCK hint resolved the issue for us. We also used DBCC Page to find the relevant table. DBCC CheckTable came up clean.

Thanks,

Kevin3NF
www.3nf-inc.com

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2007-04-27 : 16:14:16

Excellent - I'll make this a blog post too.

Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

phillipalbertcox
Starting Member

2 Posts

Posted - 2008-04-15 : 10:56:27

Hey,

Putting both the NOLOCK and Read Uncommitted isolation levels to the side, would transactions reading temporary tables be subject to this type of error? The application (consolidation system) makes heavy usage of temporary tables during the import, processing and final storage of data into the consolidation table.

Thanks

Phillip Cox
MITP - DBAdmin|MCTS - SQL Server 2005|MCP - SQL Server 2000

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-04-15 : 13:16:07

No, shouldn't be.

Paul Randal
SQL Server MVP, Managing Director, SQLskills.com

phillipalbertcox
Starting Member

2 Posts

Posted - 2008-04-16 : 04:43:29

quote:
Originally posted by paulrandal

No, shouldn't be.

Paul Randal
SQL Server MVP, Managing Director, SQLskills.com

Hi Paul,

thanks for update!

Phillip Cox
MITP - DBAdmin|MCTS - SQL Server 2005|MCP - SQL Server 2000

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources