|
Problem IT35954
|
Status: Closed |
MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Multiple rebind package may encounter deadlock.
Here is a sample from db2diag.log
020-04-10-16.32.36.347796+540 I355336A2956 LEVEL: Event
PID : 19005480 TID : 13809 PROC :
db2sysc 0
INSTANCE: e105q4sa NODE : 000 DB :
DEADLOCK
APPHDL : 0-3365 APPID:
*LOCAL.e105q4sa.200410074339
AUTHID : E105Q4SA HOSTNAME: athena
EDUID : 13809 EDUNAME: db2agent (DEADLOCK) 0
FUNCTION: DB2 UDB, lock manager, sqlplWaitOnWP, probe:999
MESSAGE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock
detected"
DIA8002C A deadlock has occurred, rolling back
transaction.
DATA #1 :
Caught rc 0x80100002. Dumping stack trace.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000009E5FE2B0 pdLogPrintf + 0x28
[1] 0x090000009DA78FF8
sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL
P_LTRN_CHAINCbN25 + 0xD28
[2] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
[3] 0x090000009DACCEE4
sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL
P_LTRN_CHAINCbN25 + 0x29A4
[4] 0x090000009DD2CDFC sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO
+ 0x1AE8
[5] 0x090000009DD2DB74 sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO
+ 0x2860
[6] 0x090000009DD33910
sqlrr_get_lock__FP8sqlrr_cbP14SQLP_LOCK_INFOUiPUi + 0x1BC
[7] 0x090000009D686AB4
sqlra_pkg_lock__FP8sqlrr_cbPUcsT2T3T2UlUiiP14SQLP_LOCK_INFO +
0x170
[8] 0x090000009B64B644
sqlra_execute_event__FP8sqlrr_cbP20SQLR_RPC_APM_REQUEST + 0xF3C
[9] 0x090000009B645EC8
sqlra_execute_event__FP8sqlrr_cbP20SQLR_RPC_APM_REQUEST + 0x274 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v111m4fp6 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v111m4fp6 or later *
**************************************************************** |
| Comment |
Upgrade to db2_v111m4fp6 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.02.2021
18.02.2021
18.02.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
