|
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) |
