Feil #: 204382 (Innholdsvedlikehold) VSTS:2325034
Symptomer
Når du spør kolonnedata BLOBen (BLOB) i Microsoft SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 eller SQL Server-2014, kan du få følgende feilmelding:
Feil: 5180 kan ikke åpne filen kontroll Bank (FCB) for ugyldig fil-ID 0 i databasen 'tempdb'. Kontrollere filplasseringen. Utføre DBCC CHECKDB.
Årsak
Dette problemet oppstår fordi SQL Server ikke håndterer meldingen oppmerksomhet (Avbryt) på riktig måte når det leser BLOB-data. Dette problemet oppstår bare når internt i minnet BLOB-hurtigbufferen er deaktivert. Når bufferen er deaktivert, bytter hurtigbufferdata til databasen tempdb. Etter at SQL Server, leser du BLOB-data fra databasen tempdb i stedet for hurtigbufferen i minnet. Avhenger på BLOB størrelse eller server minne betingelse, interne i minnet BLOB-hurtigbufferen er deaktivert.
Oppløsning
Problemet ble først løst i den følgende kumulative oppdateringen av SQL Server.
Samleoppdatering 2 for SQL Server 2012 SP2/en-us/help/2983175
Kumulativ oppdatering 11 for SQL Server 2012 SP1/en-us/help/2975396
Kumulativ oppdatering 13 for SQL Server 2008 R2 SP2/en-us/help/2967540
Samleoppdatering 2 for SQLServer-2014/en-us/help/2967546
Kumulativ oppdatering 17 for SQL Server 2008 SP3/en-us/help/2958696
Hver nye kumulative oppdateringen for SQL Server inneholder alle hurtigreparasjonene og alle sikkerhetsreparasjoner som fulgte med den forrige kumulative oppdateringen. Sjekk ut de nyeste kumulative oppdateringene for SQL Server:
Hvis du vil ha mer informasjon
KallstakkChild-SP RetAddr Call Site00000000`11b3c878 00000000`0223f807 sqlservr!FileMgr::RaiseBadFileId [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\manager\filemgr.cpp @ 14152]
00000000`11b3c880 00000000`03255b50 sqlservr!FileMgr::GetFCB+0xd7 [e:\sql10_katmai_t\sql\ntdbms\storeng\include\filemgr.h @ 1304]
00000000`11b3c8d0 00000000`034698ff sqlservr!RecoveryUnit::GetFCB+0x30 [e:\sql10_katmai_t\sql\ntdbms\storeng\include\recoveryunit.inl @ 506]
00000000`11b3c900 00000000`03463799 sqlservr!BPool::GetFromDisk+0x4f [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\manager\buffer.cpp @ 10558]
00000000`11b3ca40 00000000`03292d9d sqlservr!BPool::Get+0x209 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\manager\buffer.cpp @ 7764]
00000000`11b3caf0 00000000`032a5315 sqlservr!PageRef::Fix+0x14d [e:\sql10_katmai_t\sql\ntdbms\storeng\include\pageref.inl @ 70]
00000000`11b3cb80 00000000`032ae6d7 sqlservr!FixPageNoCheck+0x95 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\datasetp.h @ 5565]
00000000`11b3cbd0 00000000`0329c7ee sqlservr!FixPage+0x77 [e:\sql10_katmai_t\sql\ntdbms\storeng\include\dataset.inl @ 1569]
00000000`11b3cc10 00000000`0329be6e sqlservr!BTreeMgr::HandleRoot+0x25e [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\btreemgr.inl @ 119]
00000000`11b3cc90 00000000`032a1f62 sqlservr!BTreeMgr::Seek+0x46e [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\btreemgr.cpp @ 2773]
00000000`11b3cdd0 00000000`032e3af1 sqlservr!BTreeMgr::GetHPageIdWithKey+0x182 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\btreemgr.cpp @ 5334]
00000000`11b3ce30 00000000`0339270b sqlservr!IndexPageManager::GetPageWithKey+0x211 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\datasetpagemgr.cpp @ 318]
00000000`11b3cf10 00000000`0334d9b0 sqlservr!GetRowForKeyValue+0x1fb [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\indexrowscanner.cpp @ 4156]
00000000`11b3d530 00000000`0334e3b3 sqlservr!IndexDataSetSession::GetRowByKeyValue+0x360 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\indexdataset.cpp @ 3411]
00000000`11b3d650 00000000`032b9cbd sqlservr!IndexDataSetSession::FetchRowByKeyValueInternal+0x573 [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\indexdataset.cpp @ 3657]
00000000`11b3d7a0 00000000`03382cb6 sqlservr!DatasetSession::FetchRowByKeyValueNoLock+0x5d [e:\sql10_katmai_t\sql\ntdbms\storeng\dfs\access\dataset.cpp @ 2711]
00000000`11b3d7f0 00000000`035cb44e sqlservr!DatasetSession::FetchRowByKeyValue+0x6d6 [e:\sql10_katmai_t\sql\ntdbms\storeng\include\dataset.inl @ 410]
00000000`11b3d980 00000000`03bbff8f sqlservr!RowsetNewSS::FetchRowByKeyValue+0xfe [e:\sql10_katmai_t\sql\ntdbms\storeng\drs\oledb\rowset.h @ 982]
00000000`11b3d9e0 00000000`03bc14ce sqlservr!LobStorageProvider::GetLobValueForRead+0xaf [e:\sql10_katmai_t\sql\ntdbms\storeng\drs\oledb\lobss.cpp @ 617]
00000000`11b3dad0 00000000`02989de6 sqlservr!LobStorageProviderSession::GetLobValueForUpdate+0xbe [e:\sql10_katmai_t\sql\ntdbms\storeng\drs\oledb\lobss.cpp @ 1096]
00000000`11b3db30 00000000`02989b80 sqlservr!CBlobHandleFactoryMain::PilbGetILockBytesInternal+0x256 [e:\sql10_katmai_t\sql\ntdbms\query\qeexec\tmpilb.cpp @ 1840]
00000000`11b3dbf0 00000000`0298c282 sqlservr!CBlobHandleFactoryMain::PilbGetILockBytes+0x20 [e:\sql10_katmai_t\sql\ntdbms\query\qeexec\tmpilb.cpp @ 1786]
00000000`11b3dc20 00000000`01dad815 sqlservr!CBlobHandleMain::PilbGetILockBytes+0xc2 [e:\sql10_katmai_t\sql\ntdbms\query\qeexec\tmpilb.cpp @ 2540]
00000000`11b3dc70 00000000`01d982fe sqlservr!`anonymous namespace'::TSendRowClassNoCount<6,0>::TSendUnlimitedVartype<0>+0x205 [e:\sql10_katmai_t\sql\ntdbms\msql\ods
\tdsimpl.cpp @ 734]
00000000`11b3dda0 00000000`01d8970f sqlservr!`anonymous namespace'::TSendRowClass<6,0,0>::TSendXVar<0>+0x69e [e:\sql10_katmai_t\sql\ntdbms\msql\ods\tdsimpl.cpp @ 1848]
00000000`11b3de50 00000000`01d87053 sqlservr!`anonymous namespace'::TSendRowHelper<6,0>::TSendRowNBC+0x7af [e:\sql10_katmai_t\sql\ntdbms\msql\ods\tdsimpl.cpp @ 2121]
00000000`11b3df20 00000000`01cc82f5 sqlservr!CKatmaiTds::SendRowImpl+0x53 [e:\sql10_katmai_t\sql\ntdbms\msql\ods\tdsimpl.cpp @ 5688]
00000000`11b3df50 00000000`01d88196 sqlservr!CConnectionOutput::SendRow+0x135 [e:\sql10_katmai_t\sql\ntdbms\msql\ods\connout.cpp @ 173]
00000000`11b3df90 00000000`01828378 sqlservr!CValOdsRow::SetDataX+0x86 [e:\sql10_katmai_t\sql\ntdbms\msql\ods\tdsimpl.cpp @ 6705]
00000000`11b3dfe0 00000000`01727caa sqlservr!SetMultData+0x128 [e:\sql10_katmai_t\sql\ntdbms\msql\expr\fndatamv.cpp @ 418]
00000000`11b3e040 00000000`00bd5fc6 sqlservr!CEs::GeneralEval+0x56a [e:\sql10_katmai_t\sql\ntdbms\msql\expr\es.cpp @ 513]
00000000`11b3e350 00000000`020601ce sqlservr!CEs::Eval+0xc6 [e:\sql10_katmai_t\sql\ntdbms\include\es.h @ 935]
00000000`11b3e390 00000000`02064d1d sqlservr!CXStmtQuery::ErsqExecuteQuery+0xb4e [e:\sql10_katmai_t\sql\ntdbms\msql\proc\xstmtquery.cpp @ 416]
00000000`11b3e730 00000000`020651c4 sqlservr!CXStmtSelect::XretDoExecute+0x72d [e:\sql10_katmai_t\sql\ntdbms\msql\proc\xstmtquery.cpp @ 1880]
00000000`11b3e8a0 00000000`01f2a50c sqlservr!CXStmtSelect::XretExecute+0x64 [e:\sql10_katmai_t\sql\ntdbms\msql\proc\xstmtquery.cpp @ 1914]
00000000`11b3e8e0 00000000`01f2a0aa sqlservr!CExecStmtLoopVars::ExecuteXStmtAndSetXretReturn+0x3c [e:\sql10_katmai_t\sql\ntdbms\msql\proc\execntxt.cpp @ 2279]
00000000`11b3e920 00000000`01f1bc13 sqlservr!CMsqlExecContext::ExecuteStmts<1,1>+0x2aa [e:\sql10_katmai_t\sql\ntdbms\msql\proc\execntxt.cpp @ 2961]
00000000`11b3eaa0 00000000`01fae3f0 sqlservr!CMsqlExecContext::FExecute+0x1023 [e:\sql10_katmai_t\sql\ntdbms\msql\proc\execntxt.cpp @ 1563]
00000000`11b3ed00 00000000`01cd75cb sqlservr!CSQLSource::Execute+0x1090 [e:\sql10_katmai_t\sql\ntdbms\msql\proc\sqlsrc.cpp @ 3873]
00000000`11b3eef0 00000000`01cd8b54 sqlservr!process_request+0x6cb [e:\sql10_katmai_t\sql\ntdbms\msql\ods\c_events.cpp @ 1925]
00000000`11b3f2a0 00000000`03d0b13b sqlservr!process_commands+0x3c4 [e:\sql10_katmai_t\sql\ntdbms\msql\ods\c_events.cpp @ 2493]
00000000`11b3f420 00000000`03d00c65 sqlservr!SOS_Task::Param::Execute+0x16b [e:\sql10_katmai_t\sql\common\dk\sos\include\sos.inl @ 10472]
00000000`11b3f520 00000000`03d00a27 sqlservr!SOS_Scheduler::RunTask+0x1a5 [e:\sql10_katmai_t\sql\common\dk\sos\src\scheduler.cpp @ 873]
00000000`11b3f5a0 00000000`03cdd9d2 sqlservr!SOS_Scheduler::ProcessTasks+0x2e7 [e:\sql10_katmai_t\sql\common\dk\sos\src\scheduler.cpp @ 768]
00000000`11b3f610 00000000`03ce3edb sqlservr!SchedulerManager::WorkerEntryPoint+0x2a2 [e:\sql10_katmai_t\sql\common\dk\sos\src\node.cpp @ 1730]
00000000`11b3f700 00000000`03cdb15b sqlservr!SystemThread::RunWorker+0x18b [e:\sql10_katmai_t\sql\common\dk\sos\include\worker.inl @ 895]
00000000`11b3f770 00000000`03cddfef sqlservr!SystemThreadDispatcher::ProcessWorker+0x4ab [e:\sql10_katmai_t\sql\common\dk\sos\src\node.cpp @ 391]
00000000`11b3f840 00000000`740137d7 sqlservr!SchedulerManager::ThreadEntryPoint+0x14f [e:\sql10_katmai_t\sql\common\dk\sos\src\node.cpp @ 1928]
00000000`11b3f930 00000000`74013894 MSVCR80!_callthreadstartex+0x17 [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c @ 348]
00000000`11b3f960 00000000`76b8bd1d MSVCR80!_threadstartex+0x84 [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c @ 326]
00000000`11b3f990 00000000`76d965a1 kernel32!BaseThreadInitThunk+0xd [d:\vistasp2_ldr\base\win32\client\thread.c @ 66]
00000000`11b3f9c0 00000000`00000000 ntdll!RtlUserThreadStart+0x1d [d:\vistasp2_ldr\base\ntos\rtl\rtlexec.c @ 2742]
Status
Microsoft har bekreftet at dette er et problem i Microsoft-produktene som er oppført i delen "Gjelder for".
Author: lyi
Tekstforfatter: v-juwang
Teknisk redaktør: keiikoga; hozhan; lyi
Redaktør: v-emy
