|
Problem IC61931
|
Status: Closed |
DATA SERVER DRIVER HANGS WHEN EXECUTING A STATEMENT WITH MORE THAN 32767 PARAMETERS |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
Data Server Driver hangs when executing a statement with more
than 32767 parameters
The stacks from the hanging thread look like that:
ChildEBP RetAddr
0012d404 7c826f69 ntdll!KiFastSystemCallRet
0012d408 77e41ed5 ntdll!NtDelayExecution+0xc
0012d470 77e424fd KERNEL32!SleepEx+0x68
0012d480 1033a86a KERNEL32!Sleep+0xf
WARNING: Stack unwind information not available. Following
frames may be wrong.
0012d4e4 10529501 db2app!sqlogstt+0xe37c
0012d4f8 10172d60
db2app!cryptContextSetProcessTerminate+0x15061d
0012d518 102637dd db2app!sqlecrea_api+0x284e
0012d550 10048ac7 db2app!sqloxltc_app+0x81
0012d56c 1008f825 db2app!SQLInitializeADONET+0x3cd
0012d648 79e718cc db2app!SQLFreeStmt+0x6b
0012d65c 79eda643 mscorwks!CallJitEHFinallyHelper+0x28
0012d694 79edecc7 mscorwks!CallJitEHFinally+0x74
0012d6d8 79eda709 mscorwks!EEJitManager::CallJitEHFinally+0x24
0012d7e0 79e8efd7 mscorwks!COMPlusUnwindCallback+0x696
0012d7f4 79e8d7d5 mscorwks!Thread::MakeStackwalkerCallback+0x15
0012d9e4 79e8dc47 mscorwks!Thread::StackWalkFramesEx+0x382
0012dd14 79edc5b4 mscorwks!Thread::StackWalkFrames+0xb8
0012dd34 79edc75b mscorwks!UnwindFrames+0x62
0012ddc4 79edbd4c mscorwks!COMPlusAfterUnwind+0x97
0012dedc 79edc370 mscorwks!CPFH_RealFirstPassHandler+0x51b
0:000> !CLRStack
OS Thread Id: 0x424 (0)
ESP EIP
0012d5e8 7c82860c [NDirectMethodFrameStandalone: 0012d5e8]
IBM.Data.Informix.UnsafeNativeMethods+Ifx32.SQLFreeStmt(IntPtr,
Int16)
0012d5f8 04e1d504
IBM.Data.Informix.IfxDataReader.Dispose(Boolean)
0012d644 04e1d3b5
IBM.Data.Informix.IfxDataReader.System.IDisposable.Dispose()
0012d64c 0430ef5a
IBM.Data.Informix.IfxCommand.ExecuteReaderObject(System.Data.Com
mandBehavior,
System.String, IBM.Data.Informix.IfxCursorType, Boolean,
Boolean, Boolean, Int32, Boolean)
0012f410 0430dd65
IBM.Data.Informix.IfxCommand.ExecuteReaderObject(System.Data.Com
mandBehavior,
System.String)
0012f418 0430dc97 IBM.Data.Informix.IfxCommand.ExecuteScalar()
0012f458 03980248
ConsoleApplication1.Program.Main(System.String[])
0012f69c 79e71b4c [GCFrame: 0012f69c] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* Data Server Driver hangs when executing a statement with *
* more than 32767 parameters *
* *
* The stacks from the hanging thread look like that: *
* *
* ChildEBP RetAddr *
* 0012d404 7c826f69 ntdll!KiFastSystemCallRet *
* 0012d408 77e41ed5 ntdll!NtDelayExecution+0xc *
* 0012d470 77e424fd KERNEL32!SleepEx+0x68 *
* 0012d480 1033a86a KERNEL32!Sleep+0xf *
* WARNING: Stack unwind information not available. Following *
* frames may be wrong. *
* 0012d4e4 10529501 db2app!sqlogstt+0xe37c *
* 0012d4f8 10172d60 *
* db2app!cryptContextSetProcessTerminate+0x15061d *
* 0012d518 102637dd db2app!sqlecrea_api+0x284e *
* 0012d550 10048ac7 db2app!sqloxltc_app+0x81 *
* 0012d56c 1008f825 db2app!SQLInitializeADONET+0x3cd *
* 0012d648 79e718cc db2app!SQLFreeStmt+0x6b *
* 0012d65c 79eda643 mscorwks!CallJitEHFinallyHelper+0x28 *
* 0012d694 79edecc7 mscorwks!CallJitEHFinally+0x74 *
* 0012d6d8 79eda709 *
* mscorwks!EEJitManager::CallJitEHFinally+0x24 *
* 0012d7e0 79e8efd7 mscorwks!COMPlusUnwindCallback+0x696 *
* 0012d7f4 79e8d7d5 *
* mscorwks!Thread::MakeStackwalkerCallback+0x15 *
* 0012d9e4 79e8dc47 mscorwks!Thread::StackWalkFramesEx+0x382 *
* 0012dd14 79edc5b4 mscorwks!Thread::StackWalkFrames+0xb8 *
* 0012dd34 79edc75b mscorwks!UnwindFrames+0x62 *
* 0012ddc4 79edbd4c mscorwks!COMPlusAfterUnwind+0x97 *
* 0012dedc 79edc370 mscorwks!CPFH_RealFirstPassHandler+0x51b *
* *
* 0:000> !CLRStack *
* OS Thread Id: 0x424 (0) *
* ESP EIP *
* 0012d5e8 7c82860c [NDirectMethodFrameStandalone: 0012d5e8] *
* IBM.Data.Informix.UnsafeNativeMethods+Ifx32.SQLFreeStmt(IntPtr
* Int16) *
* 0012d5f8 04e1d504 *
* IBM.Data.Informix.IfxDataReader.Dispose(Boolean) *
* 0012d644 04e1d3b5 *
* IBM.Data.Informix.IfxDataReader.System.IDisposable.Dispose() *
* 0012d64c 0430ef5a *
* IBM.Data.Informix.IfxCommand.ExecuteReaderObject(System.Data.C
* System.String, IBM.Data.Informix.IfxCursorType, Boolean, *
* Boolean, Boolean, Int32, Boolean) *
* 0012f410 0430dd65 *
* IBM.Data.Informix.IfxCommand.ExecuteReaderObject(System.Data.C
* System.String) *
* 0012f418 0430dc97 *
* IBM.Data.Informix.IfxCommand.ExecuteScalar() *
* 0012f458 03980248 *
* ConsoleApplication1.Program.Main(System.String[]) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IBM Data Server Provider for .Net 9.7 Fix Pack 1 *
**************************************************************** |
| Local Fix: |
Limit number of parameters to 32767. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1
This fix should be applied on the client. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.07.2009
05.02.2010
05.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
