| Latest versions | fixlist |
| 14.10.xC12 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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 |
|