Microsoft KB Archive/246031

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

Article ID: 246031

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q246031



BUG #: 56658 (SQLBUG_70)



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.

Keywords: kbbug kbfix KB246031

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.