FIX: Queries Using Linked Servers May Cause Access Violation and CPU Spin

Article translations Article translations
Article ID: 246031 - View products that this article applies to.
This article was previously published under Q246031
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56658 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

An access violation (AV) or CPU spin may occur when executing a query multiple times against two linked servers that use full text indexes. Query Analyzer may return the following error:
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server Connection Broken.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

MORE INFORMATION

If a CPU spin occurs, the SQL service cannot be stopped and must be killed or the server rebooted. The SQL Server errorlog may contain the following short stack dump:
0x00402af8 Module(sqlservr+2af8) (getdes+7b)
0x00402d5f Module(sqlservr+2d5f) (opentabid+19b)
0x00412bb8 Module(sqlservr+12bb8) (RowsetSS::Init+fe)
0x00412f0c Module(sqlservr+12f0c) (RowsetSS::WakeUp+2d)
0x00412edb Module(sqlservr+12edb) (RowsetDormant::WakeUp+12)
0x00412ec0 Module(sqlservr+12ec0) (CQScanRowset::WakeUp+63)
0x00423f65 Module(sqlservr+23f65) (CQScanRowset::Open+25)
0x00473428 Module(sqlservr+73428) (CQScanTableScan::Open+e)
0x00423ee3 Module(sqlservr+23ee3) (CQScan::Open+1c)
0x00654d60 Module(sqlservr+254d60) (CQScanConcat::Open+e)
0x0047e0fc Module(sqlservr+7e0fc) (CQScanSort::FillSortTable+16)
0x0047dfc5 Module(sqlservr+7dfc5) (CQScanSort::Open+63)
0x0065879f Module(sqlservr+25879f) (CQScanMergeJoin::Open+21)
0x0047e0fc Module(sqlservr+7e0fc) (CQScanSort::FillSortTable+16)
0x0047dfc5 Module(sqlservr+7dfc5) (CQScanSort::Open+63)
0x00414bbf Module(sqlservr+14bbf) (CQueryScan::Startup+a3)
0x0041286f Module(sqlservr+1286f) (CStmtQuery::FExecuteQuery+28e)
0x0041c1d0 Module(sqlservr+1c1d0) (CStmtSelect::XretExecute+19c)
0x00411c32 Module(sqlservr+11c32) (CMsqlExecContext::ExecuteStmts+11b)
0x004116eb Module(sqlservr+116eb) (CMsqlExecContext::Execute+16b)
1999-10-04 18:23:37.63 spid7    CImageHelper::GetSym Error - The specified module could not be found.
				

Properties

Article ID: 246031 - Last Review: October 22, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB246031

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com