APAR status
Closed as program error.
Error 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.
Local fix
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). * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
Temporary fix
Comments
APAR Information
APAR number
IT31090
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-11-27
Closed date
2020-02-28
Last modified date
2020-02-28
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":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
28 February 2020