You are currently offline, waiting for your internet to reconnect

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

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)
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.
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.
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.				

Article ID: 246031 - Last Review: 10/22/2013 02:31:16 - Revision: 2.1

Microsoft SQL Server 7.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix KB246031