|
Problem IT33355
|
Status: Closed |
DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
This is reported originally as IT15631 and the code change is
needed for V11.5.
A deadlock is received in Purescale environment when 2 agents
are accessing the same package, where an agent could be
invalidating the package because of a change in the dependent
objects and another agent could be implicitly rebinding the
package during execution of the invalid package.
Following is an example scenario:
1. Create a multi-partitioned table.
2. Create a procedure dependent on the paritioned-table.
3. Detach a partition, which will mark the procedure's PLAN
invalid.
4. Running concurrent "call procedure()" and another detach
might result in a deadlock scenario.
The "call procedure()" would be doing an implicit rebind on
the package.
And the following is an example of lock information observed in
this problem.
Participant No 2 requesting lock
----------------------------------
Lock Name : 0x63413657455946672B247466EB
Lock wait start time : 2016-05-27-02.17.12.360474
Lock wait end time : 2016-05-27-02.17.20.025958
Lock Type : GLOBAL_PKG
Lock Specifics :
Lock Attributes : 00040000
Lock mode requested : Exclusive
Lock mode held : Exclusive
Lock Count : 0
Lock Hold Count : 0
Lock rrIID : 0
Lock Status : Waiting
Lock release flags : 00000000
Tablespace TID :
Tablespace Name :
Table FID :
Table Schema :
Table Name :
Participant No 1 requesting lock
----------------------------------
Lock Name : 0x63413657455946672B247466C1
Lock wait start time : 2016-05-27-02.16.53.247656
Lock wait end time : 2016-05-27-02.17.20.025958
Lock Type : PLAN
Lock Specifics :
PACKAGE_TOKEN=cA6WEYFg,HashPkgID:6674242b,LoadingBit:0
Lock Attributes : 00000000
Lock mode requested : Exclusive
Lock mode held : Exclusive
Lock Count : 0
Lock Hold Count : 0
Lock rrIID : 0
Lock Status : Waiting
Lock release flags : 00000000
Tablespace TID :
Tablespace Name :
Table FID :
Table Schema :
Table Name : |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2020
09.04.2021
09.04.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
