Informix - Problem description
Problem IT31090 | Status: Closed |
SIMPLE EVALUATION ERRORS ON A SINGLE REPLICATE CAN FORCE ALL OF ER TO SHUT DOWN | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Take the following test case: create table t1 (c1 int, c2 char(4)) lock mode row; create unique index t1_idx1 on t1(c1); alter table t1 add constraint primary key (c1) constraint t1_pk; Then created the following replicate on the table: cdr def repl -c g_er1 -C always -M g_er1 -S row er1_t1_rep "P db1@g_er1:informix.t1" "select * from t1 where c2 in (1,2,3,4,5)" "R db1@g_er2:informix.t1" "select * from t1 where c2 in (1,2,3,4,5)" cdr def repl -c g_er2 -C always -M g_er2 -S row er2_t1_rep "P db1@g_er2:informix.t1" "select * from t1 where c2 in (1,2,3,4,5)" "R db1@g_er1:informix.t1" "select * from t1 where c2 in (1,2,3,4,5)" Note, that c2 is a character column but the where clause in the define replicate is using integer values because there are no quotes around the numbers in the "in clause". Then insert the following row on 1 side to get replicated. insert into t1 values(4,"3"); Then do the following update statement: update t1 set c2 = "a" where c1 = 4; When the update is processed by ER, it will shutdown ER with the following error in the MSGPATH file: 11:00:33 Error - ER has encountered a fatal error and must shut down 11:00:33 ER encountered a fatal error while evaluating replicate er1_t1_rep SQLCODE:-1213 ISAMCODE:0 So at this point, ER is down and would need to do a cleanstart to skip trying to process the update that changed the column from a numeric value to a character value. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.11.2019 28.02.2020 28.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |