| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |