Informix - Problem description
Problem IT30188 | Status: Closed |
ROLLFORWARD OF LOG RECORD FAILED ISERRNO = 111 APPLYING LOG RECORD FOR JUST CREATED RTREE INDEX IN NONDEFAULT PAGE SIZE DBSPACE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Here's the MSGPATH output and assertion file info/stack: 12:29:59 DR: Receiving index db1:"informix".t2#t2_geo : Started 12:29:59 DR: Receiving index db1:"informix".t2#t2_geo : Completed. 12:30:00 Rollforward of log record failed. iserrno = 111 12:30:00 Log Record: log = 11, pos = 0x11251cc, type = OLDRSAM:HUPDATE(73), trans = 4213245132192874524 12:30:00 Assert Failed: Logical log replay error. 12:30:00 IBM Informix Dynamic Server Version 11.70.FC8 12:30:00 Who: Session(26, informix@machine, 0, 0x56451d68) Thread(45, xchg_1.0, 56418170, 1) File: rsprecvr.c Line: 7433 12:30:00 Results: The secondary server cannot continue. 12:30:00 Action: Reestablish the secondary server. 12:30:00 Log record (OLDRSAM:HUPDATE) failed, partnum 0x300002 rowid 0x801 iserrno 111 ... 12:30:00 Stack for thread: 45 xchg_1.0 base: 0x0000000058b2d000 len: 69632 pc: 0x0000000001317a03 tos: 0x0000000058b3cf90 state: running vp: 1 0x0000000001317a03 afstack 0x0000000001319ffd afhandler 0x000000000131a5ba afcrash_interface 0x0000000000e3ec83 rollfwd_error 0x0000000000e9b8db rlogm_redo 0x0000000000e49d9b next_recvr 0x0000000001325656 producer_thread 0x00000000012e1a28 startup As MSGPATH indicates an index was just received by the HDR secondary, this index was an RTREE index that was being stored in a 16k page sized dbspace. 12:29:59 DR: Receiving index db1:"informix".t2#t2_geo : Started 12:29:59 DR: Receiving index db1:"informix".t2#t2_geo : Completed. create index t2_geo on t2(c2geo st_geometry_ops) using rtree in dbs16k; Dbspaces address number flags fchunk nchunks pgsize flags owner name 56319028 1 0x60801 1 1 2048 NL BA informix rootdbs 56319600 2 0x48801 2 1 2048 NLSBA informix sbs1 58cded48 3 0x60801 3 1 16384 NL BA informix dbs16k 3 active, 2047 maximum The problem will happen for any non-default sized dbspace (so 2k or 4k depending on platform). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 11.70.xC9W2 and * * 12.10.xC15. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 11.70.xC9W2 or 12.10.xC15 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 11.70.xC9W2 and * * 12.10.xC15. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 11.70.xC9W2 or 12.10.xC15 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 11.70.xC9W2 and 12.10.xC15. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.09.2019 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) |