IT30188: ROLLFORWARD OF LOG RECORD FAILED ISERRNO = 111 APPLYING LOG RECORD FOR JUST CREATED RTREE INDEX IN NONDEFAULT PAGE SIZE DBSPACE

APAR status

• Closed as program error.

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

Local fix

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

Problem conclusion

• Fixed in Informix Server 11.70.xC9W2 and 12.10.xC15.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels