INFORMIX SERVER / 5725A3900 / E10 - 

On a secondary you'll receive:

   244: Could not do a physical-order read to fetch next row.
   126: ISAM error: bad row id

after an update in primary, for a table that uses remainder
pages due to col sizes, on a row and the update needs, due to
the size, a before / after image for the HUPDATE.

Primary will show the row correctly.

create table "informix".table1
  (
    a_serial_col serial not null ,
    a_char_with_index char(10) not null ,
    a_big_char char(4096),
    other_big_char char(4096),
    another_big_char char(4096)
  );

revoke all on "informix".table1 from "public" as "informix";

create unique index "informix".ix103_1 on "informix".table1
(a_serial_col) using btree ;
create unique index "informix".ix103_2 on "informix".table1
(a_char_with_index)  using btree ;

Insert 2 rows:

1|KEY1|A char with some info on it so it gets some space used,
I'll explain later why|Other char with some info as well|Another
one with info|
2|KEY2|A char with some info on it so it gets some space used,
I'll explain later why|Other char with some info as well|Another
one with info|

UPDATE table1 SET a_big_char = "Update with a very big char so
the update doesn't fit on a HUPDATE record and needs the HUPDBEF
& HUPDAFT records"
WHERE a_char_with_index="KEY2";

A SELECT * FROM table1;  will return correctly first row and
then the 244/126 error for the updated row.

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 12.10.xC15 (when available) or     *
* 14.10.xC4.                                                   *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 12.10.xC15 (when available) or     *
* 14.10.xC4.                                                   *
****************************************************************

Fixed in Informix Server 12.10.xC15 and 14.10.xC4.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.01.2020
10.12.2020
10.12.2020