The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Knowledge Base

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

Microsoft KB Archive/246031

Contents