|
Problem IT32439
|
Status: Closed |
Instance Crash, sqeWlmAdmissionQueue::ReleaseResources
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
If a query is interrupted while it is in the wlm admission
control queue, and another instance of the same query completed
execution just before the queued query was interrupted, the
instance may crash with the following stack.
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002B4D6C849EA6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002B4D6C849AEB ossDumpStackTraceV98 + 0x002b
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002B4D6C845CD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002B4D63E82627 sqlo_trce + 0x03c7
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D63FFF5F1 sqloEDUCodeTrapHandler + 0x03d1
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D5A5FF5D0 address: 0x00002B4D5A5FF5D0 ; dladdress:
0x00002B4D5A5F0000 ; offset in lib: 0x000000000000F5D0 ;
(/lib64/libpthread.so.0)
0x00002B4D62186CF4
_ZN20sqeWlmAdmissionQueue37ServiceClassHandleResourceUsageChange
EP18sqeWlmAdmAgentInfoP24sqeWlmAdmMemberResourcesS3_mbmm +
0x1094
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D6215D1E9
_ZN20sqeWlmAdmissionQueue16ReleaseResourcesEP18sqeWlmAdmAgentInf
o + 0x0459
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D6215C8AB
_ZN20sqeWlmAdmissionQueue16RequestResourcesEP18sqeWlmAdmAgentInf
o + 0x08fb
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D6490A49A
_Z32sqlrwRequestResourcesFromAdmCtrlP8sqlrr_cbP21sqlrw_activity_
ticket + 0x01ca
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D648A39F7
_Z38sqlrwPassQueuingObjectsAtQueueLocationP8sqlrr_cbP27sqlrw_act
ivity_threshold_cbP21sqlrw_activity_ticketiiP5sqlca + 0x0117
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D648A2A6E
_Z42sqlrwPassAdmCtrlAndDBConcQueuingThresholdsP8sqlrr_cbP19sqlrr
_curr_activity + 0x146e
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D6489FE0D
_Z53sqlrwProcessAdmCtrlAndThresholdsBeforeRunningActivityP8sqlrr
_cbP19sqlrr_curr_activity + 0x051d
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D647944E9
_Z37sqlrr_activity_exe_start_common_coordP8sqlrr_cbiPP19sqlrr_cu
rr_activityPib + 0x0289
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D64792BF5 _Z24sqlrr_activity_exe_startP8sqlrr_cbbPi +
0x0215
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D64681C64 address: 0x00002B4D64681C64 ; dladdress:
0x00002B4D5ABB7000 ; offset in lib: 0x0000000009ACAC64 ;
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D646804DD
_Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x06cd
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626D8A31
_Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x0431
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626C2CDB
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x00fb
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626C3DAE
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x054e
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626B6D76 address: 0x00002B4D626B6D76 ; dladdress:
0x00002B4D5ABB7000 ; offset in lib: 0x0000000007AFFD76 ;
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626BD3C3 address: 0x00002B4D626BD3C3 ; dladdress:
0x00002B4D5ABB7000 ; offset in lib: 0x0000000007B063C3 ;
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D626BE07F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x011f
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D620B3EA3 _ZN8sqeAgent6RunEDUEv + 0x0de3
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D65B9507E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D63FFCA8A sqloEDUEntry + 0x057a
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B4D5A5F7DD5 address: 0x00002B4D5A5F7DD5 ; dladdress:
0x00002B4D5A5F0000 ; offset in lib: 0x0000000000007DD5 ;
(/lib64/libpthread.so.0)
0x00002B4D6D96A02D clone + 0x006d
(/lib64/libc.so.6)
This issue only exists on databases where the adaptive workload
manager is enabled (i.e. the wlm_admission_ctrl db config
parameter is set to YES) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 v11.5.4.0 or higher *
**************************************************************** |
| Local Fix: |
The issue can be worked around by setting the following registry
variable:
db2set DB2_WLM_SETTINGS="ADM_ENABLE_REFRESH_ACTUALS:FALSE" -im |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.04.2020
30.06.2020
30.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
