FIX: µ¥ÀÌÅͺ£À̽º »ç¿ëÇÒ ¶§ ¾×¼¼½º À§¹ÝÀÌ DBCC CHECKDB ½Äǰ ÀÖ´Ù

±â¼ú ÀÚ·á: 293292 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
# ¹ö±×: 351941 (SHILOH_BUGS)
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

Çö»ó

DBCC CHECKDB ¸í·ÉÀ» ¾×¼¼½º À§¹Ý (AV) ´Ù¸¥ »ç¿ëÀÚ°¡ Àû±ØÀûÀ¸·Î µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÏ´Â µ¿¾È µ¥ÀÌÅͺ£À̽º¸¦ ½ÇÇàÇÒ ¶§ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÇØ°á ¹æ¹ý

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é SQL Server 2000ÀÇ Ãֽм­ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
290211INF: SQL Server 2000ÀÇ Ãֽм­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý

ÇØ°á °úÁ¤

DBCC CHECKDB Ãà¼ÒµÈ ÀÛ¾÷ ·Îµå ½Ã°£ µ¿¾È ¶Ç´Â ´ÜÀÏ »ç¿ëÀÚ ¸ðµå·Î ½ÇÇàÇϽʽÿÀ.

ÇöÀç »óÅÂ

MicrosoftÀº SQL Server 2000¿¡ ¹®Á¦°¡ ÀÖÀ½À» È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â SQL Server 2000 ¼­ºñ½º ÆÑ 1¿¡¼­ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù.

Ãß°¡ Á¤º¸

¿¬°áÀ» Áß¿¡¼­ ²÷¾îÁø °ÍÀ¸·Î DBCC CHECKDB¸¦ ½ÇÇàÇÏ¿© ÀÖÁö¸¸ ½ÇÇàÇØµµ µ¥ÀÌÅͺ£À̽º¿¡ ¼öÇàµË´Ï´Ù ¾×¼¼½º À§¹ÝÀÌ ¹ß»ýÇÕ´Ï´Ù. ¸í·ÉÀº ¾ÈÀüÇϰÔ, °¡±ÞÀû Ãà¼ÒµÈ ÀÛ¾÷ ºÎÇÏ ÇÑ ¹ø¿¡ ´Ù½Ã ¼ö ÀÖ½À´Ï´Ù.

´ÙÀ½ ½ºÅà ÃßÀûÀ» ¿À·ù ·Î±×¿¡ Àִ ãÀ» ¼ö ÀÖ½À´Ï´Ù:
2001-01-16 13:47:54.86 spid59    SqlDumpExceptionHandler: Process 2624 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
*******************************************************************************
*
* BEGIN STACK DUMP:
*   01/16/01 13:47:54 spid 59
*
*   Exception Address = 008DBAD2 (CheckTables::PageUpdate(class CheckRecInfo &,unsigned char,unsigned char) + 00000092 Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 00000012
* Input Buffer 50 bytes -
*  dbcc checkdb([MSSales])  
*  

Short Stack Dump
008DBAD2 Module(sqlservr+004DBAD2) (CheckTables::PageUpdate(class CheckRecInfo &,unsigned char,unsigned char)+00000092)
008E88B9 Module(sqlservr+004E88B9) (CheckTables::ProcessLogModifyRow(class PageLog const *,class CheckRecInfo &,unsigned char,enum LOGR_UNDO_FLAG)+00000208)
008C91D1 Module(sqlservr+004C91D1) (CheckAggregate::ProcessLog(class LogRec const *,class CheckRecInfo &,enum LOGR_UNDO_FLAG)+000000B6)
008C938E Module(sqlservr+004C938E) (CheckAggregate::ProcessLogRecord(class LogRec const *,class LSN const &,enum LOGR_UNDO_FLAG)+0000009E)
008DB1F3 Module(sqlservr+004DB1F3) (CheckLogReader::ReadLog(int (__cdecl*)(class LogRec const *,class LSN const &,enum LOGR_UNDO_FLAG),class CAutoLatch &)+00000303)
008DB495 Module(sqlservr+004DB495) (CheckLogReader::ScanLog(int (__cdecl*)(class LogRec const *,class LSN const &,enum LOGR_UNDO_FLAG))+000000D6)
008C8EA1 Module(sqlservr+004C8EA1) (CheckAggregate::GetNextFact(void)+000000F2)
008EB20E Module(sqlservr+004EB20E) (CTRowsetInstance::FGetNextRow(void)+00000216)
0091FD06 Module(sqlservr+0051FD06) (CUtRowset::GetNextRows(unsigned long,long,long,unsigned long *,unsigned long * *)+00000050)
0070FAA3 Module(sqlservr+0030FAA3) (CQScanRmtScan::GetRow(unsigned long *,unsigned long *)+00000155)
00719763 Module(sqlservr+00319763) (CQScanXProducer::Open(unsigned long *)+0000039B)
007191AA Module(sqlservr+003191AA) (FnProducerThread(void *)+0000022C)
004DF8D2 Module(sqlservr+000DF8D2) (subproc_main(void *)+000000E3)
410735D0 Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue *)+00000264)
4107382C Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
7800BEA1 Module(MSVCRT+0000BEA1) (_beginthread+0000008B)
77E837CD Module(KERNEL32+000037CD) (_BaseThreadStart@8+00000052)
-------------------------------------------------------------------------------
Dump thread - spid = 59, PSS = 0x4a569228, EC = 0x4a569538
Stack Dump being sent to d:\MSSQL\log\SQL00164.dmp
				

¼Ó¼º

±â¼ú ÀÚ·á: 293292 - ¸¶Áö¸· °ËÅä: 2003³â 11¿ù 6ÀÏ ¸ñ¿äÀÏ - ¼öÁ¤: 3.2
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2000 Standard Edition
Ű¿öµå:?
kbmt kbbug kbfix kbsqlserv2000sp1fix KB293292 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â