This discussion is archived
3 Replies Latest reply: Feb 13, 2013 6:08 AM by Jan-Marten Spit RSS

OCI  Crash and Hang problem

986813 Newbie
Currently Being Moderated
Hi,everyone

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

Stack:

ADDITIONAL_DEBUG_TEXT:
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

DEBUG_FLR_IMAGE_TIMESTAMP: 4ead4afb

MODULE_NAME: OraOCIEI11

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

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

FAULTING_THREAD: 00000dc8

PRIMARY_PROBLEM_CLASS: WRONG_SYMBOLS

BUGCHECK_STR: APPLICATION_FAULT_WRONG_SYMBOLS

LAST_CONTROL_TRANSFER: from 05455cb6 to 7596b727

STACK_TEXT:
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

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

SYMBOL_STACK_INDEX: 1

SYMBOL_NAME: OraOCIEI11!sltln+304

FOLLOWUP_NAME: MachineOwner

IMAGE_NAME: OraOCIEI11.dll

STACK_COMMAND: ~35s; .ecxr ; kb

BUCKET_ID: WRONG_SYMBOLS

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

Stack:

*** 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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points