Informix - Problem description
Problem IT34191 | Status: Closed |
LOG RECOVERY CAN HANG WHEN SKIPPING LOG RECORDS OLDER THAN THE DBSPACE BEING RECOVERED | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
HDR or RSS secondary servers can hang soon after newly being instantiated, with all active wreplay_# threads hung in recvr_txatt() function, if dbspaces got restored from backups newer than related log records being recovered (or actually skipped). Typical picture would be: onstat -g laq showing some of the wreplay threads with non-zero Queue Size and picture not changing over time, e.g. Log Apply Info: Thread Queue Total Avg Size Queued Depth wreplay_1 0 0 0.00 wreplay_2 0 0 0.00 wreplay_3 84 107 33.58 wreplay_4 0 79 1.03 wreplay_5 0 79 1.00 wreplay_6 0 0 0.00 wreplay_7 0 25 1.00 wreplay_8 0 104 1.00 wreplay_9 0 111 1.00 wreplay_10 0 158 1.01 wreplay_11 159 160 79.51 wreplay_12 0 0 0.00 wreplay_13 0 0 0.00 wreplay_14 0 0 0.00 wreplay_15 0 0 0.00 wreplay_16 0 79 1.00 wreplay_17 7 7 4.00 wreplay_18 0 0 0.00 wreplay_19 0 0 0.00 wreplay_20 0 0 0.00 and exatly those wreplay threads shown in status "yield forever" (all others in "cond wait ReplayTime") and showing this stack: (oninit)yield_processor_mvp (oninit)mt_yield (oninit)recvr_txatt | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Switch back to pre-14.10 log recovery, at least temporarily: onconfig CDR_FEATURES CLASSIC_REPLAY | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.09.2020 09.12.2020 09.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |