DB2 - Problem description
Problem IT35984 | Status: Closed |
A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When running a query having FFNR (fetch first N rows only) in intra_parallel environment, it might be in a hang situation at sqlri_hsjnDoneProbeTuples if there are some sub-agents which reach FFNR conditions and are early closed. The stack trace of sub-agents other than early closed sub-agents are like the following : 0x000003FF7AB7121C sqloWaitEDUWaitPost + 0x0224 0x000003FF78C081B8 _ZN8sqeAgent14IntrptWaitLockEP16SQLO_EDUWAITPOSTiPji + 0x0330 0x000003FF7BA3AE62 _Z25sqlri_hsjnDoneProbeTuplesP8sqlrr_cbP11sqlri_hsjno + 0x0f5a 0x000003FF7BA45358 _Z9sqlrihsjnP8sqlrr_cb + 0x03a0 0x000003FF7B8FEC96 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x0696 0x000003FF7B39A496 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x0456 0x000003FF7B39D9A8 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1578 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2021 14.06.2021 14.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |