|
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) |
