3 Replies Latest reply on Feb 13, 2013 2:08 PM by Jan-Marten Spit

    OCI  Crash and Hang problem


      Our program in the query the database was met with the problem of crash and hang up.
      Please help to check how to solve the problem, thanks very much!

      Oracle server: solaris
      Oracle client: windows server 2008 x64
      Program: x86 32bit

      -----------------------------------Crash Problem-------------------------------------
      Crash problem info:

      Oracle server: 11g
      Client: 11g

      when Insert into DB, crash


      Use '!findthebuild' command to search for the target build information.
      If the build information is available, run '!findthebuild -s ; .reload' to set symbol path and load symbols.

      FAULTING_MODULE: 76f20000 kernel32



      ERROR_CODE: (NTSTATUS) 0xebf00baa - <Unable to get error code text>

      EXCEPTION_CODE: (NTSTATUS) 0xebf00baa - <Unable to get error code text>

      FAULTING_THREAD: 00000dc8



      LAST_CONTROL_TRANSFER: from 05455cb6 to 7596b727

      WARNING: Stack unwind information not available. Following frames may be wrong.
      11d7d114 05455cb6 ebf00baa 00000000 00000000 KERNELBASE!RaiseException+0x58
      11d7d12c 05466bac 11d7d144 0536441b 00000000 OraOCIEI11!sltln+0x304
      11d7d134 0536441b 00000000 0cd702e0 11d7d470 OraOCIEI11!slgtd+0x10cf2
      11d7d144 06c260fc 00000000 00000005 0c9b8b3c OraOCIEI11!kpeDbgCrash+0x85
      11d7d470 05b5a21a 11d89d2c 00000004 11d7df0c OraOCIEI11!sqlprct+0x348fa4
      11d7d490 00214e09 11d89d2c 00000004 11d7df0c OraOCIEI11!OCIAttrGet+0x1c
      11d7dee8 01abab47 11d89d2c 00000004 11d7df0c oci!OCIAttrGet+0x39
      11d7df18 01ad3256 cccccccc 00000001 21031028 DataCentre!std::_Mutex::_Mutex+0x1fccd9
      11d7df2c 01ad3162 21030fb0 21031014 21031018 DataCentre!std::_Mutex::_Mutex+0x2153e8
      11d7df54 01ad2b3d 21030fa0 11d7ecd4 01acaf2f DataCentre!std::_Mutex::_Mutex+0x2152f4
      11d7df60 01acaf2f 9070b6b2 11d7f4bc cccccccc DataCentre!std::_Mutex::_Mutex+0x214ccf
      11d7ecd4 01abf32a 11d7f418 00000003 11d7f150 DataCentre!std::_Mutex::_Mutex+0x20d0c1
      11d7ece8 01af6227 11d7f418 9070aeaa 11d7f5fc DataCentre!std::_Mutex::_Mutex+0x2014bc
      11d7f4cc 018e2ed9 11d7f5b8 9070ac6e 11d7f788 DataCentre!std::_Mutex::_Mutex+0x2383b9
      11d7f608 018e23e3 11d7f760 11d7fc50 11d7f790 DataCentre!std::_Mutex::_Mutex+0x2506b
      11d7f788 01b8672f 9070a606 00000000 11d7fc6c DataCentre!std::_Mutex::_Mutex+0x24575
      11d7fc60 74e52922 0e5e7cb0 00000000 cccccccc DataCentre!std::_Mutex::_Mutex+0x2c88c1
      11d7fc84 7492a293 004b2160 9076a5c1 00000000 omnithread34_vc10_rtd!omni_thread::run_undetached+0x1792
      11d7fcc0 7492a224 0ea7f808 11d7fcd8 76f333ca MSVCR100D!beginthreadex+0x243
      11d7fccc 76f333ca 0ea7f808 11d7fd18 77d79ed2 MSVCR100D!beginthreadex+0x1d4
      11d7fcd8 77d79ed2 0ea7f5c0 45468573 00000000 kernel32!BaseThreadInitThunk+0x12
      11d7fd18 77d79ea5 7492a1a0 0ea7f5c0 ffffffff ntdll!RtlInitializeExceptionChain+0x63
      11d7fd30 00000000 7492a1a0 0ea7f5c0 00000000 ntdll!RtlInitializeExceptionChain+0x36

      05455cb6 ebea jmp OraOCIEI11!sltln+0x2f0 (05455ca2)


      SYMBOL_NAME: OraOCIEI11!sltln+304

      FOLLOWUP_NAME: MachineOwner

      IMAGE_NAME: OraOCIEI11.dll

      STACK_COMMAND: ~35s; .ecxr ; kb


      FAILURE_BUCKET_ID: WRONG_SYMBOLS_ebf00baa_OraOCIEI11.dll!sltln

      WATSON_STAGEONE_URL: http://watson.microsoft.com/StageOne/DataCentre_exe/0_0_0_0/50f7e3f0/KERNELBASE_dll/6_1_7601_17514/4ce7bafa/ebf00baa/0000b727.htm?Retriage=1

      Followup: MachineOwner

      -----------------------------------Hang Problem-------------------------------------

      Hang problem info:

      Oracle server: 9i
      Client: 11g

      when query from DB, hang up


      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\Windows\system32\MSWSOCK.dll -
      ChildEBP RetAddr Args to Child
      0e144324 72e66f0f 000007ec 00000001 0e14434c ntdll!NtWaitForSingleObject+0x15
      WARNING: Stack unwind information not available. Following frames may be wrong.
      0e144364 72e676a6 000007ec 000007f0 00000002 MSWSOCK+0x6f0f
      0e1443e0 76d370fa 000007f0 0e144440 00000001 MSWSOCK+0x76a6
      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\app\admin\product\11.2.0\client_1\bin\orantcp11.dll -
      0e14441c 056a9e27 000007f0 0e144440 00000001 WS2_32!WSARecv+0x7b
      0e144458 056a5e9d 000007f0 086b3516 00000810 orantcp11!nttini+0x1033
      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\app\admin\product\11.2.0\client_1\bin\oran11.dll -
      0e144560 07776c83 0868ca38 086b3516 00000810 orantcp11+0x5e9d
      0e14483c 077772b7 08677688 086777a4 0e144974 oran11!nsbnt+0x8d4f
      0e144858 076d6dd9 08677688 086777a4 0e144974 oran11!nsbrecv+0x43
      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\app\admin\product\11.2.0\client_1\bin\oracommon11.dll -
      0e144978 610bc6dc 0866a154 00000000 0866c22a oran11!nioqrc+0x191
      0e145230 076e6670 0866c218 00000000 086c45f8 oracommon11!ttcdrv+0x472
      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\app\admin\product\11.2.0\client_1\bin\OraClient11.Dll -
      0e145248 61e27ac9 0866a154 00000000 610bc26a oran11!nioqwa+0x30
      0e147574 61e17215 0866a0b0 00000005 0866c0f8 OraClient11!upicui2+0x653
      0e1475b4 61d94cd0 0866a0b0 00000005 0866c0f8 OraClient11!upirtrc+0x57
      0e1475ec 61d45e7d 08669194 00000005 0866c0f8 OraClient11!kpurcsc+0x5a
      0e149950 61d46b28 08673060 086757c8 0e1499dc OraClient11!kpufGetRcvInfo+0xf4b
      0e1499cc 61c560e7 08673060 086757c8 00000000 OraClient11!kpufGetRcvInfo+0x1bf6
      *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\app\admin\product\11.2.0\client_1\bin\OCI.dll -
      0e1499ec 040298e4 08673060 086757c8 00000032 OraClient11!OCIStmtFetch+0x1d
      *** WARNING: Unable to verify checksum for C:\transactive\bin\DataCentre.exe
      0e14a440 0094a512 08673060 086757c8 00000032 OCI!OCIStmtFetch+0x38
      0e14a460 0096298e 00000032 198103a8 00000001 DataCentre!otl_cur::fetch+0x32 [d:\perforce\tcc2_tip\base\cots\otl\otlv4.h @ 27350]
      0e14a478 009627ee 19810358 198103bc 198103c0 DataCentre!otl_sel::first+0x5e [d:\perforce\tcc2_tip\base\cots\otl\otlv4.h @ 28128]

      thank you :)

      Edited by: 983810 on 2013-1-23 下午9:53

      Edited by: lizhe on 2013-1-24 上午2:43