IBM Support

IT28982: ON AN UPDATABLE_SECONDARY, IF TABLE IS CREATED WITH VERCOLS, IFX_ROW_VERSION IS INCORRECTLY UPDATED AND FAILS WITH -244/-7350

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • On following scenario:
    
    create table "informix".table_a
      (
        id integer,
        name char(10)
      ) WITH VERCOLS;
    
    revoke all on "informix".table_a from "public" as "informix";
    
    grant select on "informix".table_a to "public" as "informix";
    grant update on "informix".table_a to "public" as "informix";
    grant insert on "informix".table_a to "public" as "informix";
    grant delete on "informix".table_a to "public" as "informix";
    grant index on "informix".table_a to "public" as "informix";
    
    If you run following sequences:
    
    insert into table_a values (1, 'aaa');
    select id, name, ifx_insert_checksum, ifx_row_version from
    table_a;
    begin work;
    update table_a set name = 'bbb' where id = 1;
    select id, name, ifx_insert_checksum, ifx_row_version from
    table_a;
    update table_a set name = 'ccc' where id = 1;
    select id, name, ifx_insert_checksum, ifx_row_version from
    table_a;
    commit;
    
    Result will be:
             id name       ifx_insert_checks+ ifx_row_version
              1 aaa                -190036525               1
    
             id name       ifx_insert_checks+ ifx_row_version
              1 bbb                -190036525               2
    
             id name       ifx_insert_checks+ ifx_row_version
              1 ccc                -190036525               3
    
    If same sequence is run on HDR secondary (will fail with
    -244/-7350)
    
             id name       ifx_insert_checks+ ifx_row_version
              1 aaa                -869941552               2
    
             id name       ifx_insert_checks+ ifx_row_version
              1 bbb                -869941552               4
    
       244: Could not do a physical-order read to fetch next row.
      7350: Attempt to update a stale version of a row
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IDS 14.10.xC1.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ON AN UPDATABLE_SECONDARY, IF TABLE IS CREATED WITH VERCOLS, *
    * IFX_ROW_VERSION IS INCORRECTLY UPDATED AND FAILS WITH        *
    * -244/-7350                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in IDS 14.10.xC2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28982

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-29

  • Closed date

    2019-09-19

  • Last modified date

    2019-09-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 September 2019