Select the product you need help with
FIX: Àá±Ý ¸ð´ÏÅÍ ¿¹¿Ü°¡ DeadlockMonitor::ResolveDeadlock±â¼ú ÀÚ·á: 821741 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. # ¹ö±×: 469704 (SHILOH_BUGS) ÀÌ ÆäÀÌÁö¿¡¼Çö»óSQL Server ´ÙÀ½ ½ºÅà ÃßÀûÀÌ ±â·ÏµÉ ¼ö ÀÖ½À´Ï´Ù ¿À·ù ·Î±× ¹× SQL Server ÇÁ·Î¼¼½º°¡ ÀÀ´äÀ» ÁßÁö ¶Ç´Â ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù: * Short Stack Dump * 00845549 Module(sqlservr+00445549) (DeadlockMonitor::ResolveDeadlock+00000025 Line 583+00000006) * 00845438 Module(sqlservr+00445438) (DeadlockMonitor::SearchAndResolve+00000134 Line 424+00000000) * 004C2D12 Module(sqlservr+000C2D12) (lockMonitor+000002F7 Line 6600+00000000) * 004C2BBC Module(sqlservr+000C2BBC) (lockMonitorThread+000000A4 Line 6414+00000005) * 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272 Line 451+00000000) * 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098 Line 263+00000007) * 77C37E53 Module(MSVCRT+00027E53) (endthread+000000AA) * 77E7D33B Module(kernel32+0001D33B) (RegisterWaitForInputIdle+00000043) ÇØ°á ¹æ¹ý¼ºñ½º ÆÑ Á¤º¸ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼ È®ÀÎÇϽʽÿÀ:290211
(http://support.microsoft.com/kb/290211/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý ÇÖÇȽº Á¤º¸ÀÌ ¼öÁ¤ÀÇ ¿µ¾î ¹öÀüÀº ÆÄÀÏ Æ¯¼ºÀ» °¡Áý´Ï´Ù (¶Ç´Â ÀÌ»ó) ´ÙÀ½ Ç¥¿¡. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ.Date Time Version Size File name ------------------------------------------------------------------ 31-May-2003 18:45 2000.80.818.0 78,400 Console.exe 25-Jun-2003 01:01 2000.80.818.0 33,340 Dbmslpcn.dll 25-Apr-2003 02:12 786,432 Distmdl.ldf 25-Apr-2003 02:12 2,359,296 Distmdl.mdf 30-Jan-2003 01:55 180 Drop_repl_hotfix.sql 23-Jun-2003 22:40 2000.80.837.0 1,557,052 Dtsui.dll 23-Jun-2003 22:40 2000.80.837.0 639,552 Dtswiz.dll 24-Apr-2003 02:51 747,927 Instdist.sql 03-May-2003 01:56 1,581 Inst_repl_hotfix.sql 08-Feb-2003 06:40 2000.80.765.0 90,692 Msgprox.dll 01-Apr-2003 02:07 1,873 Odsole.sql 05-Apr-2003 01:46 2000.80.800.0 62,024 Odsole70.dll 07-May-2003 20:41 2000.80.819.0 25,144 Opends60.dll 02-Apr-2003 21:48 2000.80.796.0 57,904 Osql.exe 02-Apr-2003 23:15 2000.80.797.0 279,104 Pfutil80.dll 22-May-2003 22:57 19,195 Qfe469571.sql 12-Jun-2003 16:37 1,083,989 Replmerg.sql 04-Apr-2003 21:53 2000.80.798.0 221,768 Replprov.dll 08-Feb-2003 06:40 2000.80.765.0 307,784 Replrec.dll 05-May-2003 00:05 1,085,874 Replsys.sql 01-Jun-2003 01:01 2000.80.818.0 492,096 Semobj.dll 31-May-2003 18:27 2000.80.818.0 172,032 Semobj.rll 29-May-2003 00:29 115,944 Sp3_serv_uni.sql 01-Jun-2003 01:01 2000.80.818.0 4,215,360 Sqldmo.dll 07-Apr-2003 17:44 25,172 Sqldumper.exe 19-Mar-2003 18:20 2000.80.789.0 28,672 Sqlevn70.rll 02-Jul-2003 00:18 2000.80.834.0 180,736 Sqlmap70.dll 08-Feb-2003 06:40 2000.80.765.0 57,920 Sqlrepss.dll 23-Jun-2003 22:40 2000.80.837.0 7,553,105 Sqlservr.exe 08-Feb-2003 06:40 2000.80.765.0 45,644 Sqlvdi.dll 25-Jun-2003 01:01 2000.80.818.0 33,340 Ssmslpcn.dll 01-Jun-2003 01:01 2000.80.818.0 82,492 Ssnetlib.dll 01-Jun-2003 01:01 2000.80.818.0 25,148 Ssnmpn70.dll 01-Jun-2003 01:01 2000.80.818.0 158,240 Svrnetcn.dll 31-May-2003 18:59 2000.80.818.0 76,416 Svrnetcn.exe 30-Apr-2003 23:52 2000.80.816.0 45,132 Ums.dll 02-Jul-2003 00:19 2000.80.834.0 98,816 Xpweb70.dll ÇöÀç »óÅÂMicrosoft ¹®Á¦´Â ÀÌ ¹®¼ÀÇ ½ÃÀÛ ºÎºÐ¿¡ ³ª¿ÇÑ Á¦Ç°¿¡¼ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼ºñ½º ÆÑ 4¿¡¼ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. Ãß°¡ Á¤º¸°¡´ÉÇÑ °æ¿ì ±³Âø »óÅ°¡ ¹®Á¦ÀÇ ¿øÀÎÀ» Á¦°ÅÇÑ ´ÙÀ½ Transact-SQL ±â¹Ý ±³Âø »óÅ ¿ì¼± ¼øÀ§ Á¶Á¤À» »ç¿ëÇÏÁö ¸¶½Ê½Ã¿À. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL "deadlock_priority ¼³Á¤" Ç׸ñ¿¡¼ Server ¿Â¶óÀÎ. ÀÌ ¹®Á¦°¡ ¹ß»ýÇϸé SQL Server ÇÁ·Î¼¼½º°¡ ¿¹±âÄ¡ ¾ÊÀº »óÅ·Π³²¾Æ ÀÖ½À´Ï´Ù ¹× ¾Ê´Â ¿øÇß½À´Ï´Ù µ¿ÀÛÀÌ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®Á¦°¡ ¹ß»ýÇÑ ÈÄ¿¡ SQL Server ÇÁ·Î¼¼½º°¡ ´Ù½Ã ½ÃÀÛÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¼Ó¼º±â¼ú ÀÚ·á: 821741 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 10.3 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
±â°è ¹ø¿ªµÈ ¹®¼ Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù. |
À§·Î °¡±â
