Informix - Problem description
Problem IT28982 | Status: Closed |
ON AN UPDATABLE_SECONDARY, IF TABLE IS CREATED WITH VERCOLS, IFX_ROW_VERSION IS INCORRECTLY UPDATED AND FAILS WITH -244/-7350 | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem 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 | |
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: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.04.2019 19.09.2019 19.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
14.10.xC2 | |
Problem solved according to the fixlist(s) of the following version(s) |