DB2 - Problem description
Problem IT37583 | Status: Closed |
HADR PRIMARY STUCK IN CRASH RECOVERY BECAUSE NOT ABLE TO SHIP LOGS TO STANDBY IN PEER STATE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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 : | 13.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) |