hi everyone:
I am a new guy to oracle, and I use the cx_oracle to connect oracle database, when I fetch data with multiprocessing (for one single table), appcrash was happen occasionally.
more information:
python version:
Python 2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:24:40) [MSC v.1500 64 bit (AMD64)] on win32
packages:
cx-Freeze==4.3.4
cx-Oracle==5.2.1
pywin32==220
oracle instatclient:
instantclient-basic-windows.x64-11.2.0.4.0
windbg output:
Microsoft (R) Windows Debugger Version 6.12.0002.633 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [D:\dump\bdpsync-noah.exe.5384.dmp]
User Mini Dump File with Full Memory: Only application data is available
Symbol search path is: SRV*D:\Symbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows 7 Version 7601 (Service Pack 1) MP (12 procs) Free x64
Product: Server, suite: Enterprise TerminalServer SingleUserTS
Machine Name:
Debug session time: Thu Nov 17 06:10:30.000 2016 (UTC + 8:00)
System Uptime: 44 days 16:12:32.852
Process Uptime: 0 days 6:26:38.000
................................................................
...........................................
Loading unloaded module list
................................................................
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(1508.151c): Unknown exception - code ebf00baa (first/second chance not available)
KERNELBASE!RaiseException+0x39:
000007fe`fdd5a49d 4881c4c8000000 add rsp,0C8h
0:001> !analyze -v
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
*** ERROR: Symbol file could not be found. Defaulted to export symbols for oci.dll -
*** WARNING: Unable to verify checksum for cx_Oracle.pyd
*** ERROR: Symbol file could not be found. Defaulted to export symbols for cx_Oracle.pyd -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for python27.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for user32.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for QtCore4.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for QtGui4.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for PyQt4.QtGui.pyd -
*** ERROR: Module load completed but symbols could not be loaded for bdpsync-noah.exe
*** ERROR: Symbol file could not be found. Defaulted to export symbols for _ssl.pyd -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for select.pyd -
FAULTING_IP:
KERNELBASE!RaiseException+39
000007fe`fdd5a49d 4881c4c8000000 add rsp,0C8h
EXCEPTION_RECORD: 0000000002b48690 -- (.exr 0x2b48690)
ExceptionAddress: 000007fefdd5a49d (KERNELBASE!RaiseException+0x0000000000000039)
ExceptionCode: ebf00baa
ExceptionFlags: 00000000
NumberParameters: 0
DEFAULT_BUCKET_ID: APPLICATION_FAULT
PROCESS_NAME: bdpsync-noah.exe
ERROR_CODE: (NTSTATUS) 0xebf00baa - <Unable to get error code text>
EXCEPTION_CODE: (NTSTATUS) 0xebf00baa - <Unable to get error code text>
MOD_LIST: <ANALYSIS/>
NTGLOBALFLAG: 0
APPLICATION_VERIFIER_FLAGS: 0
CONTEXT: 0000000002b48060 -- (.cxr 0x2b48060)
rax=0000000091d21f9f rbx=0000000000000000 rcx=0000000002b48060
rdx=0000000000000000 rsi=0000000013c82000 rdi=0000000000000005
rip=000007fefdd5a49d rsp=0000000002b48670 rbp=0000000000000001
r8=0000000000000000 r9=0000000000000000 r10=0000000000000000
r11=0000000000000246 r12=0000000055e37fa0 r13=0000000010ccf278
r14=0000000000000005 r15=0000000000000000
iopl=0 nv up ei pl nz na po nc
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00000206
KERNELBASE!RaiseException+0x39:
000007fe`fdd5a49d 4881c4c8000000 add rsp,0C8h
Resetting default scope
ADDITIONAL_DEBUG_TEXT: Followup set based on attribute [Is_ChosenCrashFollowupThread] from Frame:[0] on thread:[PSEUDO_THREAD]
LAST_CONTROL_TRANSFER: from 000000000905be34 to 000007fefdd5a49d
FAULTING_THREAD: ffffffffffffffff
PRIMARY_PROBLEM_CLASS: APPLICATION_FAULT
BUGCHECK_STR: APPLICATION_FAULT_APPLICATION_FAULT
STACK_TEXT:
00000000`02b48670 000007fe`fdd5a49d kernelbase!RaiseException+0x39
00000000`02b48740 00000000`0905be34 oraociei11!sltln+0x524
00000000`02b48770 00000000`0907da03 oraociei11!slgtd+0x217b9
00000000`02b487a0 00000000`08ed5412 oraociei11!kpeDbgCrash+0xa8
00000000`02b487f0 00000000`08c765cb oraociei11!upicui2+0xd65
00000000`02b4b350 00000000`09c53de5 oraociei11!upirtr+0xad
00000000`02b4b3c0 00000000`09d30878 oraociei11!kpurcsc+0x96
00000000`02b4b430 00000000`09c4d08b oraociei11!kpugc+0x1dc93
00000000`02b4e070 00000000`09c4ee4f oraociei11!kpugc+0x1fa57
00000000`02b4e170 00000000`09ad1769 oraociei11!OCIStmtFetch+0x1b
00000000`02b4e1b0 00000000`08834809 oci!OCIStmtFetch+0x91
00000000`02b4e210 00000000`0592e3e5 cx_oracle+0xe3e5
00000000`02b4e260 00000000`0592e63f cx_oracle+0xe63f
00000000`02b4e290 00000000`6e83be19 python27!PyEval_GetFuncDesc+0x1d9
00000000`02b4e2f0 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4e400 00000000`6e83c1c8 python27!PyEval_GetFuncDesc+0x588
00000000`02b4e470 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4e4d0 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4e5e0 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4e690 00000000`6e83c239 python27!PyEval_GetFuncDesc+0x5f9
00000000`02b4e700 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4e760 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4e870 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4e920 00000000`6e83c239 python27!PyEval_GetFuncDesc+0x5f9
00000000`02b4e990 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4e9f0 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4eb00 00000000`6e83c1c8 python27!PyEval_GetFuncDesc+0x588
00000000`02b4eb70 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4ebd0 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4ece0 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4ed90 00000000`6e7c52f8 python27!PyFunction_SetClosure+0xbd8
00000000`02b4ee10 00000000`6e791293 python27!PyObject_Call+0x83
00000000`02b4ee40 00000000`6e83bb91 python27!PyEval_CallObjectWithKeywords+0x141
00000000`02b4ee70 00000000`6e8313b7 python27!PyAST_FromNode+0x9077
00000000`02b4ef60 00000000`6e7d7179 python27!PyCFunction_Call+0x69
00000000`02b4ef90 00000000`6e83c928 python27!PyEval_GetFuncDesc+0xce8
00000000`02b4eff0 00000000`6e8395c3 python27!PyEval_EvalFrameEx+0x3ac3
00000000`02b4f100 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4f1b0 00000000`6e7c52f8 python27!PyFunction_SetClosure+0xbd8
00000000`02b4f230 00000000`6e791293 python27!PyObject_Call+0x83
00000000`02b4f260 00000000`6e83c93b python27!PyEval_GetFuncDesc+0xcfb
00000000`02b4f2c0 00000000`6e8395c3 python27!PyEval_EvalFrameEx+0x3ac3
00000000`02b4f3d0 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4f480 00000000`6e7c52f8 python27!PyFunction_SetClosure+0xbd8
00000000`02b4f500 00000000`6e791293 python27!PyObject_Call+0x83
00000000`02b4f530 00000000`6e83c93b python27!PyEval_GetFuncDesc+0xcfb
00000000`02b4f590 00000000`6e8395c3 python27!PyEval_EvalFrameEx+0x3ac3
00000000`02b4f6a0 00000000`6e83c1c8 python27!PyEval_GetFuncDesc+0x588
00000000`02b4f710 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4f770 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4f880 00000000`6e83c1c8 python27!PyEval_GetFuncDesc+0x588
00000000`02b4f8f0 00000000`6e83c07f python27!PyEval_GetFuncDesc+0x43f
00000000`02b4f950 00000000`6e8394eb python27!PyEval_EvalFrameEx+0x39eb
00000000`02b4fa60 00000000`6e83aa61 python27!PyEval_EvalCodeEx+0x911
00000000`02b4fb10 00000000`6e7c52f8 python27!PyFunction_SetClosure+0xbd8
00000000`02b4fb90 00000000`6e791293 python27!PyObject_Call+0x83
00000000`02b4fbc0 00000000`6e7a5a79 python27!PyMethod_New+0xb19
00000000`02b4fe40 00000000`6e791293 python27!PyObject_Call+0x83
00000000`02b4fe70 00000000`6e83bb91 python27!PyEval_CallObjectWithKeywords+0x141
00000000`02b4fea0 00000000`6e75c76e python27!PyOS_AfterFork+0x419e
00000000`02b4fed0 00000000`6e87ee05 python27!PyThread_init_thread+0x1f5
00000000`02b4ff00 00000000`75752fdf msvcr90!endthreadex+0x47
00000000`02b4ff30 00000000`75753080 msvcr90!endthreadex+0xe8
00000000`02b4ff60 00000000`77b2652d kernel32!BaseThreadInitThunk+0xd
00000000`02b4ff90 00000000`77c5c521 ntdll!RtlUserThreadStart+0x1d
STACK_COMMAND: .cxr 0000000002B48060 ; kb ; dt ntdll!LdrpLastDllInitializer BaseDllName ; dt ntdll!LdrpFailureData ; dds 2b48670 ; kb
FOLLOWUP_IP:
KERNELBASE!RaiseException+0
000007fe`fdd5a460 4881ecc8000000 sub rsp,0C8h
SYMBOL_NAME: kernelbase!RaiseException+0
FOLLOWUP_NAME: MachineOwner
MODULE_NAME: KERNELBASE
IMAGE_NAME: KERNELBASE.dll
DEBUG_FLR_IMAGE_TIMESTAMP: 4ce7c78c
FAILURE_BUCKET_ID: APPLICATION_FAULT_ebf00baa_KERNELBASE.dll!RaiseException
BUCKET_ID: X64_APPLICATION_FAULT_APPLICATION_FAULT_kernelbase!RaiseException+0
Followup: MachineOwner
---------
thanks