|
Problem IT37637
|
Status: Closed |
HADR PRIMARY STUCK IN CRASH RECOVERY BECAUSE NOT ABLE TO SHIP LOGS TO STANDBY IN PEER STATE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
HADR primary can be stuck in crash recovery in PEER state, when
standby disk is full.
In PEER state, primary cannot write more log records if it
cannot ship to standby because standby disk is full. Thus, the
primary may be stuck in crash recovery and cannot make progress,
unless standby gets more disk space to receive log files.
We can observed the following on the primary while it's in crash
recovery from db2pd -hadr:
HADR_ROLE = PRIMARY
REPLAY_TYPE = PHYSICAL
HADR_SYNCMODE = NEARSYNC
STANDBY_ID = 1
LOG_STREAM_ID = 0
HADR_STATE = PEER
HADR_FLAGS = STANDBY_RECV_BLOCKED
STANDBY_LOG_DEVICE_FULL TCP_PROTOCOL |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* HADR *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade Db2 to latest version *
**************************************************************** |
| Local Fix: |
Refer to
https://www.ibm.com/support/pages/transactions-are-blocked-hadr-
primary-when-standby-log-device-full |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* HADR *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade Db2 to latest version *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.07.2021
02.12.2021
02.12.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
