INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70

When a table is altered with an in-place alter mechanism the
bitmap value for all existing data pages is updated to value 0xc
to indicate "very full" thereby blocking further attempts to
insert new rows onto that page. When secondary servers, such as
HDR or RSS, are used there are occasions when the bitmap page on
the secondary server may not be updated in the same way. If the
server is promoted to a primary a later insert operation on the
table may generate an Assert Failure of the form:

allocvslot: Attempting to allocate slot on in-use old (0)
 version page - new version is 1
allocvslot:partnum 0x10014c tr_pagenum 1

with a similar message in the online log of the form:

Assert Failed: Slot allocation error for
'test:"informix".tab442'
IBM Informix Dynamic Server Version 11.70.FC7XBU
Who: Session(49, informix@host1, 22282406, 7000000203a93f0)
Thread(81, sqlexec, 700000020371f60, 1)
File: rsbitmap.c Line: 3285
Results: Internally corrected
Action: Run 'oncheck -cDI test:"informix".tab442'

The result is that the bitmap is internally corrected and the
insert operation succeeds. For this specific discrepancy in
expected and actual bitmap values the Assert Failure is
unhelpful and its generation may cause further problems on
replicated servers if the generation of the AF file takes a long
time potentially leading to a failover scenario.

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix clustering.                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 11.70.xC9                      *
****************************************************************

A workaround to avoid this situation is to resolve the
outstanding in-place alters by performing a dummy update on
every row of the table.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.12.2016
22.06.2017
22.06.2017

11.70.xC9