IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT30188

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-04

  • Closed date

    2020-12-09

  • Last modified date

    2020-12-09

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70"}]

Document Information

Modified date:
10 December 2020