|
Problem IC74634
|
Status: Closed |
DB2 SERVER CRASHES DURING DEBUGGING OF SQL PROCEDURE WITH ROW DATA TYPE INPUT PARAMETER. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Env:
------
OS: Windows
DB: DB2 V9.7 FP2
IBM Optim Development Studio V2.2.1
Problem Description:
------------------------
DB2 Server crashes during debugging of SQL procedure with ROW
data type input parameter.
When we trying to debug a stored procedure which accepts Row
Data Type as input using the Optim Development Studio. In order
to
debug this procedure we create another test stored procedure
that calls the first with sample data. While debugging the
connection to the db2 is lost and the db2 instance crashes. This
happens when we step into the inner stored procedure and the
SELECT statement is reached.
Stack trace:
--------------------------------------------
<StackTrace>
<![CDATA[
------RBP--------------RIP--------------ARGS--------------------
-------------------------------------
0000000010A11A80 00000000040B57CF 0000000000000000
000000000666C978 0000000000000000 000000000666F160 offset:
000000000000002B in <CDBGVariable::setName> <udbgvarw.C:235>
0000000010A11AE0 00000000040B54D1 000000008D00008D
0000000000000020 0000000000000000 000000000E750000 offset:
0000000000000249 in <CDBGVariable::getElement> <udbgvarw.C:1087>
0000000010A12080 00000000040BB9F9 000000000666C500
0000000003E67E69 0000000000000000 0000000010A12434 offset:
0000000000000135 in <CUdbgVarROW::Report> <udbgvar.C:4873>
0000000010A120C0 00000000040B86DD 0000000010A121F8
000007FEFD27739E 0000000006C950C0 0000000006651490 offset:
0000000000000063 in <CUdbgRoutine::ReportUpdates>
<udbgrtn.C:1732>
0000000010A122A0 00000000040B94FE 0000000000000030
0000000000000004 000007FFFCD5CA60 000007FFFCD5CA60 offset:
0000000000000522 in <CUdbgRoutine::Process> <udbgrtn.C:1203>
0000000010A122F0 00000000040B9C65 000007FFFCD5CA60
00000000040B9E88 0000000000000009 000000000666C500 offset:
0000000000000067 in <CUdbgRoutine::AtLineEvent> <udbgrtn.C:668>
0000000010A12460 00000000040B7015 0000000100000001
0000000000000000 0000000000000000 0000000000000008 offset:
0000000000000061 in <v9_AtLine> <udbgapii.C:829>
0000000010A124A0 00000000040B5225 00000001F93E4758
000007FFFCD5CA60 0000000000000000 0000000003F140F1 offset:
000000000000001B in <dbg_AtLine> <udbgpsmapi.C:226>
0000000010A12500 0000000003F14B49 0000000000000000
0000000000000000 0000000000000000 000000000000000C offset:
0000000000000039 in <pvmDebug::atLine> <psm_pvmdebug.C:370>
0000000010A126D0 0000000003F1396C 000007FFF988ACC0
000007FFF9D0AB20 0000000010A12A50 0000000003F00004 offset:
0000000000000138 in <PVM::event> <psm_pvmdebug.C:631>
0000000010A12900 0000000003F06542 0000000000000000
0000000000000000 0000000000000000 0000000000000000 offset:
0000000000001044 in <PVM::run> <psm_pvm.C:4408>
0000000010A12E60 0000000003F014A3 0000000000000208
0000000006C654A4 0000000000000000 000007FFF98C0080 offset:
0000000000000127 in <pvm_entry> <psm_entrypoints.C:247>
0000000010A14440 000000018005C16F 0000000000000000
00000000000001C3 0000000000000000 0000000010A14EB8 offset:
0000000000000075 in <sqloInvokeFnArgs> <NotFound:-1>
0000000010A14F10 0000000003144DC0 0000000000000000
0000000000369E99 353535343A363831 302E302E3031492C offset:
00000000000021F8 in <sqlriInvokerTrusted> <sqlriudf.C:8243>
0000000010A15570 0000000003140E9A FFFFFFFFFFFFFFFF
0000000007BB1680 000007FFF98BEEE0 0000000000000000 offset:
0000000000000350 in <sqlriInvokeInvoker> <sqlriudf.C:6765>
0000000010A15C40 0000000003140130 000007FFF9895C40
000007FF00000000 000007FF00000001 0000000000000000 offset:
00000000000000E4 in <sqlricall> <sqlriudf.C:1760>
0000000010A15CD0 0000000003171ACD 0000000010A15DC0
0000000000000009 0000000000000000 0000000000000000 offset:
00000000000000F3 in <sqlriSectInvoke> <sqlri_exe.C:911>
0000000010A15E20 0000000002FDB381 0000000000000000
0000000003F14B60 0000000010A15F00 0000000004A6CAC8 offset:
0000000000001AF1 in <sqlrr_process_execute_request>
<sqlrr_sql.C:1519>
0000000010A15F10 0000000002EEA6A6 0000000000000000
0000000000000000 0000000000000000 0000000000000000 offset:
0000000000000118 in <sqlrr_execute> <sqlrr_req_sql.C:831>
0000000010A16060 0000000003F07044 000007FFF988A740
000007FFF9D0AB20 0000000000000003 0000000003F00007 offset:
00000000000002D4 in <pvmPackage::executeSection>
<psm_pvm.C:2194>
0000000010A16290 0000000003F056EF 0000000000000000
0000000000000000 0000000000000000 0000000000000000 offset:
00000000000001F1 in <PVM::run> <psm_pvm.C:4137>
0000000010A167F0 0000000003F014A3 0000000000120000
00000001800567CB 0004000A000107DB 000102F70032000E offset:
0000000000000127 in <pvm_entry> <psm_entrypoints.C:247>
0000000010A17DD0 000000018005C16F 0000000000000000
00000000000001C3 0000000000000000 0000000010A18848 offset:
0000000000000075 in <sqloInvokeFnArgs> <NotFound:-1>
0000000010A188A0 0000000003144DC0 00000000045A0000
0000000000369E99 353535343A363831 302E302E3031492C offset:
00000000000021F8 in <sqlriInvokerTrusted> <sqlriudf.C:8243>
0000000010A18F00 0000000003140E9A 000007FFF9D0AB20
000007FF0000022B 000007FFFCBBEFC0 000007FFFCBBF080 offset:
0000000000000350 in <sqlriInvokeInvoker> <sqlriudf.C:6765>
0000000010A195D0 0000000003140130 000007FFF9893D00
000007FF00000000 000007FF00000001 000007FF00000000 offset:
00000000000000E4 in <sqlricall> <sqlriudf.C:1760>
0000000010A19660 0000000003171ACD 0000000000000008
000007FFF9D0FAAE 0000000000000001 0000000000000000 offset:
00000000000000F3 in <sqlriSectInvoke> <sqlri_exe.C:911>
0000000010A197B0 0000000002FDB381 000007FFF9E80000
0000000000000000 000007FF00000001 000007FF00000000 offset:
0000000000001AF1 in <sqlrr_process_execute_request>
<sqlrr_sql.C:1519>
0000000010A198A0 0000000002EEA6A6 000007FFFE09B548
000007FFFCAB00E0 000007FFF98C4540 000007FFFCD50DC0 offset:
0000000000000118 in <sqlrr_execute> <sqlrr_req_sql.C:831>
0000000010A19A10 000000000210EDE2 000A0001000107DB
0000000000369E99 0000000101E0004B 0000000007B81E0E offset:
00000000000004FA in <sqljs_ddm_excsqlstt> <sqljsexe.C:1393>
0000000010A19C60 00000000020F2DB9 000007FFFE099608
0000000000369E99 000007FFFCD700A2 0000000007B768F8 offset:
0000000000000371 in <sqljsParse> <sqljspar.C:887>
0000000010A19E20 00000000020C7664 000007FFF9D0F7C0
000007FFF9D0F360 0000000000000000 00000000020C718A offset:
000000000000029E in <sqljsSqlam> <sqljsqam.C:2134>
0000000010A19E90 00000000020C72DD 0000000000000000
0000000000369E99 0000000000000000 0000000000000000 offset:
00000000000000A3 in <sqljsDriveRequests> <sqljsqam.C:2916>
0000000010A19F30 00000000020C4BBF 0000000000000000
0000000000000000 0000000000000000 0000000000000000 offset:
00000000000002E1 in <sqljsDrdaAsInnerDriver> <sqljsqam.C:1256>
0000000010A1F850 00000000020C475F 000007FFFE07F790
0000000000000000 0000000000000000 0000000006BB0348 offset:
000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046>
0000000010A1FBB0 0000000001EF633F 0000000010A1FB00
000007FFFCFEE480 000007FFF9A3FD00 0000000000006B0B offset:
0000000000000715 in <sqeAgent::RunEDU> <sqle_agent.C:3964>
0000000010A1FC40 0000000003899195 0000000000000000
0000000010A1FC90 0000000000000000 0000000000000000 offset:
000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35>
0000000010A1FF50 00000001800E29ED 000000000DA0F308
0000000000000000 0000000000000000 0000000000000000 offset:
000000000000042B in <sqloInitEDUServices> <NotFound:-1>
0000000010A1FF80 0000000076E3F56D 0000000000000000
0000000000000000 0000000000000000 0000000000000000
0000000010A1FFD0 0000000076F73281 0000000000000000
0000000000000000 0000000000000000 0000000000000000
]]></StackTrace>
-------------------------------------------- |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 Server crashes during debugging of SQL procedure with *
* ROW data type input parameter. *
* *
* Env: *
* *
* ------ *
* *
* OS: Windows *
* *
* DB: DB2 V9.7 FP2 *
* *
* IBM Optim Development Studio V2.2.1 *
* *
* *
* *
* *
* *
* Problem Description: *
* *
* ------------------------ *
* *
* *
* *
* DB2 Server crashes during debugging of SQL procedure with *
* ROW *
* data type input parameter. *
* *
* *
* *
* When we trying to debug a stored procedure which accepts Row *
* *
* Data Type as input using the Optim Development Studio. In *
* order *
* to *
* *
* debug this procedure we create another test stored procedure *
* *
* that calls the first with sample data. While debugging the *
* *
* connection to the db2 is lost and the db2 instance crashes. *
* This *
* happens when we step into the inner stored procedure and *
* the *
* SELECT statement is reached. *
* *
* *
* *
* *
* *
* Stack trace: *
* *
* *
* *
* -------------------------------------------- *
* *
* <StackTrace> *
* *
* <![CDATA[ *
* *
* ------RBP--------------RIP--------------ARGS------------------
* ------------------------------------- *
* *
* 0000000010A11A80 00000000040B57CF 0000000000000000 *
* *
* 000000000666C978 0000000000000000 000000000666F160 offset: *
* *
* 000000000000002B in <CDBGVariable::setName> <udbgvarw.C:235> *
* *
* 0000000010A11AE0 00000000040B54D1 000000008D00008D *
* *
* 0000000000000020 0000000000000000 000000000E750000 offset: *
* *
* 0000000000000249 in <CDBGVariable::getElement> *
* <udbgvarw.C:1087> *
* 0000000010A12080 00000000040BB9F9 000000000666C500 *
* *
* 0000000003E67E69 0000000000000000 0000000010A12434 offset: *
* *
* 0000000000000135 in <CUdbgVarROW::Report> <udbgvar.C:4873> *
* *
* 0000000010A120C0 00000000040B86DD 0000000010A121F8 *
* *
* 000007FEFD27739E 0000000006C950C0 0000000006651490 offset: *
* *
* 0000000000000063 in <CUdbgRoutine::ReportUpdates> *
* *
* <udbgrtn.C:1732> *
* *
* 0000000010A122A0 00000000040B94FE 0000000000000030 *
* *
* 0000000000000004 000007FFFCD5CA60 000007FFFCD5CA60 offset: *
* *
* 0000000000000522 in <CUdbgRoutine::Process> <udbgrtn.C:1203> *
* *
* 0000000010A122F0 00000000040B9C65 000007FFFCD5CA60 *
* *
* 00000000040B9E88 0000000000000009 000000000666C500 offset: *
* *
* 0000000000000067 in <CUdbgRoutine::AtLineEvent> *
* <udbgrtn.C:668> *
* 0000000010A12460 00000000040B7015 0000000100000001 *
* *
* 0000000000000000 0000000000000000 0000000000000008 offset: *
* *
* 0000000000000061 in <v9_AtLine> <udbgapii.C:829> *
* *
* 0000000010A124A0 00000000040B5225 00000001F93E4758 *
* *
* 000007FFFCD5CA60 0000000000000000 0000000003F140F1 offset: *
* *
* 000000000000001B in <dbg_AtLine> <udbgpsmapi.C:226> *
* *
* 0000000010A12500 0000000003F14B49 0000000000000000 *
* *
* 0000000000000000 0000000000000000 000000000000000C offset: *
* *
* 0000000000000039 in <pvmDebug::atLine> <psm_pvmdebug.C:370> *
* *
* 0000000010A126D0 0000000003F1396C 000007FFF988ACC0 *
* *
* 000007FFF9D0AB20 0000000010A12A50 0000000003F00004 offset: *
* *
* 0000000000000138 in <PVM::event> <psm_pvmdebug.C:631> *
* *
* 0000000010A12900 0000000003F06542 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 offset: *
* *
* 0000000000001044 in <PVM::run> <psm_pvm.C:4408> *
* *
* 0000000010A12E60 0000000003F014A3 0000000000000208 *
* *
* 0000000006C654A4 0000000000000000 000007FFF98C0080 offset: *
* *
* 0000000000000127 in <pvm_entry> <psm_entrypoints.C:247> *
* *
* 0000000010A14440 000000018005C16F 0000000000000000 *
* *
* 00000000000001C3 0000000000000000 0000000010A14EB8 offset: *
* *
* 0000000000000075 in <sqloInvokeFnArgs> <NotFound:-1> *
* *
* 0000000010A14F10 0000000003144DC0 0000000000000000 *
* *
* 0000000000369E99 353535343A363831 302E302E3031492C offset: *
* *
* 00000000000021F8 in <sqlriInvokerTrusted> <sqlriudf.C:8243> *
* *
* 0000000010A15570 0000000003140E9A FFFFFFFFFFFFFFFF *
* *
* 0000000007BB1680 000007FFF98BEEE0 0000000000000000 offset: *
* *
* 0000000000000350 in <sqlriInvokeInvoker> <sqlriudf.C:6765> *
* *
* 0000000010A15C40 0000000003140130 000007FFF9895C40 *
* *
* 000007FF00000000 000007FF00000001 0000000000000000 offset: *
* *
* 00000000000000E4 in <sqlricall> <sqlriudf.C:1760> *
* *
* 0000000010A15CD0 0000000003171ACD 0000000010A15DC0 *
* *
* 0000000000000009 0000000000000000 0000000000000000 offset: *
* *
* 00000000000000F3 in <sqlriSectInvoke> <sqlri_exe.C:911> *
* *
* 0000000010A15E20 0000000002FDB381 0000000000000000 *
* *
* 0000000003F14B60 0000000010A15F00 0000000004A6CAC8 offset: *
* *
* 0000000000001AF1 in <sqlrr_process_execute_request> *
* *
* <sqlrr_sql.C:1519> *
* *
* 0000000010A15F10 0000000002EEA6A6 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 offset: *
* *
* 0000000000000118 in <sqlrr_execute> <sqlrr_req_sql.C:831> *
* *
* 0000000010A16060 0000000003F07044 000007FFF988A740 *
* *
* 000007FFF9D0AB20 0000000000000003 0000000003F00007 offset: *
* *
* 00000000000002D4 in <pvmPackage::executeSection> *
* *
* <psm_pvm.C:2194> *
* *
* 0000000010A16290 0000000003F056EF 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 offset: *
* *
* 00000000000001F1 in <PVM::run> <psm_pvm.C:4137> *
* *
* 0000000010A167F0 0000000003F014A3 0000000000120000 *
* *
* 00000001800567CB 0004000A000107DB 000102F70032000E offset: *
* *
* 0000000000000127 in <pvm_entry> <psm_entrypoints.C:247> *
* *
* 0000000010A17DD0 000000018005C16F 0000000000000000 *
* *
* 00000000000001C3 0000000000000000 0000000010A18848 offset: *
* *
* 0000000000000075 in <sqloInvokeFnArgs> <NotFound:-1> *
* *
* 0000000010A188A0 0000000003144DC0 00000000045A0000 *
* *
* 0000000000369E99 353535343A363831 302E302E3031492C offset: *
* *
* 00000000000021F8 in <sqlriInvokerTrusted> <sqlriudf.C:8243> *
* *
* 0000000010A18F00 0000000003140E9A 000007FFF9D0AB20 *
* *
* 000007FF0000022B 000007FFFCBBEFC0 000007FFFCBBF080 offset: *
* *
* 0000000000000350 in <sqlriInvokeInvoker> <sqlriudf.C:6765> *
* *
* 0000000010A195D0 0000000003140130 000007FFF9893D00 *
* *
* 000007FF00000000 000007FF00000001 000007FF00000000 offset: *
* *
* 00000000000000E4 in <sqlricall> <sqlriudf.C:1760> *
* *
* 0000000010A19660 0000000003171ACD 0000000000000008 *
* *
* 000007FFF9D0FAAE 0000000000000001 0000000000000000 offset: *
* *
* 00000000000000F3 in <sqlriSectInvoke> <sqlri_exe.C:911> *
* *
* 0000000010A197B0 0000000002FDB381 000007FFF9E80000 *
* *
* 0000000000000000 000007FF00000001 000007FF00000000 offset: *
* *
* 0000000000001AF1 in <sqlrr_process_execute_request> *
* *
* <sqlrr_sql.C:1519> *
* *
* 0000000010A198A0 0000000002EEA6A6 000007FFFE09B548 *
* *
* 000007FFFCAB00E0 000007FFF98C4540 000007FFFCD50DC0 offset: *
* *
* 0000000000000118 in <sqlrr_execute> <sqlrr_req_sql.C:831> *
* *
* 0000000010A19A10 000000000210EDE2 000A0001000107DB *
* *
* 0000000000369E99 0000000101E0004B 0000000007B81E0E offset: *
* *
* 00000000000004FA in <sqljs_ddm_excsqlstt> <sqljsexe.C:1393> *
* *
* 0000000010A19C60 00000000020F2DB9 000007FFFE099608 *
* *
* 0000000000369E99 000007FFFCD700A2 0000000007B768F8 offset: *
* *
* 0000000000000371 in <sqljsParse> <sqljspar.C:887> *
* *
* 0000000010A19E20 00000000020C7664 000007FFF9D0F7C0 *
* *
* 000007FFF9D0F360 0000000000000000 00000000020C718A offset: *
* *
* 000000000000029E in <sqljsSqlam> <sqljsqam.C:2134> *
* *
* 0000000010A19E90 00000000020C72DD 0000000000000000 *
* *
* 0000000000369E99 0000000000000000 0000000000000000 offset: *
* *
* 00000000000000A3 in <sqljsDriveRequests> <sqljsqam.C:2916> *
* *
* 0000000010A19F30 00000000020C4BBF 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 offset: *
* *
* 00000000000002E1 in <sqljsDrdaAsInnerDriver> *
* <sqljsqam.C:1256> *
* 0000000010A1F850 00000000020C475F 000007FFFE07F790 *
* *
* 0000000000000000 0000000000000000 0000000006BB0348 offset: *
* *
* 000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046> *
* *
* 0000000010A1FBB0 0000000001EF633F 0000000010A1FB00 *
* *
* 000007FFFCFEE480 000007FFF9A3FD00 0000000000006B0B offset: *
* *
* 0000000000000715 in <sqeAgent::RunEDU> <sqle_agent.C:3964> *
* *
* 0000000010A1FC40 0000000003899195 0000000000000000 *
* *
* 0000000010A1FC90 0000000000000000 0000000000000000 offset: *
* *
* 000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35> *
* *
* 0000000010A1FF50 00000001800E29ED 000000000DA0F308 *
* *
* 0000000000000000 0000000000000000 0000000000000000 offset: *
* *
* 000000000000042B in <sqloInitEDUServices> <NotFound:-1> *
* *
* 0000000010A1FF80 0000000076E3F56D 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 *
* *
* 0000000010A1FFD0 0000000076F73281 0000000000000000 *
* *
* 0000000000000000 0000000000000000 0000000000000000 *
* *
* ]]></StackTrace> *
* *
* -------------------------------------------- *
****************************************************************
* RECOMMENDATION: *
* Move to the the latest fixpack *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2011
07.10.2011
07.10.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
