• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT31587 Status: Closed

-244/-126 ON SECONDARY WHEN TABLE WITH SIZE THAT REQUIRES REMAINDER PAGES
AND UPDATE NEEDS BEFORE/AFTER IMAGE

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
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.
Problem Summary:
****************************************************************
* 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.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.01.2020
10.12.2020
10.12.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.