Informix - Problem description
Problem IT00683 | Status: Closed |
UNDER LOAD INSTANCE IS SWAMPED WITH ASSERT WARNINGS: EXCEEDING MAX # OF PAGES | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Under heavy load the instance may produce a high number of assert warnings similar to the one below. From the online.log: 01:37:30 01:37:30 IBM Informix Dynamic Server Version 12.10.FC1 Software Serial Number AAA#B000000 01:37:30 Assert Warning: Exceeding max # of pages (Actual 41, Allowed 40) that can be physically logged in a critical section while critical section blocking is active. 01:37:30 Who: Session(1721, instance@domain.com 16843, 0x5ba02fab8) Thread(4647, sqlexec, 5b9ffe4d8, 1) File: rsbuff.c Line: 4278 01:37:30 Action: Please notify IBM Informix Technical Support. 01:37:30 Raw hex dump of stack located in /informixdir/af.160f94a9.rawstk 01:37:30 Stack for thread: 4647 sqlexec The stack printed in the AF files may look similar to: afstack afhandler afwarn_interface bfphyslogx buffclear mapfree ptextend ptbuild rspnbuild_sz fmamaddindex sqmgm_isaddindex creaidx aud_creaidx excommand sq_execute sqmain spawn_thread startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * users using large extents in 12.10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.03.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC4.W1 | |
12.10.xC5 | |
12.10.xC5.W1 |