|
Problem IC63840
|
Status: Closed |
LARGE QUERY RESULTS IN SIGSEGV, STACK SHOWS THE TRAP OCCURING IN FUNCTION SQLRI_BFBANDP() |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
db2agntp crashes with the following stack:
bfControl->probeFilter (bloomfilter)
0x090000000177C484 sqlri_BFBandP__FP8sqlrr_cb + 0x15C
0x09000000020A6EA8
@58@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB + 0x3D4
0x0900000001FF38A0 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + 0x214
0x0900000001FF3458
sqlirdk__FP20sqle_agent_privatecbP10SQLI_IXPCRP9SQLD_IXCBiP8SQLD
_KEYPUiP9sqli_scanPi + 0x7DC
0x0900000001FF2BBC sqldIndexFetch__FP8SQLD_CCBPUi + 0x120
0x0900000001FB90BC
sqldRowFetch__FP20sqle_agent_privatecbP8SQLD_CCBUlT3PP10SQLD_VAL
UEPUiT3 - 0x1808
0x0900000001FB7F60 sqlriFetch__FP8sqlrr_cbP9sqlri_taol - 0x524
0x0900000001FB7750 sqlriNljnNonPiped__FP8sqlrr_cb - 0x120
0x09000000027B8434 sqlri_BFixAnd__FP8sqlrr_cb + 0xB20
0x0900000001F54C04 sqlrihsjn__FP8sqlrr_cb + 0x5C
0x0900000001FB7AFC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x14
0x0900000002CB5EDC sqlrr_dss_router__FP8sqlrr_cb + 0x9D0
0x09000000030B9E38
sqlrr_subagent_router__FP20sqle_agent_privatecbP10sqle_db2ra +
0xAA0
0x090000000309A044 sqleSubRequestRouter__FP13sqle_agent_cbPUiT2
+ 0x2EC
0x09000000028E3448 sqleProcessSubRequest__FP13sqle_agent_cb +
0x200
0x0900000001C5E0D0 sqleRunAgent__FPcUi - 0x450
0x0900000001EA0110
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x31C
0x090000000227B8D8 sqloSpawnEDU + 0x274
0x0900000001C64080
sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst
RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU
WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb + 0x1F4
0x0900000001C635A8
sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16
sqlkdRqstRplyFmtP17sqle_connect_info + 0x390
0x09000000020D599C
sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlPv + 0x224
0x0000000100004078 sqleInitSysCtlr__FPi + 0x7C4
0x0000000100002EDC sqleSysCtlr__Fv + 0x58
0x0900000001EA1304 sqloRunInstance + 0x6D4
0x0000000100002A48 DB2main + 0x8A4
0x0000000100003880 main + 0x10 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2agntp crashes with the following stack: *
* *
* *
* *
* bfControl->probeFilter (bloomfilter) *
* *
* *
* *
* 0x090000000177C484 sqlri_BFBandP__FP8sqlrr_cb + 0x15C *
* *
* 0x09000000020A6EA8 *
* *
* @58@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB + 0x3D4 *
* *
* 0x0900000001FF38A0 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + *
* 0x214 *
* 0x0900000001FF3458 *
* *
* sqlirdk__FP20sqle_agent_privatecbP10SQLI_IXPCRP9SQLD_IXCBiP8SQ
* _KEYPUiP9sqli_scanPi + 0x7DC *
* *
* 0x0900000001FF2BBC sqldIndexFetch__FP8SQLD_CCBPUi + 0x120 *
* *
* 0x0900000001FB90BC *
* *
* sqldRowFetch__FP20sqle_agent_privatecbP8SQLD_CCBUlT3PP10SQLD_V
* UEPUiT3 - 0x1808 *
* *
* 0x0900000001FB7F60 sqlriFetch__FP8sqlrr_cbP9sqlri_taol - *
* 0x524 *
* 0x0900000001FB7750 sqlriNljnNonPiped__FP8sqlrr_cb - 0x120 *
* *
* 0x09000000027B8434 sqlri_BFixAnd__FP8sqlrr_cb + 0xB20 *
* *
* 0x0900000001F54C04 sqlrihsjn__FP8sqlrr_cb + 0x5C *
* *
* 0x0900000001FB7AFC *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + *
* 0x14 *
* *
* 0x0900000002CB5EDC sqlrr_dss_router__FP8sqlrr_cb + 0x9D0 *
* *
* 0x09000000030B9E38 *
* *
* sqlrr_subagent_router__FP20sqle_agent_privatecbP10sqle_db2ra *
* + *
* 0xAA0 *
* *
* 0x090000000309A044 *
* sqleSubRequestRouter__FP13sqle_agent_cbPUiT2 *
* + 0x2EC *
* *
* 0x09000000028E3448 sqleProcessSubRequest__FP13sqle_agent_cb *
* + *
* 0x200 *
* *
* 0x0900000001C5E0D0 sqleRunAgent__FPcUi - 0x450 *
* *
* 0x0900000001EA0110 *
* *
* sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x31C *
* *
* 0x090000000227B8D8 sqloSpawnEDU + 0x274 *
* *
* 0x0900000001C64080 *
* *
* sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRq
* RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_E
* WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb + 0x1F4 *
* *
* 0x0900000001C635A8 *
* *
* sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP
* sqlkdRqstRplyFmtP17sqle_connect_info + 0x390 *
* *
* 0x09000000020D599C *
* *
* sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlPv + *
* 0x224 *
* 0x0000000100004078 sqleInitSysCtlr__FPi + 0x7C4 *
* *
* 0x0000000100002EDC sqleSysCtlr__Fv + 0x58 *
* *
* 0x0900000001EA1304 sqloRunInstance + 0x6D4 *
* *
* 0x0000000100002A48 DB2main + 0x8A4 *
* *
* 0x0000000100003880 main + 0x10 *
****************************************************************
* RECOMMENDATION: *
* none *
**************************************************************** |
| Local Fix: |
|
| 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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 |
db2agntp crashes with the following stack:
bfControl->probeFilter (bloomfilter)
0x090000000177C484 sqlri_BFBandP__FP8sqlrr_cb + 0x15C
0x09000000020A6EA8
@58@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB + 0x3D4
0x0900000001FF38A0 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + 0x214
0x0900000001FF3458
sqlirdk__FP20sqle_agent_privatecbP10SQLI_IXPCRP9SQLD_IXCBiP8SQLD
_KEYPUiP9sqli_scanPi + 0x7DC
0x0900000001FF2BBC sqldIndexFetch__FP8SQLD_CCBPUi + 0x120
0x0900000001FB90BC
sqldRowFetch__FP20sqle_agent_privatecbP8SQLD_CCBUlT3PP10SQLD_VAL
UEPUiT3 - 0x1808
0x0900000001FB7F60 sqlriFetch__FP8sqlrr_cbP9sqlri_taol - 0x524
0x0900000001FB7750 sqlriNljnNonPiped__FP8sqlrr_cb - 0x120
0x09000000027B8434 sqlri_BFixAnd__FP8sqlrr_cb + 0xB20
0x0900000001F54C04 sqlrihsjn__FP8sqlrr_cb + 0x5C
0x0900000001FB7AFC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x14
0x0900000002CB5EDC sqlrr_dss_router__FP8sqlrr_cb + 0x9D0
0x09000000030B9E38
sqlrr_subagent_router__FP20sqle_agent_privatecbP10sqle_db2ra +
0xAA0
0x090000000309A044 sqleSubRequestRouter__FP13sqle_agent_cbPUiT2
+ 0x2EC
0x09000000028E3448 sqleProcessSubRequest__FP13sqle_agent_cb +
0x200
0x0900000001C5E0D0 sqleRunAgent__FPcUi - 0x450
0x0900000001EA0110
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x31C
0x090000000227B8D8 sqloSpawnEDU + 0x274
0x0900000001C64080
sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst
RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU
WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb + 0x1F4
0x0900000001C635A8
sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16
sqlkdRqstRplyFmtP17sqle_connect_info + 0x390
0x09000000020D599C
sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlPv + 0x224
0x0000000100004078 sqleInitSysCtlr__FPi + 0x7C4
0x0000000100002EDC sqleSysCtlr__Fv + 0x58
0x0900000001EA1304 sqloRunInstance + 0x6D4
0x0000000100002A48 DB2main + 0x8A4
0x0000000100003880 main + 0x10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.10.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
