|
Problem IT15631
|
Status: Closed |
Deadlock between invalidation of package and implicit rebind of the same package. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Users on all platforms are affected. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 Version 10.5 Fixpack 8 *
**************************************************************** |
| Local Fix: |
|
| Solution |
The fix has been applied to DB2 Version 10.5 Fixpack 8 and the
deadlock has been resolved. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.06.2016
11.01.2017
11.01.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
