|
Problem IC76697
|
Status: Closed |
DB2 instance maybe crash with signal 11 when array is taken as an input of the SQL SP and intra_parallel is enabled. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The instance could be crashed (signal 11) with the following
callstack when array is taken as an input of the SQL SP and
intra_parallel is enabled.
Here's a sample of the stack dump:
destroy__20sqlriArrayDescriptorFv@AF439_78 + 0xC
destroy__20sqlriArrayDescriptorFv@glue104F + 0x74
sqlricls_complex__FP8sqlrr_cbilN23 + 0x1358
@87@sqlricls__FP8sqlrr_cbiN32 + 0x64
sqlriecc__FP8sqlrr_cbilT3 + 0x1058
sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi + 0x4AC
sqlrr_process_execute_request__FP8sqlrr_cbi + 0x948
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xFC
executeSection__10pvmPackageFP5sqlcaUib + 0x8D8
executeQuery__3PVMFUib + 0x1B0
run__3PVMFv + 0x9FC
pvm_entry + 0x31C
sqloInvokeFnArgs + 0xB0
sqloInvokeFnArgs@glue64C + 0x74
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf
+0x1154
sqlriInvokeInvoker__FP10sqlri_ufob + 0x848
sqlricall__FP8sqlrr_cb + 0x7C
sqlriAggressiveValidateOp__FP8sqlrr_cb + 0x108
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x6C8
sqlrr_process_execute_request__FP8sqlrr_cbi - 0x258
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x240
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x968
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
- 0x48
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
@63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8
RunEDU__8sqeAgentFv + 0x11C
EDUDriver__9sqzEDUObjFv + 0x78
sqloEDUEntry + 0x57C |
| Problem Summary: |
The instance could be crashed (signal 11) with the following
callstack when array is taken as an input of the SQL SP and
intra_parallel is enabled.
Here's a sample of the stack dump:
destroy__20sqlriArrayDescriptorFv@AF439_78 + 0xC
destroy__20sqlriArrayDescriptorFv@glue104F + 0x74
sqlricls_complex__FP8sqlrr_cbilN23 + 0x1358
@87@sqlricls__FP8sqlrr_cbiN32 + 0x64
sqlriecc__FP8sqlrr_cbilT3 + 0x1058
sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi + 0x4AC
sqlrr_process_execute_request__FP8sqlrr_cbi + 0x948
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xFC
executeSection__10pvmPackageFP5sqlcaUib + 0x8D8
executeQuery__3PVMFUib + 0x1B0
run__3PVMFv + 0x9FC
pvm_entry + 0x31C
sqloInvokeFnArgs + 0xB0
sqloInvokeFnArgs@glue64C + 0x74
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf
+0x1154
sqlriInvokeInvoker__FP10sqlri_ufob + 0x848
sqlricall__FP8sqlrr_cb + 0x7C
sqlriAggressiveValidateOp__FP8sqlrr_cb + 0x108
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x6C8
sqlrr_process_execute_request__FP8sqlrr_cbi - 0x258
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x240
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x968
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
- 0x48
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
@63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8
RunEDU__8sqeAgentFv + 0x11C
EDUDriver__9sqzEDUObjFv + 0x78
sqloEDUEntry + 0x57C |
| Local Fix: |
Turn off Intra_Parallel at the instance level. |
| 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 |
This APAR is fixed on the DB2 v9.7FP5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.05.2011
19.07.2011
19.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
