home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC63840 Status: Geschlossen

LARGE QUERY RESULTS IN SIGSEGV, STACK SHOWS THE TRAP OCCURING IN FUNCTION
SQLRI_BFBANDP()

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
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
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.10.2009
24.02.2010
24.02.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.1 FixList