Deadlock or hang
Oracle 10G r2 + windows server 2003 with sp1，COM+调用无返回。去掉sp1后，问题解决。经ms分析和建议，此问题已经给oracle提过tar了。
Microsoft (R) Windows Debugger Version 6.5.0003.7
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [C:\aaa\Hang_Mode__Date_01-11-2006__Time_15-28-4242\PID-3480__DLLHOST.EXE_Genersoft_BSCW__full_066C_2006-01-11_15-28-48-812_0D98.dmp]
User Mini Dump File with Full Memory: Only application data is available
Comment: 'Full dump in Hang Mode for DLLHOST.EXE_Genersoft_BSCW_running_on_LANG'
Windows Server 2003 Version 3790 (Service Pack 1) UP Free x86 compatible
Product: Server, suite: Enterprise TerminalServer SingleUserTS
Debug session time: Wed Jan 11 15:28:56.000 2006 (GMT+8)
System Uptime: 0 days 0:40:39.176
Process Uptime: 0 days 0:06:22.000
Symbol search path is: srv*c:\symcache*http://msdl.microsoft.com/download/symbols
Executable search path is:
..........................................................................................................................
(d98.a6c): Wake debugger - code 80000007 (!!! second chance !!!)
eax=0007fd08 ebx=00000102 ecx=7694d060 edx=7694d084 esi=00000040 edi=00000000
eip=7c95ed54 esp=0007fcd8 ebp=0007fd48 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246
ntdll!KiFastSystemCallRet:
7c95ed54 c3 ret
Windows Server 2003 Version 3790 (Service Pack 1) UP Free x86 compatible
Product: Server, suite: Enterprise TerminalServer SingleUserTS
Debug session time: Wed Jan 11 15:28:56.000 2006 (GMT+8)
System Uptime: 0 days 0:40:39.176
Process Uptime: 0 days 0:06:22.000
Symbol search path is: srv*c:\symcache*http://msdl.microsoft.com/download/symbols
Executable search path is:
..........................................................................................................................
(d98.a6c): Wake debugger - code 80000007 (!!! second chance !!!)
eax=0007fd08 ebx=00000102 ecx=7694d060 edx=7694d084 esi=00000040 edi=00000000
eip=7c95ed54 esp=0007fcd8 ebp=0007fd48 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246
ntdll!KiFastSystemCallRet:
7c95ed54 c3 ret
0:000> ~11s
eax=00000300 ebx=00000010 ecx=00000000 edx=0000001f esi=000009d0 edi=00000000
eip=7c95ed54 esp=0151d42c ebp=0151d49c iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246
ntdll!KiFastSystemCallRet:
7c95ed54 c3 ret
eax=00000300 ebx=00000010 ecx=00000000 edx=0000001f esi=000009d0 edi=00000000
eip=7c95ed54 esp=0151d42c ebp=0151d49c iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246
ntdll!KiFastSystemCallRet:
7c95ed54 c3 ret
0:011> .reload
..........................................................................................................................
..........................................................................................................................
0:011> kb
ChildEBP RetAddr Args to Child
0151d428 7c952124 7c82baa8 000009d0 00000000 ntdll!KiFastSystemCallRet
0151d42c 7c82baa8 000009d0 00000000 00000000 ntdll!NtWaitForSingleObject+0xc
0151d49c 7c82ba12 000009d0 ffffffff 00000000 kernel32!WaitForSingleObjectEx+0xac
0151d4b0 72280d5b 000009d0 ffffffff 00000000 kernel32!WaitForSingleObject+0x12
0151d4c8 72281191 00000010 00000001 0151d4e8 msdaora!COci7Session::OCI7Call+0x4f
0151d540 7228183a 021d2e98 021d46c0 00000010 msdaora!COci::OCI7Call+0x38
0151d55c 72282e71 021d2e98 021d46c0 021ec840 msdaora!COci::oexec+0x17
0151e590 72274701 021f2528 00000001 021dece0 msdaora!COci7Statement::Execute+0x96
0151e5e8 72278f4a 00000000 722709cc 021f2528 msdaora!CCommand::ExecuteHelper+0x272
0151e64c 4b450835 021dece0 00000000 4b431350 msdaora!CCommand::Execute+0x3cc
0151e68c 4b45c9db 021d0e00 021ed0d4 021d7168 msado15!CConnection::Execute+0x1a5
0151e85c 4b439388 021ef0e0 00000000 021eecb0 msado15!_ExecuteAsync+0x19f
0151e870 4b4390e0 021ef0e0 ffffffff 00000000 msado15!ExecuteAsync+0x23
0151e958 4b439303 00000000 00000000 00000000 msado15!CQuery::Execute+0xa5e
0151e9c4 4b471557 021eecb0 00000000 00000000 msado15!CCommand::_Execute+0x153
0151ea48 4b46c4e1 021e9720 03286ddc 00000000 msado15!CConnection::OpenRecordset+0xdf
0151eb88 01d75b45 001d0e00 03286ddc 01d7c414 msado15!CConnection::Execute+0x35a
0151ebd8 01d776f1 0151ebec 01d77766 0151ec28 DO_SYSPUBC!unitDBOPObj::TDBOperation::ExecBasicSQL [unitDBOPObj.pas line 157]+0x38
0151ec28 01d796be 0151ecac 01d796cb 0151ec50 DO_SYSPUBC!unitDBOPObj::TDBOperation::ExecMainAreaSql [unitDBOPObj.pas line 726]+0xa
0151ec50 774fc169 01d91ad4 0326938c 0011bb1c DO_SYSPUBC!unitDO_SysPubC::TDO_SysPub::ExecMainAreaSql [unitDO_SysPubC.pas line 148]+0xd
ChildEBP RetAddr Args to Child
0151d428 7c952124 7c82baa8 000009d0 00000000 ntdll!KiFastSystemCallRet
0151d42c 7c82baa8 000009d0 00000000 00000000 ntdll!NtWaitForSingleObject+0xc
0151d49c 7c82ba12 000009d0 ffffffff 00000000 kernel32!WaitForSingleObjectEx+0xac
0151d4b0 72280d5b 000009d0 ffffffff 00000000 kernel32!WaitForSingleObject+0x12
0151d4c8 72281191 00000010 00000001 0151d4e8 msdaora!COci7Session::OCI7Call+0x4f
0151d540 7228183a 021d2e98 021d46c0 00000010 msdaora!COci::OCI7Call+0x38
0151d55c 72282e71 021d2e98 021d46c0 021ec840 msdaora!COci::oexec+0x17
0151e590 72274701 021f2528 00000001 021dece0 msdaora!COci7Statement::Execute+0x96
0151e5e8 72278f4a 00000000 722709cc 021f2528 msdaora!CCommand::ExecuteHelper+0x272
0151e64c 4b450835 021dece0 00000000 4b431350 msdaora!CCommand::Execute+0x3cc
0151e68c 4b45c9db 021d0e00 021ed0d4 021d7168 msado15!CConnection::Execute+0x1a5
0151e85c 4b439388 021ef0e0 00000000 021eecb0 msado15!_ExecuteAsync+0x19f
0151e870 4b4390e0 021ef0e0 ffffffff 00000000 msado15!ExecuteAsync+0x23
0151e958 4b439303 00000000 00000000 00000000 msado15!CQuery::Execute+0xa5e
0151e9c4 4b471557 021eecb0 00000000 00000000 msado15!CCommand::_Execute+0x153
0151ea48 4b46c4e1 021e9720 03286ddc 00000000 msado15!CConnection::OpenRecordset+0xdf
0151eb88 01d75b45 001d0e00 03286ddc 01d7c414 msado15!CConnection::Execute+0x35a
0151ebd8 01d776f1 0151ebec 01d77766 0151ec28 DO_SYSPUBC!unitDBOPObj::TDBOperation::ExecBasicSQL [unitDBOPObj.pas line 157]+0x38
0151ec28 01d796be 0151ecac 01d796cb 0151ec50 DO_SYSPUBC!unitDBOPObj::TDBOperation::ExecMainAreaSql [unitDBOPObj.pas line 726]+0xa
0151ec50 774fc169 01d91ad4 0326938c 0011bb1c DO_SYSPUBC!unitDO_SysPubC::TDO_SysPub::ExecMainAreaSql [unitDO_SysPubC.pas line 148]+0xd
0:011> d 0011bb1c l 2000
0011bb1c 44 00 45 00 4c 00 45 00-54 00 45 00 20 00 46 00 D.E.L.E.T.E. .F.
0011bb2c 52 00 4f 00 4d 00 20 00-53 00 59 00 55 00 53 00 R.O.M. .S.Y.U.S.
0011bb3c 54 00 41 00 54 00 45 00-20 00 57 00 48 00 45 00 T.A.T.E. .W.H.E.
0011bb4c 52 00 45 00 20 00 53 00-59 00 55 00 53 00 54 00 R.E. .S.Y.U.S.T.
0011bb5c 41 00 54 00 45 00 5f 00-50 00 52 00 4f 00 43 00 A.T.E._.P.R.O.C.
0011bb6c 49 00 44 00 20 00 3d 00-20 00 27 00 45 00 36 00 I.D. .=. .'.E.6.
0011bb7c 42 00 43 00 34 00 38 00-38 00 35 00 33 00 43 00 B.C.4.8.8.5.3.C.
0011bb8c 31 00 44 00 34 00 37 00-41 00 37 00 42 00 42 00 1.D.4.7.A.7.B.B.
0011bb9c 41 00 46 00 41 00 44 00-39 00 36 00 30 00 43 00 A.F.A.D.9.6.0.C.
0011bbac 39 00 33 00 32 00 45 00-38 00 38 00 27 00 00 00 9.3.2.E.8.8.'...
0011bb1c 44 00 45 00 4c 00 45 00-54 00 45 00 20 00 46 00 D.E.L.E.T.E. .F.
0011bb2c 52 00 4f 00 4d 00 20 00-53 00 59 00 55 00 53 00 R.O.M. .S.Y.U.S.
0011bb3c 54 00 41 00 54 00 45 00-20 00 57 00 48 00 45 00 T.A.T.E. .W.H.E.
0011bb4c 52 00 45 00 20 00 53 00-59 00 55 00 53 00 54 00 R.E. .S.Y.U.S.T.
0011bb5c 41 00 54 00 45 00 5f 00-50 00 52 00 4f 00 43 00 A.T.E._.P.R.O.C.
0011bb6c 49 00 44 00 20 00 3d 00-20 00 27 00 45 00 36 00 I.D. .=. .'.E.6.
0011bb7c 42 00 43 00 34 00 38 00-38 00 35 00 33 00 43 00 B.C.4.8.8.5.3.C.
0011bb8c 31 00 44 00 34 00 37 00-41 00 37 00 42 00 42 00 1.D.4.7.A.7.B.B.
0011bb9c 41 00 46 00 41 00 44 00-39 00 36 00 30 00 43 00 A.F.A.D.9.6.0.C.
0011bbac 39 00 33 00 32 00 45 00-38 00 38 00 27 00 00 00 9.3.2.E.8.8.'...
看到上面的sql了？此时在sqlplus里面执行，会无响应。跑一下这个sql：
select b.owner,b.object_name,l.session_id,l.locked_mode from v$locked_object l, dba_objects b where b.object_id=l.object_id
得到这么个结果：
OBJECT_NAME -------------------------- SESSION_ID LOCKED_MODE ---------- ----------- LC019999 SYUSTATE 153 3 LC019999 SYAUDIT 160 3 OWNER -------------------------- OBJECT_NAME -------------------------- SESSION_ID LOCKED_MODE ---------- ----------- LC019999 SYUSTATE 160 3
exclusive lock，呜。。。
