On a primary of a primary/rss pair when multiple tables are
inserting into the same dbspace with smaller extents
after a truncate table occurred on at least one of the tables,
then you can get a logical log replay error on the RSS
comparable to:
03/07/16 17:17:57 Rollforward of log record failed. iserrno =
131
03/07/16 17:17:57 Log Record: log = 10, pos = 0xbc7280, type =
OLDRSAM:CHALLOC(51), trans = 3619337690157154333
03/07/16 17:17:57 Assert Failed: Logical log replay error.
03/07/16 17:17:57 IBM Informix Dynamic Server Version 12.10.FC6
03/07/16 17:17:57 Who: Session(56, informix@server, 0,
0x451c9b80)
Thread(90, xchg_2.0, 4519c328, 9)
File: rsprecvr.c Line: 7932
03/07/16 17:17:57 Results: The secondary server cannot
continue.
03/07/16 17:17:57 Action: Reestablish the secondary server.
03/07/16 17:17:57 stack trace for pid 20779 written to
$INFORMIXDIR/tmp/af.4420c24
03/07/16 17:17:57 See Also: $INFORMIXDIR/tmp/af.4420c24
(/work2/prod/12.10.FC6/bin/oninit) afstack
(/work2/prod/12.10.FC6/bin/oninit) afhandler
(/work2/prod/12.10.FC6/bin/oninit) afcrash_interface
(/work2/prod/12.10.FC6/bin/oninit) rollfwd_error
(/work2/prod/12.10.FC6/bin/oninit) rlogm_redo
(/work2/prod/12.10.FC6/bin/oninit) scan_logredo
(/work2/prod/12.10.FC6/bin/oninit) next_lscan
(/work2/prod/12.10.FC6/bin/oninit) producer_thread
(/work2/prod/12.10.FC6/bin/oninit) startup
I have also seen the same assert, but with an iserrno = 0 as
follows:
03/07/16 16:42:50 Rollforward of log record failed. iserrno = 0
03/07/16 16:42:50 Log Record: log = 11, pos = 0xe595e4, type =
OLDRSAM:CHALLOC(51), trans = 3907568066308866111
03/07/16 16:42:50 Assert Failed: Logical log replay error.
03/07/16 16:42:50 IBM Informix Dynamic Server Version 12.10.FC6
03/07/16 16:42:50 Who: Session(56, informix@server, 0,
0x451c9b80)
Thread(89, xchg_2.0, 4519c328, 1)
File: rsprecvr.c Line: 7932
03/07/16 16:42:50 Results: The secondary server cannot
continue.
03/07/16 16:42:50 Action: Reestablish the secondary server.
03/07/16 16:42:50 stack trace for pid 19444 written to
$INFORMIXDIR/tmp/af.44103ea
03/07/16 16:42:50 See Also: $INFORMIXDIR/tmp/af.44103ea |
****************************************************************
* USERS AFFECTED: *
* Users who truncate tables with small first extent sizes *
* which contain either several in-table indexes or an FOT *
* index with many buckets. Rolling forward that truncate *
* operation, either after an archive restore or on a secondary *
* server, can fail. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
