|
Problem IC69690
|
Status: Closed |
CRASHED INVOLVING NESTED FUNCTION CALLS AND PL/SQL CODE IN SQLRIINVOKERTRUSTED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Signal 11 can occuring with nested function calls that include
pl/sql code.
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000056F10E0
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0xA4
0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4
0x0900000004D05EB4 sqlriInvokeInvoker__FP10sqlri_ufobb@glueFD8 +
0x78
0x090000000506CFEC
sqlri_close_udf_ufob_cleanup__FP10sqlri_ufobP5sqlcaP8sqlrr_cb +
0x30C
0x09000000054949E8
sqlri_close_udf_eos__FP25sqlra_sql_context_siblingiP8sqlrr_cb +
0x13C
0x0900000005493F8C sqlricls_simple__FP8sqlrr_cbil + 0x634
0x09000000054943DC
@148@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_siblin
giN63
+ 0xEC
0x090000000808C244 sqlrr_process_close_request__FP8sqlrr_cbiN32
+ 0x8DC
0x09000000054F0EA8
sqlrr_close__FP14db2UCinterfaceP15db2UCCursorInfo + 0x3F0
0x0900000008404DC0
csmDriveClose__FP14db2UCinterfaceP9db2UC_CCBUlT3 + 0x108
0x09000000069AFAC4
csmCursorBlaster__FP14db2UCinterfaceUiT2PUiN22 + 0x784
0x09000000083E9CC8 run__3PVMFv + 0x5F4
0x09000000083E7F30 pvm_entry + 0x460
0x09000000054F3E44 sqloInvokeFnArgs + 0xBC
0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78
0x090000000587FA94
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0x1D0
0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4
0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264
0x0900000005475548 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x588
0x090000000548C19C sqlrr_process_execute_request__FP8sqlrr_cbi +
0xC7C
0x090000000548C414 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x1C4
0x0900000008400B98 executeSection__10pvmPackageFP5sqlcaUi +
0x7DC
0x09000000083EB23C executeQuery__3PVMFUi + 0xE0
0x09000000083EA3BC run__3PVMFv + 0xCE8
0x09000000083E7F30 pvm_entry + 0x460
0x09000000054F3E44 sqloInvokeFnArgs + 0xBC
0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78
0x090000000587FA94
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0x1D0
0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4
0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264
0x0900000005475548 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x588
0x09000000054CAC50
sqlrr_process_fetch_request__FP14db2UCinterface + 0x1E8
0x09000000052E6CFC
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x110
0x09000000054B94C8
sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0xBE8
0x09000000054BA53C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x98
0x09000000054BA32C
.sqljsParse.fdpr.clone.624__FP13sqljsDrdaAsCbP14db2UCinterface +
0x330
0x09000000054B6F48 @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x3CC
0x090000000566C128
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x090000000566BF70
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2B0
0x090000000566B604 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0xFC
0x090000000560EA10 RunEDU__8sqeAgentFv + 0x80
0x0900000005615AA0 EDUDriver__9sqzEDUObjFv + 0xE4
0x0900000005609474 sqloEDUEntry + 0x264
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All v97 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Signal 11 can occuring with nested function calls that *
* include *
* pl/sql code. *
* *
* *
* *
* <StackTrace> *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x09000000056F10E0 *
* *
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + *
* 0xA4 *
* *
* 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + *
* 0x6E4 *
* 0x0900000004D05EB4 *
* sqlriInvokeInvoker__FP10sqlri_ufobb@glueFD8 + *
* 0x78 *
* *
* 0x090000000506CFEC *
* *
* sqlri_close_udf_ufob_cleanup__FP10sqlri_ufobP5sqlcaP8sqlrr_cb
* + *
* 0x30C *
* *
* 0x09000000054949E8 *
* *
* sqlri_close_udf_eos__FP25sqlra_sql_context_siblingiP8sqlrr_cb
* + *
* 0x13C *
* *
* 0x0900000005493F8C sqlricls_simple__FP8sqlrr_cbil + 0x634 *
* *
* 0x09000000054943DC *
* *
* @148@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibl
* *
* giN63 *
* *
* + 0xEC *
* *
* 0x090000000808C244 *
* sqlrr_process_close_request__FP8sqlrr_cbiN32 *
* + 0x8DC *
* *
* 0x09000000054F0EA8 *
* *
* sqlrr_close__FP14db2UCinterfaceP15db2UCCursorInfo + 0x3F0 *
* *
* 0x0900000008404DC0 *
* *
* csmDriveClose__FP14db2UCinterfaceP9db2UC_CCBUlT3 + 0x108 *
* *
* 0x09000000069AFAC4 *
* *
* csmCursorBlaster__FP14db2UCinterfaceUiT2PUiN22 + 0x784 *
* *
* 0x09000000083E9CC8 run__3PVMFv + 0x5F4 *
* *
* 0x09000000083E7F30 pvm_entry + 0x460 *
* *
* 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC *
* *
* 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 *
* *
* 0x090000000587FA94 *
* *
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + *
* 0x1D0 *
* *
* 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + *
* 0x6E4 *
* 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 *
* *
* 0x0900000005475548 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + *
* 0x588 *
* *
* 0x090000000548C19C *
* sqlrr_process_execute_request__FP8sqlrr_cbi + *
* 0xC7C *
* *
* 0x090000000548C414 *
* sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo *
* + 0x1C4 *
* *
* 0x0900000008400B98 executeSection__10pvmPackageFP5sqlcaUi + *
* *
* 0x7DC *
* *
* 0x09000000083EB23C executeQuery__3PVMFUi + 0xE0 *
* *
* 0x09000000083EA3BC run__3PVMFv + 0xCE8 *
* *
* 0x09000000083E7F30 pvm_entry + 0x460 *
* *
* 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC *
* *
* 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 *
* *
* 0x090000000587FA94 *
* *
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + *
* 0x1D0 *
* *
* 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + *
* 0x6E4 *
* 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 *
* *
* 0x0900000005475548 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + *
* 0x588 *
* *
* 0x09000000054CAC50 *
* *
* sqlrr_process_fetch_request__FP14db2UCinterface + 0x1E8 *
* *
* 0x09000000052E6CFC *
* *
* sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x110 *
* *
* 0x09000000054B94C8 *
* *
* sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0xBE8 *
* *
* 0x09000000054BA53C *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* *
* interface *
* *
* + 0x98 *
* *
* 0x09000000054BA32C *
* *
* .sqljsParse.fdpr.clone.624__FP13sqljsDrdaAsCbP14db2UCinterface
* + *
* 0x330 *
* *
* 0x09000000054B6F48 *
* @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + 0x3CC *
* *
* 0x090000000566C128 *
* *
* @64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 *
* *
* 0x090000000566BF70 *
* *
* @64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2B0 *
* *
* 0x090000000566B604 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + *
* 0xFC *
* *
* 0x090000000560EA10 RunEDU__8sqeAgentFv + 0x80 *
* *
* 0x0900000005615AA0 EDUDriver__9sqzEDUObjFv + 0xE4 *
* *
* 0x0900000005609474 sqloEDUEntry + 0x264 *
* *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 |
|
| Workaround |
n/a |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69695
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.07.2010
28.09.2010
28.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
