Informix - Problem description
Problem IT35727 | Status: Closed |
LOG REPLAY ERROR ON SECONDARY WHEN SP_AUTOEXPAND 0 AND MANUALLY EXTEND CHUNK WHICH ALSO ALLOWS MON_LOW_STORAGE TASK TO EXTEND | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following problem was reported in a PRI/RSS pair running a special build of IDS 12.10.FC10 on linux x86_64 and was reproduced on the same platform running 12.10.FC14 but this is likely a platform independent defect. If you run the following commands to manually extend a chunk when SP_AUTOEXPAND is off: EXECUTE FUNCTION TASK ("modify chunk extendable", "2"); EXECUTE FUNCTION TASK ("modify chunk extend", "2", "1000000"); EXECUTE FUNCTION TASK ("modify chunk extendable off", "2"); There is a window such that if the mon_low_storage task runs, it may also start a chunk extend which ends after turning chunk extendable off. This can cause a logical log replay error on a secondary when we try to roll forward through the chunk extend when the chunk is no longer extendable. 01/28/21 14:49:10 Assert Failed: Logical log replay error. 01/28/21 14:49:10 IBM Informix Dynamic Server Version 12.10.FC14 01/28/21 14:49:10 Who: Session(45, informix@hostname, 0, 0x45c493f8) Thread(79, xchg_2.0, 45c17128, 9) File: rsprecvr.c Line: 7968 01/28/21 14:49:10 Results: The secondary server cannot continue. 14:49:10 Stack for thread: 79 xchg_2.0 base: 0x0000000047f9d000 len: 102400 pc: 0x0000000001410459 tos: 0x0000000047fb4c00 state: running vp: 9 0x0000000001410459 (/work2/prod/12.10.FC14/bin/oninit) afstack 0x0000000001413431 (/work2/prod/12.10.FC14/bin/oninit) afhandler 0x0000000001413a92 (/work2/prod/12.10.FC14/bin/oninit) afcrash_interface 0x0000000000eb68e3 (/work2/prod/12.10.FC14/bin/oninit) rollfwd_error 0x0000000000f125f4 (/work2/prod/12.10.FC14/bin/oninit) rlogm_redo 0x0000000000ec459d (/work2/prod/12.10.FC14/bin/oninit) scan_logredo 0x0000000000ec540e (/work2/prod/12.10.FC14/bin/oninit) next_lscan 0x000000000146ea00 (/work2/prod/12.10.FC14/bin/oninit) producer_thread 0x0000000001448997 (/work2/prod/12.10.FC14/bin/oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Disabling the mon_low_storage task can be a suitable workaround when chunks are manually extended. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.01.2021 13.05.2021 13.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |