Informix - Problem description
Problem IT14183 | Status: Closed |
RSS SECONDARY ASSERT LOGICAL LOG REPLAY ERROR ON CHALLOC WHEN ROLLFORWARD INSERTS AFTER A TRUNCATE TABLE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * 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 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2016 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |