|
Problem IT04450
|
Status: Closed |
HADR TAKEOVER CAN HANG IF CREATE TABLESPACE IS ISSUED ON CONNECT ION TO NEW PRIMARY DATABASE BEFORE THE TAKEOVER COMMAND RETURNS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When a TAKEOVER command is issued to change the database role,
the database is opened to application connections immediately
after the role change, before the TAKEOVER command completes all
of its processing. If user issues CREATE / DROP / ALTER
TABLESPACE command on the connection to the new primary, before
TAKEOVER command returns, there is a chance that this can create
a timing window that would cause the TAKEOVER command to hang.
If the TAKEOVER command is hung, then if any stack tracebacks
are created
one will see the following functions listed that can provide
insight as to whether you hit this problem:
If the TAKEOVER command is hung, the root cause can be confirmed
by db2pd -stack. The db2hadrs EDU would have the following
stack:
getConflictComplex
getConflict
sqlbQryPools
sqlbGetDatapools
hdrVerifyPoolStatesOnPrimaryStartup
hdrEduStartup
hdrStbyTkHandlePrimaryDone
hdrSDoTakeover
while one of the agent EDU has the following stack:
sqloWaitThreshold
sqlpgild
sqlpWriteToLog
sqlpWriteLR
sqlbCreatePool
sqldPoolCreate
sqlrlCreateTablespace
sqlnq_create_tablespace_end
sqlnq_create_tablespace_stmt
(The above stack can be slightly different for DROP / ALTER
TABLESPACE.) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* HADR *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5.5. *
**************************************************************** |
| Local Fix: |
Once hung there is no workaround. To avoid the issue, wait
until the TAKEOVER is complete before starting new workload on
the new Primary. |
| Solution |
The fix will be delivered to DB2 10.5.5 and at that time the
hang will no longer be seen. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.09.2014
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
