IT39684: UNIQUE CONSTRAINT VIOLATION WITH DUPLICATE VALUE (ERROR -268 / -100) SEEN ON A REPLICATE BUT ROW DOES NOT EXIST

APAR status

• Closed as program error.

Error description

• A 14.10.FC7 server is receiving data from another sever and
  inserting these details into a table.   There are a number of
  indexes and unique constraints on the source server:table and
  also on target server:table.   The source server reports no
  errors but a replicate upon the target server:table is seeing
  regular -268 -100 errors being raised.
  
  The ATS details show:
  
  TXH Source ID:220 / Name:cdr_220 / CommitTime:22-01-18 17:33:59
  TXH Target ID:221 / Name:cdr_221 / ReceiveTime:22-01-18 17:34:00
  TXH Number of rows processed when transaction was aborted:1
  TXH Error return from SQL for the commit command, Constraint:
  informix.uk42
  TXH CDR:0 / SQL:-268 / ISAM:-100
  ----------
  RRH Row:1 / Replicate Id: 14417924 / Table: er@informix.trans2 /
  DbOp:Insert
  RRD 1200026|0|a|0|new|1313|200276
  
  An error trap on 268 produces the following stack:
  
  17:34:00  Assert Failed: found errno 268 in session 165
  17:34:00   Who: Session(165, informix@name, 0, 0x45516d18)
                  Thread(182, CDRD_4, 454dc6e8, 1)
  
  0x00000000014ce3ed (oninit) afstack
  0x00000000014cbed9 (oninit) afhandler
  0x00000000014c8c12 (oninit) affail_interface
  0x0000000000ef2d38 (oninit) check_traperror
  0x0000000000764058 (oninit) sqerr1
  0x0000000000764443 (oninit) sqconerr
  0x0000000000906c3d (oninit) chkdefcon
  0x000000000090fabb (oninit) chkdeflist
  0x00000000007c20ea (oninit) sqcommit
  0x0000000001241655 (oninit) rmCommitTxn
  0x0000000001220333 (oninit) dsiResolverThread
  0x0000000001148cb5 (oninit) cdrTrampolineThread
  0x00000000014bb6b3 (oninit) th_init_initgls
  0x000000000150337f (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC8.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC8.                        *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC8.
  

Temporary fix

Comments

APAR Information

• 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